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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| f03634927 | 2025-08-10 10:11:00 | 2026-07-11 23:59:30 | 201095 | 15 | 6284.21875 | 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 |
| f03662041 | 2026-04-02 16:00:30 | 2026-07-11 23:59:00 | 28109 | 3 | 878.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-11 23:57:00 | 344409 | 32 | 10762.78125 | 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-11 22:56:00 | 246527 | 5 | 7701.9453125 | 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-11 05:19:00 | 11194 | 4 | 349.8125 | 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-10 05:38:30 | 354863 | 30 | 11089.46875 | 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 |
| f03649823 | 2025-10-06 20:03:00 | 2026-07-10 02:46:30 | 163568 | 15 | 5111.5 | f1lurvvlzrl6ljo64jb7wpojbykjmsw4ln6cdvmfq | qizhenys | null | China | Information, Media & Telecommunications | https://www.qizhenys.com/ | 5120.0 | 56.0 | f03251436 | Xingchi Allocator | null | null | null | 0.0 | 0.0 | 5064.0 | 56.0 | null | 2026-04-25 03:00:30+00:00 | 3 |
| f03235906 | 2024-11-17 15:35:00 | 2026-07-09 18:34:30 | 141521 | 22 | 4422.53125 | 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 |
| f03200311 | 2024-09-19 16:03:00 | 2026-07-09 11:08:30 | 1516 | 24 | 47.296875 | f1ggmci7w2weizhh36uqetihmh76ewgme6hwgowti | Lighthouse | null | null | null | lighthouse.storage | 60.0 | 8.015625 | f02824311 | datacap-data-preparation-and-onboarding | null | null | null | 0.0 | 0.03125 | 51.984375 | 8.015625 | null | 2026-03-31 06:09:30+00:00 | 3 |
| f03771751 | 2026-04-30 20:51:00 | 2026-07-07 14:14:30 | 6722 | 6 | 209.28485679626465 | f410fjmezxhwkpu4hf6uptnzlseyrtnhqrrpn74cs7yy | null | null | null | null | null | 319.4045925140381 | 0.0 | f03771751 | null | null | null | null | 0.0 | 0.0 | 319.4045925140381 | 0.0 | null | 2026-06-17 22:55: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-11 | f03535091 | 75.625 | 2420 | 1 |
| 2026-07-11 | f03644598 | 0.375 | 12 | 4 |
| 2026-07-11 | f03634927 | 38.28125 | 1225 | 2 |
| 2026-07-11 | f03662041 | 44.28125 | 1417 | 1 |
| 2026-07-11 | f03290418 | 129.0 | 4128 | 5 |
| 2026-07-10 | f03634927 | 40.0625 | 1282 | 2 |
| 2026-07-10 | f03535091 | 4.59375 | 147 | 1 |
| 2026-07-10 | f03649823 | 2.5 | 80 | 1 |
| 2026-07-10 | f03644598 | 0.59375 | 19 | 4 |
| 2026-07-10 | f03501759 | 6.90625 | 221 | 1 |
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-11 | 0x970626b28834c08614aac03966f870cda8a2d26d | 1 | 1 | 1 | 1 | 1 | 463.8541666666666 | 2.319270833333333 |
| 2026-07-11 | 0xfba3ff50630a44f86def3683859fa20b67e1ddd8 | 1 | 1 | 1 | 1 | 1 | 437.2992 | 2.186496 |
| 2026-07-11 | 0x47a1588758f3873712e379a1429ae4257d1ccbc0 | 1 | 1 | 1 | 1 | 1 | 46.2528 | 0.231264 |
| 2026-07-11 | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 798 | 601 | 597 | 106 | 19 | 521.8782563239021 | 2.6093912816195104 |
| 2026-07-11 | 0xb8b6b17ce0c2ee682a50fa451c405e3e4ff0aea8 | 1 | 1 | 1 | 1 | 1 | 17.8704 | 0.089352 |
| 2026-07-11 | 0xbf6444312e8facf2803c1ef179cb50ff69f79dc0 | 1 | 1 | 1 | 1 | 1 | 437.2992 | 2.186496 |
| 2026-07-11 | 0xed5a6e89f6380b2a698bbdd3f3f8e2a0f40d0a2e | 1 | 1 | 1 | 1 | 1 | 1616.8359375 | 8.0841796875 |
| 2026-07-11 | 0x56e53c5e7f27504b810494cc3b88b2aa0645a839 | 12 | 8 | 8 | 1 | 10 | 567.1241597282818 | 2.835620798641409 |
| 2026-07-11 | 0x6bec40e399f04801dd8f479222a7f99dcf109732 | 1 | 1 | 1 | 1 | 1 | 437.2992 | 2.186496 |
| 2026-07-11 | 0x9fa9d8674a3e3dd64beea17d0bfbf9f5c0bbec7d | 1 | 1 | 1 | 1 | 1 | 11.5632 | 0.057816 |
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-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.0001981140528328029 | 0.00015632438652852368 | 5038122.406474911 | 2364.737457303173 | 1865.925849419258 | 887359247.2595984 | 404261316.7794728 | 582117811.774398 | 73593317.83841416 | 42493182.41763174 | 73593317.83841416 | 110 | 832 | 41.1469035730207 | 104 | 601 | 0 | 2 | 9989.080899385495 | 8520.554499385496 | 1468.5264000000002 | 49.94540449692748 | 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.00044090603954587 | 0.0003489136743553297 | 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.620180655062 | 9060.093780655063 | 1468.5264000000002 | 52.64310090327531 | 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.0012488222000954076 | 0.0009687633555747913 | 5652860.89242361 | 3813.599655950993 | 2958.3679720265245 | 886870050.0535424 | 404138758.8845286 | 581743560.5844437 | 73589856.96439485 | 42489031.41280835 | 73589856.96439485 | 110 | 867 | 32.07171994147017 | 103 | 633 | 0 | 3 | 10526.195656496084 | 9057.669256496083 | 1468.5264000000002 | 52.63097828248042 | 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.0004866260190360198 | 0.000369352476207437 | 7343135.5873977905 | 73668.75039402863 | 55915.08532783165 | 886580668.7762543 | 404077254.3492555 | 581556434.9894664 | 73634421.71108869 | 42485217.8131524 | 73634421.71108869 | 110 | 862 | 30.972845591278112 | 103 | 630 | 0 | 5 | 10523.312420925036 | 9054.786020925036 | 1468.5264000000002 | 52.61656210462518 | 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.768634776694746 | 103 | 625 | 0 | 8 | 10054.857165839083 | 8586.330765839084 | 1468.5264000000002 | 50.274285829195414 | 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.411026741208699e-05 | 7.41198714366521e-05 | 5351017.274069626 | 3446.983681490787 | 2714.79397882915 | 884652359.9091069 | 403955840.3363534 | 581182183.7995121 | 75143005.05572703 | 42409278.13280514 | 75143005.05572703 | 110 | 850 | 24.616106503005586 | 103 | 618 | 1 | 5 | 10053.942102923893 | 8585.41570292389 | 1468.5264000000002 | 50.26971051461947 | 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 |
| 2026-07-05 | 36694 | 0.35516357421875 | 0.0010986328125 | 1.68505859375 | 1.6861572265625 | 1663.1220397949219 | 14764.888748534344 | 610 | 20291394.834376 | 5285673.032180923 | 22.694587773976785 | 15.032187762087435 | 11.822004578859504 | 0.814693898250452 | 0.6407127923040455 | 15.846881660337885 | 12.46271737116355 | 6.8477061136389015 | 5.385351374754365 | 0.00013446378609235902 | 0.00010574851246096397 | 5285695.726768697 | 2035.036609591406 | 1600.4464883956116 | 884369122.2942346 | 403893322.74751425 | 580995058.204535 | 75180046.47046436 | 42405831.14912365 | 75180046.47046436 | 109 | 844 | 38.54338329102935 | 102 | 614 | 0 | 0 | 9586.764462912946 | 8118.238062912947 | 1468.5264000000002 | 47.933822314564736 | 0.7864460427161302 | 74116145.68641116 | 625478625.6829268 | 0.347198486328125 | 11377 | 7 | 15 | 13993 | 14120 | 61526.08254005354 | 48386.94413745109 | 0.2987098463146352 | 0.004069388263185211 | 0.0032003542958574747 | 4.357371284706342 | 6227833.403262468 | 0.1950083421073244 | 2437991.8785584476 | 39952158.99249083 | 0.05279324989197367 |
| 2026-07-04 | 38955 | 0.301849365234375 | 9.1552734375e-05 | 2.4598388671875 | 2.459930419921875 | 1663.943603515625 | 14764.122315772198 | 613 | 22019674.879793994 | 5179736.255472003 | 25.05275963956053 | 16.64625969101068 | 13.309130736922405 | 0.9936150253659605 | 0.7944218413165421 | 17.63987471637665 | 14.103552578238954 | 7.412884923183887 | 5.926800158818455 | 0.000130360518601885 | 0.00010422672823868175 | 5179761.3082316425 | 2053.521861350074 | 1641.8457618197228 | 884103472.8535814 | 403831796.66497415 | 580807932.6095577 | 75199079.27020994 | 42403796.112514056 | 75199079.27020994 | 109 | 844 | 66.41001890803365 | 102 | 614 | 0 | 0 | 9062.919014079265 | 7594.392614079264 | 1468.5264000000002 | 45.31459507039633 | 0.7995267996515522 | 97650227.51219513 | 635788031.71777 | 0.3022165298461914 | 9904 | 7 | 14 | 13982 | 14091 | 61438.65152056142 | 49121.84842514144 | 0.29820987201752364 | 0.004063816449248253 | 0.0032491301600387898 | 4.360134236077029 | 6227833.403262468 | 0.19517818139305765 | 2439115.7345347865 | 40082697.378520355 | 0.052668706088211406 |
| 2026-07-03 | 40935 | 0.29931640625 | 5.427032470703125 | 4.61199951171875 | 10.039031982421875 | 1655.3903503417969 | 14670.672177680157 | 614 | 20276602.051915005 | 5918069.995906297 | 21.074822584380723 | 14.214255391083489 | 11.21829251504035 | 0.8695317290401781 | 0.686259042003745 | 15.083787120123667 | 11.904551557044094 | 5.991035464257055 | 4.728294691270012 | 0.0010836142764890878 | 0.000855219045434766 | 5918091.070728881 | 4980.510128111204 | 3930.7595054413637 | 883798680.632469 | 403770358.0134536 | 580620807.0145806 | 75257360.7666859 | 42401742.590652704 | 75257360.7666859 | 109 | 844 | 65.99922687699024 | 102 | 614 | 1 | 4 | 7446.0341213281845 | 5977.507721328185 | 1468.5264000000002 | 37.230170606640925 | 0.7892282927516212 | 108569563.5923345 | 627449086.4773519 | 0.30023193359375 | 9838 | 7 | 14 | 14157 | 14267 | 62193.916545269734 | 49085.19857456004 | 0.3016419830267604 | 0.0041399770842568216 | 0.003267387046238846 | 4.359284821284764 | 6227833.403262468 | 0.19516852032074522 | 2439124.593508956 | 40216715.49323728 | 0.05251691859349243 |
| 2026-07-02 | 42752 | 0.370452880859375 | 0.48394775390625 | 2.199310302734375 | 2.683258056640625 | 1670.2305603027344 | 14759.676572134864 | 618 | 18663988.799627002 | 10477914.965269586 | 14.13541818699274 | 8.762413122621998 | 6.70265224160171 | 0.5349630794660724 | 0.40921050326881575 | 9.297376202088072 | 7.1118627448705265 | 4.8380419849046685 | 3.7007742617573633 | 0.00018507725521791605 | 0.00014157155822215516 | 10477929.100687774 | 2910.1541251027525 | 2226.0706950312874 | 883357422.8077384 | 403708164.09690833 | 580433681.4196035 | 75454279.59002215 | 42396762.08052459 | 75454279.59002215 | 108 | 834 | 20.264588585967328 | 101 | 611 | 1 | 1 | 7444.379715637307 | 5975.853315637307 | 1468.5264000000002 | 37.22189857818653 | 0.7649322335986891 | 133522990.20979021 | 607940605.0734266 | 0.371063232421875 | 12159 | 8 | 14 | 14319 | 14434 | 62987.08940149569 | 48180.85498376641 | 0.30469163255500875 | 0.004167491692180834 | 0.0031878487286038657 | 4.363800013959795 | 6227833.403262468 | 0.19502603659872325 | 2444016.2728291815 | 40359075.27097567 | 0.052461439111985676 |
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-11 | 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-11 | f0101020 | 430.90625 | 4250.213134765625 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0 | 9 | 9 | 28.411186228853058 | 22.418204030793078 |
| 2026-07-11 | f0101021 | 437.59375 | 4320.603759765625 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0 | 7 | 7 | 19.816577400420346 | 15.636519776969573 |
| 2026-07-11 | f0101087 | 1223.21875 | 1223.2187883257866 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 |
| 2026-07-11 | f01016847 | 284.15625 | 2836.18359375 | 0.0 | 0 | 0.0 | 0 | 0.625 | 20 | 0.625 | 20 | 0.0 | 0 | 0 | 3 | 3 | 13.375897287622024 | 10.554420082056094 |
| 2026-07-11 | f01019009 | 305.625 | 3032.8359375 | 0.0 | 0 | 0.0 | 0 | 1.125 | 36 | 1.125 | 36 | 0.0 | 0 | 0 | 2 | 2 | 15.898163594392745 | 12.544646052549252 |
| 2026-07-11 | f01021773 | 1010.0 | 7381.4375 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0 | 2 | 2 | 8.533139254718526 | 6.733180913128387 |
| 2026-07-11 | f010479 | 61.4375 | 449.80859375 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 |
| 2026-07-11 | 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-11 | 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 |
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-11 | 2026-07-11 23:59:30+00:00 | 6183599 | 0xbf76ea0d3cf0cab668e7b6d6056bc3c1127ec153d941e93a0329a20725cf6603 | RailOneTimePaymentProcessed | 2294 | 0x9b68333791834e67db8dd7f95d0ba0d728ae820a | 0x32c90c26bca6ed3945de9b29ba4e19d38314d618 | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x80b98d3aa09ffff255c3ba4a241111ff1262f045 | USDFC | 18 | True | 0.0125 | 0.0124375 | 0.0 | 6.25e-05 | 0.0125 |
| 2026-07-11 | 2026-07-11 23:59:00+00:00 | 6183598 | 0xf077174478437abf3b92a9355168d5ea12e64c86ab57e14d51a56eea29bfc95d | RailOneTimePaymentProcessed | 2294 | 0x9b68333791834e67db8dd7f95d0ba0d728ae820a | 0x32c90c26bca6ed3945de9b29ba4e19d38314d618 | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x80b98d3aa09ffff255c3ba4a241111ff1262f045 | USDFC | 18 | True | 0.0125 | 0.0124375 | 0.0 | 6.25e-05 | 0.0125 |
| 2026-07-11 | 2026-07-11 23:58:30+00:00 | 6183597 | 0xa2118c091110948c095dedc7635eaba9bc5e2c3760947020c43dd06740a4d2b0 | RailOneTimePaymentProcessed | 2375 | 0x1f91dde7f314b93156f5e377dce1a3f440f1a8f3 | 0xd2d13ac4cc6d968d404623768c259cae7fa45b07 | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x80b98d3aa09ffff255c3ba4a241111ff1262f045 | USDFC | 18 | True | 0.0125 | 0.0124375 | 0.0 | 6.25e-05 | 0.0125 |
| 2026-07-11 | 2026-07-11 23:58:30+00:00 | 6183597 | 0xac1ec80efefaa695dbd231c1d072bccffd07ef1cb331167314923871a622ff1e | RailOneTimePaymentProcessed | 2294 | 0x9b68333791834e67db8dd7f95d0ba0d728ae820a | 0x32c90c26bca6ed3945de9b29ba4e19d38314d618 | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x80b98d3aa09ffff255c3ba4a241111ff1262f045 | USDFC | 18 | True | 0.0125 | 0.0124375 | 0.0 | 6.25e-05 | 0.0125 |
| 2026-07-11 | 2026-07-11 23:58:00+00:00 | 6183596 | 0x3b9c0f168dfec2c20e6bb26ab7a9e2156b71765212777c07c5b708ad52102ca8 | RailOneTimePaymentProcessed | 2294 | 0x9b68333791834e67db8dd7f95d0ba0d728ae820a | 0x32c90c26bca6ed3945de9b29ba4e19d38314d618 | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x80b98d3aa09ffff255c3ba4a241111ff1262f045 | USDFC | 18 | True | 0.0125 | 0.0124375 | 0.0 | 6.25e-05 | 0.0125 |
| 2026-07-11 | 2026-07-11 23:57:30+00:00 | 6183595 | 0x0105821926701ede905e10cbb6a24c1f94aabe5fe4ab293dfed914a3199af690 | RailOneTimePaymentProcessed | 2398 | 0xf60c59acdc9925d06e38aa2eb35afb07844a3843 | 0xd2d13ac4cc6d968d404623768c259cae7fa45b07 | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x80b98d3aa09ffff255c3ba4a241111ff1262f045 | USDFC | 18 | True | 0.0125 | 0.0124375 | 0.0 | 6.25e-05 | 0.0125 |
| 2026-07-11 | 2026-07-11 23:57:30+00:00 | 6183595 | 0x6e76db20143f5f0f942ec58e978a7a3e7e92625f1ec04276aaa569c2848cf205 | RailOneTimePaymentProcessed | 2389 | 0x305025d07c1dee47f25a4990179eff2becddca0b | 0xd2d13ac4cc6d968d404623768c259cae7fa45b07 | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x80b98d3aa09ffff255c3ba4a241111ff1262f045 | USDFC | 18 | True | 0.0008 | 0.000796 | 0.0 | 4e-06 | 0.0008 |
| 2026-07-11 | 2026-07-11 23:57:00+00:00 | 6183594 | 0x139728b0a26494d85fc986fa4041d96a444385a4f803b14e0c62499194e55ede | RailOneTimePaymentProcessed | 2398 | 0xf60c59acdc9925d06e38aa2eb35afb07844a3843 | 0xd2d13ac4cc6d968d404623768c259cae7fa45b07 | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x80b98d3aa09ffff255c3ba4a241111ff1262f045 | USDFC | 18 | True | 0.0125 | 0.0124375 | 0.0 | 6.25e-05 | 0.0125 |
| 2026-07-11 | 2026-07-11 23:57:00+00:00 | 6183594 | 0x8753c1baf6729decd847758d0d439736a39a8ef766eb7cc3af949c02f439035e | RailOneTimePaymentProcessed | 2294 | 0x9b68333791834e67db8dd7f95d0ba0d728ae820a | 0x32c90c26bca6ed3945de9b29ba4e19d38314d618 | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x80b98d3aa09ffff255c3ba4a241111ff1262f045 | USDFC | 18 | True | 0.0125 | 0.0124375 | 0.0 | 6.25e-05 | 0.0125 |
| 2026-07-11 | 2026-07-11 23:56:30+00:00 | 6183593 | 0x26e8ccff3ca3d24d3d5447fa9698268e3b1d87dddf364d10406a480650726d4d | 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
| 2400 | 0xf60c59acdc9925d06e38aa2eb35afb07844a3843 | 0x1d60d2f5960af6341e842c539985fa297e10d6ea | 0x80b98d3aa09ffff255c3ba4a241111ff1262f045 | USDFC | 18 | True | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | FWSS | 0x0000000000000000000000000000000000000000 | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0 | True | 6180150 | 50 | 0xc813603131a88b09b3e4ca878f6d7755e82e1c3e850d9662f5def1663d7a1a02 | 2026-07-10 19:15:00+00:00 | null | null | null | null | null | null | null | False |
| 2399 | 0xf60c59acdc9925d06e38aa2eb35afb07844a3843 | 0xd2d13ac4cc6d968d404623768c259cae7fa45b07 | 0x80b98d3aa09ffff255c3ba4a241111ff1262f045 | USDFC | 18 | True | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | FWSS | 0x0000000000000000000000000000000000000000 | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0 | True | 6180150 | 48 | 0xc813603131a88b09b3e4ca878f6d7755e82e1c3e850d9662f5def1663d7a1a02 | 2026-07-10 19:15:00+00:00 | null | null | null | null | null | null | null | False |
| 2398 | 0xf60c59acdc9925d06e38aa2eb35afb07844a3843 | 0xd2d13ac4cc6d968d404623768c259cae7fa45b07 | 0x80b98d3aa09ffff255c3ba4a241111ff1262f045 | USDFC | 18 | True | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | FWSS | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0 | True | 6180150 | 45 | 0xc813603131a88b09b3e4ca878f6d7755e82e1c3e850d9662f5def1663d7a1a02 | 2026-07-10 19:15:00+00:00 | null | null | null | null | null | null | null | False |
| 2397 | 0x934e20411c9e8e92946bd8786d7c3e5bc4db1387 | 0x32c90c26bca6ed3945de9b29ba4e19d38314d618 | 0x80b98d3aa09ffff255c3ba4a241111ff1262f045 | USDFC | 18 | True | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | FWSS | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0 | True | 6179514 | 0 | 0x35437d7769388adf9bbc6ca2b65e0f819067038bc83205328ff1c9ce87f57be1 | 2026-07-10 13:57:00+00:00 | null | null | null | null | null | null | null | False |
| 2396 | 0x934e20411c9e8e92946bd8786d7c3e5bc4db1387 | 0x32c90c26bca6ed3945de9b29ba4e19d38314d618 | 0x80b98d3aa09ffff255c3ba4a241111ff1262f045 | USDFC | 18 | True | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | FWSS | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0 | True | 6179513 | 45 | 0x0ee0a0af8ed2dca49d61073d352bb6ceec03de0035d6187fe4147b42749c3712 | 2026-07-10 13:56:30+00:00 | null | null | null | null | null | null | null | False |
| 2395 | 0x1721eb5d0b038b07f356d7c3858e6f1fb10089ea | 0x18778b2eae4c449887e2000d4e4cb1a1bab5dfb9 | 0x80b98d3aa09ffff255c3ba4a241111ff1262f045 | USDFC | 18 | True | 0xdea897523a989962cb56a55a03128e889b7ee944 | FWSS | 0xdea897523a989962cb56a55a03128e889b7ee944 | 0x0000000000000000000000000000000000000000 | 0 | True | 6176815 | 7 | 0x3a0f669914dcb03f52b2ddda0b4ee63f4d526f1b225b3ca1c963ac3597f59bb0 | 2026-07-09 15:27:30+00:00 | 6182391 | 4 | 0x1ffd16e4667fe7ec6d179c1d9d3168ecf49b1e5d7520871b5c30eaeddd081c44 | 0xdea897523a989962cb56a55a03128e889b7ee944 | 6268791 | 2026-07-11 13:55:30+00:00 | 2026-08-10 13:55:30+00:00 | True |
| 2394 | 0x1721eb5d0b038b07f356d7c3858e6f1fb10089ea | 0x89b5899619d93a180d38011b8aec849deea3f573 | 0x80b98d3aa09ffff255c3ba4a241111ff1262f045 | USDFC | 18 | True | 0x0d46adc8f78f557ca16dab11d260dcacb99dfe7e | FWSS | 0x0d46adc8f78f557ca16dab11d260dcacb99dfe7e | 0x0000000000000000000000000000000000000000 | 0 | True | 6176809 | 46 | 0xe0002f9966125b7f935ff5245db7b701a3c554de11aad81a1231e9d574f2b152 | 2026-07-09 15:24:30+00:00 | 6182389 | 46 | 0xdbc8e174f8f98614822e28ac3a0cab700eed0eaca8c2a1803ee8dd3c0500bf4e | 0x0d46adc8f78f557ca16dab11d260dcacb99dfe7e | 6268789 | 2026-07-11 13:54:30+00:00 | 2026-08-10 13:54:30+00:00 | True |
| 2393 | 0x305025d07c1dee47f25a4990179eff2becddca0b | 0xd2d13ac4cc6d968d404623768c259cae7fa45b07 | 0x80b98d3aa09ffff255c3ba4a241111ff1262f045 | USDFC | 18 | True | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | FWSS | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0 | True | 6175628 | 47 | 0x690c24cd89b8b000f9f96782dddaf73eade8dc9a4c641efa744909e6da9a5db7 | 2026-07-09 05:34:00+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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7 | 0x89b5899619d93a180d38011b8aec849deea3f573 | 0x89b5899619d93a180d38011b8aec849deea3f573 | True | False | True | PDP | True | https://mainnet-pdp.infrafolio.com | C=US;ST=Texas;L=Austin | US | Texas | Austin | 0x0000000000000000000000000000000000000000 | 1048576 | 1073741824 | 83300000000000000 | 30 | True | True | 0x002408011220295ed42035299e74ea5743cc52a1d00a782351a700abd804de06199436ed911c | 90 | 90.0 | testing | {capacityTib:0x3930,serviceStatus:0x74657374696e67,IPNIPeerID:0x002408011220295ed42035299e74ea5743cc52a1d00a782351a700abd804de06199436ed911c,ipniIpfs:0x01,ipniPiece:0x01,paymentTokenAddress:0x0000000000000000000000000000000000000000,location:0x433d55533b53543d54657861733b4c3d41757374696e,minProvingPeriodInEpochs:0x1e,storagePricePerTibPerDay:0x0127f0e89dca4000,maxPieceSizeInBytes:0x40000000,minPieceSizeInBytes:0x100000,serviceURL:0x68747470733a2f2f6d61696e6e65742d7064702e696e667261666f6c696f2e636f6d} | 5482846 | 0x85d6c4cdeb7104168b7a7888a36c2c73f1224442a0638ca807933c04b3462e04 | 2025-11-10 16:23:00+00:00 | 5482858 | 0x1600836de3729985fe9efd52f545228dee0bb2d251f429bba4f08847cfea6cec | 2025-11-10 16:29:00+00:00 | True | 5865704 | 2026-03-23 14:52:00+00:00 | 5865704 | 0x71a2f0fb50af07ec51c1bda943f6c8baf6fe9f7a8a0a95276675ac8d08fc774f | 2026-03-23 14:52:00+00:00 |
| 1 | 0x32c90c26bca6ed3945de9b29ba4e19d38314d618 | 0x32c90c26bca6ed3945de9b29ba4e19d38314d618 | True | False | True | PDP | True | https://main.ezpdpz.net | C=GB;ST=Gloucestershire;L=Cheltenham | GB | Gloucestershire | Cheltenham | 0x0000000000000000000000000000000000000000 | 1048576 | 2147483648 | 83333333333333330 | 30 | True | True | 0x0024080112201dcb0e9feaf9a369c13ccbb8f0c91921afcde832f957020c13f67cd8fb9ad4f1 | 10 | 10.0 | testing | {serviceStatus:0x74657374696e67,capacityTib:0x3130,IPNIPeerID:0x0024080112201dcb0e9feaf9a369c13ccbb8f0c91921afcde832f957020c13f67cd8fb9ad4f1,ipniPeerId:0x0024080112201dcb0e9feaf9a369c13ccbb8f0c91921afcde832f957020c13f67cd8fb9ad4f1,ipniIpfs:0x01,ipniPiece:0x01,paymentTokenAddress:0x0000000000000000000000000000000000000000,location:0x433d47423b53543d476c6f7563657374657273686972653b4c3d4368656c74656e68616d,minProvingPeriodInEpochs:0x1e,storagePricePerTibPerDay:0x01280f39a3485552,maxPieceSizeInBytes:0x80000000,minPieceSizeInBytes:0x100000,serviceURL:0x68747470733a2f2f6d61696e2e657a7064707a2e6e6574} | 5462468 | 0x9f0f508355403a1141bf8be4e389d5d1edbbe9f5b57158dd9e694531a98f1825 | 2025-11-03 14:34:00+00:00 | 5821285 | 0xc71cdb16b2fbe88756c3816f13d3b8cfd541e6fd7835b442cfea8a5e15b947f3 | 2026-03-08 04:42:30+00:00 | True | 5464743 | 2025-11-04 09:31:30+00:00 | 5464743 | 0xfe009d2d0746f8180ff7e0cc1f69d07412a93a70991a65ee68061215e9f037e7 | 2025-11-04 09:31:30+00:00 |
| 25 | 0x7b7fd1531767736acb4fbb5b20a5aba8c675028a | 0x7b7fd1531767736acb4fbb5b20a5aba8c675028a | True | False | True | PDP | True | https://storacha.network | earth | null | null | null | 0x7b7fd1531767736acb4fbb5b20a5aba8c675028a | 1 | 1 | 1 | 1 | null | null | null | null | null | null | {paymentTokenAddress:0x7b7fd1531767736acb4fbb5b20a5aba8c675028a,location:0x6561727468,minProvingPeriodInEpochs:0x01,storagePricePerTibPerDay:0x01,maxPieceSizeInBytes:0x01,minPieceSizeInBytes:0x01,serviceURL:0x68747470733a2f2f73746f72616368612e6e6574776f726b} | 5549432 | 0x9fa2b6db8d630aba1fa5967eb6f31b381bed42e5614890576e0cfe8dcdd057de | 2025-12-03 19:16:00+00:00 | 5549432 | 0x9fa2b6db8d630aba1fa5967eb6f31b381bed42e5614890576e0cfe8dcdd057de | 2025-12-03 19:16:00+00:00 | False | null | null | null | null | null |
| 19 | 0x21f15b5a2711ef55d9463cf66cc793eb17ce087f | 0x21f15b5a2711ef55d9463cf66cc793eb17ce087f | True | False | True | PDP | True | https://storacha.network | earth | null | null | null | 0x21f15b5a2711ef55d9463cf66cc793eb17ce087f | 1 | 1 | 1 | 1 | null | null | null | null | null | null | {paymentTokenAddress:0x21f15b5a2711ef55d9463cf66cc793eb17ce087f,location:0x6561727468,minProvingPeriodInEpochs:0x01,storagePricePerTibPerDay:0x01,maxPieceSizeInBytes:0x01,minPieceSizeInBytes:0x01,serviceURL:0x68747470733a2f2f73746f72616368612e6e6574776f726b} | 5535854 | 0x4baa606cadf93908dec2736947e13cf91554d2d851a53e758d6ccaaacd8787ca | 2025-11-29 02:07:00+00:00 | 5535854 | 0x4baa606cadf93908dec2736947e13cf91554d2d851a53e758d6ccaaacd8787ca | 2025-11-29 02:07:00+00:00 | False | null | null | null | null | null |
| 27 | 0xe686d370d8e53f72e543dafe978da41e7e0505cc | 0xe686d370d8e53f72e543dafe978da41e7e0505cc | True | False | True | PDP | True | https://storacha.network | earth | null | null | null | 0xe686d370d8e53f72e543dafe978da41e7e0505cc | 1 | 1 | 1 | 1 | null | null | null | null | null | null | {paymentTokenAddress:0xe686d370d8e53f72e543dafe978da41e7e0505cc,location:0x6561727468,minProvingPeriodInEpochs:0x01,storagePricePerTibPerDay:0x01,maxPieceSizeInBytes:0x01,minPieceSizeInBytes:0x01,serviceURL:0x68747470733a2f2f73746f72616368612e6e6574776f726b} | 5724026 | 0xbf9bf3f6492f1b36cfa8c187befbc99b9c915caf6616a9f7814e8fbaee310b68 | 2026-02-02 10:13:00+00:00 | 5724026 | 0xbf9bf3f6492f1b36cfa8c187befbc99b9c915caf6616a9f7814e8fbaee310b68 | 2026-02-02 10:13:00+00:00 | False | null | null | null | null | null |
| 21 | 0x3fa2a4c02478f1e57d3dd2868484164647c45038 | 0x3fa2a4c02478f1e57d3dd2868484164647c45038 | True | False | True | PDP | True | https://storacha.network | earth | null | null | null | 0x3fa2a4c02478f1e57d3dd2868484164647c45038 | 1 | 1 | 1 | 1 | null | null | null | null | null | null | {paymentTokenAddress:0x3fa2a4c02478f1e57d3dd2868484164647c45038,location:0x6561727468,minProvingPeriodInEpochs:0x01,storagePricePerTibPerDay:0x01,maxPieceSizeInBytes:0x01,minPieceSizeInBytes:0x01,serviceURL:0x68747470733a2f2f73746f72616368612e6e6574776f726b} | 5543204 | 0x65b202618e4abda7774d050adb9d620e62efc0e88782728f71de8a270f3ad1e8 | 2025-12-01 15:22:00+00:00 | 5543204 | 0x65b202618e4abda7774d050adb9d620e62efc0e88782728f71de8a270f3ad1e8 | 2025-12-01 15:22:00+00:00 | False | null | null | null | null | null |
| 8 | 0xa4440add7c5d9baa1859cde7cd83b88816bc1362 | 0xa4440add7c5d9baa1859cde7cd83b88816bc1362 | True | False | True | PDP | True | http://116.182.20.74:12310 | C=US;ST=California;L=San Francisco | US | California | San Francisco | 0x0000000000000000000000000000000000000000 | 1048576 | 1073741824 | 83333333333333330 | 30 | True | True | 0x0024080112200cbe9eba1bb1f9140df2b7ba22fd503b1a3cfcc409a32f044d5709de0d861450 | 1 | 1.0 | testing | {serviceStatus:0x74657374696e67,capacityTib:0x31,IPNIPeerID:0x0024080112200cbe9eba1bb1f9140df2b7ba22fd503b1a3cfcc409a32f044d5709de0d861450,ipniIpfs:0x01,ipniPiece:0x01,paymentTokenAddress:0x0000000000000000000000000000000000000000,location:0x433d55533b53543d43616c69666f726e69613b4c3d53616e204672616e636973636f,minProvingPeriodInEpochs:0x1e,storagePricePerTibPerDay:0x01280f39a3485552,maxPieceSizeInBytes:0x40000000,minPieceSizeInBytes:0x100000,serviceURL:0x687474703a2f2f3131362e3138322e32302e37343a3132333130} | 5484390 | 0x6dea3d6afc40f508ead658ac1b52087bfe29c59fb11169aa6e46c143594fb272 | 2025-11-11 05:15:00+00:00 | 5484398 | 0xccf6beb922a5597fb4939be006f571f3afc4b3408d8e8117b0dd2d69bf7e3298 | 2025-11-11 05:19:00+00:00 | False | null | null | null | null | null |
| 13 | 0x40dbb5c4dc728b9d5f23444a1e5449d655ce0224 | 0x40dbb5c4dc728b9d5f23444a1e5449d655ce0224 | True | False | True | PDP | True | https://curio.akave.xyz | C=US;ST=Texas;L=Dallas | US | Texas | Dallas | 0x0000000000000000000000000000000000000000 | 1048576 | 68719476736 | 83333333333333330 | 1440 | True | True | 0x002408011220111c71c31b084ff774b23ecc0f6796fc9d2b084920e049dca56cbee72575ad2a | 350 | 350.0 | testing | {capacityTib:0x333530,serviceStatus:0x74657374696e67,IPNIPeerID:0x002408011220111c71c31b084ff774b23ecc0f6796fc9d2b084920e049dca56cbee72575ad2a,ipniIpfs:0x01,ipniPiece:0x01,paymentTokenAddress:0x0000000000000000000000000000000000000000,location:0x433d55533b53543d54657861733b4c3d44616c6c6173,minProvingPeriodInEpochs:0x05a0,storagePricePerTibPerDay:0x01280f39a3485552,maxPieceSizeInBytes:0x1000000000,minPieceSizeInBytes:0x100000,serviceURL:0x68747470733a2f2f637572696f2e616b6176652e78797a} | 5494281 | 0x46dfc7c0b766a7293e70278a8d1ae9338b718bc99c0fcc1d47ed01c93584bb45 | 2025-11-14 15:40:30+00:00 | 5512634 | 0xcbfb1c358bd2c092d7a341379cfa2ee84cf750f2f031cecfe595440e4d89396c | 2025-11-21 00:37: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 |
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| f01518369 | f02829362 | f01869550 | f02829362 | 12D3KooWGcWttoCPEZUqhp7YJPbnRBUrqvJSpA6xzUN5tPPZs2CM | [f01518485, f01518492, f01518493] | [/ip4/192.168.200.11/tcp/1111] | 34359738368 | 418265 | 418215 | 0 | 673686.6954764243 | 14371.68813884142 | 2441.147058307584 | 2404.1312902021573 | 37.01576810542656 | 628042.744631963 | 31270.284410034088 | 1.9782955858747222 | 0.0 | 13033.65625 | 130323.34375 | True | True | True | True | 2021-12-18 | 2026-07-11 | 2022-12-02 07:24:00 | 2026-07-11 23:59:30 | 2022-11-02 08:24:00+00:00 | 2026-08-02 06:13:30+00:00 | 387421 | 34 | 12106.47265625 | 451249.20149966225 |
| f01904546 | f03066523 | f01813570 | f03066523 | 12D3KooWJmosyoJmjmwbEGzqwfuAJPJ8LcE2NE1tj4vyHu41WUbS | [f01813572] | [/dns/retrieval.simpleipfs.com/tcp/443/wss] | 34359738368 | 86082 | 85837 | 3 | 167545.29688620617 | 5502.171332608817 | 583.9642342792275 | 582.8658268236143 | 1.0984074556132555 | 155840.37728955603 | 6192.855127066183 | 9.893136975129934 | 0.0 | 2639.78125 | 26265.484375 | True | True | True | True | 2022-08-18 | 2026-07-11 | 2026-07-04 13:43:30 | 2026-07-11 23:59:00 | 2023-12-20 02:56:00+00:00 | 2024-06-05 05:24:30+00:00 | 9906 | 1 | 309.5625 | 80082.43664481942 |
| f01081439 | f03338164 | f03759651 | f03338164 | 12D3KooWNZ1bNnLikm84dXC4oSWcBX9TEPUAV7Bx2PUpryWmWv8a | [f03759648] | [/dns/f01081439.44943.com/tcp/443/wss] | 34359738368 | 61553 | 60886 | 1 | 172411.53984861213 | 49431.081952093526 | 299.9636041188874 | 154.440461649343 | 145.5231424695444 | 121332.2541184109 | 1646.647239013942 | 1.5565390937485828 | 0.0 | 1902.6875 | 19026.875 | True | True | True | True | 2026-04-16 | 2026-07-11 | 2026-04-16 23:42:00 | 2026-07-11 23:57:00 | 2026-05-16 14:03:00+00:00 | 2026-08-07 17:34:00+00:00 | 61237 | 7 | 1913.65625 | 2577.875183572475 |
| f01082688 | f03338164 | f03759652 | f03338164 | 12D3KooWNZ1bNnLikm84dXC4oSWcBX9TEPUAV7Bx2PUpryWmWv8a | [f03759649] | [/dns/f01081439.44943.com/tcp/443/wss] | 34359738368 | 57594 | 57223 | 1 | 170657.3748943529 | 55017.89475670091 | 200.0 | 143.94944383104766 | 56.05055616895234 | 114082.72993749035 | 1555.5632569695804 | 1.1869431920344744 | 0.0 | 1787.78125 | 17877.8125 | True | True | True | True | 2026-05-05 | 2026-07-11 | 2026-05-05 20:33:30 | 2026-07-11 23:54:30 | 2026-06-03 15:15:30+00:00 | 2026-08-09 16:09:30+00:00 | 57252 | 5 | 1789.125 | 2329.5048739477415 |
| f01084868 | f03338164 | f03759653 | f03338164 | 12D3KooWLGAZMarHVML2KUtY7Hf5H5pfNhXWqCcypqPUYuDeBVFc | [f03759650] | [/dns/f01084868.44943.com/tcp/443/wss] | 34359738368 | 107257 | 107007 | 26 | 265135.65923530946 | 51307.54898423165 | 499.86194691193623 | 270.5756551688627 | 229.28629174307355 | 210398.111343841 | 3425.4374932365477 | 4.561414000266953 | 0.0 | 3273.15625 | 32731.0 | True | True | True | True | 2026-04-19 | 2026-07-11 | 2026-04-19 15:24:00 | 2026-07-11 23:52:30 | 2026-05-19 09:45:30+00:00 | 2026-08-09 18:54:30+00:00 | 106275 | 7 | 3321.09375 | 5274.5147619262025 |
| f03143698 | f03221540 | f03143694 | f03221540 | 12D3KooWHc2QLhJYQ6KEF46JWznthaxQzKGmUoUeoXiyftzNwWEE | [f03245856, f03245875] | [/dns/market.curio.filstarry.com/tcp/443/wss] | 34359738368 | 4863 | 4860 | 0 | 19023.15366329863 | 11948.552439430228 | 42.14072285368235 | 38.261046789204265 | 3.879676064478083 | 6540.168655852473 | 534.4325680159284 | 0.0 | 0.0 | 147.59375 | 1462.4375 | True | True | True | True | 2024-07-19 | 2026-07-11 | 2024-08-02 06:47:00 | 2026-07-11 23:05:30 | 2024-11-07 03:24:30+00:00 | 2025-01-15 15:08:00+00:00 | 11847 | 4 | 370.21875 | 6601.03274395626 |
| f03780816 | f03200943 | f03741652 | f03286739 | QmQSH8CqPJZnXUSHNqiEHGiUoqQikPPCamExmw1gAgTjis | null | null | 34359738368 | 73625 | 73617 | 1 | 201045.709914875 | 49920.345862303984 | 0.0 | 0.0 | 0.0 | 149900.24433695947 | 731.3862280183705 | 493.73348759319975 | 0.0 | 2228.15625 | 22263.984375 | True | True | True | False | 2026-05-19 | 2026-07-11 | 2026-05-19 15:20:30 | 2026-07-11 22:56:00 | null | null | 73785 | 1 | 2303.828125 | 1180.193181341267 |
| f01084788 | f03338164 | f03696738 | f03338164 | 12D3KooWLGAZMarHVML2KUtY7Hf5H5pfNhXWqCcypqPUYuDeBVFc | [f03696744] | [/dns/f01084868.44943.com/tcp/443/wss] | 34359738368 | 151336 | 151329 | 7 | 343181.6674263256 | 56929.64966337067 | 599.130543552361 | 385.84267545092604 | 213.28786810143498 | 278018.4467149646 | 8233.571047990321 | 0.0 | 0.0 | 4729.03125 | 47290.3125 | True | True | True | True | 2026-02-11 | 2026-07-11 | 2026-02-11 04:36:30 | 2026-07-11 18:57:30 | 2026-03-12 09:46:00+00:00 | 2026-08-07 16:17:00+00:00 | 151461 | 11 | 4733.15625 | 15563.428244829556 |
| f01083688 | f03338164 | f03696737 | f03338164 | 12D3KooWLGAZMarHVML2KUtY7Hf5H5pfNhXWqCcypqPUYuDeBVFc | [f03696743] | [/dns/f01084868.44943.com/tcp/443/wss] | 34359738368 | 134672 | 134595 | 5 | 311961.46488502086 | 56842.558755589496 | 395.9669419645405 | 339.5113548628299 | 56.45558710171065 | 247528.7188237935 | 7590.135300826868 | 0.052004810985987325 | 0.0 | 4206.09375 | 42060.65625 | True | True | True | True | 2025-12-10 | 2026-07-11 | 2025-12-10 01:52:30 | 2026-07-11 18:44:30 | 2026-01-08 15:51:00+00:00 | 2026-08-07 16:16:00+00:00 | 135405 | 12 | 4231.40625 | 14059.690780054378 |
| f03644168 | f03632590 | f03644165 | f03632590 | 12D3KooWQKTq2derMYzNrRhwZsrRRCc47GLkX1WS2hvbq3oFbdct | [f03644177, f03644178, f03644179, f03644180, f03644181, f03644182] | [/dns/a-fil-http.aur.lu/tcp/443/wss] | 34359738368 | 73215 | 73215 | 0 | 114133.093262462 | 12139.123882642152 | 193.9113783752584 | 165.49353246071442 | 28.41784591454399 | 97705.48371989925 | 4288.485659920603 | 0.0 | 0.0 | 2287.96875 | 18072.0703125 | True | True | True | True | 2025-10-08 | 2025-12-20 | 2025-10-10 12:50:30 | 2026-07-11 05:19:00 | 2025-10-12 11:55:30+00:00 | 2026-07-14 05:04:00+00:00 | 56122 | 6 | 1753.7890625 | 11131.696728327792 |
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 |