Datasets
The Filecoin Data Portal datasets, one click away.
clients
Filecoin clients metrics and latest details.
Columns
| column | type | description | tests |
|---|---|---|---|
client_id | VARCHAR | Filecoin client actor id address. | not_null, unique |
first_claim_at | TIMESTAMP | Timestamp of the first successful verified claim. | |
last_claim_at | TIMESTAMP | Timestamp of the most recent successful verified claim. | |
verified_claims | BIGINT | Total successful verified claims. | |
verified_storage_providers | BIGINT | Providers with at least one successful verified claim. | |
verified_data_onboarded_tibs | DOUBLE | Verified data successfully claimed, in tebibytes. | |
client_address | VARCHAR | Filecoin client address from DatacapStats. | |
client_name | VARCHAR | Client name from DatacapStats. | |
organization_name | VARCHAR | Organization name from DatacapStats. | |
region | VARCHAR | Region from DatacapStats. | |
industry | VARCHAR | Industry from DatacapStats. | |
website | VARCHAR | Website from DatacapStats. | |
initial_datacap_tibs | DOUBLE | Initial datacap allowance, in tebibytes. | |
current_datacap_tibs | DOUBLE | Current datacap allowance, in tebibytes. | |
allocator_id | VARCHAR | Latest allocator actor id address. | |
allocator_name | VARCHAR | Latest allocator name. | |
deal_count | BIGINT | Deal count from DatacapStats. | |
storage_provider_count | BIGINT | Provider count from DatacapStats. | |
top_storage_provider | VARCHAR | Top provider from DatacapStats. | |
received_datacap_change_tibs | DOUBLE | Received datacap change, in tebibytes. | |
used_datacap_change_tibs | DOUBLE | Used datacap change, in tebibytes. | |
used_datacap_tibs | DOUBLE | Used datacap, in tebibytes. | |
remaining_datacap_tibs | DOUBLE | Remaining datacap, in tebibytes. | |
datacap_issue_created_at | TIMESTAMP WITH TIME ZONE | Datacap issue creation timestamp. | |
datacap_message_created_at | TIMESTAMP WITH TIME ZONE | Datacap message creation timestamp. | |
datacap_retries | BIGINT | DatacapStats retry counter. |
Sample
| client_id | first_claim_at | last_claim_at | verified_claims | verified_storage_providers | verified_data_onboarded_tibs | client_address | client_name | organization_name | region | industry | website | initial_datacap_tibs | current_datacap_tibs | allocator_id | allocator_name | deal_count | storage_provider_count | top_storage_provider | received_datacap_change_tibs | used_datacap_change_tibs | used_datacap_tibs | remaining_datacap_tibs | datacap_issue_created_at | datacap_message_created_at | datacap_retries |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| f03662041 | 2026-04-02 16:00:30 | 2026-07-15 23:59:30 | 31565 | 3 | 986.40625 | f1hwh6vu3xs6rkd4terlahvjuargtsmiy34hztayy | CERNOpen Data Sets | null | United States | Not-for-Profit | None. | 450.0 | 2.40625 | f03016877 | FIL-DC-Allocator | null | null | null | 0.0 | 0.0 | 447.59375 | 2.40625 | null | 2026-04-19 23:48:30+00:00 | 3 |
| f03290418 | 2024-12-28 09:41:00 | 2026-07-15 23:55:00 | 358078 | 32 | 11189.9375 | f1ggl2f2raedzz3kyzsqhtf77djs4zjqphepkb5ha | zhipianbangcom | null | China | Information, Media & Telecommunications | https://www.zhipianbang.com/ | 11744.16 | 1077.0349999999999 | f03012494 | Storify Data Fortress | null | null | null | 0.0 | 0.0 | 10667.125 | 1077.0349999999999 | null | 2026-03-26 15:34:30+00:00 | 3 |
| f03535091 | 2025-05-09 12:11:00 | 2026-07-15 23:54:30 | 262349 | 5 | 8196.3828125 | f3r3tkbr34pcrzj42hy2pc7e4ujpxhrmuohy4bapnommhzmnn7vlyn6e5jb2lqpddsjtitzeicjcm2a4cypspa | null | null | null | null | null | 6095.92 | 3085.4296875 | f03760270 | Ramo Cloud | null | null | null | 0.0 | 0.0 | 3010.4903125 | 3085.4296875 | null | 2026-05-12 15:55:30+00:00 | 3 |
| f03644598 | 2025-09-08 10:15:30 | 2026-07-15 23:51:00 | 11251 | 4 | 351.59375 | f1nplitd46e2m5woeiwlcjqu7kri66hr2rx4sywvi | null | null | null | null | ** https://aurorainfra.ai/ | 410.0 | 66.96875 | f03019298 | datacap-decentralized-onboarding-to-self-selected-sps | null | null | null | 0.0 | 0.0 | 343.03125 | 66.96875 | null | 2025-10-15 11:36:00+00:00 | 3 |
| f03501759 | 2025-03-27 18:04:00 | 2026-07-15 23:47:30 | 356382 | 30 | 11136.9375 | f1a5venknwex7jxd6hkeju7odpjpdj322iqdaw3ba | Xuanse | null | China | Arts & Recreation | http://www.xuanse.net/ | 11264.0 | 2048.09375 | f03012494 | Storify Data Fortress | null | null | null | 0.0 | 0.0 | 9215.90625 | 2048.09375 | null | 2026-03-21 12:33:00+00:00 | 3 |
| f03634927 | 2025-08-10 10:11:00 | 2026-07-15 22:59:30 | 205445 | 15 | 6420.15625 | f16k5n2uqxp3ly5xqnwd6gxyl6xbwzblfau2p3lci | HunanZero Point Realm Media Co., Ltd. | null | China | Information, Media & Telecommunications | http://www.bgyhcm.com/index.html | 6912.0 | 1385.78125 | f03251448 | Yunphant Allocator | null | null | null | 0.0 | 0.0 | 5526.21875 | 1385.78125 | null | 2026-04-16 07:27:30+00:00 | 3 |
| f03630410 | 2025-07-30 14:05:00 | 2026-07-15 13:27:00 | 159 | 8 | 4.96875 | f1egc7pvchnhj6hrgc2woigwqbwv4bar6nz6n3oki | null | null | null | null | https://aurorainfra.ai/ | 10.0 | 5.03125 | f03019298 | datacap-decentralized-onboarding-to-self-selected-sps | null | null | null | 0.0 | 0.0 | 4.96875 | 5.03125 | null | 2025-07-26 08:00:00+00:00 | 3 |
| f03235906 | 2024-11-17 15:35:00 | 2026-07-14 14:11:00 | 141537 | 22 | 4423.03125 | f1zcqp4nfzej54gmv723pc5toccp64r27tnlidcda | CACE | null | China | Construction, Property & Real Estate | http://www.cac-e.com/ | 4438.4 | 470.55624999999964 | f03012494 | Storify Data Fortress | null | null | null | 0.0 | 0.0 | 3967.84375 | 470.55624999999964 | null | 2026-03-05 14:42:00+00:00 | 3 |
| f03495258 | 2025-03-12 11:53:00 | 2026-07-14 14:09:30 | 176886 | 17 | 5527.6875 | f155vmnyxux6o6o7vk243o6oprjxnmf4lkln4yxoi | NationalMicrobiology Data Center | null | China | Life Science / Healthcare | https://nmdc.cn/ | 5548.0 | 5.4375 | f03014781 | Bitengine-Reeta Allocator | null | null | null | 0.0 | 0.0 | 5542.5625 | 5.4375 | null | 2025-09-05 03:37:30+00:00 | 3 |
| f03753456 | 2026-02-17 00:45:00 | 2026-07-12 21:29:00 | 144145 | 4 | 4504.53125 | f1i4i2s26mu3zh2tu34emv4l4evodewpfiyw3bheq | GuangxiShanhai Xingchen Culture Media Co., Ltd. | null | China | Information, Media & Telecommunications | null | 4515.839999999999 | 0.058749999999236024 | f03251444 | Starry Manual Allocator | null | null | null | 0.0 | 0.0 | 4515.78125 | 0.058749999999236024 | null | 2026-02-28 11:04:00+00:00 | 3 |
daily_clients_metrics
Daily metrics for clients.
Columns
| column | type | description | tests |
|---|---|---|---|
date | DATE | UTC claim date. | not_null |
client_id | VARCHAR | Filecoin client actor id address. | not_null |
verified_data_onboarded_tibs | DOUBLE | Verified data claimed on the date, in tebibytes. | not_null |
verified_claims | HUGEINT | Successful verified claims on the date. | not_null |
verified_storage_providers | BIGINT | Providers with at least one successful verified claim on the date. | not_null |
Sample
| date | client_id | verified_data_onboarded_tibs | verified_claims | verified_storage_providers |
|---|---|---|---|---|
| 2026-07-15 | f03535091 | 120.34375 | 3851 | 1 |
| 2026-07-15 | f03290418 | 95.875 | 3068 | 4 |
| 2026-07-15 | f03630410 | 0.0625 | 2 | 2 |
| 2026-07-15 | f03644598 | 0.9375 | 30 | 4 |
| 2026-07-15 | f03501759 | 28.25 | 904 | 1 |
| 2026-07-15 | f03662041 | 17.875 | 572 | 1 |
| 2026-07-15 | f03634927 | 14.375 | 460 | 2 |
| 2026-07-14 | f03535091 | 107.9375 | 3454 | 1 |
| 2026-07-14 | f03495258 | 0.03125 | 1 | 1 |
| 2026-07-14 | f03290418 | 81.28125 | 2601 | 5 |
daily_filecoin_pay_operators_metrics
Daily Filecoin Pay operators metrics.
Columns
| column | type | description | tests |
|---|---|---|---|
date | DATE | UTC date. | not_null |
operator | VARCHAR | Filecoin Pay operator address. | not_null |
active_rails | BIGINT | Active rails at end of day. | not_null |
recurring_rails | BIGINT | Active rails with a positive recurring rate at end of day. | not_null |
eligible_recurring_rails | BIGINT | Active recurring rails counted toward payment run-rate and network fee ARR at end of day. | not_null |
unique_payers | BIGINT | Payers across the operator’s active rails at end of day. | not_null |
unique_payees | BIGINT | Payees across the operator’s active rails at end of day. | not_null |
filecoin_pay_gross_payment_volume_run_rate_usd | DOUBLE | End-of-day annualized gross stablecoin payment volume run-rate from the operator’s active eligible recurring rails. | not_null |
filecoin_pay_network_fee_arr_usd | DOUBLE | End-of-day annualized Filecoin Pay network fee revenue from the operator’s active eligible recurring stablecoin rails. | not_null |
Sample
| date | operator | active_rails | recurring_rails | eligible_recurring_rails | unique_payers | unique_payees | filecoin_pay_gross_payment_volume_run_rate_usd | filecoin_pay_network_fee_arr_usd |
|---|---|---|---|---|---|---|---|---|
| 2026-07-15 | 0xbf93f1f3d5c113983dd8f3486a1923974c727132 | 1 | 0 | 0 | 1 | 1 | 0.0 | 0.0 |
| 2026-07-15 | 0xac405b07220cb8772ef34df0706ab43b66b9ed69 | 1 | 1 | 1 | 1 | 1 | 11.5632 | 0.057816 |
| 2026-07-15 | 0x1fef02fa259a27d5dbd99253bb381635c4717503 | 1 | 1 | 1 | 1 | 1 | 11.5632 | 0.057816 |
| 2026-07-15 | 0x0aa09b68f35042923ff777aa41441450060936ea | 1 | 1 | 1 | 1 | 1 | 463.8541666666666 | 2.319270833333333 |
| 2026-07-15 | 0x261355eab90ed0f9aea99a00470406e48c49bd5c | 1 | 1 | 1 | 1 | 1 | 36.499999999999766 | 0.18249999999999883 |
| 2026-07-15 | 0xa5c2ce72e4355d3bd16cb3060de76a085514e643 | 1 | 1 | 1 | 1 | 1 | 11.5632 | 0.057816 |
| 2026-07-15 | 0x11248aa22d57ede8570c07044901714ba3b1c6cb | 1 | 1 | 1 | 1 | 1 | 1616.8359375 | 8.0841796875 |
| 2026-07-15 | 0x96f1a3026eac5a6c10cd121ef58d3c13d150e441 | 1 | 1 | 1 | 1 | 1 | 46.2528 | 0.231264 |
| 2026-07-15 | 0xe7585412650c57f8b8d0c86ba51e443e3b42576f | 1 | 0 | 0 | 1 | 1 | 0.0 | 0.0 |
| 2026-07-15 | 0xcb71d6e32e12b618f8e0b4dcf36b6a10b5cedc14 | 1 | 0 | 0 | 1 | 1 | 0.0 | 0.0 |
daily_network_metrics
Daily network core metrics.
Columns
| column | type | description | tests |
|---|---|---|---|
date | DATE | UTC date. | not_null, unique |
transactions | HUGEINT | Onchain transactions. | |
onboarded_pibs | DOUBLE | Raw sector data onboarded on the date, in pebibytes. | |
terminated_pibs | DOUBLE | Raw sector data terminated on the date, in pebibytes. | |
expired_pibs | DOUBLE | Raw sector data expired on the date, in pebibytes. | |
removed_pibs | DOUBLE | Raw sector data removed on the date, in pebibytes. | |
raw_power_pibs | DOUBLE | End-of-day raw byte power, in pebibytes. | |
quality_adjusted_power_pibs | DOUBLE | End-of-day quality adjusted power, in pebibytes. | |
storage_providers_with_power | BIGINT | Storage providers with positive end-of-day power. | |
gas_used_millions | DOUBLE | Total gas used, in millions. | |
total_value_fil | DOUBLE | FIL transferred by top-level messages. | |
total_gas_fee_fil | DOUBLE | FIL paid in gas fees. | |
base_fee_burn_fil | DOUBLE | FIL burned by message base fees. | |
base_fee_burn_usd | DOUBLE | FIL burned by message base fees, valued with the daily average FIL price, in USD. | |
overestimation_burn_fil | DOUBLE | FIL burned by gas overestimation. | |
overestimation_burn_usd | DOUBLE | FIL burned by gas overestimation, valued with the daily average FIL price, in USD. | |
message_burn_fil | DOUBLE | FIL burned by message execution. | |
message_burn_usd | DOUBLE | FIL burned by message execution, valued with the daily average FIL price, in USD. | |
miner_tip_fil | DOUBLE | FIL paid to miners as message tips. | |
miner_tip_usd | DOUBLE | FIL paid to miners as message tips, valued with the daily average FIL price, in USD. | |
message_storage_provider_penalty_fil | DOUBLE | FIL penalties incurred by storage providers during message execution. | |
message_storage_provider_penalty_usd | DOUBLE | FIL penalties incurred by storage providers during message execution, valued with the daily average FIL price, in USD. | |
total_value_flow_fil | DOUBLE | FIL value transferred plus gas fees. | |
protocol_revenue_fil | DOUBLE | Total FIL burned. | |
protocol_revenue_usd | DOUBLE | Total FIL burned, valued at average FIL/USD price. | |
circulating_fil | DOUBLE | End-of-day VM circulating supply, in FIL. | |
mined_fil | DOUBLE | End-of-day cumulative mined FIL, in FIL. | |
vested_fil | DOUBLE | End-of-day cumulative vested FIL, in FIL. | |
locked_fil | DOUBLE | End-of-day VM locked FIL, in FIL. | |
burnt_fil | DOUBLE | End-of-day cumulative burned FIL, in FIL. | |
pledge_collateral_fil | DOUBLE | End-of-day total pledge collateral locked by storage providers, in FIL. | |
filecoin_pay_active_payers | BIGINT | Payers with at least one active Filecoin Pay rail at end of day. | |
filecoin_pay_active_rails | BIGINT | Active Filecoin Pay rails at end of day. | |
filecoin_pay_paid_usd | DOUBLE | Gross stablecoin paid through Filecoin Pay rails on the date, assuming tagged stablecoins at $1. | |
active_payers | BIGINT | Payers with at least one active chargeable warm storage dataset. | |
active_datasets | BIGINT | Active chargeable warm storage datasets. | |
new_payers | BIGINT | Payers whose first chargeable warm storage dataset started billing on the date. | |
new_datasets | BIGINT | Warm storage datasets whose billing started on the date. | |
filecoin_pay_gross_payment_volume_run_rate_usd | DOUBLE | End-of-day annualized gross stablecoin payment volume run-rate from active eligible recurring Filecoin Pay rails. | |
filecoin_pay_gross_payment_volume_run_rate_usdfc_usd | DOUBLE | End-of-day annualized gross USDFC payment volume run-rate from active eligible recurring Filecoin Pay rails. | |
filecoin_pay_gross_payment_volume_run_rate_usdc_axl_usd | DOUBLE | End-of-day annualized gross USDC.axl payment volume run-rate from active eligible recurring Filecoin Pay rails. | |
filecoin_pay_network_fee_arr_usd | DOUBLE | End-of-day annualized Filecoin Pay network fee revenue from active eligible recurring stablecoin rails. | |
fil_token_price_avg_usd | DOUBLE | Average FIL price in USD. | |
fil_token_volume_usd | DOUBLE | FIL trading volume in USD. | |
fil_token_market_cap_usd | DOUBLE | FIL market capitalization in USD. | |
verified_data_onboarded_pibs | DOUBLE | Verified data claimed on the date, in pebibytes. | |
verified_claims | HUGEINT | Successful verified claims on the date. | |
verified_clients | BIGINT | Clients with at least one successful verified claim on the date. | |
verified_storage_providers | BIGINT | Providers with at least one successful verified claim on the date. | |
blocks_mined | HUGEINT | Block headers mined on the date. | |
win_count | HUGEINT | Winning proofs recorded on the date. | |
block_rewards_fil | DOUBLE | Exact block rewards minted on the date, in FIL. | |
block_rewards_usd | DOUBLE | Exact block rewards minted on the date, valued with the daily average FIL price, in USD. | |
mining_yield | DOUBLE | Annualized block rewards divided by locked FIL. | |
yearly_inflation_rate | DOUBLE | Year-over-year circulating FIL change. | |
block_rewards_fil_per_qap_tib_day | DOUBLE | Exact block rewards minted on the date per 1 TiB of network quality adjusted power, in FIL. | |
block_rewards_usd_per_qap_tib_day | DOUBLE | Exact block rewards minted on the date per 1 TiB of network quality adjusted power, in USD. | |
reward_per_wincount_fil | DOUBLE | Exact reward allocated per win count on the date, in FIL. | |
annual_pgf_deployments_usd | DOUBLE | Public goods funding deployments disbursed over the trailing 365 days, in USD. | |
annual_protocol_revenue_usd | DOUBLE | Total FIL burned over the trailing 365 days, valued at average FIL/USD price. | |
annual_block_rewards_usd | DOUBLE | Block reward issuance over the trailing 365 days, in USD. | |
revenue_coverage_ratio | DOUBLE | Trailing-365-day protocol revenue divided by annual public goods funding and block reward issuance. |
Sample
| date | transactions | onboarded_pibs | terminated_pibs | expired_pibs | removed_pibs | raw_power_pibs | quality_adjusted_power_pibs | storage_providers_with_power | gas_used_millions | total_value_fil | total_gas_fee_fil | base_fee_burn_fil | base_fee_burn_usd | overestimation_burn_fil | overestimation_burn_usd | message_burn_fil | message_burn_usd | miner_tip_fil | miner_tip_usd | message_storage_provider_penalty_fil | message_storage_provider_penalty_usd | total_value_flow_fil | protocol_revenue_fil | protocol_revenue_usd | circulating_fil | mined_fil | vested_fil | locked_fil | burnt_fil | pledge_collateral_fil | filecoin_pay_active_payers | filecoin_pay_active_rails | filecoin_pay_paid_usd | active_payers | active_datasets | new_payers | new_datasets | filecoin_pay_gross_payment_volume_run_rate_usd | filecoin_pay_gross_payment_volume_run_rate_usdfc_usd | filecoin_pay_gross_payment_volume_run_rate_usdc_axl_usd | filecoin_pay_network_fee_arr_usd | fil_token_price_avg_usd | fil_token_volume_usd | fil_token_market_cap_usd | verified_data_onboarded_pibs | verified_claims | verified_clients | verified_storage_providers | blocks_mined | win_count | block_rewards_fil | block_rewards_usd | mining_yield | block_rewards_fil_per_qap_tib_day | block_rewards_usd_per_qap_tib_day | reward_per_wincount_fil | annual_pgf_deployments_usd | yearly_inflation_rate | annual_protocol_revenue_usd | annual_block_rewards_usd | revenue_coverage_ratio |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2026-07-15 | 40970 | 0.279510498046875 | 2.698394775390625 | 0.7322998046875 | 3.430694580078125 | 1618.1694641113281 | 14394.592103363277 | 588 | 34610688.890023 | 7516694.3730399 | 41.97047266937066 | 33.643392309505884 | 26.494387682603374 | 1.6058988524108255 | 1.264655667995721 | 35.249291161916695 | 27.759043350599082 | 6.721181507453956 | 5.292973636707713 | 0.000327483594963599 | 0.0002578954358953489 | 7516736.34351257 | 15459.75056454231 | 12174.652935268941 | 888774888.0399609 | 404505659.3893577 | 582866314.1543067 | 73127273.90855208 | 42536430.556924835 | 73127273.90855208 | 113 | 749 | 43.6378757576221 | 107 | 516 | 1 | 1 | 9947.05938147786 | 8478.532981477862 | 1468.5263999999997 | 49.735296907389305 | 0.7875064273800186 | 92650765.0174216 | 628468465.087108 | 0.271209716796875 | 8887 | 7 | 13 | 13988 | 14109 | 61070.78864842056 | 48093.638585797875 | 0.30482249187285293 | 0.0041431838853939135 | 0.0032627839395650256 | 4.32849873473815 | 6227833.403262468 | 0.19334441904596633 | 2334656.4204829587 | 38490790.697989136 | 0.05220769796487579 |
| 2026-07-14 | 38481 | 0.286346435546875 | 2.67462158203125 | 0.830322265625 | 3.50494384765625 | 1620.3268127441406 | 14409.370255003014 | 590 | 36073760.71325699 | 6812649.95959319 | 61.84121351916606 | 47.07246954888325 | 35.99173493739679 | 5.2362531181837735 | 4.003653007817579 | 52.30872266706703 | 39.99538794521438 | 9.532490852099041 | 7.288567762216502 | 0.005328709448967501 | 0.004074345363301426 | 6812711.800806709 | 14243.473507181854 | 10890.597582222768 | 888378958.2868407 | 404444588.60070926 | 582679188.5593295 | 73290467.0286112 | 42520970.8063603 | 73290467.0286112 | 112 | 749 | 34.69442478384368 | 106 | 516 | 0 | 0 | 9941.736052222665 | 8473.209652222664 | 1468.5263999999997 | 49.70868026111332 | 0.7646026495385064 | 101830461.02787456 | 610109208.7003484 | 0.279571533203125 | 9161 | 8 | 12 | 14075 | 14183 | 61418.38763269786 | 46960.661914343815 | 0.3058748619678364 | 0.004162492399814037 | 0.0031826527175817087 | 4.330422874758362 | 6227833.403262468 | 0.19351756770822476 | 2326431.500865529 | 38645631.58579967 | 0.051844258102925506 |
| 2026-07-13 | 36915 | 0.322021484375 | 1.850830078125 | 0.40228271484375 | 2.25311279296875 | 1621.0661315917969 | 14413.615607668296 | 593 | 33093995.186671 | 7442659.8189435145 | 52.212339659691146 | 40.76600233240273 | 30.875365680998808 | 3.222248905630667 | 2.4404677325318027 | 43.988251238033406 | 33.31583341353062 | 8.224088421657749 | 6.228762274531943 | 0.001221083130923105 | 0.0009248242662288959 | 7442712.031283175 | 10909.897321808921 | 8262.940933142669 | 887991354.3247588 | 404383170.2130766 | 582492062.9643524 | 73443770.48159036 | 42506727.33285311 | 73443770.48159036 | 112 | 749 | 38.00078835867306 | 106 | 516 | 1 | 1 | 9937.181248210778 | 8468.654848210776 | 1468.5263999999997 | 49.68590624105389 | 0.7573802657725313 | 94402983.90243903 | 604106964.6027875 | 0.3138427734375 | 10284 | 6 | 12 | 14068 | 14191 | 61457.807681295875 | 46546.93071545698 | 0.3054323008824267 | 0.0041639372068334604 | 0.003153683868371658 | 4.33075947299668 | 6227833.403262468 | 0.1937283022047965 | 2318189.444088535 | 38803439.99081133 | 0.05147954453345779 |
| 2026-07-12 | 36347 | 0.336517333984375 | 0.35235595703125 | 1.4591064453125 | 1.81146240234375 | 1623.9431762695312 | 14446.905389975524 | 591 | 25007608.619542994 | 8993200.540397638 | 31.833923805758012 | 24.66453022295267 | 19.215739593812344 | 1.0954752533033334 | 0.8534671858194615 | 25.760005476256 | 20.069206779631802 | 6.073918329502021 | 4.732092274969841 | 2.7223646541165996e-05 | 2.1209506039657754e-05 | 8993232.374321444 | 2635.0178995681513 | 2052.900149544159 | 887641578.6542491 | 404321712.40539527 | 582304937.3693751 | 73555872.64676347 | 42495817.4355313 | 73555872.64676347 | 111 | 750 | 47.731085906908305 | 105 | 515 | 1 | 2 | 9931.943385786579 | 8463.416985786576 | 1468.5263999999997 | 49.659716928932895 | 0.779083948492572 | 83493539.2195122 | 621274722.8815331 | 0.327850341796875 | 10743 | 8 | 11 | 13812 | 13934 | 60395.62592243936 | 47053.26271533439 | 0.2996960360670854 | 0.004082542374840188 | 0.0031806432332787357 | 4.334406912762979 | 6227833.403262468 | 0.1935620627821238 | 2312667.870257732 | 38954348.364081964 | 0.05118539609632619 |
| 2026-07-11 | 34527 | 0.28961181640625 | 0.410369873046875 | 0.39495849609375 | 0.805328369140625 | 1624.8626403808594 | 14448.254316116072 | 591 | 22702966.019306008 | 5038093.817395712 | 28.58907919810772 | 21.973639956574868 | 17.33857713217942 | 0.880128973371767 | 0.6944768423087854 | 22.853768929946632 | 18.033053974488205 | 5.735310268161086 | 4.525518742366439 | 0.00019811405283280296 | 0.00015632438652852374 | 5038122.406474911 | 2364.737457303173 | 1865.925849419258 | 887359247.2595984 | 404261316.7794728 | 582117811.774398 | 73593317.83841416 | 42493182.41763174 | 73593317.83841416 | 110 | 832 | 41.14690357302071 | 104 | 601 | 0 | 2 | 9989.080899385506 | 8520.554499385506 | 1468.5263999999997 | 49.94540449692753 | 0.7890625843712998 | 77727835.4738676 | 629176780.5087107 | 0.28082275390625 | 9202 | 5 | 13 | 13967 | 14088 | 61073.682293357226 | 48190.95758746815 | 0.3029064960221088 | 0.004127991282523291 | 0.003257243469650025 | 4.335156324059996 | 6227833.403262468 | 0.19414895716220154 | 2313510.7274986436 | 39107949.86913123 | 0.0510305670379232 |
| 2026-07-10 | 39183 | 0.22607421875 | 0.069305419921875 | 0.31500244140625 | 0.384307861328125 | 1626.0035400390625 | 14449.146701599268 | 594 | 20267119.821030002 | 10002783.795824256 | 25.024091300682418 | 16.590651751295226 | 13.12911310640341 | 1.010823269136536 | 0.7999211381217715 | 17.60147502043176 | 13.929034244525182 | 7.4226162802506686 | 5.873932510290581 | 0.00044090603954586997 | 0.00034891367435532967 | 10002808.819915557 | 1786.2673660789776 | 1413.5735376217096 | 887115966.5347877 | 404200243.0971795 | 581930686.1794208 | 73590764.02341157 | 42490817.68017443 | 73590764.02341157 | 110 | 870 | 38.82572151393457 | 104 | 634 | 0 | 3 | 10528.620180655067 | 9060.093780655068 | 1468.5263999999997 | 52.64310090327534 | 0.7913560783034594 | 96974127.56097561 | 630921830.9059234 | 0.217620849609375 | 7131 | 7 | 13 | 14030 | 14173 | 61484.212650890535 | 48655.90540098468 | 0.3049531814948356 | 0.004155482510966517 | 0.0032884663433370752 | 4.338122673455905 | 6227833.403262468 | 0.19474394867489433 | 2314925.487950825 | 39264280.87109866 | 0.050886302491671455 |
| 2026-07-09 | 37869 | 0.436614990234375 | 1.243621826171875 | 1.58319091796875 | 2.826812744140625 | 1629.7550354003906 | 14485.928448202321 | 597 | 21539333.60595 | 5652834.582171343 | 26.310252266796706 | 17.796118630464747 | 13.805189881585198 | 0.9690469394014491 | 0.7517300418364669 | 18.765165569866195 | 14.556919923421663 | 7.545086696930511 | 5.853037771159654 | 0.001248822200095408 | 0.0009687633555747916 | 5652860.89242361 | 3813.599655950993 | 2958.3679720265245 | 886870050.0535424 | 404138758.8845286 | 581743560.5844437 | 73589856.96439485 | 42489031.41280835 | 73589856.96439485 | 110 | 867 | 32.07171994147013 | 103 | 633 | 0 | 3 | 10526.195656496087 | 9057.669256496089 | 1468.5263999999997 | 52.63097828248044 | 0.7757416191838835 | 116514892.91608392 | 618376667.979021 | 0.428466796875 | 14040 | 9 | 14 | 14034 | 14172 | 61504.53527310365 | 47711.6277799097 | 0.3050577389428064 | 0.004146301215169539 | 0.0032164584182797222 | 4.339862776820748 | 6227833.403262468 | 0.195531074239814 | 2335782.22146162 | 39411539.28070241 | 0.05117910444641767 |
| 2026-07-08 | 39636 | 0.349700927734375 | 18.825714111328125 | 3.62420654296875 | 22.449920654296875 | 1627.2106018066406 | 14465.13004339239 | 598 | 22614581.393024996 | 7343109.994758965 | 25.592638824784263 | 16.78506143945578 | 12.739976416053636 | 0.870053124097135 | 0.6603762709891323 | 17.65511456355291 | 13.400352687042764 | 7.937524261231342 | 6.024635194497065 | 0.0004866260190360199 | 0.00036935247620743713 | 7343135.5873977905 | 73668.75039402863 | 55915.08532783165 | 886580668.7762543 | 404077254.3492555 | 581556434.9894664 | 73634421.71108869 | 42485217.8131524 | 73634421.71108869 | 110 | 862 | 30.97284559127858 | 103 | 630 | 0 | 5 | 10523.312420925042 | 9054.786020925043 | 1468.5263999999997 | 52.61656210462521 | 0.7590068384323234 | 114066707.91637631 | 604520315.6167247 | 0.341796875 | 11200 | 8 | 14 | 13905 | 14023 | 60892.70661941426 | 46217.98073478863 | 0.3018403268418579 | 0.0041109574286326825 | 0.003120244800836366 | 4.342345191429384 | 6227833.403262468 | 0.19662744225335124 | 2488727.5999418157 | 39550852.04377895 | 0.05436433081550308 |
| 2026-07-07 | 40918 | 0.279266357421875 | 0.490447998046875 | 7.819580078125 | 8.310028076171875 | 1649.521728515625 | 14666.313071554847 | 609 | 20158625.508151 | 6107774.48660739 | 22.549087628235796 | 14.76676948633645 | 11.566485620493683 | 0.7911130770410034 | 0.6196614661213512 | 15.55788256337745 | 12.186147086615032 | 6.9912050648583355 | 5.476057097486957 | 0.00027953347276720196 | 0.00021895241855032487 | 6107797.035695018 | 2270.929953232933 | 1778.7694643382504 | 885356429.2180582 | 404016361.64263606 | 581369309.3944893 | 74684311.71808216 | 42411549.06275837 | 74684311.71808216 | 110 | 857 | 28.76863477669487 | 103 | 625 | 0 | 8 | 10054.857165839094 | 8586.330765839093 | 1468.5263999999997 | 50.27428582919547 | 0.7832779966665046 | 99168852.05226481 | 623160434.3763067 | 0.2786569595336914 | 9132 | 6 | 13 | 13795 | 13904 | 60521.3062826174 | 47405.00754068849 | 0.29578202282350247 | 0.004029836120248098 | 0.0031564819631622497 | 4.352798207898259 | 6227833.403262468 | 0.19544220473601007 | 2436591.9135590657 | 39684938.44603944 | 0.053070024209311895 |
| 2026-07-06 | 46492 | 0.3348388671875 | 3.00030517578125 | 0.9134521484375 | 3.91375732421875 | 1658.3782348632812 | 14745.501017935894 | 609 | 17331639.038032003 | 5350997.516881442 | 19.757188184633215 | 13.010863148794387 | 10.247165696021147 | 1.001406853466272 | 0.7886934048300182 | 14.012270002260657 | 11.035859100851162 | 5.744918182372555 | 4.524613613379765 | 9.4110267412087e-05 | 7.411987143665211e-05 | 5351017.274069626 | 3446.983681490787 | 2714.79397882915 | 884652359.9091069 | 403955840.3363534 | 581182183.7995121 | 75143005.05572703 | 42409278.13280514 | 75143005.05572703 | 110 | 850 | 24.61610650300603 | 103 | 618 | 1 | 5 | 10053.942102923902 | 8585.4157029239 | 1468.5263999999997 | 50.26971051461951 | 0.7875853875974915 | 94727320.03832753 | 626466635.3101045 | 0.3405771255493164 | 11161 | 6 | 14 | 14239 | 14348 | 62517.58883922858 | 49237.93943760445 | 0.30367324156647213 | 0.004140404098616066 | 0.0032609217668187773 | 4.357233679901629 | 6227833.403262468 | 0.19478422042657953 | 2438443.1767256227 | 39819784.83763821 | 0.05295481655465375 |
daily_storage_providers_metrics
Daily metrics for storage providers.
Columns
| column | type | description | tests |
|---|---|---|---|
date | DATE | UTC date. | not_null |
storage_provider_id | VARCHAR | Filecoin storage provider actor id address. | not_null |
raw_power_tibs | DOUBLE | End-of-day raw byte power, in tebibytes. | not_null |
quality_adjusted_power_tibs | DOUBLE | End-of-day quality adjusted power, in tebibytes. | not_null |
onboarded_tibs | DOUBLE | Raw data onboarded on the date, in tebibytes. | not_null |
onboarded_sectors | BIGINT | Sectors onboarded on the date. | not_null |
terminated_tibs | DOUBLE | Raw data terminated on the date, in tebibytes. | not_null |
terminated_sectors | BIGINT | Sectors terminated on the date. | not_null |
expired_tibs | DOUBLE | Raw data expired on the date, in tebibytes. | not_null |
expired_sectors | BIGINT | Sectors expired on the date. | not_null |
removed_tibs | DOUBLE | Raw data removed on the date, in tebibytes. | not_null |
removed_sectors | BIGINT | Sectors removed on the date. | not_null |
verified_data_onboarded_tibs | DOUBLE | Verified data claimed on the date, in tebibytes. | not_null |
verified_claims | HUGEINT | Successful verified claims on the date. | not_null |
verified_clients | BIGINT | Clients with at least one successful verified claim on the date. | not_null |
blocks_mined | BIGINT | Block headers mined by the provider on the date. | not_null |
win_count | BIGINT | Winning proofs recorded by the provider on the date. | not_null |
block_rewards_fil | DOUBLE | Exact block rewards allocated to the provider on the date, in FIL. | not_null |
block_rewards_usd | DOUBLE | Exact block rewards allocated to the provider on the date, valued with the daily average FIL price, in USD. |
Sample
| date | storage_provider_id | raw_power_tibs | quality_adjusted_power_tibs | onboarded_tibs | onboarded_sectors | terminated_tibs | terminated_sectors | expired_tibs | expired_sectors | removed_tibs | removed_sectors | verified_data_onboarded_tibs | verified_claims | verified_clients | blocks_mined | win_count | block_rewards_fil | block_rewards_usd |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2026-07-15 | f01002224 | 276.0625 | 276.0625 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 |
| 2026-07-15 | f0101020 | 430.90625 | 4250.213134765625 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0 | 4 | 4 | 29.579821533759713 | 23.294299578589655 |
| 2026-07-15 | f0101021 | 437.59375 | 4320.603759765625 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0 | 3 | 3 | 9.378317140621022 | 7.3854850262472524 |
| 2026-07-15 | f0101087 | 1223.21875 | 1223.2187883257866 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0 | 2 | 2 | 8.811773999919614 | 6.939328661556832 |
| 2026-07-15 | f01016847 | 226.75 | 2262.47265625 | 0.0 | 0 | 0.0 | 0 | 16.4375 | 526 | 16.4375 | 526 | 0.0 | 0 | 0 | 3 | 3 | 6.4484725092349535 | 5.078213547805882 |
| 2026-07-15 | f01019009 | 249.4375 | 2471.3125 | 0.0 | 0 | 0.0 | 0 | 15.34375 | 491 | 15.34375 | 491 | 0.0 | 0 | 0 | 3 | 3 | 8.800373252601242 | 6.9303504997666785 |
| 2026-07-15 | f01021773 | 1010.0 | 7381.4375 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0 | 4 | 4 | 18.467959098780394 | 14.543636490880857 |
| 2026-07-15 | f01051151 | 60.65625 | 60.65625 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 |
| 2026-07-15 | f01051152 | 70.5625 | 70.5625 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 |
| 2026-07-15 | f01053413 | 203.75 | 2037.5 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0 | 4 | 4 | 20.197110199816706 | 15.905354096858188 |
filecoin_pay_payments
Filecoin Pay payment events.
Columns
| column | type | description | tests |
|---|---|---|---|
date | DATE | UTC event date. | not_null |
event_at | TIMESTAMP WITH TIME ZONE | UTC event timestamp. | not_null |
block_number | BIGINT | Event block number. | not_null |
transaction_hash | VARCHAR | Event transaction hash. | not_null |
event_name | VARCHAR | Payment event name. | not_null |
rail_id | BIGINT | Filecoin Pay rail identifier. | not_null |
payer | VARCHAR | Payer address. | not_null |
payee | VARCHAR | Payee address. | not_null |
operator | VARCHAR | Operator address. | not_null |
service_fee_recipient | VARCHAR | Service fee recipient address. | |
token | VARCHAR | ERC20 token address. | not_null |
token_symbol | VARCHAR | ERC20 token symbol. | |
token_decimals | INTEGER | ERC20 token decimals. | |
is_stablecoin | BOOLEAN | Whether the rail token is a tagged stablecoin. | not_null |
gross_amount | DOUBLE | Gross amount paid, in token units. | |
net_payee_amount | DOUBLE | Net amount credited to the payee, in token units. | |
operator_commission | DOUBLE | Operator commission, in token units. | |
network_fee | DOUBLE | Network fee, in token units. | |
gross_amount_usd | DOUBLE | Gross amount paid in USD for tagged stablecoins. |
Sample
| date | event_at | block_number | transaction_hash | event_name | rail_id | payer | payee | operator | service_fee_recipient | token | token_symbol | token_decimals | is_stablecoin | gross_amount | net_payee_amount | operator_commission | network_fee | gross_amount_usd |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2026-07-15 | 2026-07-15 23:59:30+00:00 | 6195119 | 0xde81378a8b759f2cdc85b07e3c9adbaf50e1842361185c05b18c5fe015d67852 | RailOneTimePaymentProcessed | 2294 | 0x9b68333791834e67db8dd7f95d0ba0d728ae820a | 0x32c90c26bca6ed3945de9b29ba4e19d38314d618 | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x80b98d3aa09ffff255c3ba4a241111ff1262f045 | USDFC | 18 | True | 0.0125 | 0.0124375 | 0.0 | 6.25e-05 | 0.0125 |
| 2026-07-15 | 2026-07-15 23:59:00+00:00 | 6195118 | 0x79bda57fe75e641293a9737df55f86a4020f392de590092505a55658f618b678 | RailOneTimePaymentProcessed | 2294 | 0x9b68333791834e67db8dd7f95d0ba0d728ae820a | 0x32c90c26bca6ed3945de9b29ba4e19d38314d618 | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x80b98d3aa09ffff255c3ba4a241111ff1262f045 | USDFC | 18 | True | 0.0125 | 0.0124375 | 0.0 | 6.25e-05 | 0.0125 |
| 2026-07-15 | 2026-07-15 23:58:00+00:00 | 6195116 | 0x8993fe28c3a6b641f68afc5725e0c854d0820857cbf5d457ccee3384d93e4eca | RailOneTimePaymentProcessed | 2398 | 0xf60c59acdc9925d06e38aa2eb35afb07844a3843 | 0xd2d13ac4cc6d968d404623768c259cae7fa45b07 | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x80b98d3aa09ffff255c3ba4a241111ff1262f045 | USDFC | 18 | True | 0.0125 | 0.0124375 | 0.0 | 6.25e-05 | 0.0125 |
| 2026-07-15 | 2026-07-15 23:57:30+00:00 | 6195115 | 0x1fcb4eaf6373f02d93b04297b4d9fdbcd5191f24a00b2e53629f4695ad517669 | RailOneTimePaymentProcessed | 2375 | 0x1f91dde7f314b93156f5e377dce1a3f440f1a8f3 | 0xd2d13ac4cc6d968d404623768c259cae7fa45b07 | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x80b98d3aa09ffff255c3ba4a241111ff1262f045 | USDFC | 18 | True | 0.0125 | 0.0124375 | 0.0 | 6.25e-05 | 0.0125 |
| 2026-07-15 | 2026-07-15 23:57:30+00:00 | 6195115 | 0xc7a32ac455f2c4346b15f780db317d88b3d0c721eec979798e50029cacbd062b | RailOneTimePaymentProcessed | 2294 | 0x9b68333791834e67db8dd7f95d0ba0d728ae820a | 0x32c90c26bca6ed3945de9b29ba4e19d38314d618 | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x80b98d3aa09ffff255c3ba4a241111ff1262f045 | USDFC | 18 | True | 0.0125 | 0.0124375 | 0.0 | 6.25e-05 | 0.0125 |
| 2026-07-15 | 2026-07-15 23:57:00+00:00 | 6195114 | 0xdc3a181a9f82524d38e7a70469fcaa361aabfee87f9eb4ede97addad0542177e | RailOneTimePaymentProcessed | 2398 | 0xf60c59acdc9925d06e38aa2eb35afb07844a3843 | 0xd2d13ac4cc6d968d404623768c259cae7fa45b07 | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x80b98d3aa09ffff255c3ba4a241111ff1262f045 | USDFC | 18 | True | 0.0125 | 0.0124375 | 0.0 | 6.25e-05 | 0.0125 |
| 2026-07-15 | 2026-07-15 23:56:30+00:00 | 6195113 | 0xda7793b35b02f3f5120f7fc32f5b885579c965a70d294b9b461f6c4445723bf6 | RailOneTimePaymentProcessed | 2375 | 0x1f91dde7f314b93156f5e377dce1a3f440f1a8f3 | 0xd2d13ac4cc6d968d404623768c259cae7fa45b07 | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x80b98d3aa09ffff255c3ba4a241111ff1262f045 | USDFC | 18 | True | 0.0125 | 0.0124375 | 0.0 | 6.25e-05 | 0.0125 |
| 2026-07-15 | 2026-07-15 23:56:00+00:00 | 6195112 | 0x75f9d3a2644d261798183bff50b04e3bfe8dd57a412abe29117870cb47e1c9e7 | RailOneTimePaymentProcessed | 76 | 0xd19d84c77bbb901971e460830e310933a210dbaa | 0x32c90c26bca6ed3945de9b29ba4e19d38314d618 | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x80b98d3aa09ffff255c3ba4a241111ff1262f045 | USDFC | 18 | True | 0.0008 | 0.000796 | 0.0 | 4e-06 | 0.0008 |
| 2026-07-15 | 2026-07-15 23:56:00+00:00 | 6195112 | 0x25e8bdb72d1471d62c0ad14fe6e3e5a20eb69e30b771c290ebc05fd5706852a9 | RailOneTimePaymentProcessed | 2294 | 0x9b68333791834e67db8dd7f95d0ba0d728ae820a | 0x32c90c26bca6ed3945de9b29ba4e19d38314d618 | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x80b98d3aa09ffff255c3ba4a241111ff1262f045 | USDFC | 18 | True | 0.0125 | 0.0124375 | 0.0 | 6.25e-05 | 0.0125 |
| 2026-07-15 | 2026-07-15 23:55:30+00:00 | 6195111 | 0x463f52d4a5d6100063f6ac8d912787429964ff91e879c4a5bdda76f9aa72a678 | RailOneTimePaymentProcessed | 2375 | 0x1f91dde7f314b93156f5e377dce1a3f440f1a8f3 | 0xd2d13ac4cc6d968d404623768c259cae7fa45b07 | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x80b98d3aa09ffff255c3ba4a241111ff1262f045 | USDFC | 18 | True | 0.0125 | 0.0124375 | 0.0 | 6.25e-05 | 0.0125 |
filecoin_pay_rails
Filecoin Pay rails.
Columns
| column | type | description | tests |
|---|---|---|---|
rail_id | BIGINT | Filecoin Pay rail identifier. | |
payer | VARCHAR | Payer address. | |
payee | VARCHAR | Payee address. | |
token | VARCHAR | ERC20 token address. | |
token_symbol | VARCHAR | ERC20 token symbol. | |
token_decimals | INTEGER | ERC20 token decimals. | |
is_stablecoin | BOOLEAN | Whether the rail token is a tagged stablecoin. | |
operator | VARCHAR | Operator address. | |
service | VARCHAR | Service classification. | |
validator | VARCHAR | Validator address. | |
service_fee_recipient | VARCHAR | Service fee recipient address. | |
commission_rate_bps | BIGINT | Commission rate in basis points. | |
is_arr_eligible | BOOLEAN | Whether the rail counts toward ARR. | |
created_block | BIGINT | Creation block number. | |
created_log_index | BIGINT | Creation log index. | |
created_transaction_hash | VARCHAR | Creation transaction hash. | |
created_at | TIMESTAMP WITH TIME ZONE | UTC creation timestamp. | |
terminated_block | BIGINT | Termination block number, if any. | |
terminated_log_index | BIGINT | Termination log index, if any. | |
terminated_transaction_hash | VARCHAR | Termination transaction hash, if any. | |
terminated_by | VARCHAR | Address that terminated the rail, if any. | |
terminated_end_epoch | BIGINT | End epoch emitted on termination, if any. | |
terminated_at | TIMESTAMP WITH TIME ZONE | UTC termination timestamp, if any. | |
terminated_end_at | TIMESTAMP WITH TIME ZONE | UTC termination end timestamp, if any. | |
is_terminated | BOOLEAN | Whether the rail has a termination event. |
Sample
| rail_id | payer | payee | token | token_symbol | token_decimals | is_stablecoin | operator | service | validator | service_fee_recipient | commission_rate_bps | is_arr_eligible | created_block | created_log_index | created_transaction_hash | created_at | terminated_block | terminated_log_index | terminated_transaction_hash | terminated_by | terminated_end_epoch | terminated_at | terminated_end_at | is_terminated |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2410 | 0xf628a52d70f90c3757de5289c33fe4bb588000f2 | 0x89b5899619d93a180d38011b8aec849deea3f573 | 0x80b98d3aa09ffff255c3ba4a241111ff1262f045 | USDFC | 18 | True | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | FWSS | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0 | True | 6194884 | 45 | 0xff7a74ddb901f16f449087e7401e53efc97bce1d0aaa0ff00991e56ca37bc5ed | 2026-07-15 22:02:00+00:00 | null | null | null | null | null | null | null | False |
| 2409 | 0x0a5526faa23c37a40b67ea9e8c15046f70db48b5 | 0x89b5899619d93a180d38011b8aec849deea3f573 | 0x80b98d3aa09ffff255c3ba4a241111ff1262f045 | USDFC | 18 | True | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | FWSS | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0 | True | 6188784 | 76 | 0xbb494561ef56bcc32092ad37bda179431fdeb8bb74b64a526e1a67546ca14fce | 2026-07-13 19:12:00+00:00 | null | null | null | null | null | null | null | False |
| 2408 | 0xc8033e3ee7bffe3a282ddd423a931bb663ee720c | 0x1d60d2f5960af6341e842c539985fa297e10d6ea | 0x80b98d3aa09ffff255c3ba4a241111ff1262f045 | USDFC | 18 | True | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | FWSS | 0x0000000000000000000000000000000000000000 | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0 | True | 6184509 | 52 | 0x6c9173eada1c62faf332f40f34e22bfe1487ecf68f9228c26eb9a9837465f4ea | 2026-07-12 07:34:30+00:00 | null | null | null | null | null | null | null | False |
| 2407 | 0xc8033e3ee7bffe3a282ddd423a931bb663ee720c | 0x32c90c26bca6ed3945de9b29ba4e19d38314d618 | 0x80b98d3aa09ffff255c3ba4a241111ff1262f045 | USDFC | 18 | True | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | FWSS | 0x0000000000000000000000000000000000000000 | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0 | True | 6184509 | 50 | 0x6c9173eada1c62faf332f40f34e22bfe1487ecf68f9228c26eb9a9837465f4ea | 2026-07-12 07:34:30+00:00 | null | null | null | null | null | null | null | False |
| 2406 | 0xc8033e3ee7bffe3a282ddd423a931bb663ee720c | 0x32c90c26bca6ed3945de9b29ba4e19d38314d618 | 0x80b98d3aa09ffff255c3ba4a241111ff1262f045 | USDFC | 18 | True | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | FWSS | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0 | True | 6184509 | 47 | 0x6c9173eada1c62faf332f40f34e22bfe1487ecf68f9228c26eb9a9837465f4ea | 2026-07-12 07:34:30+00:00 | null | null | null | null | null | null | null | False |
| 2404 | 0xc8033e3ee7bffe3a282ddd423a931bb663ee720c | 0x010ecc2436e0c5ea4741cd25a27a5476fe7a252c | 0x80b98d3aa09ffff255c3ba4a241111ff1262f045 | USDFC | 18 | True | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | FWSS | 0x0000000000000000000000000000000000000000 | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0 | True | 6184493 | 56 | 0x0b4143b389a4f78e1c71b1a6a2f3dadcfcda35d20a129eb18d4b3faecabe4597 | 2026-07-12 07:26:30+00:00 | null | null | null | null | null | null | null | False |
| 2405 | 0xc8033e3ee7bffe3a282ddd423a931bb663ee720c | 0x1d60d2f5960af6341e842c539985fa297e10d6ea | 0x80b98d3aa09ffff255c3ba4a241111ff1262f045 | USDFC | 18 | True | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | FWSS | 0x0000000000000000000000000000000000000000 | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0 | True | 6184493 | 58 | 0x0b4143b389a4f78e1c71b1a6a2f3dadcfcda35d20a129eb18d4b3faecabe4597 | 2026-07-12 07:26:30+00:00 | null | null | null | null | null | null | null | False |
| 2403 | 0xc8033e3ee7bffe3a282ddd423a931bb663ee720c | 0x010ecc2436e0c5ea4741cd25a27a5476fe7a252c | 0x80b98d3aa09ffff255c3ba4a241111ff1262f045 | USDFC | 18 | True | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | FWSS | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0 | True | 6184493 | 53 | 0x0b4143b389a4f78e1c71b1a6a2f3dadcfcda35d20a129eb18d4b3faecabe4597 | 2026-07-12 07:26:30+00:00 | null | null | null | null | null | null | null | False |
| 2402 | 0x934e20411c9e8e92946bd8786d7c3e5bc4db1387 | 0xd2d13ac4cc6d968d404623768c259cae7fa45b07 | 0x80b98d3aa09ffff255c3ba4a241111ff1262f045 | USDFC | 18 | True | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | FWSS | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0 | True | 6183108 | 48 | 0x8025bfe5a80b1e27f1692c00ec8160d0e1758446fe303f5afbfb138665da3230 | 2026-07-11 19:54:00+00:00 | null | null | null | null | null | null | null | False |
| 2401 | 0x934e20411c9e8e92946bd8786d7c3e5bc4db1387 | 0x6c8e9ce0a324ec85de5ba9147909b289d56bd796 | 0x80b98d3aa09ffff255c3ba4a241111ff1262f045 | USDFC | 18 | True | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | FWSS | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0 | True | 6183089 | 10 | 0xb146a54dbb78756d157b6b11c016d9a852fd02ef6430d4b35de02a2dcb41cdb1 | 2026-07-11 19:44:30+00:00 | null | null | null | null | null | null | null | False |
pdp_service_providers
PDP service providers.
Columns
| column | type | description | tests |
|---|---|---|---|
service_provider_id | BIGINT | Service provider registry identifier. | not_null, unique |
service_provider_address | VARCHAR | Provider control address. | |
payee | VARCHAR | Payee address. | |
is_registered | BOOLEAN | Whether the provider has a registration event. | |
is_removed | BOOLEAN | Whether the provider has a removal event. | |
is_active | BOOLEAN | Whether the provider is active based on registry and PDP product state. | |
product_type | VARCHAR | Latest PDP product type label. | |
offers_pdp_storage | BOOLEAN | Whether the latest PDP product event indicates an active PDP offering. | |
service_url | VARCHAR | Service endpoint URL decoded from capabilities. | |
location | VARCHAR | Provider location decoded from capabilities. | |
location_country_code | VARCHAR | Country code parsed from the location DN. | |
location_region | VARCHAR | State or region parsed from the location DN. | |
location_city | VARCHAR | City parsed from the location DN. | |
payment_token_address | VARCHAR | Payment token address from capabilities. | |
min_piece_size_bytes | BIGINT | Minimum supported piece size, in bytes. | |
max_piece_size_bytes | BIGINT | Maximum supported piece size, in bytes. | |
storage_price_per_tib_per_day | BIGINT | Storage price per TiB per day in token base units. | |
min_proving_period_epochs | BIGINT | Minimum proving period, in epochs. | |
supports_ipni_piece | BOOLEAN | Whether IPNI piece support is declared. | |
supports_ipni_ipfs | BOOLEAN | Whether IPNI IPFS support is declared. | |
ipni_peer_id_hex | VARCHAR | Raw hex-encoded IPNI peer id. | |
capacity_tib_text | VARCHAR | Capacity text from extra capabilities, if any. | |
capacity_tib | DOUBLE | Parsed numeric capacity, in TiB, if any. | |
service_status | VARCHAR | Service status from extra capabilities, if any. | |
capabilities_json | JSON | Latest active PDP capability key-value pairs. | |
registered_block | BIGINT | Registration block number. | |
registered_transaction_hash | VARCHAR | Registration transaction hash. | |
registered_at | TIMESTAMP WITH TIME ZONE | UTC registration timestamp. | |
product_updated_block | BIGINT | Latest PDP product lifecycle block. | |
product_updated_transaction_hash | VARCHAR | Latest PDP product lifecycle transaction hash. | |
product_updated_at | TIMESTAMP WITH TIME ZONE | UTC latest PDP product lifecycle timestamp. | |
is_fwss_approved | BOOLEAN | Whether the latest FWSS approval event is approved. | |
fwss_first_approved_block | BIGINT | First FWSS approval block, if any. | |
fwss_first_approved_at | TIMESTAMP WITH TIME ZONE | UTC first FWSS approval timestamp, if any. | |
fwss_last_approval_block | BIGINT | Latest FWSS approval block, if any. | |
fwss_last_approval_transaction_hash | VARCHAR | Latest FWSS approval transaction hash, if any. | |
fwss_last_approval_at | TIMESTAMP WITH TIME ZONE | UTC latest FWSS approval timestamp, if any. |
Sample
| service_provider_id | service_provider_address | payee | is_registered | is_removed | is_active | product_type | offers_pdp_storage | service_url | location | location_country_code | location_region | location_city | payment_token_address | min_piece_size_bytes | max_piece_size_bytes | storage_price_per_tib_per_day | min_proving_period_epochs | supports_ipni_piece | supports_ipni_ipfs | ipni_peer_id_hex | capacity_tib_text | capacity_tib | service_status | capabilities_json | registered_block | registered_transaction_hash | registered_at | product_updated_block | product_updated_transaction_hash | product_updated_at | is_fwss_approved | fwss_first_approved_block | fwss_first_approved_at | fwss_last_approval_block | fwss_last_approval_transaction_hash | fwss_last_approval_at |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18 | 0x4de3d41c4fc6a80c9a5c908f3c6f4e48975637fd | 0x4de3d41c4fc6a80c9a5c908f3c6f4e48975637fd | True | False | True | PDP | True | https://storacha.network | earth | null | null | null | 0x4de3d41c4fc6a80c9a5c908f3c6f4e48975637fd | 1 | 1 | 1 | 1 | null | null | null | null | null | null | {paymentTokenAddress:0x4de3d41c4fc6a80c9a5c908f3c6f4e48975637fd,location:0x6561727468,minProvingPeriodInEpochs:0x01,storagePricePerTibPerDay:0x01,maxPieceSizeInBytes:0x01,minPieceSizeInBytes:0x01,serviceURL:0x68747470733a2f2f73746f72616368612e6e6574776f726b} | 5535714 | 0x5327e820ed39045e15c47fc11903e69b7da122aae06cfe0e968f8842aaada2c6 | 2025-11-29 00:57:00+00:00 | 5535714 | 0x5327e820ed39045e15c47fc11903e69b7da122aae06cfe0e968f8842aaada2c6 | 2025-11-29 00:57:00+00:00 | False | null | null | null | null | null |
| 29 | 0x4a30c03e35bde301c361cd66fa01a25cf542ebc5 | 0x4a30c03e35bde301c361cd66fa01a25cf542ebc5 | True | False | True | PDP | True | https://sp.reiers.io | C=NO;ST=Viken;L=Drammen | NO | Viken | Drammen | 0x80b98d3aa09ffff255c3ba4a241111ff1262f045 | 1048576 | 68719476736 | 83333333333333333 | 1440 | True | True | 0x002408011220dab53646cc1648db7c9b0fdc047c159c4fcc1a99c536e23c9dcdb20e0096e0a7 | null | null | null | {IPNIPeerID:0x002408011220dab53646cc1648db7c9b0fdc047c159c4fcc1a99c536e23c9dcdb20e0096e0a7,ipniPeerId:0x002408011220dab53646cc1648db7c9b0fdc047c159c4fcc1a99c536e23c9dcdb20e0096e0a7,ipniIpfs:0x01,ipniPiece:0x01,paymentTokenAddress:0x80b98d3aa09ffff255c3ba4a241111ff1262f045,location:0x433d4e4f3b53543d56696b656e3b4c3d4472616d6d656e,minProvingPeriodInEpochs:0x05a0,storagePricePerTibPerDay:0x01280f39a3485555,maxPieceSizeInBytes:0x1000000000,minPieceSizeInBytes:0x100000,serviceURL:0x68747470733a2f2f73702e7265696572732e696f} | 6015864 | 0x3e5aea216e13e74b788b90795475c2400180837b29d0fc592cfbbebcd1a383ef | 2026-05-14 18:12:00+00:00 | 6015864 | 0x3e5aea216e13e74b788b90795475c2400180837b29d0fc592cfbbebcd1a383ef | 2026-05-14 18:12:00+00:00 | False | null | null | null | null | null |
| 28 | 0x4a30c03e35bde301c361cd66fa01a25cf542ebc5 | 0x4a30c03e35bde301c361cd66fa01a25cf542ebc5 | True | True | False | PDP | True | https: | C=NO | NO | null | null | 0x80b98d3aa09ffff255c3ba4a241111ff1262f045 | 1048576 | 68719476736 | 83333333333333333 | 1440 | True | True | 0x002408011220dab53646cc1648db7c9b0fdc047c159c4fcc1a99c536e23c9dcdb20e0096e0a7 | null | null | null | {IPNIPeerID:0x002408011220dab53646cc1648db7c9b0fdc047c159c4fcc1a99c536e23c9dcdb20e0096e0a7,ipniPeerId:0x002408011220dab53646cc1648db7c9b0fdc047c159c4fcc1a99c536e23c9dcdb20e0096e0a7,ipniIpfs:0x01,ipniPiece:0x01,paymentTokenAddress:0x80b98d3aa09ffff255c3ba4a241111ff1262f045,location:0x433d4e4f,minProvingPeriodInEpochs:0x05a0,storagePricePerTibPerDay:0x01280f39a3485555,maxPieceSizeInBytes:0x1000000000,minPieceSizeInBytes:0x100000,serviceURL:0x68747470733a} | 5994847 | 0x117bff8749e42d47e07964e0e94991311e47c54b0d1f61d9033a9b3bc9754d46 | 2026-05-07 11:03:30+00:00 | 5994847 | 0x117bff8749e42d47e07964e0e94991311e47c54b0d1f61d9033a9b3bc9754d46 | 2026-05-07 11:03:30+00:00 | False | null | null | null | null | null |
| 10 | 0x74075b4a9e00304c2dddbae4a76399830c917544 | 0x74075b4a9e00304c2dddbae4a76399830c917544 | True | False | True | PDP | True | https://mokanla.meje.dev | C=NG;ST=Lagos;L=Lagos | NG | Lagos | Lagos | 0x0000000000000000000000000000000000000000 | 1048576 | 1073741824 | 83333333333333330 | 30 | True | True | 0x00240801122024a43e835a090adfcdcb65b95c6f934a345e4e206562f66888faeccc1ae98111 | 1 | 1.0 | testing | {capacityTib:0x31,serviceStatus:0x74657374696e67,IPNIPeerID:0x00240801122024a43e835a090adfcdcb65b95c6f934a345e4e206562f66888faeccc1ae98111,ipniIpfs:0x01,ipniPiece:0x01,paymentTokenAddress:0x0000000000000000000000000000000000000000,location:0x433d4e473b53543d4c61676f733b4c3d4c61676f73,minProvingPeriodInEpochs:0x1e,storagePricePerTibPerDay:0x01280f39a3485552,maxPieceSizeInBytes:0x40000000,minPieceSizeInBytes:0x100000,serviceURL:0x68747470733a2f2f6d6f6b616e6c612e6d656a652e646576} | 5488948 | 0x133bec4c34cd4566d5771fd25770e311ec5ab325ead44842026558828e37150a | 2025-11-12 19:14:00+00:00 | 5724256 | 0x92b0a31ad528d5ca5078c4eaf64a8e92440e7ceea67eaba4bc5e24d914e9f494 | 2026-02-02 12:08:00+00:00 | False | null | null | null | null | null |
| 2 | 0x86d026029052c6582d277d9b28700edc9670b150 | 0x86d026029052c6582d277d9b28700edc9670b150 | True | False | True | PDP | True | https://pdp-main.660688.xyz:8443 | C=CN;ST=Zhejiang;L=Hangzhou | CN | Zhejiang | Hangzhou | 0x0000000000000000000000000000000000000000 | 1048576 | 1073741824 | 83333333333333330 | 30 | True | True | 0x002408011220b45c4247d808f10ebfa3532764d0dd5893524bc91108c8486ba7b9b9195eee8c | 12 | 12.0 | prod | {capacityTib:0x3132,serviceStatus:0x70726f64,IPNIPeerID:0x002408011220b45c4247d808f10ebfa3532764d0dd5893524bc91108c8486ba7b9b9195eee8c,ipniPeerId:0x002408011220b45c4247d808f10ebfa3532764d0dd5893524bc91108c8486ba7b9b9195eee8c,ipniIpfs:0x01,ipniPiece:0x01,paymentTokenAddress:0x0000000000000000000000000000000000000000,location:0x433d434e3b53543d5a68656a69616e673b4c3d48616e677a686f75,minProvingPeriodInEpochs:0x1e,storagePricePerTibPerDay:0x01280f39a3485552,maxPieceSizeInBytes:0x40000000,minPieceSizeInBytes:0x100000,serviceURL:0x68747470733a2f2f7064702d6d61696e2e3636303638382e78797a3a38343433} | 5476431 | 0xe4e00123e5b0c83a1272ad9358108adb614b1c0c1706f394e080ca0671424f81 | 2025-11-08 10:55:30+00:00 | 5874396 | 0x49bcc4b898aee83edb8d878c56a4cb03aa16570989e734377e4e8739dd1b7d7e | 2026-03-26 15:18:00+00:00 | False | null | null | null | null | null |
| 4 | 0x67b8a4df8afb983d24646ad7c3035e58be5cdffe | 0x67b8a4df8afb983d24646ad7c3035e58be5cdffe | True | False | True | PDP | True | http://pdp.tigerteches.org:5521 | C=CN;ST=California;L=San Francisco | CN | California | San Francisco | 0x0000000000000000000000000000000000000000 | 1048576 | 1073741824 | 833000000000000000 | 30 | True | True | 0x0024080112203276426764730c2eda8660ef8caaeaca459120328bd8ff13593c6ab7ed911d82 | 10 | 10.0 | testing | {serviceStatus:0x74657374696e67,capacityTib:0x3130,IPNIPeerID:0x0024080112203276426764730c2eda8660ef8caaeaca459120328bd8ff13593c6ab7ed911d82,ipniIpfs:0x01,ipniPiece:0x01,paymentTokenAddress:0x0000000000000000000000000000000000000000,location:0x433d434e3b53543d43616c69666f726e69613b4c3d53616e204672616e636973636f,minProvingPeriodInEpochs:0x1e,storagePricePerTibPerDay:0x0b8f691629e68000,maxPieceSizeInBytes:0x40000000,minPieceSizeInBytes:0x100000,serviceURL:0x687474703a2f2f7064702e74696765727465636865732e6f72673a35353231} | 5479238 | 0x8713f4aa6212dd0da518e4ccaf95976cbb858160f30890fbd72677c01478f7c4 | 2025-11-09 10:19:00+00:00 | 5505746 | 0xe0a17c2dee0eae922ad531da53f9e0a145dd438ee8c41e87d94dfd87629167b5 | 2025-11-18 15:13:00+00:00 | False | null | null | null | null | null |
| 20 | 0xc1aba8ce560ad630c5a640cc4ec8a434327616d9 | 0xc1aba8ce560ad630c5a640cc4ec8a434327616d9 | True | False | True | PDP | True | https://storacha.network | earth | null | null | null | 0xc1aba8ce560ad630c5a640cc4ec8a434327616d9 | 1 | 1 | 1 | 1 | null | null | null | null | null | null | {paymentTokenAddress:0xc1aba8ce560ad630c5a640cc4ec8a434327616d9,location:0x6561727468,minProvingPeriodInEpochs:0x01,storagePricePerTibPerDay:0x01,maxPieceSizeInBytes:0x01,minPieceSizeInBytes:0x01,serviceURL:0x68747470733a2f2f73746f72616368612e6e6574776f726b} | 5537693 | 0x24ebe319f569b6b5e5d17536d64f340eddc3725e15010a954376c866c69cd7d5 | 2025-11-29 17:26:30+00:00 | 5537693 | 0x24ebe319f569b6b5e5d17536d64f340eddc3725e15010a954376c866c69cd7d5 | 2025-11-29 17:26:30+00:00 | False | null | null | null | null | null |
| 24 | 0x55bc49caca448bb810710edbf5cec721ff8ebad2 | 0x55bc49caca448bb810710edbf5cec721ff8ebad2 | True | False | True | PDP | True | https://storacha.network | earth | null | null | null | 0x55bc49caca448bb810710edbf5cec721ff8ebad2 | 1 | 1 | 1 | 1 | null | null | null | null | null | null | {paymentTokenAddress:0x55bc49caca448bb810710edbf5cec721ff8ebad2,location:0x6561727468,minProvingPeriodInEpochs:0x01,storagePricePerTibPerDay:0x01,maxPieceSizeInBytes:0x01,minPieceSizeInBytes:0x01,serviceURL:0x68747470733a2f2f73746f72616368612e6e6574776f726b} | 5548350 | 0xb01d27cf170c58e2d4131ad7dc2d367f81e05946bbbd48f5622065b2e38c7129 | 2025-12-03 10:15:00+00:00 | 5548350 | 0xb01d27cf170c58e2d4131ad7dc2d367f81e05946bbbd48f5622065b2e38c7129 | 2025-12-03 10:15:00+00:00 | False | null | null | null | null | null |
| 3 | 0xafd1f948e8aef14c0b39058aa2fcff4ecb7c585d | 0xafd1f948e8aef14c0b39058aa2fcff4ecb7c585d | True | False | True | PDP | True | https://pdp-main.filweb3.com | C=CA;ST=British Columbia;L=Vancouver | CA | British Columbia | Vancouver | 0x0000000000000000000000000000000000000000 | 1048576 | 1073741824 | 833000000000000000 | 30 | True | True | 0x002408011220efcf5c0b85e29a71933bca3d2f4c99a420d01ff904e026f8457fdc639c343614 | 200 | 200.0 | testing | {capacityTib:0x323030,serviceStatus:0x74657374696e67,IPNIPeerID:0x002408011220efcf5c0b85e29a71933bca3d2f4c99a420d01ff904e026f8457fdc639c343614,ipniIpfs:0x01,ipniPiece:0x01,paymentTokenAddress:0x0000000000000000000000000000000000000000,location:0x433d43413b53543d4272697469736820436f6c756d6269613b4c3d56616e636f75766572,minProvingPeriodInEpochs:0x1e,storagePricePerTibPerDay:0x0b8f691629e68000,maxPieceSizeInBytes:0x40000000,minPieceSizeInBytes:0x100000,serviceURL:0x68747470733a2f2f7064702d6d61696e2e66696c776562332e636f6d} | 5478647 | 0x223cd6183ccc6b50dd95d2082122c58143de436773de1af41b2566aae7662fef | 2025-11-09 05:23:30+00:00 | 5478656 | 0xcf9a68285b56c8c65c03b6f1ea258c83bb73eacc921288c90ce06c82b51af563 | 2025-11-09 05:28:00+00:00 | False | null | null | null | null | null |
| 23 | 0x3de6c9f2a3b1009f18431f6124009a6d12ff3537 | 0x3de6c9f2a3b1009f18431f6124009a6d12ff3537 | True | False | True | PDP | True | https://storacha.network | earth | null | null | null | 0x3de6c9f2a3b1009f18431f6124009a6d12ff3537 | 1 | 1 | 1 | 1 | null | null | null | null | null | null | {paymentTokenAddress:0x3de6c9f2a3b1009f18431f6124009a6d12ff3537,location:0x6561727468,minProvingPeriodInEpochs:0x01,storagePricePerTibPerDay:0x01,maxPieceSizeInBytes:0x01,minPieceSizeInBytes:0x01,serviceURL:0x68747470733a2f2f73746f72616368612e6e6574776f726b} | 5545887 | 0x12ab8add29da8682ddf9f1b2b519eeecdebd0c4c8d0527f16cf8f3f1cb9fc166 | 2025-12-02 13:43:30+00:00 | 5545887 | 0x12ab8add29da8682ddf9f1b2b519eeecdebd0c4c8d0527f16cf8f3f1cb9fc166 | 2025-12-02 13:43:30+00:00 | False | null | null | null | null | null |
storage_providers
Filecoin storage providers metrics and latest details.
Columns
| column | type | description | tests |
|---|---|---|---|
storage_provider_id | VARCHAR | Filecoin storage provider actor id address. | not_null, unique |
owner_id | VARCHAR | Current owner actor id address. | |
worker_id | VARCHAR | Current worker actor id address. | |
beneficiary_id | VARCHAR | Current beneficiary actor id address. | |
peer_id | VARCHAR | Current libp2p peer id. | |
control_addresses | VARCHAR | Current JSON array of control addresses. | |
multi_addresses | VARCHAR | Current JSON array of multiaddrs. | |
sector_size | BIGINT | Current sector size in bytes. | |
live_sectors | BIGINT | Current live sector count. | |
active_sectors | BIGINT | Current active sector count. | |
faulty_sectors | BIGINT | Current faulty sector count. | |
actor_balance_fil | DOUBLE | Current storage provider actor balance, in FIL. | |
available_balance_fil | DOUBLE | Current available storage provider balance, in FIL. | |
market_escrow_fil | DOUBLE | Current market escrow balance, in FIL. | |
market_locked_fil | DOUBLE | Current market locked balance, in FIL. | |
market_available_fil | DOUBLE | Current market available balance, in FIL. | |
initial_pledge_fil | DOUBLE | Current initial pledge, in FIL. | |
locked_funds_fil | DOUBLE | Current locked funds, in FIL. | |
pre_commit_deposits_fil | DOUBLE | Current pre-commit deposits, in FIL. | |
fee_debt_fil | DOUBLE | Current fee debt, in FIL. | |
raw_power_tibs | DOUBLE | Current raw byte power, in tebibytes. | |
quality_adjusted_power_tibs | DOUBLE | Current quality adjusted power, in tebibytes. | |
has_power | BOOLEAN | Whether the provider currently has positive power. | not_null |
has_sector_activity | BOOLEAN | Whether the provider has sector lifecycle activity. | not_null |
has_verified_claims | BOOLEAN | Whether the provider has successful verified claims. | not_null |
has_market_deals | BOOLEAN | Whether the provider has market deal activity. | not_null |
first_sector_activity_date | DATE | First date with sector lifecycle activity. | |
last_sector_activity_date | DATE | Most recent date with sector lifecycle activity. | |
first_verified_claim_at | TIMESTAMP | First successful verified claim timestamp. | |
last_verified_claim_at | TIMESTAMP | Most recent successful verified claim timestamp. | |
first_market_deal_start_at | TIMESTAMP WITH TIME ZONE | First observed market deal start timestamp. | |
last_market_deal_start_at | TIMESTAMP WITH TIME ZONE | Most recent market deal start timestamp. | |
verified_claims | BIGINT | Total successful verified claims. | |
verified_clients | BIGINT | Clients with at least one successful verified claim. | |
verified_data_onboarded_tibs | DOUBLE | Verified data successfully claimed, in tebibytes. | |
total_block_rewards_fil | DOUBLE | Total block rewards allocated to the provider, in FIL. |
Sample
| storage_provider_id | owner_id | worker_id | beneficiary_id | peer_id | control_addresses | multi_addresses | sector_size | live_sectors | active_sectors | faulty_sectors | actor_balance_fil | available_balance_fil | market_escrow_fil | market_locked_fil | market_available_fil | initial_pledge_fil | locked_funds_fil | pre_commit_deposits_fil | fee_debt_fil | raw_power_tibs | quality_adjusted_power_tibs | has_power | has_sector_activity | has_verified_claims | has_market_deals | first_sector_activity_date | last_sector_activity_date | first_verified_claim_at | last_verified_claim_at | first_market_deal_start_at | last_market_deal_start_at | verified_claims | verified_clients | verified_data_onboarded_tibs | total_block_rewards_fil |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| f01904546 | f03066523 | f01813570 | f03066523 | 12D3KooWJmosyoJmjmwbEGzqwfuAJPJ8LcE2NE1tj4vyHu41WUbS | [f01813572] | [/dns/retrieval.simpleipfs.com/tcp/443/wss] | 34359738368 | 89964 | 89408 | 0 | 170882.05546599196 | 684.8922502163468 | 583.9642342792275 | 582.8658268236143 | 1.0984074556132555 | 163966.34890235058 | 6216.882887853675 | 13.931425571350816 | 0.0 | 2770.96875 | 27577.359375 | True | True | True | True | 2022-08-18 | 2026-07-15 | 2026-07-04 13:43:30 | 2026-07-15 23:59:30 | 2023-12-20 02:56:00+00:00 | 2024-06-05 05:24:30+00:00 | 13362 | 1 | 417.5625 | 80452.1283252341 |
| f01082688 | f03338164 | f03759652 | f03338164 | 12D3KooWNZ1bNnLikm84dXC4oSWcBX9TEPUAV7Bx2PUpryWmWv8a | [f03759649] | [/dns/f01081439.44943.com/tcp/443/wss] | 34359738368 | 60008 | 59643 | 0 | 170813.79340987862 | 50045.8656353017 | 200.0 | 149.69115505723778 | 50.30884494276222 | 119134.10748427908 | 1631.857157934665 | 1.9631323631706397 | 0.0 | 1569.09375 | 15690.9375 | True | True | True | True | 2026-05-05 | 2026-07-15 | 2026-05-05 20:33:30 | 2026-07-15 23:55:00 | 2026-06-03 15:15:30+00:00 | 2026-08-13 04:25:30+00:00 | 59643 | 5 | 1863.84375 | 2578.2748887016596 |
| f03780816 | f03200943 | f03741652 | f03286739 | QmQSH8CqPJZnXUSHNqiEHGiUoqQikPPCamExmw1gAgTjis | null | null | 34359738368 | 92152 | 91113 | 0 | 201351.97483560082 | 11352.086096682537 | 0.0 | 0.0 | 0.0 | 188668.11476713364 | 942.3801443818695 | 389.39382740279035 | 0.0 | 2742.125 | 27403.671875 | True | True | True | False | 2026-05-19 | 2026-07-15 | 2026-05-19 15:20:30 | 2026-07-15 23:54:30 | null | null | 89607 | 1 | 2798.265625 | 1542.6426812627171 |
| f03644166 | f03632590 | f03644164 | f03632590 | 12D3KooWQKTq2derMYzNrRhwZsrRRCc47GLkX1WS2hvbq3oFbdct | [f03644171, f03644172, f03644173, f03644174, f03644175, f03644176] | [/dns/a-fil-http.aur.lu/tcp/443/wss] | 34359738368 | 72405 | 72405 | 0 | 114216.55404906429 | 12273.14672399217 | 194.30476979588443 | 165.85556445396665 | 28.449205341917775 | 97796.00593745353 | 4147.4013876185845 | 0.0 | 0.0 | 2262.65625 | 18082.6875 | True | True | True | True | 2025-10-08 | 2025-11-23 | 2025-10-10 12:40:00 | 2026-07-15 23:51:00 | 2025-10-12 11:55:00+00:00 | 2026-07-18 23:36:30+00:00 | 56252 | 6 | 1757.8125 | 10683.213773637928 |
| f03623016 | f03632590 | f03622984 | f03632590 | 12D3KooWQKTq2derMYzNrRhwZsrRRCc47GLkX1WS2hvbq3oFbdct | [f03622996, f03622993, f03622986, f03622991, f03622992, f03622987] | [/dns/a-fil-http.aur.lu/tcp/443/wss] | 34359738368 | 302138 | 302138 | 0 | 491778.7013092883 | 21107.704354446978 | 914.113729230977 | 839.6952031466329 | 74.41852608434408 | 452862.0444363064 | 17808.952518534934 | 0.0 | 0.0 | 9441.8125 | 86862.0625 | True | True | True | True | 2025-07-31 | 2026-07-02 | 2025-08-20 11:25:00 | 2026-07-15 23:50:30 | 2025-08-24 10:23:00+00:00 | 2026-07-19 13:12:00+00:00 | 275272 | 8 | 8602.1875 | 58695.99778363398 |
| f01084868 | f03338164 | f03759653 | f03338164 | 12D3KooWLGAZMarHVML2KUtY7Hf5H5pfNhXWqCcypqPUYuDeBVFc | [f03759650] | [/dns/f01084868.44943.com/tcp/443/wss] | 34359738368 | 115349 | 114926 | 25 | 265640.374929078 | 34576.78172563263 | 499.86194691193623 | 289.4415579822305 | 210.42038892970572 | 227330.75117967676 | 3728.1270599911772 | 4.714963777438098 | 0.0 | 3536.8125 | 35367.5625 | True | True | True | True | 2026-04-19 | 2026-07-15 | 2026-04-19 15:24:00 | 2026-07-15 23:50:00 | 2026-05-19 09:45:30+00:00 | 2026-08-11 21:23:30+00:00 | 114263 | 7 | 3570.71875 | 5756.074566932444 |
| f03623017 | f03632590 | f03622985 | f03632590 | 12D3KooWJLEqAUExUULbfFagCDXwTVabndyVcr3LnvkA8SmYr1Hv | [f03622994, f03622995, f03622988, f03622989, f03622990, f03622997] | [/dns/p-fil-http.aur.lu/tcp/443/wss] | 34359738368 | 29696 | 29696 | 0 | 24630.621204980274 | 12594.723955636155 | 20.8890923535557 | 16.217904188308133 | 4.6711881652475675 | 11424.718570274319 | 611.178679069799 | 0.0 | 0.0 | 928.0 | 2375.875 | True | True | True | True | 2025-07-31 | 2025-08-20 | 2025-08-25 16:03:30 | 2026-07-15 23:50:00 | 2025-08-29 11:29:00+00:00 | 2026-07-19 13:12:00+00:00 | 5148 | 5 | 160.875 | 2326.476089812442 |
| f01081439 | f03338164 | f03759651 | f03338164 | 12D3KooWNZ1bNnLikm84dXC4oSWcBX9TEPUAV7Bx2PUpryWmWv8a | [f03759648] | [/dns/f01081439.44943.com/tcp/443/wss] | 34359738368 | 65663 | 64827 | 0 | 172714.24351691967 | 40943.69656739005 | 299.9636041188874 | 164.33318032422034 | 135.63042379466708 | 129933.31577426029 | 1835.3214912440935 | 1.909684025215901 | 0.0 | 2025.84375 | 20258.4375 | True | True | True | True | 2026-04-16 | 2026-07-15 | 2026-04-16 23:42:00 | 2026-07-15 23:47:30 | 2026-05-16 14:03:00+00:00 | 2026-08-11 18:17:00+00:00 | 65101 | 7 | 2034.40625 | 2878.9906287734743 |
| f01084788 | f03338164 | f03696738 | f03338164 | 12D3KooWLGAZMarHVML2KUtY7Hf5H5pfNhXWqCcypqPUYuDeBVFc | [f03696744] | [/dns/f01084868.44943.com/tcp/443/wss] | 34359738368 | 152226 | 149629 | 2350 | 343844.4371283557 | 55492.48956728838 | 599.130543552361 | 388.20211608363826 | 210.92842746872276 | 279881.8348684099 | 8469.05136493143 | 1.06132772596987 | 0.0 | 4675.90625 | 46759.0625 | True | True | True | True | 2026-02-11 | 2026-07-15 | 2026-02-11 04:36:30 | 2026-07-15 23:40:00 | 2026-03-12 09:46:00+00:00 | 2026-08-13 04:34:30+00:00 | 152118 | 11 | 4753.6875 | 16202.190739734835 |
| f03644168 | f03632590 | f03644165 | f03632590 | 12D3KooWQKTq2derMYzNrRhwZsrRRCc47GLkX1WS2hvbq3oFbdct | [f03644177, f03644178, f03644179, f03644180, f03644181, f03644182] | [/dns/a-fil-http.aur.lu/tcp/443/wss] | 34359738368 | 73215 | 73215 | 0 | 114420.99872522795 | 12344.238698255222 | 193.9113783752584 | 165.53349617621794 | 28.37788219904047 | 97738.64560460646 | 4338.11442236628 | 0.0 | 0.0 | 2287.96875 | 18076.5703125 | True | True | True | True | 2025-10-08 | 2025-12-20 | 2025-10-10 12:50:30 | 2026-07-15 23:28:00 | 2025-10-12 11:55:30+00:00 | 2026-07-18 23:12:30+00:00 | 56138 | 6 | 1754.2890625 | 11415.749206330807 |
warm_storage_datasets
Warm storage datasets.
Columns
| column | type | description | tests |
|---|---|---|---|
dataset_id | BIGINT | FWSS dataset identifier. | |
payer | VARCHAR | Payer address. | |
service_provider_id | BIGINT | Service provider registry identifier. | |
service_provider_address | VARCHAR | Service provider address. | |
payee | VARCHAR | Payee address. | |
pdp_rail_id | BIGINT | Filecoin Pay PDP rail identifier. | |
cache_miss_rail_id | BIGINT | Filecoin Pay cache-miss rail identifier, if any. | |
cdn_rail_id | BIGINT | Filecoin Pay CDN rail identifier, if any. | |
has_cdn | BOOLEAN | Whether CDN payment rails were configured. | |
created_block | BIGINT | Creation block number. | |
created_at | TIMESTAMP WITH TIME ZONE | UTC creation timestamp. | |
billing_started_block | BIGINT | First block with a positive billing rate, if any. | |
billing_started_at | TIMESTAMP WITH TIME ZONE | UTC billing start timestamp, if any. | |
billing_terminated_block | BIGINT | Billing termination block, if any. | |
billing_terminated_at | TIMESTAMP WITH TIME ZONE | UTC billing termination timestamp, if any. | |
settlement_end_epoch | BIGINT | Settlement end epoch, if any. | |
settlement_end_at | TIMESTAMP WITH TIME ZONE | UTC settlement end timestamp, if any. |
Sample
| dataset_id | payer | service_provider_id | service_provider_address | payee | pdp_rail_id | cache_miss_rail_id | cdn_rail_id | has_cdn | created_block | created_at | billing_started_block | billing_started_at | billing_terminated_block | billing_terminated_at | settlement_end_epoch | settlement_end_at |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0x2127c3a31f54b81b5e9ad1e29c36c420d3d6ecc5 | 1 | 0x32c90c26bca6ed3945de9b29ba4e19d38314d618 | 0x32c90c26bca6ed3945de9b29ba4e19d38314d618 | 1 | null | null | False | 5465826 | 2025-11-04 18:33:00+00:00 | 5465828 | 2025-11-04 18:34:00+00:00 | 6059912 | 2026-05-30 01:16:00+00:00 | 6062261 | 2026-05-30 20:50:30+00:00 |
| 2 | 0xaf992fbc0c22bc941a232c63dc1b0c0cd572d145 | 1 | 0x32c90c26bca6ed3945de9b29ba4e19d38314d618 | 0x32c90c26bca6ed3945de9b29ba4e19d38314d618 | 2 | 3 | 4 | True | 5467575 | 2025-11-05 09:07:30+00:00 | 5467577 | 2025-11-05 09:08:30+00:00 | null | null | null | null |
| 3 | 0xaf992fbc0c22bc941a232c63dc1b0c0cd572d145 | 1 | 0x32c90c26bca6ed3945de9b29ba4e19d38314d618 | 0x32c90c26bca6ed3945de9b29ba4e19d38314d618 | 5 | null | null | False | 5467591 | 2025-11-05 09:15:30+00:00 | 5467593 | 2025-11-05 09:16:30+00:00 | null | null | null | null |
| 4 | 0xaf992fbc0c22bc941a232c63dc1b0c0cd572d145 | 1 | 0x32c90c26bca6ed3945de9b29ba4e19d38314d618 | 0x32c90c26bca6ed3945de9b29ba4e19d38314d618 | 6 | 7 | 8 | True | 5467605 | 2025-11-05 09:22:30+00:00 | 5467607 | 2025-11-05 09:23:30+00:00 | null | null | null | null |
| 5 | 0x741c0a74b858396c966fb139db17e4ad484cc446 | 1 | 0x32c90c26bca6ed3945de9b29ba4e19d38314d618 | 0x32c90c26bca6ed3945de9b29ba4e19d38314d618 | 9 | 10 | 11 | True | 5471214 | 2025-11-06 15:27:00+00:00 | 5471217 | 2025-11-06 15:28:30+00:00 | null | null | null | null |
| 6 | 0x741c0a74b858396c966fb139db17e4ad484cc446 | 1 | 0x32c90c26bca6ed3945de9b29ba4e19d38314d618 | 0x32c90c26bca6ed3945de9b29ba4e19d38314d618 | 12 | 13 | 14 | True | 5471219 | 2025-11-06 15:29:30+00:00 | 5471221 | 2025-11-06 15:30:30+00:00 | null | null | null | null |
| 7 | 0x838294adde22f9dcc62a0e6ed99aaad4d037ca3a | 1 | 0x32c90c26bca6ed3945de9b29ba4e19d38314d618 | 0x32c90c26bca6ed3945de9b29ba4e19d38314d618 | 15 | null | null | False | 5472377 | 2025-11-07 01:08:30+00:00 | 5472386 | 2025-11-07 01:13:00+00:00 | 5813543 | 2026-03-05 12:11:30+00:00 | 5567426 | 2025-12-10 01:13:00+00:00 |
| 8 | 0x2127c3a31f54b81b5e9ad1e29c36c420d3d6ecc5 | 1 | 0x32c90c26bca6ed3945de9b29ba4e19d38314d618 | 0x32c90c26bca6ed3945de9b29ba4e19d38314d618 | 16 | null | null | False | 5473782 | 2025-11-07 12:51:00+00:00 | 5473784 | 2025-11-07 12:52:00+00:00 | 6059916 | 2026-05-30 01:18:00+00:00 | 6062261 | 2026-05-30 20:50:30+00:00 |
| 9 | 0x7d3f0ca48194490d7c8b60fea6225e817ec52aa9 | 1 | 0x32c90c26bca6ed3945de9b29ba4e19d38314d618 | 0x32c90c26bca6ed3945de9b29ba4e19d38314d618 | 17 | null | null | False | 5474343 | 2025-11-07 17:31:30+00:00 | 5474360 | 2025-11-07 17:40:00+00:00 | 5813543 | 2026-03-05 12:11:30+00:00 | 5583800 | 2025-12-15 17:40:00+00:00 |
| 10 | 0x2127c3a31f54b81b5e9ad1e29c36c420d3d6ecc5 | 5 | 0x010ecc2436e0c5ea4741cd25a27a5476fe7a252c | 0x010ecc2436e0c5ea4741cd25a27a5476fe7a252c | 18 | null | null | False | 5485045 | 2025-11-11 10:42:30+00:00 | 5485047 | 2025-11-11 10:43:30+00:00 | 6060092 | 2026-05-30 02:46:00+00:00 | 6062261 | 2026-05-30 20:50:30+00:00 |