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_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. | |
provider_count | BIGINT | Provider count from DatacapStats. | |
top_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_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 | provider_count | top_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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| f03774028 | 2026-05-08 19:43:00 | 2026-06-13 23:59:30 | 140903 | 3 | 4403.21875 | f1vjvnnlikd4uiyodie2ia5prifbctljzbvw2wgti | null | null | null | null | null | 5120.0 | 243.9375 | f03777695 | Large Data Onboarding | null | null | null | 0.0 | 164.40625 | 4876.0625 | 243.9375 | null | 2026-05-07 12:11:30+00:00 | 3 |
| f03662041 | 2026-04-02 16:00:30 | 2026-06-13 23:59:00 | 6753 | 2 | 211.03125 | f1hwh6vu3xs6rkd4terlahvjuargtsmiy34hztayy | CERNOpen Data Sets | null | United States | Not-for-Profit | None. | 450.0 | 2.40625 | f03016877 | FIL-DC-Allocator | null | null | null | 0.0 | 100.96875 | 447.59375 | 2.40625 | null | 2026-04-19 23:48:30+00:00 | 3 |
| f03235906 | 2024-11-17 15:35:00 | 2026-06-13 23:54:30 | 97381 | 22 | 3043.15625 | f1zcqp4nfzej54gmv723pc5toccp64r27tnlidcda | CACE | null | China | Construction, Property & Real Estate | http://www.cac-e.com/ | 4438.4 | 1268.2124999999996 | f03012494 | Storify Data Fortress | null | null | null | 0.0 | 415.71875 | 3170.1875 | 1268.2124999999996 | null | 2026-03-05 14:42:00+00:00 | 3 |
| f03634927 | 2025-08-10 10:11:00 | 2026-06-13 23:44:00 | 168548 | 14 | 5267.125 | f16k5n2uqxp3ly5xqnwd6gxyl6xbwzblfau2p3lci | HunanZero Point Realm Media Co., Ltd. | null | China | Information, Media & Telecommunications | http://www.bgyhcm.com/index.html | 6912.0 | 1598.28125 | f03251448 | Yunphant Allocator | null | null | null | 0.0 | 398.71875 | 5313.71875 | 1598.28125 | null | 2026-04-16 07:27:30+00:00 | 3 |
| f03535091 | 2025-05-09 12:11:00 | 2026-06-13 23:32:00 | 174794 | 5 | 5460.3125 | f3r3tkbr34pcrzj42hy2pc7e4ujpxhrmuohy4bapnommhzmnn7vlyn6e5jb2lqpddsjtitzeicjcm2a4cypspa | null | null | null | null | null | 6095.92 | 3293.40625 | f03760270 | Ramo Cloud | null | null | null | 0.0 | 110.8125 | 2802.51375 | 3293.40625 | null | 2026-05-12 15:55:30+00:00 | 3 |
| f03767350 | 2026-05-11 22:20:30 | 2026-06-13 19:51:30 | 16077 | 1 | 495.317138671875 | f13dwjgdbcxi2hmpbxjdijghbernii4qtbag5n3sq | TheStarling Lab | null | United States | Education & Training | null | 768.0 | 272.550048828125 | f03015757 | FIDL Enterprise Data | null | null | null | 0.0 | 243.181396484375 | 495.449951171875 | 272.550048828125 | null | 2026-05-29 18:03:00+00:00 | 3 |
| f03644598 | 2025-09-08 10:15:30 | 2026-06-13 19:25:30 | 10386 | 4 | 324.5625 | f1nplitd46e2m5woeiwlcjqu7kri66hr2rx4sywvi | null | null | null | null | ** https://aurorainfra.ai/ | 410.0 | 80.3125 | f03019298 | datacap-decentralized-onboarding-to-self-selected-sps | null | null | null | 0.0 | 6.53125 | 329.6875 | 80.3125 | null | 2025-10-15 11:36:00+00:00 | 3 |
| f03200311 | 2024-09-19 16:03:00 | 2026-06-13 17:29:00 | 1479 | 24 | 46.140625 | f1ggmci7w2weizhh36uqetihmh76ewgme6hwgowti | Lighthouse | null | null | null | lighthouse.storage | 60.0 | 8.515625 | f02824311 | datacap-data-preparation-and-onboarding | null | null | null | 0.0 | 1.6875 | 51.484375 | 8.515625 | null | 2026-03-31 06:09:30+00:00 | 3 |
| f03771751 | 2026-04-30 20:51:00 | 2026-06-12 01:33:30 | 2026 | 5 | 62.87174034118652 | f410fjmezxhwkpu4hf6uptnzlseyrtnhqrrpn74cs7yy | null | null | null | null | null | 172.05592155456543 | 0.0 | f03771751 | null | null | null | null | 0.0 | 43.67236328125 | 172.05592155456543 | 0.0 | null | 2026-05-29 16:39:30+00:00 | 3 |
| f03649823 | 2025-10-06 20:03:00 | 2026-06-10 17:07:30 | 161776 | 15 | 5055.5 | f1lurvvlzrl6ljo64jb7wpojbykjmsw4ln6cdvmfq | qizhenys | null | China | Information, Media & Telecommunications | https://www.qizhenys.com/ | 5120.0 | 56.0 | f03251436 | Xingchi Allocator | null | null | null | 0.0 | 1338.625 | 5064.0 | 56.0 | null | 2026-04-25 03:00:30+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_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_providers |
|---|---|---|---|---|
| 2026-06-13 | f03535091 | 23.15625 | 741 | 2 |
| 2026-06-13 | f03767350 | 10.349609375 | 356 | 1 |
| 2026-06-13 | f03662041 | 47.65625 | 1525 | 1 |
| 2026-06-13 | f03644598 | 0.84375 | 27 | 4 |
| 2026-06-13 | f03634927 | 35.375 | 1132 | 1 |
| 2026-06-13 | f03200311 | 0.03125 | 1 | 1 |
| 2026-06-13 | f03774028 | 89.9375 | 2878 | 1 |
| 2026-06-13 | f03235906 | 133.96875 | 4287 | 5 |
| 2026-06-12 | f03535091 | 3.5625 | 114 | 1 |
| 2026-06-12 | f03767350 | 20.833984375 | 686 | 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-06-12 | 0xb8b6b17ce0c2ee682a50fa451c405e3e4ff0aea8 | 1 | 1 | 1 | 1 | 1 | 17.8704 | 0.089352 |
| 2026-06-12 | 0xbf6444312e8facf2803c1ef179cb50ff69f79dc0 | 1 | 1 | 1 | 1 | 1 | 437.2992 | 2.186496 |
| 2026-06-12 | 0x9fa9d8674a3e3dd64beea17d0bfbf9f5c0bbec7d | 1 | 1 | 1 | 1 | 1 | 11.5632 | 0.057816 |
| 2026-06-12 | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 799 | 609 | 605 | 99 | 16 | 525.4754669990009 | 2.6273773349950047 |
| 2026-06-12 | 0x6bec40e399f04801dd8f479222a7f99dcf109732 | 1 | 1 | 1 | 1 | 1 | 437.2992 | 2.186496 |
| 2026-06-12 | 0x56e53c5e7f27504b810494cc3b88b2aa0645a839 | 12 | 8 | 8 | 1 | 10 | 567.1241597282818 | 2.835620798641409 |
| 2026-06-12 | 0x47a1588758f3873712e379a1429ae4257d1ccbc0 | 1 | 1 | 1 | 1 | 1 | 46.2528 | 0.231264 |
| 2026-06-12 | 0xfba3ff50630a44f86def3683859fa20b67e1ddd8 | 1 | 1 | 1 | 1 | 1 | 437.2992 | 2.186496 |
| 2026-06-12 | 0xe6d291a31f5034ed26d91352e784ae5d3a6991eb | 1 | 0 | 0 | 1 | 1 | 0.0 | 0.0 |
| 2026-06-12 | 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. | |
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. | |
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. | |
message_miner_penalty_burn_fil | DOUBLE | FIL burned by message execution miner penalties. | |
message_miner_penalty_burn_usd | DOUBLE | FIL burned by message execution miner penalties, 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_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 | providers_with_power | gas_used_millions | total_value_fil | total_gas_fee_fil | base_fee_burn_fil | base_fee_burn_usd | message_burn_fil | message_burn_usd | message_miner_penalty_burn_fil | message_miner_penalty_burn_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_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-06-13 | 42068 | 0.24603271484375 | 6.103515625e-05 | 5.660125732421875 | 5.660186767578125 | 1738.7422485351562 | 15255.861755268677 | 647 | 15020946.662968004 | 4732402.605744432 | 18.172415566616117 | 6.233925743265001 | 4.8415137672482995 | 6.740893691778472 | 5.235245165947326 | 7.8626236758441e-05 | 6.106425122952164e-05 | 4732420.778159998 | 1970.4450433355414 | 1530.3257045084213 | 876418578.9389101 | 402530096.9817837 | 576878295.1150372 | 77761484.15915398 | 42294947.96053016 | 77761484.15915398 | 0 | 0 | 0.0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.7766396275218657 | 194387354.4250871 | 612794664.261324 | 0.33331871032714844 | 10947 | 8 | 14 | 13965 | 14086 | 62259.525471118686 | 48353.21467157773 | 0.2922362792156558 | 0.003985374200306429 | 0.0030951995344612386 | 4.419957792923377 | 6227833.403262468 | 0.19526435866172634 | 2752206.3526052507 | 42979717.03165105 | 0.05593057017226604 |
| 2026-06-12 | 44777 | 0.2335205078125 | 0.164031982421875 | 0.883819580078125 | 1.0478515625 | 1743.4466552734375 | 15289.8173711384 | 646 | 17073836.794187002 | 7045305.082956141 | 17.961763918353345 | 10.702686001139583 | 8.051660304030571 | 11.50529485929617 | 8.655465169668469 | 0.000587782964441058 | 0.00044219075115083876 | 7045323.044720059 | 2174.946566544805 | 1636.2183223325235 | 875904537.2487665 | 402467837.45631254 | 576691169.5200601 | 78028111.17389263 | 42292977.51548683 | 78028111.17389263 | 102 | 825 | 29.300150024828383 | 73 | 480 | 0 | 0 | 2561.126026727262 | 1092.5996267272828 | 1468.5264000000002 | 12.80563013363631 | 0.7523027680316193 | 179252591.2160279 | 593550969.9268292 | 0.29689598083496094 | 9748 | 9 | 15 | 14078 | 14186 | 62683.845449505636 | 47157.23044252932 | 0.29322257382445555 | 0.004003624852794767 | 0.0030119380589176876 | 4.4187117897579045 | 6227833.403262468 | 0.1948381899506985 | 2751971.426773124 | 43129863.83599714 | 0.055755668937167886 |
| 2026-06-11 | 48551 | 0.2060546875 | 0.000274658203125 | 2.280242919921875 | 2.280517578125 | 1741.1937255859375 | 15259.585492031678 | 646 | 17487180.622241996 | 9407415.634161552 | 15.12664093885456 | 9.634708096073801 | 7.26032602915751 | 10.275935842079145 | 7.74352930304162 | 0.0013316735859459836 | 0.0010034953111163864 | 9407430.76080249 | 2424.750782890213 | 1827.1940413443135 | 875658222.3856555 | 402405153.61086303 | 576504043.9250829 | 78026791.54314356 | 42290802.568920285 | 78026791.54314356 | 100 | 805 | 8.080551879886775 | 73 | 480 | 0 | 0 | 2552.382004955205 | 1083.855604955226 | 1468.5264000000002 | 12.761910024776025 | 0.7535595221733946 | 221919411.3205575 | 594277375.0696864 | 0.3035087585449219 | 9955 | 8 | 15 | 13994 | 14111 | 62375.603407168004 | 47003.72989878269 | 0.2917856135482343 | 0.0039918302652533185 | 0.003008081707281586 | 4.420353157619446 | 6227833.403262468 | 0.1948519312653613 | 2751620.688139915 | 43295930.163302705 | 0.05556162314767225 |
| 2026-06-10 | 47459 | 0.185211181640625 | 0.142608642578125 | 1.329010009765625 | 1.47161865234375 | 1744.6355895996094 | 15293.713224276784 | 648 | 17617175.552498993 | 7152193.003581085 | 23.827941612624365 | 15.018770878818525 | 11.22652776731632 | 16.042412814020807 | 11.9916998777415 | 0.0012469117933697116 | 0.0009320662779003969 | 7152216.831522698 | 2269.8247563184314 | 1696.6934817342035 | 875396890.2918136 | 402342778.0074559 | 576316918.3301058 | 78041047.18938404 | 42288377.81813739 | 78041047.18938404 | 100 | 803 | 1.3995053169329108 | 73 | 480 | 0 | 0 | 2562.971561590524 | 1094.4451615905443 | 1468.5264000000002 | 12.81485780795262 | 0.7474997693153084 | 186898468.87804878 | 589278666.3275261 | 0.18527626991271973 | 6091 | 10 | 16 | 13823 | 13930 | 61616.333507493706 | 46058.19508290665 | 0.28818118849249014 | 0.003934440237534745 | 0.002940993169942089 | 4.423283094579591 | 6227833.403262468 | 0.1949971267693545 | 2752392.2476383382 | 43471637.68745655 | 0.05538071507067458 |
| 2026-06-09 | 47487 | 0.216461181640625 | 0.086822509765625 | 1.107513427734375 | 1.1943359375 | 1745.3126220703125 | 15285.31756438504 | 650 | 17007262.06598901 | 6920139.324147359 | 17.19672029688438 | 11.2646831531074 | 8.622910396953337 | 12.07052214524835 | 9.239765512109042 | 0.000509943082246432 | 0.0003903521693412396 | 6920156.520867655 | 2436.192816034636 | 1864.861361553096 | 875142096.363381 | 402281161.67394835 | 576129792.7351286 | 78049369.01408826 | 42286107.993381076 | 78049369.01408826 | 99 | 794 | 1.2146048611105895 | 73 | 480 | 0 | 0 | 2549.9827201639723 | 1081.4563201639933 | 1468.5264000000002 | 12.749913600819863 | 0.7654818408784696 | 165527098.4599303 | 603398853.4390244 | 0.214813232421875 | 7043 | 8 | 15 | 13800 | 13910 | 61550.204223209104 | 47115.56363522786 | 0.2878412064729971 | 0.00393237635126267 | 0.0030101626883915077 | 4.42488887298412 | 6227833.403262468 | 0.19529996830485147 | 2752941.8395794304 | 43639682.23280234 | 0.055205113077429285 |
| 2026-06-08 | 39188 | 0.18975830078125 | 0.000213623046875 | 1.224609375 | 1.224822998046875 | 1745.7786254882812 | 15301.933329672494 | 651 | 6959474.267497 | 4466118.247777228 | 6.882055719985172 | 1.2189468764449884 | 0.9443786605848682 | 1.2959781011740426 | 1.0040585746472421 | 0.000234433522245768 | 0.00018162728828703215 | 4466125.129832949 | 2277.1995928789497 | 1764.2595776440994 | 874889827.1947253 | 402219611.4697252 | 575942667.1401514 | 78055398.57635964 | 42283671.80056504 | 78055398.57635964 | 98 | 790 | 0.8405076388885427 | 73 | 480 | 0 | 0 | 2544.4073422385686 | 1075.8809422385896 | 1468.5264000000002 | 12.722036711192843 | 0.7747496456442073 | 186542588.6620209 | 610642401.3344948 | 0.1841888427734375 | 6036 | 7 | 14 | 13833 | 13929 | 61666.56422662867 | 47776.14878267631 | 0.2883630902313587 | 0.003935532382093836 | 0.003049052318448503 | 4.427206850931773 | 6227833.403262468 | 0.19532459900999655 | 2754230.2046036725 | 43795005.68475736 | 0.05505945393777728 |
| 2026-06-07 | 38880 | 0.1978759765625 | 6.103515625e-05 | 2.5380859375 | 2.53814697265625 | 1750.5194702148438 | 15329.296740626887 | 653 | 4163267.331775 | 4943470.68834172 | 6.428420613830153 | 0.0004286045816663091 | 0.00032376998851980557 | 0.0005424065230463209 | 0.0004097365293133995 | 0.0 | 0.0 | 4943477.116762334 | 2277.3900517484267 | 1720.3515371745912 | 874618991.3358414 | 402157944.90549856 | 575755541.5451742 | 78079719.4756326 | 42281394.60097216 | 78079719.4756326 | 96 | 783 | 1.760284947096352 | 73 | 480 | 0 | 0 | 2537.8820080390633 | 1069.3556080390838 | 1468.5264000000002 | 12.689410040195316 | 0.7554048705244063 | 188743578.60627177 | 595294925.5853659 | 0.19080543518066406 | 6271 | 7 | 16 | 13656 | 13792 | 61104.99748495973 | 46159.01271352018 | 0.2856481072395605 | 0.0038927323357409076 | 0.00294058896606653 | 4.43046675499998 | 6227833.403262468 | 0.19522381913267686 | 2754068.1082531493 | 43951945.93575919 | 0.05488402190145711 |
| 2026-06-06 | 44073 | 0.2301025390625 | 0.000213623046875 | 0.739044189453125 | 0.7392578125 | 1752.0762023925781 | 15329.25791251834 | 654 | 10290774.511171 | 9627701.00650389 | 13.291434101826878 | 3.6963426061656937 | 2.672794642469811 | 4.099396871006073 | 2.9642398342366705 | 0.000176868539229549 | 0.00012789217192303988 | 9627714.297937991 | 2279.412664355559 | 1648.2243683539857 | 874284720.8341458 | 402096839.9080136 | 575568415.9501971 | 78168036.77491789 | 42279117.21092041 | 78168036.77491789 | 97 | 782 | 1.0306308108594788 | 74 | 481 | 0 | 0 | 2532.769954238033 | 1064.2435542380538 | 1468.5264000000002 | 12.663849771190165 | 0.723091695561837 | 468374615.68292683 | 569747671.8118467 | 0.21387171745300293 | 7016 | 7 | 16 | 13807 | 13915 | 61639.48659421739 | 44571.000874973775 | 0.2878211291358479 | 0.00392679224726257 | 0.002839430864192168 | 4.429715170263557 | 6227833.403262468 | 0.19505723371300396 | 2754828.288738091 | 44105045.4001444 | 0.05473218210899604 |
| 2026-06-05 | 51303 | 0.209197998046875 | 0.118621826171875 | 1.42431640625 | 1.542938232421875 | 1750.6249084472656 | 15311.8765254303 | 655 | 10691087.082912 | 20357401.809967633 | 25.010342685615825 | 3.085466892398733 | 2.413998942463533 | 3.4433932435098753 | 2.694032358213589 | 0.000204694987185955 | 0.00016014869056343295 | 20357426.82031032 | 2192.3455797708025 | 1715.2411922225854 | 874037514.9458866 | 402035200.4214194 | 575381290.35522 | 78168756.99426997 | 42276837.798256055 | 78168756.99426997 | 97 | 783 | 1.6010355428176652 | 74 | 482 | 0 | 0 | 2530.4741828280175 | 1061.9477828280385 | 1468.5264000000002 | 12.652370914140088 | 0.7823771982161244 | 461392924.4843206 | 616336990.2195122 | 0.19387054443359375 | 6359 | 7 | 16 | 14003 | 14117 | 62592.348900239675 | 48970.826562335635 | 0.2922677579517119 | 0.0039920215279539385 | 0.0031232666182590546 | 4.433827930880476 | 6227833.403262468 | 0.19496841968409312 | 2757101.49356143 | 44256712.178917654 | 0.0546127822240837 |
| 2026-06-04 | 49165 | 0.200927734375 | 0.153350830078125 | 0.67755126953125 | 0.830902099609375 | 1755.9362182617188 | 15359.538947848894 | 657 | 15251345.380980998 | 24661678.36777662 | 35.093326697401835 | 7.5662829987881555 | 6.592699891001459 | 8.270147548040066 | 7.205995446808198 | 0.0017961060840086251 | 0.001564994117477135 | 24661713.46110332 | 2199.0401485828147 | 1916.0810863394545 | 873746832.598599 | 401972608.0725191 | 575194164.7602427 | 78211913.74326009 | 42274645.45267628 | 78211913.74326009 | 97 | 784 | 7.184038214369122 | 74 | 482 | 0 | 0 | 2528.426521543785 | 1059.9001215438057 | 1468.5264000000002 | 12.642132607718924 | 0.8713261045162295 | 467165909.0383275 | 686260866.2578397 | 0.19078731536865234 | 6268 | 6 | 14 | 13834 | 13954 | 61895.036804759926 | 53930.761307980116 | 0.28885226498736855 | 0.003935298584474348 | 0.0034289283857182654 | 4.435648330569007 | 6227833.403262468 | 0.19502676001393737 | 2759859.8584461883 | 44412092.20696324 | 0.054499682319614044 |
daily_storage_providers_metrics
Daily metrics for storage providers.
Columns
| column | type | description | tests |
|---|---|---|---|
date | DATE | UTC date. | not_null |
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 | 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-06-13 | f01002224 | 307.09375 | 307.09375 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 |
| 2026-06-13 | f0101020 | 430.90625 | 4250.213134765625 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0 | 1 | 1 | 7.366781508798104 | 5.721334447027926 |
| 2026-06-13 | f0101021 | 437.59375 | 4320.603759765625 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0 | 7 | 7 | 33.27781677498332 | 25.84487122486394 |
| 2026-06-13 | f0101087 | 1339.1875 | 1339.1875383257866 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0 | 3 | 3 | 8.587039845406998 | 6.66903542705231 |
| 2026-06-13 | f01016847 | 503.75 | 5029.4140625 | 0.0 | 0 | 0.0 | 0 | 2.25 | 72 | 2.25 | 72 | 0.0 | 0 | 0 | 6 | 6 | 18.3636992896166 | 14.261976576211387 |
| 2026-06-13 | f01019009 | 526.9375 | 5244.0625 | 0.0 | 0 | 0.0 | 0 | 1.21875 | 39 | 1.21875 | 39 | 0.0 | 0 | 0 | 3 | 3 | 24.61761918096544 | 19.119018591180136 |
| 2026-06-13 | f01021773 | 1010.25 | 7383.9375 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0 | 4 | 4 | 18.118022497437178 | 14.071174243842393 |
| 2026-06-13 | f01045957 | 846.78125 | 846.78125 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0 | 2 | 2 | 7.500651567845236 | 5.825303239822622 |
| 2026-06-13 | f010479 | 61.46875 | 446.74609375 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 |
| 2026-06-13 | f01051151 | 64.90625 | 64.90625 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 |
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2277 | 0x5d59abc30eff32acda6a342455df6531058aa9d0 | 0x86d026029052c6582d277d9b28700edc9670b150 | 0x80b98d3aa09ffff255c3ba4a241111ff1262f045 | USDFC | 18 | True | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | FWSS | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0 | True | 6099658 | 23 | 0x95cae02ff73ad6e8c209437b56080dc557165298ebfd158a7a5a4d432a287c07 | 2026-06-12 20:29:00+00:00 | null | null | null | null | null | null | null | False |
| 2276 | 0x5d59abc30eff32acda6a342455df6531058aa9d0 | 0x86d026029052c6582d277d9b28700edc9670b150 | 0x80b98d3aa09ffff255c3ba4a241111ff1262f045 | USDFC | 18 | True | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | FWSS | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0 | True | 6099648 | 20 | 0xae0136edd90c05ab65a9e5f847aefaf83e8fdfbad784de5e9d7320485438d3bb | 2026-06-12 20:24:00+00:00 | null | null | null | null | null | null | null | False |
| 2275 | 0x5d59abc30eff32acda6a342455df6531058aa9d0 | 0x86d026029052c6582d277d9b28700edc9670b150 | 0x80b98d3aa09ffff255c3ba4a241111ff1262f045 | USDFC | 18 | True | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | FWSS | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0 | True | 6099515 | 16 | 0x0ce1ce0980a73588608ff50cca4c408d5466cc8a270a96ae695f19b694c720d1 | 2026-06-12 19:17:30+00:00 | null | null | null | null | null | null | null | False |
| 2274 | 0x5d59abc30eff32acda6a342455df6531058aa9d0 | 0x86d026029052c6582d277d9b28700edc9670b150 | 0x80b98d3aa09ffff255c3ba4a241111ff1262f045 | USDFC | 18 | True | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | FWSS | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0 | True | 6099484 | 26 | 0xd5f78487a18fbdb943e6024d09350b69bf5a1fa1f9fc783b54c1c144eb2f0e0e | 2026-06-12 19:02:00+00:00 | null | null | null | null | null | null | null | False |
| 2273 | 0x1f91dde7f314b93156f5e377dce1a3f440f1a8f3 | 0x1d60d2f5960af6341e842c539985fa297e10d6ea | 0x80b98d3aa09ffff255c3ba4a241111ff1262f045 | USDFC | 18 | True | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | FWSS | 0x0000000000000000000000000000000000000000 | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0 | True | 6099327 | 7 | 0x589dc01088f8f9c53940dd69dcc1e739cb42a31bbc119594380440a8ec1ddf78 | 2026-06-12 17:43:30+00:00 | null | null | null | null | null | null | null | False |
| 2271 | 0x1f91dde7f314b93156f5e377dce1a3f440f1a8f3 | 0x32c90c26bca6ed3945de9b29ba4e19d38314d618 | 0x80b98d3aa09ffff255c3ba4a241111ff1262f045 | USDFC | 18 | True | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | FWSS | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0 | True | 6099327 | 2 | 0x589dc01088f8f9c53940dd69dcc1e739cb42a31bbc119594380440a8ec1ddf78 | 2026-06-12 17:43:30+00:00 | null | null | null | null | null | null | null | False |
| 2272 | 0x1f91dde7f314b93156f5e377dce1a3f440f1a8f3 | 0x32c90c26bca6ed3945de9b29ba4e19d38314d618 | 0x80b98d3aa09ffff255c3ba4a241111ff1262f045 | USDFC | 18 | True | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | FWSS | 0x0000000000000000000000000000000000000000 | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0 | True | 6099327 | 5 | 0x589dc01088f8f9c53940dd69dcc1e739cb42a31bbc119594380440a8ec1ddf78 | 2026-06-12 17:43:30+00:00 | null | null | null | null | null | null | null | False |
| 2268 | 0xbb33701edeef929199e219c292480735fa260724 | 0x32c90c26bca6ed3945de9b29ba4e19d38314d618 | 0x80b98d3aa09ffff255c3ba4a241111ff1262f045 | USDFC | 18 | True | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | FWSS | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0 | True | 6099057 | 45 | 0x0c15d6453b037e3a13a6184a9a791908d12728cce54c8e788f7359a787996bfd | 2026-06-12 15:28:30+00:00 | null | null | null | null | null | null | null | False |
| 2270 | 0xbb33701edeef929199e219c292480735fa260724 | 0x1d60d2f5960af6341e842c539985fa297e10d6ea | 0x80b98d3aa09ffff255c3ba4a241111ff1262f045 | USDFC | 18 | True | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | FWSS | 0x0000000000000000000000000000000000000000 | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0 | True | 6099057 | 50 | 0x0c15d6453b037e3a13a6184a9a791908d12728cce54c8e788f7359a787996bfd | 2026-06-12 15:28:30+00:00 | null | null | null | null | null | null | null | False |
| 2269 | 0xbb33701edeef929199e219c292480735fa260724 | 0x32c90c26bca6ed3945de9b29ba4e19d38314d618 | 0x80b98d3aa09ffff255c3ba4a241111ff1262f045 | USDFC | 18 | True | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | FWSS | 0x0000000000000000000000000000000000000000 | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0 | True | 6099057 | 48 | 0x0c15d6453b037e3a13a6184a9a791908d12728cce54c8e788f7359a787996bfd | 2026-06-12 15:28:30+00:00 | null | null | null | null | null | null | null | False |
pdp_service_providers
PDP service providers.
Columns
| column | type | description | tests |
|---|---|---|---|
provider_id | BIGINT | Service provider registry identifier. | not_null, unique |
service_provider | 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
| provider_id | service_provider | 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 |
| 5 | 0x010ecc2436e0c5ea4741cd25a27a5476fe7a252c | 0x010ecc2436e0c5ea4741cd25a27a5476fe7a252c | True | False | True | PDP | True | https://pdp.lotus.dedyn.io | C=US;ST=California;L=Chino | US | California | Chino | 0x0000000000000000000000000000000000000000 | 1048576 | 1073741824 | 833000000000000000 | 30 | True | True | 0x0024080112203456597f5d5d0374ecdb37af9932b482c63e307169714eb657c60f1b61b8f1a8 | 60 | 60.0 | testing | {capacityTib:0x3630,serviceStatus:0x74657374696e67,IPNIPeerID:0x0024080112203456597f5d5d0374ecdb37af9932b482c63e307169714eb657c60f1b61b8f1a8,ipniIpfs:0x01,ipniPiece:0x01,paymentTokenAddress:0x0000000000000000000000000000000000000000,location:0x433d55533b53543d43616c69666f726e69613b4c3d4368696e6f,minProvingPeriodInEpochs:0x1e,storagePricePerTibPerDay:0x0b8f691629e68000,maxPieceSizeInBytes:0x40000000,minPieceSizeInBytes:0x100000,serviceURL:0x68747470733a2f2f7064702e6c6f7475732e646564796e2e696f} | 5481060 | 0x471f0fbda2e766d68489abaa031d538352ea51aa34c0dcbda54b6e22d538cb6c | 2025-11-10 01:30:00+00:00 | 5481066 | 0x3d84c94f04f9714f2baf4b21b64540a541a0c4580851456d2a93a6c25e3d1efd | 2025-11-10 01:33:00+00:00 | True | 5496762 | 2025-11-15 12:21:00+00:00 | 5496762 | 0x052e29aff0e02af72cba9ff73213bb5d5abb7d2533a8311e43737e23b4d1e5ae | 2025-11-15 12:21:00+00:00 |
| 16 | 0x1674f650feb5b696f30e1bb920626c15bc62af30 | 0x1674f650feb5b696f30e1bb920626c15bc62af30 | True | False | True | PDP | True | https://pdp2.filstarry.com | C=HK;ST=Hong Kong;L=Hong Kong | HK | Hong Kong | Hong Kong | 0x0000000000000000000000000000000000000000 | 1048576 | 1073741824 | 83333333333333330 | 30 | True | True | 0x00240801122060916c7cb04a54c14eb8889a4d320bf9db5c27b38851c5036b314eb1ad7f8f25 | 5 | 5.0 | testing | {capacityTib:0x35,serviceStatus:0x74657374696e67,IPNIPeerID:0x00240801122060916c7cb04a54c14eb8889a4d320bf9db5c27b38851c5036b314eb1ad7f8f25,ipniIpfs:0x01,ipniPiece:0x01,paymentTokenAddress:0x0000000000000000000000000000000000000000,location:0x433d484b3b53543d486f6e67204b6f6e673b4c3d486f6e67204b6f6e67,minProvingPeriodInEpochs:0x1e,storagePricePerTibPerDay:0x01280f39a3485552,maxPieceSizeInBytes:0x40000000,minPieceSizeInBytes:0x100000,serviceURL:0x68747470733a2f2f706470322e66696c7374617272792e636f6d} | 5502498 | 0x656172b8b40a6d59856736ad6fd5dbf20c3d111283116471df2fa098f4336716 | 2025-11-17 12:09:00+00:00 | 5502507 | 0x364627a02876faafd0a3c02fced2803bf75d896b5c77d38abb78a42fc5ff7cc7 | 2025-11-17 12:13:30+00:00 | False | null | null | null | null | null |
storage_providers
Filecoin storage providers metrics and latest details.
Columns
| column | type | description | tests |
|---|---|---|---|
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 miner actor balance, in FIL. | |
available_balance_fil | DOUBLE | Current available miner 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
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| f03623016 | f03632590 | f03622984 | f03632590 | 12D3KooWQKTq2derMYzNrRhwZsrRRCc47GLkX1WS2hvbq3oFbdct | [f03622996, f03622993, f03622986, f03622991, f03622992, f03622987] | [/dns/a-fil-http.aur.lu/tcp/443/wss] | 34359738368 | 302139 | 302138 | 1 | 464455.3188675133 | 19194.02323207451 | 904.2675286337267 | 824.8356021369285 | 79.43192649679816 | 431146.80316556635 | 14114.492469872519 | 0.0 | 0.0 | 9441.8125 | 81194.59375 | True | True | True | True | 2025-07-31 | 2025-09-28 | 2025-08-20 11:25:00 | 2026-06-13 23:59:30 | 2025-08-24 10:23:00+00:00 | 2026-06-16 19:08:30+00:00 | 255126 | 8 | 7972.625 | 47204.44091061956 |
| f03199233 | f03636147 | f03199206 | f03636147 | 12D3KooWJmosyoJmjmwbEGzqwfuAJPJ8LcE2NE1tj4vyHu41WUbS | [f03199207] | [/dns/retrieval.simpleipfs.com/tcp/443/wss] | 34359738368 | 97444 | 95968 | 0 | 132919.1114715019 | 2134.575702090571 | 447.4211867306294 | 425.08011000905316 | 22.341076721576258 | 123714.1146188024 | 7062.410504167705 | 8.010646441225074 | 0.0 | 2999.0 | 28365.11328125 | True | True | True | True | 2024-09-20 | 2026-06-13 | 2024-09-20 14:04:00 | 2026-06-13 23:59:00 | 2024-09-27 05:17:30+00:00 | 2026-04-06 05:36:00+00:00 | 91046 | 5 | 2836.73828125 | 45964.55979480572 |
| f01084788 | f03338164 | f03696738 | f03338164 | 12D3KooWLGAZMarHVML2KUtY7Hf5H5pfNhXWqCcypqPUYuDeBVFc | [f03696744] | [/dns/f01084868.44943.com/tcp/443/wss] | 34359738368 | 137130 | 136518 | 38 | 288525.3862567486 | 33355.3414020233 | 399.2152269562703 | 351.93000751999483 | 47.2852194362755 | 249150.53931114526 | 6018.448669958547 | 1.0568736214619332 | 0.0 | 4266.1875 | 42661.875 | True | True | True | True | 2026-02-11 | 2026-06-13 | 2026-02-11 04:36:30 | 2026-06-13 23:54:30 | 2026-03-12 09:46:00+00:00 | 2026-07-12 04:49:30+00:00 | 136875 | 9 | 4277.34375 | 10464.472721341694 |
| f01084868 | f03338164 | f03759653 | f03338164 | 12D3KooWLGAZMarHVML2KUtY7Hf5H5pfNhXWqCcypqPUYuDeBVFc | [f03759650] | [/dns/f01084868.44943.com/tcp/443/wss] | 34359738368 | 66312 | 65373 | 5 | 142137.34773049856 | 13850.563315726466 | 299.89486779972935 | 171.1915429529912 | 128.70332484673816 | 126770.66686989274 | 1513.9273081365598 | 2.190236742783335 | 0.0 | 2042.9375 | 20428.8125 | True | True | True | True | 2026-04-19 | 2026-06-13 | 2026-04-19 15:24:00 | 2026-06-13 23:53:00 | 2026-05-19 09:45:30+00:00 | 2026-07-12 05:27:30+00:00 | 65526 | 5 | 2047.6875 | 2216.914518401465 |
| f01083688 | f03338164 | f03696737 | f03338164 | 12D3KooWLGAZMarHVML2KUtY7Hf5H5pfNhXWqCcypqPUYuDeBVFc | [f03696743] | [/dns/f01084868.44943.com/tcp/443/wss] | 34359738368 | 120462 | 120348 | 1 | 257664.28030354372 | 33449.35061006933 | 395.9897031272575 | 305.5441645037953 | 90.4455386234622 | 218652.74620522594 | 5560.863421926118 | 1.320066322335517 | 0.0 | 3741.53125 | 37415.03125 | True | True | True | True | 2025-12-10 | 2026-06-13 | 2025-12-10 01:52:30 | 2026-06-13 23:47:30 | 2026-01-08 15:51:00+00:00 | 2026-07-12 04:49:30+00:00 | 120810 | 10 | 3775.3125 | 9599.371574647108 |
| f01518369 | f02829362 | f01869550 | f02829362 | 12D3KooWGcWttoCPEZUqhp7YJPbnRBUrqvJSpA6xzUN5tPPZs2CM | [f01518485, f01518492, f01518493] | [/ip4/192.168.200.11/tcp/1111] | 34359738368 | 386633 | 385809 | 0 | 604204.3902274328 | 11663.226921378728 | 2341.152077714259 | 2326.476979639445 | 14.675098074814287 | 562907.1978357515 | 29631.98752473257 | 1.9779455701254303 | 0.0 | 12056.53125 | 120456.75 | True | True | True | True | 2021-12-18 | 2026-06-13 | 2022-12-02 07:24:00 | 2026-06-13 23:44:00 | 2022-11-02 08:24:00+00:00 | 2026-08-02 06:13:30+00:00 | 355235 | 34 | 11100.66015625 | 436985.76795943116 |
| f01082688 | f03338164 | f03759652 | f03338164 | 12D3KooWNZ1bNnLikm84dXC4oSWcBX9TEPUAV7Bx2PUpryWmWv8a | [f03759649] | [/dns/f01081439.44943.com/tcp/443/wss] | 34359738368 | 34671 | 33950 | 2 | 89132.11377867099 | 21211.843087578898 | 200.0 | 88.57865118602545 | 111.42134881397455 | 67384.03503320065 | 534.8614815681286 | 1.3741763233084405 | 0.0 | 1060.9375 | 10609.375 | True | True | True | True | 2026-05-05 | 2026-06-13 | 2026-05-05 20:33:30 | 2026-06-13 23:40:30 | 2026-06-03 15:15:30+00:00 | 2026-07-09 16:35:00+00:00 | 34143 | 3 | 1066.96875 | 748.7284962248966 |
| f01081439 | f03338164 | f03759651 | f03338164 | 12D3KooWNZ1bNnLikm84dXC4oSWcBX9TEPUAV7Bx2PUpryWmWv8a | [f03759648] | [/dns/f01081439.44943.com/tcp/443/wss] | 34359738368 | 37957 | 37800 | 1 | 100873.29453169034 | 27023.48932511522 | 299.9790100159665 | 97.48084254595042 | 202.49816747001606 | 73214.80833222534 | 633.1251870961833 | 1.871687253586271 | 0.0 | 1153.8125 | 11538.125 | True | True | True | True | 2026-04-16 | 2026-06-13 | 2026-04-16 23:42:00 | 2026-06-13 23:40:30 | 2026-05-16 14:03:00+00:00 | 2026-07-09 17:07:00+00:00 | 37444 | 5 | 1170.125 | 841.5700380775719 |
| f03780816 | f03200943 | f03741652 | f03286739 | QmQSH8CqPJZnXUSHNqiEHGiUoqQikPPCamExmw1gAgTjis | null | null | 34359738368 | 10758 | 10502 | 0 | 200179.21221628884 | 178932.50467996133 | 0.0 | 0.0 | 0.0 | 20920.308859258443 | 133.46892301105586 | 192.92975405800627 | 0.0 | 328.1875 | 3264.5078125 | True | True | True | False | 2026-05-19 | 2026-06-13 | 2026-05-19 15:20:30 | 2026-06-13 23:32:00 | null | null | 10697 | 1 | 332.3515625 | 141.31895604460792 |
| f03046733 | f03123631 | f03092523 | f03123631 | 12D3KooWKGWdBKoV26bvFuZ5pSPvzR5UYzVaFe5SzQ6692c2Hwhm | [f03092519, f03092520, f03092521, f03092513, f03092522] | [/dns/market.web3.usc.edu/tcp/443/wss] | 34359738368 | 111199 | 111178 | 0 | 180929.1129748114 | 8223.169608425444 | 502.4997310884493 | 431.6601647728501 | 70.8395663155992 | 165569.4874490994 | 7136.455917286571 | 0.0 | 0.0 | 3474.3125 | 34622.29078865051 | True | True | True | True | 2024-05-09 | 2026-06-13 | 2024-08-28 02:39:30 | 2026-06-13 19:51:30 | 2024-05-30 02:05:30+00:00 | 2026-06-16 19:42:00+00:00 | 115540 | 2 | 3602.259157180786 | 29866.15564403004 |
warm_storage_datasets
Warm storage datasets.
Columns
| column | type | description | tests |
|---|---|---|---|
dataset_id | BIGINT | FWSS dataset identifier. | |
payer | VARCHAR | Payer address. | |
provider_id | BIGINT | Service provider registry identifier. | |
service_provider | 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 | provider_id | service_provider | 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 |