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-06-22 23:59:30 | 178759 | 14 | 5586.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 | 381.78125 | 5526.21875 | 1385.78125 | null | 2026-04-16 07:27:30+00:00 | 3 |
| f03535091 | 2025-05-09 12:11:00 | 2026-06-22 23:58:00 | 185204 | 5 | 5785.6015625 | f3r3tkbr34pcrzj42hy2pc7e4ujpxhrmuohy4bapnommhzmnn7vlyn6e5jb2lqpddsjtitzeicjcm2a4cypspa | null | null | null | null | null | 6095.92 | 3085.4296875 | f03760270 | Ramo Cloud | null | null | null | 0.0 | 215.46875 | 3010.4903125 | 3085.4296875 | null | 2026-05-12 15:55:30+00:00 | 3 |
| f03235906 | 2024-11-17 15:35:00 | 2026-06-22 23:57:30 | 135411 | 22 | 4231.59375 | 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 | 1290.3125 | 3967.84375 | 470.55624999999964 | null | 2026-03-05 14:42:00+00:00 | 3 |
| f03771751 | 2026-04-30 20:51:00 | 2026-06-22 23:55:30 | 2705 | 5 | 84.02897453308105 | f410fjmezxhwkpu4hf6uptnzlseyrtnhqrrpn74cs7yy | null | null | null | null | null | 319.4045925140381 | 0.0 | f03771751 | null | null | null | null | 147.34867095947266 | 14.5 | 319.4045925140381 | 0.0 | null | 2026-06-17 22:55:00+00:00 | 3 |
| f03200311 | 2024-09-19 16:03:00 | 2026-06-22 21:27:30 | 1498 | 24 | 46.734375 | f1ggmci7w2weizhh36uqetihmh76ewgme6hwgowti | Lighthouse | null | null | null | lighthouse.storage | 60.0 | 8.015625 | f02824311 | datacap-data-preparation-and-onboarding | null | null | null | 0.0 | 1.0625 | 51.984375 | 8.015625 | null | 2026-03-31 06:09:30+00:00 | 3 |
| f03791343 | 2026-06-14 00:17:00 | 2026-06-22 09:07:30 | 69 | 2 | 2.15625 | f1utbrvr4no6whk65d4qxursrarrmzq6qlawrk5ii | null | null | null | null | null | 10.0 | 8.53125 | f03019296 | datacap-decentralized-onboarding-to-the-mix | null | null | null | 10.0 | 1.09375 | 1.46875 | 8.53125 | null | 2026-06-10 11:29:00+00:00 | 3 |
| f03644598 | 2025-09-08 10:15:30 | 2026-06-22 03:39:30 | 10833 | 4 | 338.53125 | 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 | 5.8125 | 343.03125 | 66.96875 | null | 2025-10-15 11:36:00+00:00 | 3 |
| f03767350 | 2026-05-11 22:20:30 | 2026-06-20 04:53:00 | 17791 | 1 | 547.781005859375 | f13dwjgdbcxi2hmpbxjdijghbernii4qtbag5n3sq | TheStarling Lab | null | United States | Education & Training | null | 768.0 | 220.218994140625 | f03015757 | FIDL Enterprise Data | null | null | null | 0.0 | 143.964111328125 | 547.781005859375 | 220.218994140625 | null | 2026-05-29 18:03:00+00:00 | 3 |
| f03774028 | 2026-05-08 19:43:00 | 2026-06-15 11:44:00 | 160865 | 3 | 5027.03125 | f1vjvnnlikd4uiyodie2ia5prifbctljzbvw2wgti | null | null | null | null | null | 10240.0 | 5139.9375 | f03777695 | Large Data Onboarding | null | null | null | 5120.0 | 878.15625 | 5100.0625 | 5139.9375 | null | 2026-06-16 09:16:30+00:00 | 3 |
| f03662041 | 2026-04-02 16:00:30 | 2026-06-14 23:44:00 | 8259 | 2 | 258.09375 | f1hwh6vu3xs6rkd4terlahvjuargtsmiy34hztayy | CERNOpen Data Sets | null | United States | Not-for-Profit | None. | 450.0 | 2.40625 | f03016877 | FIL-DC-Allocator | null | null | null | 0.0 | 179.6875 | 447.59375 | 2.40625 | null | 2026-04-19 23:48: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_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-06-22 | f03535091 | 27.5625 | 882 | 2 |
| 2026-06-22 | f03791343 | 0.0625 | 2 | 1 |
| 2026-06-22 | f03200311 | 0.15625 | 5 | 4 |
| 2026-06-22 | f03634927 | 35.8125 | 1146 | 1 |
| 2026-06-22 | f03771751 | 8.687507629394531 | 279 | 1 |
| 2026-06-22 | f03644598 | 0.1875 | 6 | 4 |
| 2026-06-22 | f03235906 | 128.5 | 4112 | 5 |
| 2026-06-21 | f03235906 | 131.8125 | 4218 | 5 |
| 2026-06-21 | f03644598 | 0.25 | 8 | 4 |
| 2026-06-21 | f03634927 | 36.5625 | 1170 | 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-22 | 0xfba3ff50630a44f86def3683859fa20b67e1ddd8 | 1 | 1 | 1 | 1 | 1 | 437.2992 | 2.186496 |
| 2026-06-22 | 0x47a1588758f3873712e379a1429ae4257d1ccbc0 | 1 | 1 | 1 | 1 | 1 | 46.2528 | 0.231264 |
| 2026-06-22 | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 809 | 620 | 616 | 100 | 18 | 604.2782001118626 | 3.021391000559313 |
| 2026-06-22 | 0x9fa9d8674a3e3dd64beea17d0bfbf9f5c0bbec7d | 1 | 1 | 1 | 1 | 1 | 11.5632 | 0.057816 |
| 2026-06-22 | 0x56e53c5e7f27504b810494cc3b88b2aa0645a839 | 12 | 8 | 8 | 1 | 10 | 567.1241597282818 | 2.835620798641409 |
| 2026-06-22 | 0xb8b6b17ce0c2ee682a50fa451c405e3e4ff0aea8 | 1 | 1 | 1 | 1 | 1 | 17.8704 | 0.089352 |
| 2026-06-22 | 0xed5a6e89f6380b2a698bbdd3f3f8e2a0f40d0a2e | 1 | 0 | 0 | 1 | 1 | 0.0 | 0.0 |
| 2026-06-22 | 0xbf6444312e8facf2803c1ef179cb50ff69f79dc0 | 1 | 1 | 1 | 1 | 1 | 437.2992 | 2.186496 |
| 2026-06-22 | 0xbaf5beda4a93aa653311bfa30a9b99f7617d28b5 | 1 | 0 | 0 | 1 | 1 | 0.0 | 0.0 |
| 2026-06-22 | 0x6bec40e399f04801dd8f479222a7f99dcf109732 | 1 | 1 | 1 | 1 | 1 | 437.2992 | 2.186496 |
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. | |
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_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 | message_burn_fil | message_burn_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-06-22 | 41852 | 0.196563720703125 | 0.087646484375 | 0.4525146484375 | 0.5401611328125 | 1707.0332946777344 | 15030.54311153767 | 631 | 15101803.702349996 | 5949724.895590602 | 9.290786679129118 | 4.365880482046736 | 3.4988791522626808 | 4.628097799524346 | 3.70902386631462 | 0.000868544999289239 | 0.0006960644028877454 | 5949734.186377281 | 2927.0601893465487 | 2345.787960993721 | 879537701.783316 | 403089842.2382692 | 578562425.4698318 | 76864576.58830175 | 42316608.29825669 | 76864576.58830175 | 104 | 840 | 17.421825319562906 | 0 | 0 | 0 | 0 | 2676.428759840123 | 1207.9023598401443 | 1468.5264000000002 | 13.382143799200614 | 0.8014143233308113 | 136719801.3240418 | 633810612.4459931 | 0.1962585523724556 | 6432 | 7 | 16 | 14178 | 14297 | 62815.78357346965 | 50341.46868702687 | 0.2982877421822143 | 0.0040812589532362425 | 0.003270779382345639 | 4.393633879378167 | 6227833.403262468 | 0.19625100646781726 | 2715842.572066475 | 41713108.64561835 | 0.0566497539680674 |
| 2026-06-21 | 36571 | 0.213836669921875 | 0.378936767578125 | 3.092803955078125 | 3.47174072265625 | 1707.5183715820312 | 15027.105024186953 | 630 | 7122036.071928002 | 5812897.397728535 | 4.084941549436992 | 1.8247874316594517 | 1.4533207274378075 | 1.9318321123994104 | 1.5385746318555238 | 7.6018e-06 | 6.054323541558957e-06 | 5812901.482670085 | 3343.951134495925 | 2663.232665342611 | 879289496.6349634 | 403027026.45469576 | 578375299.8748546 | 76865767.41829298 | 42313681.23806734 | 76865767.41829298 | 105 | 861 | 3.269029978243622 | 0 | 0 | 0 | 0 | 2644.77682004213 | 1176.2504200421515 | 1468.5264000000002 | 13.22388410021065 | 0.7964328897838614 | 98568159.42160279 | 629798348.4181185 | 0.2140512466430664 | 7015 | 6 | 14 | 14071 | 14206 | 62423.16334140408 | 49715.860369444454 | 0.29641874900724796 | 0.004056677607062122 | 0.003230871469513966 | 4.39414073922315 | 6227833.403262468 | 0.19618899162125045 | 2719599.2973265825 | 41834701.931930855 | 0.05658459917604851 |
| 2026-06-20 | 35090 | 0.25848388671875 | 0.967132568359375 | 1.6209716796875 | 2.588104248046875 | 1710.7652282714844 | 15038.711106726783 | 632 | 3858688.3482289994 | 2364377.919764167 | 1.4295506763819674 | 0.00038819988637313205 | 0.0003048553517789794 | 0.00045144325646968094 | 0.0003545206930509752 | 0.0 | 0.0 | 2364379.349314844 | 2726.9244767024406 | 2141.467707233643 | 879001500.9585868 | 402964603.29135436 | 578188174.2798774 | 76907558.28748547 | 42310337.28693284 | 76907558.28748547 | 104 | 862 | 2.40070714055891 | 0 | 0 | 0 | 0 | 2689.3730693281573 | 1220.8466693281787 | 1468.5264000000002 | 13.446865346640786 | 0.7853051030673329 | 122977208.76655053 | 620912469.28223 | 0.26810455322265625 | 8786 | 8 | 15 | 13897 | 13999 | 61558.43077838992 | 48342.149827086774 | 0.29215369379069844 | 0.003997394100491218 | 0.003139173986087005 | 4.397344865946848 | 6227833.403262468 | 0.19602101750289455 | 2723221.9998187115 | 41967900.31302907 | 0.05650338297263404 |
| 2026-06-19 | 38518 | 0.285675048828125 | 6.103515625e-05 | 1.2503662109375 | 1.25042724609375 | 1717.5825500488281 | 15112.6336121083 | 633 | 8172149.462516998 | 15252595.989058698 | 3.187442072291362 | 0.6264306845155088 | 0.49047896669837376 | 0.6807131082646718 | 0.532980695570363 | 1.0722999999999999e-06 | 8.395830679932877e-07 | 15252599.17650077 | 1969.411467790184 | 1541.9980623598308 | 878706980.2355795 | 402903044.8605759 | 578001048.6849003 | 76956121.909214 | 42307610.36245614 | 76956121.909214 | 106 | 873 | 3.061073232511263 | 0 | 0 | 0 | 0 | 2690.335623387698 | 1221.8092233877196 | 1468.5264000000002 | 13.45167811693849 | 0.7829740445708177 | 188393541.6933798 | 619015129.3449477 | 0.2853069305419922 | 9367 | 6 | 12 | 14091 | 14196 | 62475.37242542028 | 48916.59503399945 | 0.2963183482943691 | 0.0040370929018829094 | 0.0031609389576954007 | 4.40091380849678 | 6227833.403262468 | 0.19588085095091612 | 2728559.383274302 | 42106246.56984533 | 0.05645208070149308 |
| 2026-06-18 | 42108 | 0.201507568359375 | 0.0357666015625 | 2.164520263671875 | 2.200286865234375 | 1718.7215270996094 | 15132.523534029839 | 633 | 16281227.615078 | 6270133.764095097 | 6.737722486165078 | 2.5320508252216527 | 1.994350437469815 | 2.7068763797139033 | 2.132050446335949 | 5.2869461094052e-05 | 4.164222606095826e-05 | 6270140.501817583 | 2112.6530041891365 | 1664.0149562391546 | 878450578.4663712 | 402840569.48815054 | 577813923.0899231 | 76964892.12248747 | 42305640.95098835 | 76964892.12248747 | 105 | 872 | 12.57014606960201 | 0 | 0 | 0 | 0 | 2649.132064081506 | 1180.6056640815273 | 1468.5264000000002 | 13.24566032040753 | 0.7876423401948229 | 220505929.62020907 | 622584109.3344948 | 0.20108509063720703 | 6598 | 6 | 13 | 14078 | 14179 | 62438.459072638056 | 49179.17402213131 | 0.2961095238754208 | 0.004029404451346342 | 0.0031737295516498687 | 4.403586929447638 | 6227833.403262468 | 0.19586084051472485 | 2738712.9099007016 | 42245027.87193174 | 0.05649992259281437 |
| 2026-06-17 | 42893 | 0.20037841796875 | 0.928863525390625 | 2.37567138671875 | 3.304534912109375 | 1722.3588562011719 | 15137.867703021999 | 633 | 14870553.766388996 | 5815431.174133478 | 5.859830451953797 | 1.1193295200787725 | 0.9050968510006668 | 1.22286260903534 | 0.9888143542988613 | 8.333841529179e-06 | 6.7387963861327106e-06 | 5815437.03396393 | 2441.4362288483794 | 1974.1606050862501 | 878167297.2891693 | 402778131.0290779 | 577626797.4949459 | 77000721.89864378 | 42303528.29798416 | 77000721.89864378 | 105 | 868 | 6.840528226110303 | 0 | 0 | 0 | 0 | 2633.6973629949744 | 1165.1709629949958 | 1468.5264000000002 | 13.168486814974871 | 0.8086062546951954 | 225014096.58188152 | 639024730.4216028 | 0.2003936767578125 | 6572 | 7 | 15 | 13885 | 13990 | 61628.535794323725 | 49833.219510996896 | 0.292132528244834 | 0.0039757327892771584 | 0.0032148024004062855 | 4.405184831617135 | 6227833.403262468 | 0.19597393557722062 | 2744804.1106440825 | 42386001.62745483 | 0.05646137789601955 |
| 2026-06-16 | 45119 | 0.168304443359375 | 0.077301025390625 | 1.41937255859375 | 1.496673583984375 | 1724.0359497070312 | 15147.49162325132 | 637 | 9978470.704522 | 7490828.460096683 | 4.845712669459976 | 1.5767113777174062 | 1.2553436891001926 | 1.7053064394109343 | 1.3577283115668122 | 7.810462274515e-05 | 6.218522085799812e-05 | 7490833.305809353 | 2064.732972735313 | 1643.8959873256588 | 877841430.0206405 | 402716502.49328357 | 577439671.8999687 | 77080276.47262987 | 42301086.86175531 | 77080276.47262987 | 102 | 837 | 3.6587432210685376 | 0 | 0 | 0 | 0 | 2613.072276369884 | 1144.5458763699057 | 1468.5264000000002 | 13.06536138184942 | 0.7961784933127993 | 191251401.24738675 | 629103479.4912893 | 0.167999267578125 | 5505 | 6 | 14 | 14061 | 14185 | 62528.35443616435 | 49783.731024314024 | 0.2960919500243887 | 0.004031218346101317 | 0.003209569349013862 | 4.408061645129669 | 6227833.403262468 | 0.19580411618416094 | 2750191.993333218 | 42529683.15360842 | 0.05640549780925342 |
| 2026-06-15 | 41486 | 0.16943359375 | 0.025177001953125 | 1.976837158203125 | 2.00201416015625 | 1723.2848815917969 | 15137.562401740433 | 638 | 12856748.720316999 | 9700759.155281458 | 14.878260665100928 | 8.41972561581534 | 6.76657333160083 | 9.265891555461737 | 7.446600703343847 | 1.90429e-05 | 1.5303964187895153e-05 | 9700774.033542123 | 2096.055514364295 | 1684.5101600949083 | 877559352.8587571 | 402653974.1388474 | 577252546.3049916 | 77114764.41807267 | 42299022.12878258 | 77114764.41807267 | 102 | 830 | 15.050047578745192 | 0 | 0 | 0 | 0 | 2606.4521216838803 | 1137.9257216839014 | 1468.5264000000002 | 13.032260608419401 | 0.8036572259422228 | 197884606.48432055 | 634929503.3728223 | 0.31640625 | 10368 | 7 | 13 | 13974 | 14096 | 62141.823497601166 | 49940.72548707339 | 0.29412999894101616 | 0.0040089264637745686 | 0.0032218027208834347 | 4.408472155051161 | 6227833.403262468 | 0.19569167256317088 | 2752710.298876156 | 42684852.67207746 | 0.056278043995297504 |
| 2026-06-14 | 54858 | 0.221832275390625 | 6.103515625e-05 | 12.713531494140625 | 12.713592529296875 | 1728.2699890136719 | 15172.075067417725 | 639 | 20867328.007643003 | 6212619.880174459 | 23.790554070257002 | 16.139549342156062 | 12.421083663253288 | 17.171512455662285 | 13.215288005549985 | 5.134547924931001e-05 | 3.9515755983327646e-05 | 6212643.670728529 | 1978.1127380501405 | 1522.3661636258248 | 877287766.404498 | 402591832.3153498 | 577065420.7100145 | 77139179.50937143 | 42296926.07326821 | 77139179.50937143 | 102 | 829 | 25.57353354437278 | 0 | 0 | 0 | 0 | 2586.2865618960905 | 1117.7601618961123 | 1468.5264000000002 | 12.931432809480453 | 0.7696053588565671 | 161209346.17421603 | 607718585.076655 | 0.6836318969726562 | 22404 | 10 | 16 | 13869 | 13994 | 61735.33356613464 | 47511.843543294926 | 0.29211351345656483 | 0.003973643118544061 | 0.0030581370382150304 | 4.41155735073136 | 6227833.403262468 | 0.19603077065031163 | 2752553.5195623944 | 42831307.24288861 | 0.05610684335903355 |
| 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 | 102 | 829 | 21.960040460675323 | 0 | 0 | 0 | 0 | 2570.692585473311 | 1102.1661854733325 | 1468.5264000000002 | 12.853462927366554 | 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 |
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-06-22 | f01002224 | 295.125 | 295.125 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 |
| 2026-06-22 | f0101020 | 430.90625 | 4250.213134765625 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0 | 4 | 4 | 7.93457712851615 | 6.358883760365902 |
| 2026-06-22 | f0101021 | 437.59375 | 4320.603759765625 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0 | 7 | 7 | 19.521291226859976 | 15.644642399117691 |
| 2026-06-22 | f0101087 | 1223.3125 | 1223.3125383257866 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0 | 1 | 1 | 8.784903361475548 | 7.040347382963496 |
| 2026-06-22 | f01016847 | 448.21875 | 4475.15625 | 0.0 | 0 | 0.0 | 0 | 6.53125 | 209 | 6.53125 | 209 | 0.0 | 0 | 0 | 8 | 8 | 48.39277437014242 | 38.78266252594832 |
| 2026-06-22 | f01019009 | 462.75 | 4602.75 | 0.0 | 0 | 0.0 | 0 | 2.78125 | 89 | 2.78125 | 89 | 0.0 | 0 | 0 | 3 | 3 | 16.987586709248053 | 13.614095307615512 |
| 2026-06-22 | f01021773 | 1010.0 | 7381.4375 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0 | 13 | 13 | 47.07542359129385 | 37.72691874292807 |
| 2026-06-22 | f010479 | 61.46875 | 448.15234375 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0 | 0 | 0.0625 | 2 | 1 | 0 | 0 | 0.0 | 0.0 |
| 2026-06-22 | f01051151 | 62.90625 | 62.90625 | 0.0 | 0 | 0.0 | 0 | 0.375 | 12 | 0.375 | 12 | 0.0 | 0 | 0 | 0 | 0 | 0.0 | 0.0 |
| 2026-06-22 | f01051152 | 72.0625 | 72.0625 | 0.0 | 0 | 0.0 | 0 | 0.375 | 12 | 0.375 | 12 | 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-06-22 | 2026-06-22 23:59:30+00:00 | 6128879 | 0x86107c90df08dcfab04a6ad84c66c288c16542c1ceabdaf9bf79b070221cbfd5 | RailOneTimePaymentProcessed | 2224 | 0xf60c59acdc9925d06e38aa2eb35afb07844a3843 | 0x32c90c26bca6ed3945de9b29ba4e19d38314d618 | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x80b98d3aa09ffff255c3ba4a241111ff1262f045 | USDFC | 18 | True | 0.0125 | 0.0124375 | 0.0 | 6.25e-05 | 0.0125 |
| 2026-06-22 | 2026-06-22 23:59:00+00:00 | 6128878 | 0x4535f02d5733194d06aa85cb3a6fb9a5326064535bb4324088b6367e690a4c95 | RailOneTimePaymentProcessed | 2224 | 0xf60c59acdc9925d06e38aa2eb35afb07844a3843 | 0x32c90c26bca6ed3945de9b29ba4e19d38314d618 | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x80b98d3aa09ffff255c3ba4a241111ff1262f045 | USDFC | 18 | True | 0.0125 | 0.0124375 | 0.0 | 6.25e-05 | 0.0125 |
| 2026-06-22 | 2026-06-22 23:58:30+00:00 | 6128877 | 0x61243c0ae7c5fd8023a818723c26f8869e211ea3c4af661bd7438421f1c1a780 | RailOneTimePaymentProcessed | 76 | 0xd19d84c77bbb901971e460830e310933a210dbaa | 0x32c90c26bca6ed3945de9b29ba4e19d38314d618 | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x80b98d3aa09ffff255c3ba4a241111ff1262f045 | USDFC | 18 | True | 0.0008 | 0.000796 | 0.0 | 4e-06 | 0.0008 |
| 2026-06-22 | 2026-06-22 23:57:00+00:00 | 6128874 | 0x694e5e3efd88505560524aeeb811f6e63d1b49a47f9ca0457f96c7d4c36dfc30 | RailSettled | 2258 | 0x5d59abc30eff32acda6a342455df6531058aa9d0 | 0x89b5899619d93a180d38011b8aec849deea3f573 | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x80b98d3aa09ffff255c3ba4a241111ff1262f045 | USDFC | 18 | True | 0.04080578475318624 | 0.04060175582942031 | 0.0 | 0.000204028923765932 | 0.04080578475318624 |
| 2026-06-22 | 2026-06-22 23:57:00+00:00 | 6128874 | 0x364ecd9816a29f6b60dae4af3f388f0facd0d722e887221f065e0c5294aaaeab | RailSettled | 1858 | 0x10b948c0f51d00c4a219a7d47f539b4b40690e82 | 0x89b5899619d93a180d38011b8aec849deea3f573 | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x80b98d3aa09ffff255c3ba4a241111ff1262f045 | USDFC | 18 | True | 0.01399999999999104 | 0.013929999999991083 | 0.0 | 6.9999999999956e-05 | 0.01399999999999104 |
| 2026-06-22 | 2026-06-22 23:57:00+00:00 | 6128874 | 0xc4ac980ad156cbe94cd805d20b1abbec16becd75df88d74840d229d85f65df16 | RailSettled | 1337 | 0x4714c4f258978d9a261be4994da5431a5e483e4d | 0x89b5899619d93a180d38011b8aec849deea3f573 | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x80b98d3aa09ffff255c3ba4a241111ff1262f045 | USDFC | 18 | True | 0.01399999999999104 | 0.013929999999991083 | 0.0 | 6.9999999999956e-05 | 0.01399999999999104 |
| 2026-06-22 | 2026-06-22 23:57:00+00:00 | 6128874 | 0x7a0474f13e464f3e337609741705a99df2062cf2a5054a21b5900c967b9f0a98 | RailSettled | 2262 | 0x5d59abc30eff32acda6a342455df6531058aa9d0 | 0x89b5899619d93a180d38011b8aec849deea3f573 | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x80b98d3aa09ffff255c3ba4a241111ff1262f045 | USDFC | 18 | True | 0.06018016662087264 | 0.059879265787768275 | 0.0 | 0.000300900833104364 | 0.06018016662087264 |
| 2026-06-22 | 2026-06-22 23:56:30+00:00 | 6128873 | 0x8d3ba59ce6140d5a88fca9186f965b3ad986c62a8e8c86a25f16af8465ad727d | RailOneTimePaymentProcessed | 76 | 0xd19d84c77bbb901971e460830e310933a210dbaa | 0x32c90c26bca6ed3945de9b29ba4e19d38314d618 | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x80b98d3aa09ffff255c3ba4a241111ff1262f045 | USDFC | 18 | True | 0.0008 | 0.000796 | 0.0 | 4e-06 | 0.0008 |
| 2026-06-22 | 2026-06-22 23:56:30+00:00 | 6128873 | 0x3377f562477731f7ef04e53d8ea504dab983851e0fe2a06f3fb2a648f6a9318a | RailSettled | 2255 | 0x4aa07d74f1126d1ecb9d8294e21db50b056c55eb | 0x89b5899619d93a180d38011b8aec849deea3f573 | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x80b98d3aa09ffff255c3ba4a241111ff1262f045 | USDFC | 18 | True | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 2026-06-22 | 2026-06-22 23:56:30+00:00 | 6128873 | 0xd71cd62e3746f1ad10e70c9236885a6dab118ad00e81bf539a259d7151bd58d5 | RailSettled | 1946 | 0x9e2b13578c4a451be2d6bd1e1e1ee6c305787fc8 | 0x89b5899619d93a180d38011b8aec849deea3f573 | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x80b98d3aa09ffff255c3ba4a241111ff1262f045 | USDFC | 18 | True | 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2332 | 0xd19d84c77bbb901971e460830e310933a210dbaa | 0x010ecc2436e0c5ea4741cd25a27a5476fe7a252c | 0x80b98d3aa09ffff255c3ba4a241111ff1262f045 | USDFC | 18 | True | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | FWSS | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0 | True | 6127464 | 0 | 0xa1a3605c27787e7b018211aeef167e7911cfd3f95806b75c3fca4886b21fc160 | 2026-06-22 12:12:00+00:00 | null | null | null | null | null | null | null | False |
| 2331 | 0x4aa07d74f1126d1ecb9d8294e21db50b056c55eb | 0x32c90c26bca6ed3945de9b29ba4e19d38314d618 | 0x80b98d3aa09ffff255c3ba4a241111ff1262f045 | USDFC | 18 | True | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | FWSS | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0 | True | 6125189 | 46 | 0xdaf06b5d1320b7eb7edf7bf7dd322c38fd8b3650f558d807ae8b3927fb02b845 | 2026-06-21 17:14:30+00:00 | null | null | null | null | null | null | null | False |
| 2330 | 0x5df2ff00be0c8f320009f9621adb48b861ab4c52 | 0x5df2ff00be0c8f320009f9621adb48b861ab4c52 | 0x80b98d3aa09ffff255c3ba4a241111ff1262f045 | USDFC | 18 | True | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | FWSS | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0 | True | 6124830 | 4 | 0x707ced8496a3841288d325cc504a00e52683e3b5af6962502797dae90de7dd2c | 2026-06-21 14:15:00+00:00 | null | null | null | null | null | null | null | False |
| 2329 | 0x5d59abc30eff32acda6a342455df6531058aa9d0 | 0x010ecc2436e0c5ea4741cd25a27a5476fe7a252c | 0x80b98d3aa09ffff255c3ba4a241111ff1262f045 | USDFC | 18 | True | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | FWSS | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0 | True | 6120044 | 0 | 0x2474a56fb38b59b1c86be88b4776cefd9a471c263726a08fd9cde6807e34541d | 2026-06-19 22:22:00+00:00 | null | null | null | null | null | null | null | False |
| 2328 | 0x53212725d0692768e851743289307389633577ad | 0x261355eab90ed0f9aea99a00470406e48c49bd5c | 0x80b98d3aa09ffff255c3ba4a241111ff1262f045 | USDFC | 18 | True | 0x261355eab90ed0f9aea99a00470406e48c49bd5c | FWSS | 0x0000000000000000000000000000000000000000 | 0x0000000000000000000000000000000000000000 | 0 | True | 6118483 | 40 | 0x880dc92450705f40d8dfbb217478f249fcdfac3c2a5909f6168c57c06dcf5335 | 2026-06-19 09:21:30+00:00 | null | null | null | null | null | null | null | False |
| 2327 | 0x305025d07c1dee47f25a4990179eff2becddca0b | 0x6c8e9ce0a324ec85de5ba9147909b289d56bd796 | 0x80b98d3aa09ffff255c3ba4a241111ff1262f045 | USDFC | 18 | True | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | FWSS | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0 | True | 6115929 | 0 | 0x093cc7bb40420120fa2fc27bb684b5b7544874a9aa94163b801b28e6cc51f66c | 2026-06-18 12:04:30+00:00 | null | null | null | null | null | null | null | False |
| 2326 | 0x305025d07c1dee47f25a4990179eff2becddca0b | 0x6c8e9ce0a324ec85de5ba9147909b289d56bd796 | 0x80b98d3aa09ffff255c3ba4a241111ff1262f045 | USDFC | 18 | True | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | FWSS | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0 | True | 6115449 | 48 | 0xf625649ce47dbb397940faae34575c53487885acdb9f2e73f8d485a0e53101c6 | 2026-06-18 08:04:30+00:00 | null | null | null | null | null | null | null | False |
| 2325 | 0x305025d07c1dee47f25a4990179eff2becddca0b | 0x6c8e9ce0a324ec85de5ba9147909b289d56bd796 | 0x80b98d3aa09ffff255c3ba4a241111ff1262f045 | USDFC | 18 | True | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | FWSS | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0 | True | 6114969 | 0 | 0xcafe585ef5f58a832164b0132f23f0e7f5d7271ed774b646d0069841d9bb689a | 2026-06-18 04:04:30+00:00 | null | null | null | null | null | null | null | False |
| 2324 | 0x305025d07c1dee47f25a4990179eff2becddca0b | 0x6c8e9ce0a324ec85de5ba9147909b289d56bd796 | 0x80b98d3aa09ffff255c3ba4a241111ff1262f045 | USDFC | 18 | True | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | FWSS | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0 | True | 6114495 | 54 | 0x344883072f944b3602639adbae2b8b090d02b242e7445565355023126cfaaf6f | 2026-06-18 00:07:30+00:00 | null | null | null | null | null | null | null | False |
| 2323 | 0x1721eb5d0b038b07f356d7c3858e6f1fb10089ea | 0x1c6a2fd1dc31692929d26a227e684bf93d4f8ecc | 0x80b98d3aa09ffff255c3ba4a241111ff1262f045 | USDFC | 18 | True | 0xe06ef214e75334252fd24b43a453cfb7dfa1b0e3 | FWSS | 0xe06ef214e75334252fd24b43a453cfb7dfa1b0e3 | 0x0000000000000000000000000000000000000000 | 0 | True | 6114344 | 0 | 0xb1f2950650fc05583d63a91160a73a77575bdecf9d24e49f147c50a5d78acdb7 | 2026-06-17 22:52: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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18 | 0x4de3d41c4fc6a80c9a5c908f3c6f4e48975637fd | 0x4de3d41c4fc6a80c9a5c908f3c6f4e48975637fd | True | False | True | PDP | True | https://storacha.network | earth | null | null | null | 0x4de3d41c4fc6a80c9a5c908f3c6f4e48975637fd | 1 | 1 | 1 | 1 | null | null | null | null | null | null | {paymentTokenAddress:0x4de3d41c4fc6a80c9a5c908f3c6f4e48975637fd,location:0x6561727468,minProvingPeriodInEpochs:0x01,storagePricePerTibPerDay:0x01,maxPieceSizeInBytes:0x01,minPieceSizeInBytes:0x01,serviceURL:0x68747470733a2f2f73746f72616368612e6e6574776f726b} | 5535714 | 0x5327e820ed39045e15c47fc11903e69b7da122aae06cfe0e968f8842aaada2c6 | 2025-11-29 00:57:00+00:00 | 5535714 | 0x5327e820ed39045e15c47fc11903e69b7da122aae06cfe0e968f8842aaada2c6 | 2025-11-29 00:57:00+00:00 | False | null | null | null | null | null |
| 29 | 0x4a30c03e35bde301c361cd66fa01a25cf542ebc5 | 0x4a30c03e35bde301c361cd66fa01a25cf542ebc5 | True | False | True | PDP | True | https://sp.reiers.io | C=NO;ST=Viken;L=Drammen | NO | Viken | Drammen | 0x80b98d3aa09ffff255c3ba4a241111ff1262f045 | 1048576 | 68719476736 | 83333333333333333 | 1440 | True | True | 0x002408011220dab53646cc1648db7c9b0fdc047c159c4fcc1a99c536e23c9dcdb20e0096e0a7 | null | null | null | {IPNIPeerID:0x002408011220dab53646cc1648db7c9b0fdc047c159c4fcc1a99c536e23c9dcdb20e0096e0a7,ipniPeerId:0x002408011220dab53646cc1648db7c9b0fdc047c159c4fcc1a99c536e23c9dcdb20e0096e0a7,ipniIpfs:0x01,ipniPiece:0x01,paymentTokenAddress:0x80b98d3aa09ffff255c3ba4a241111ff1262f045,location:0x433d4e4f3b53543d56696b656e3b4c3d4472616d6d656e,minProvingPeriodInEpochs:0x05a0,storagePricePerTibPerDay:0x01280f39a3485555,maxPieceSizeInBytes:0x1000000000,minPieceSizeInBytes:0x100000,serviceURL:0x68747470733a2f2f73702e7265696572732e696f} | 6015864 | 0x3e5aea216e13e74b788b90795475c2400180837b29d0fc592cfbbebcd1a383ef | 2026-05-14 18:12:00+00:00 | 6015864 | 0x3e5aea216e13e74b788b90795475c2400180837b29d0fc592cfbbebcd1a383ef | 2026-05-14 18:12:00+00:00 | False | null | null | null | null | null |
| 28 | 0x4a30c03e35bde301c361cd66fa01a25cf542ebc5 | 0x4a30c03e35bde301c361cd66fa01a25cf542ebc5 | True | True | False | PDP | True | https: | C=NO | NO | null | null | 0x80b98d3aa09ffff255c3ba4a241111ff1262f045 | 1048576 | 68719476736 | 83333333333333333 | 1440 | True | True | 0x002408011220dab53646cc1648db7c9b0fdc047c159c4fcc1a99c536e23c9dcdb20e0096e0a7 | null | null | null | {IPNIPeerID:0x002408011220dab53646cc1648db7c9b0fdc047c159c4fcc1a99c536e23c9dcdb20e0096e0a7,ipniPeerId:0x002408011220dab53646cc1648db7c9b0fdc047c159c4fcc1a99c536e23c9dcdb20e0096e0a7,ipniIpfs:0x01,ipniPiece:0x01,paymentTokenAddress:0x80b98d3aa09ffff255c3ba4a241111ff1262f045,location:0x433d4e4f,minProvingPeriodInEpochs:0x05a0,storagePricePerTibPerDay:0x01280f39a3485555,maxPieceSizeInBytes:0x1000000000,minPieceSizeInBytes:0x100000,serviceURL:0x68747470733a} | 5994847 | 0x117bff8749e42d47e07964e0e94991311e47c54b0d1f61d9033a9b3bc9754d46 | 2026-05-07 11:03:30+00:00 | 5994847 | 0x117bff8749e42d47e07964e0e94991311e47c54b0d1f61d9033a9b3bc9754d46 | 2026-05-07 11:03:30+00:00 | False | null | null | null | null | null |
| 10 | 0x74075b4a9e00304c2dddbae4a76399830c917544 | 0x74075b4a9e00304c2dddbae4a76399830c917544 | True | False | True | PDP | True | https://mokanla.meje.dev | C=NG;ST=Lagos;L=Lagos | NG | Lagos | Lagos | 0x0000000000000000000000000000000000000000 | 1048576 | 1073741824 | 83333333333333330 | 30 | True | True | 0x00240801122024a43e835a090adfcdcb65b95c6f934a345e4e206562f66888faeccc1ae98111 | 1 | 1.0 | testing | {capacityTib:0x31,serviceStatus:0x74657374696e67,IPNIPeerID:0x00240801122024a43e835a090adfcdcb65b95c6f934a345e4e206562f66888faeccc1ae98111,ipniIpfs:0x01,ipniPiece:0x01,paymentTokenAddress:0x0000000000000000000000000000000000000000,location:0x433d4e473b53543d4c61676f733b4c3d4c61676f73,minProvingPeriodInEpochs:0x1e,storagePricePerTibPerDay:0x01280f39a3485552,maxPieceSizeInBytes:0x40000000,minPieceSizeInBytes:0x100000,serviceURL:0x68747470733a2f2f6d6f6b616e6c612e6d656a652e646576} | 5488948 | 0x133bec4c34cd4566d5771fd25770e311ec5ab325ead44842026558828e37150a | 2025-11-12 19:14:00+00:00 | 5724256 | 0x92b0a31ad528d5ca5078c4eaf64a8e92440e7ceea67eaba4bc5e24d914e9f494 | 2026-02-02 12:08:00+00:00 | False | null | null | null | null | null |
| 2 | 0x86d026029052c6582d277d9b28700edc9670b150 | 0x86d026029052c6582d277d9b28700edc9670b150 | True | False | True | PDP | True | https://pdp-main.660688.xyz:8443 | C=CN;ST=Zhejiang;L=Hangzhou | CN | Zhejiang | Hangzhou | 0x0000000000000000000000000000000000000000 | 1048576 | 1073741824 | 83333333333333330 | 30 | True | True | 0x002408011220b45c4247d808f10ebfa3532764d0dd5893524bc91108c8486ba7b9b9195eee8c | 12 | 12.0 | prod | {capacityTib:0x3132,serviceStatus:0x70726f64,IPNIPeerID:0x002408011220b45c4247d808f10ebfa3532764d0dd5893524bc91108c8486ba7b9b9195eee8c,ipniPeerId:0x002408011220b45c4247d808f10ebfa3532764d0dd5893524bc91108c8486ba7b9b9195eee8c,ipniIpfs:0x01,ipniPiece:0x01,paymentTokenAddress:0x0000000000000000000000000000000000000000,location:0x433d434e3b53543d5a68656a69616e673b4c3d48616e677a686f75,minProvingPeriodInEpochs:0x1e,storagePricePerTibPerDay:0x01280f39a3485552,maxPieceSizeInBytes:0x40000000,minPieceSizeInBytes:0x100000,serviceURL:0x68747470733a2f2f7064702d6d61696e2e3636303638382e78797a3a38343433} | 5476431 | 0xe4e00123e5b0c83a1272ad9358108adb614b1c0c1706f394e080ca0671424f81 | 2025-11-08 10:55:30+00:00 | 5874396 | 0x49bcc4b898aee83edb8d878c56a4cb03aa16570989e734377e4e8739dd1b7d7e | 2026-03-26 15:18:00+00:00 | False | null | null | null | null | null |
| 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 |
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 | 396890 | 396395 | 0 | 621489.2751204385 | 7954.456774487571 | 2391.147058307584 | 2351.748733909204 | 39.39832439837983 | 583544.1746480522 | 29988.289900013413 | 2.3537978854506503 | 0.0 | 12359.15625 | 123482.15625 | True | True | True | True | 2021-12-18 | 2026-06-22 | 2022-12-02 07:24:00 | 2026-06-22 23:59:30 | 2022-11-02 08:24:00+00:00 | 2026-08-02 06:13:30+00:00 | 365446 | 34 | 11419.75390625 | 441279.7712965232 |
| f03741653 | f03200943 | f03741652 | f03286739 | Qmaco51xxrAmLZNxPb2r7fdanb6iMyN4oFx8epiHjiv6gS | null | null | 34359738368 | 94917 | 94887 | 0 | 204680.56294022355 | 25307.555882385732 | 0.0 | 0.0 | 0.0 | 175966.16749533065 | 3238.887501224647 | 167.9520612825393 | 0.0 | 2952.375 | 29523.75 | True | True | True | False | 2026-02-06 | 2026-06-22 | 2026-02-06 16:15:00 | 2026-06-22 23:58:00 | null | null | 94934 | 1 | 2966.6875 | 5673.615670401999 |
| f01081439 | f03338164 | f03759651 | f03338164 | 12D3KooWNZ1bNnLikm84dXC4oSWcBX9TEPUAV7Bx2PUpryWmWv8a | [f03759648] | [/dns/f01081439.44943.com/tcp/443/wss] | 34359738368 | 45435 | 45305 | 1 | 141268.7611890191 | 52101.99870930721 | 299.9764544159841 | 115.82071574636832 | 184.1557386696158 | 88264.02664850085 | 901.4308627934624 | 1.3049684175634841 | 0.0 | 1389.03125 | 13890.3125 | True | True | True | True | 2026-04-16 | 2026-06-22 | 2026-04-16 23:42:00 | 2026-06-22 23:57:30 | 2026-05-16 14:03:00+00:00 | 2026-07-20 18:16:30+00:00 | 44920 | 5 | 1403.75 | 1295.9865648380319 |
| f02846602 | f02879787 | f02846599 | f02879787 | 12D3KooWEeN5hRGDNzPXVJFHqY7ELarEPX5tUeRfTkf9b1JrRkjR | [f02849091, f03774938] | [/dns/mkt.lotus.dedyn.io/tcp/443/wss] | 34359738368 | 110886 | 110874 | 0 | 180292.19540317665 | 7851.860605833352 | 643.0846716534608 | 630.6688981423025 | 12.41577351115825 | 163408.45108602772 | 9031.14137889694 | 0.7423324186229807 | 0.0 | 3455.78125 | 34428.97692871094 | True | True | True | True | 2023-12-23 | 2026-06-22 | 2024-08-08 22:06:00 | 2026-06-22 23:55:30 | 2023-12-25 07:00:00+00:00 | 2025-10-24 22:58:00+00:00 | 72583 | 8 | 2202.247444152832 | 74406.03990195184 |
| f01082688 | f03338164 | f03759652 | f03338164 | 12D3KooWNZ1bNnLikm84dXC4oSWcBX9TEPUAV7Bx2PUpryWmWv8a | [f03759649] | [/dns/f01081439.44943.com/tcp/443/wss] | 34359738368 | 42437 | 41751 | 19 | 139568.4921200344 | 55716.80540089521 | 200.0 | 107.65345642645846 | 92.34654357354154 | 83011.56943780452 | 838.7610489624526 | 1.3562323722175946 | 0.0 | 1304.71875 | 13047.1875 | True | True | True | True | 2026-05-05 | 2026-06-22 | 2026-05-05 20:33:30 | 2026-06-22 23:52:00 | 2026-06-03 15:15:30+00:00 | 2026-07-20 18:10:00+00:00 | 41909 | 3 | 1309.65625 | 1229.426455095978 |
| f01084868 | f03338164 | f03759653 | f03338164 | 12D3KooWLGAZMarHVML2KUtY7Hf5H5pfNhXWqCcypqPUYuDeBVFc | [f03759650] | [/dns/f01084868.44943.com/tcp/443/wss] | 34359738368 | 77677 | 76926 | 6 | 203008.255036203 | 51271.91631596111 | 299.8922572297551 | 198.93671492530646 | 100.95554230444864 | 149642.1756656928 | 2092.520692628506 | 1.642361920561746 | 0.0 | 2365.0625 | 23650.0625 | True | True | True | True | 2026-04-19 | 2026-06-22 | 2026-04-19 15:24:00 | 2026-06-22 23:46:00 | 2026-05-19 09:45:30+00:00 | 2026-07-20 16:49:00+00:00 | 76881 | 5 | 2402.53125 | 3024.9971992356577 |
| f01084788 | f03338164 | f03696738 | f03338164 | 12D3KooWLGAZMarHVML2KUtY7Hf5H5pfNhXWqCcypqPUYuDeBVFc | [f03696744] | [/dns/f01084868.44943.com/tcp/443/wss] | 34359738368 | 142867 | 142438 | 2 | 289940.2539204188 | 22523.219349418996 | 599.171012465256 | 365.9181153511484 | 233.2528971141076 | 260695.85213344678 | 6719.928709339975 | 1.2537282130702947 | 0.0 | 4451.1875 | 44511.875 | True | True | True | True | 2026-02-11 | 2026-06-22 | 2026-02-11 04:36:30 | 2026-06-22 23:41:00 | 2026-03-12 09:46:00+00:00 | 2026-07-20 16:45:30+00:00 | 142590 | 9 | 4455.9375 | 11912.359681639555 |
| f01083688 | f03338164 | f03696737 | f03338164 | 12D3KooWLGAZMarHVML2KUtY7Hf5H5pfNhXWqCcypqPUYuDeBVFc | [f03696743] | [/dns/f01084868.44943.com/tcp/443/wss] | 34359738368 | 126202 | 126063 | 20 | 258922.95286917253 | 22540.56882202661 | 395.9897031272575 | 319.5690852774982 | 76.42061784975931 | 230204.05559681694 | 6177.407323744936 | 0.9211265840223405 | 0.0 | 3920.75 | 39207.21875 | True | True | True | True | 2025-12-10 | 2026-06-22 | 2025-12-10 01:52:30 | 2026-06-22 23:33:30 | 2026-01-08 15:51:00+00:00 | 2026-07-20 16:45:30+00:00 | 126528 | 10 | 3954.0 | 10883.288331443484 |
| f03780816 | f03200943 | f03741652 | f03286739 | QmQSH8CqPJZnXUSHNqiEHGiUoqQikPPCamExmw1gAgTjis | null | null | 34359738368 | 16807 | 16416 | 0 | 200252.116779621 | 166724.76074243107 | 0.0 | 0.0 | 0.0 | 33096.74237304039 | 170.7833619911554 | 259.83030215838386 | 0.0 | 513.0 | 5112.421875 | True | True | True | False | 2026-05-19 | 2026-06-22 | 2026-05-19 15:20:30 | 2026-06-22 22:07:30 | null | null | 16501 | 1 | 513.703125 | 259.6048674053118 |
| f08403 | f03054261 | f01154940 | f03054261 | 12D3KooWMdvJ2PT8Rph2UYUneXwGKFu5DfUNbmkZBziJweXV6Nws | [f0134065, f0122565, f01940265, f01789563, f020403] | [/dns4/yablufc.ddns.net/tcp/4567] | 34359738368 | 4726 | 4725 | 0 | 7309.661333317155 | 926.6432902312947 | 84.13388108678781 | 71.96467615575915 | 12.16920493102866 | 5911.951869237889 | 471.0661738479717 | 0.0 | 0.0 | 147.65625 | 1470.4497756958008 | True | True | True | True | 2020-08-26 | 2026-06-22 | 2022-12-18 01:42:30 | 2026-06-22 21:27:30 | 2020-08-27 22:53:00+00:00 | 2026-06-25 13:30:30+00:00 | 15562 | 11 | 338.49268341064453 | 15393.182583641395 |
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 24 | 0xa51ac6a08cf17208a3092f6ce8a92700bf716d58 | 1 | 0x32c90c26bca6ed3945de9b29ba4e19d38314d618 | 0x32c90c26bca6ed3945de9b29ba4e19d38314d618 | 36 | null | null | False | 5491217 | 2025-11-13 14:08:30+00:00 | null | null | 5812276 | 2026-03-05 01:38:00+00:00 | 5898676 | 2026-04-04 01:38:00+00:00 |
| 33 | 0x96370f8d95b5504aa255c8aa2d07ef439a387550 | 1 | 0x32c90c26bca6ed3945de9b29ba4e19d38314d618 | 0x32c90c26bca6ed3945de9b29ba4e19d38314d618 | 45 | null | null | False | 5491219 | 2025-11-13 14:09:30+00:00 | null | null | 5812276 | 2026-03-05 01:38:00+00:00 | 5898676 | 2026-04-04 01:38:00+00:00 |
| 40 | 0x8b4b28dd23da26793c06a2ecf351675c20c95c84 | 7 | 0x89b5899619d93a180d38011b8aec849deea3f573 | 0x89b5899619d93a180d38011b8aec849deea3f573 | 52 | null | null | False | 5491219 | 2025-11-13 14:09:30+00:00 | null | null | 5812276 | 2026-03-05 01:38:00+00:00 | 5898676 | 2026-04-04 01:38:00+00:00 |
| 43 | 0xacfe2698388a0b9aeeaee2278cf110941bb812da | 7 | 0x89b5899619d93a180d38011b8aec849deea3f573 | 0x89b5899619d93a180d38011b8aec849deea3f573 | 55 | null | null | False | 5491219 | 2025-11-13 14:09:30+00:00 | null | null | 5812276 | 2026-03-05 01:38:00+00:00 | 5898676 | 2026-04-04 01:38:00+00:00 |
| 45 | 0xd671636d0c33267bd05419f813462e5614d7c9ce | 1 | 0x32c90c26bca6ed3945de9b29ba4e19d38314d618 | 0x32c90c26bca6ed3945de9b29ba4e19d38314d618 | 57 | null | null | False | 5491219 | 2025-11-13 14:09:30+00:00 | null | null | 5812276 | 2026-03-05 01:38:00+00:00 | 5898676 | 2026-04-04 01:38:00+00:00 |
| 51 | 0xd62a1b5fe75374b24f384b5dab97301328c246d1 | 7 | 0x89b5899619d93a180d38011b8aec849deea3f573 | 0x89b5899619d93a180d38011b8aec849deea3f573 | 63 | null | null | False | 5491220 | 2025-11-13 14:10:00+00:00 | null | null | 5812276 | 2026-03-05 01:38:00+00:00 | 5898676 | 2026-04-04 01:38:00+00:00 |
| 196 | 0xa5f90bc2aa73a2e0bad4d7092a932644d5dd5d71 | 5 | 0x010ecc2436e0c5ea4741cd25a27a5476fe7a252c | 0x010ecc2436e0c5ea4741cd25a27a5476fe7a252c | 272 | null | null | False | 5670127 | 2026-01-14 17:03:30+00:00 | null | null | 5692912 | 2026-01-22 14:56:00+00:00 | 5779312 | 2026-02-21 14:56:00+00:00 |
| 232 | 0xa5f90bc2aa73a2e0bad4d7092a932644d5dd5d71 | 13 | 0x40dbb5c4dc728b9d5f23444a1e5449d655ce0224 | 0x40dbb5c4dc728b9d5f23444a1e5449d655ce0224 | 328 | null | null | False | 5696773 | 2026-01-23 23:06:30+00:00 | null | null | 5919386 | 2026-04-11 06:13:00+00:00 | 5995118 | 2026-05-07 13:19:00+00:00 |
| 234 | 0xa5f90bc2aa73a2e0bad4d7092a932644d5dd5d71 | 15 | 0x749cd123a331002e888748a9b1009347c5994b04 | 0x749cd123a331002e888748a9b1009347c5994b04 | 330 | null | null | False | 5697852 | 2026-01-24 08:06:00+00:00 | null | null | 5919386 | 2026-04-11 06:13:00+00:00 | 5995118 | 2026-05-07 13:19:00+00:00 |
| 283 | 0xa5f90bc2aa73a2e0bad4d7092a932644d5dd5d71 | 11 | 0x846e8cad00fad118604623a283fc472d902b89c2 | 0x846e8cad00fad118604623a283fc472d902b89c2 | 389 | null | null | False | 5808961 | 2026-03-03 22:00:30+00:00 | null | null | 5919390 | 2026-04-11 06:15:00+00:00 | 5995118 | 2026-05-07 13:19:00+00:00 |