Datasets

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
f03771751	2026-04-30 20:51:00	2026-05-31 23:59:30	716	5	22.043127059936523	f410fjmezxhwkpu4hf6uptnzlseyrtnhqrrpn74cs7yy	null	null	null	null	null	172.05592155456543	0.0	f03771751	null	null	null	null	2.970705986022949	1.9726600646972656	172.05592155456543	0.0	null	2026-05-29 16:39:30+00:00	3
f03649823	2025-10-06 20:03:00	2026-05-31 23:59:30	123337	15	3854.28125	f1lurvvlzrl6ljo64jb7wpojbykjmsw4ln6cdvmfq	qizhenys	null	China	Information, Media & Telecommunications	https://www.qizhenys.com/	5120.0	1130.3125	f03251436	Xingchi Allocator	null	null	null	0.0	533.21875	3989.6875	1130.3125	null	2026-04-25 03:00:30+00:00	3
f03535091	2025-05-09 12:11:00	2026-05-31 23:51:00	171022	5	5342.4375	f3r3tkbr34pcrzj42hy2pc7e4ujpxhrmuohy4bapnommhzmnn7vlyn6e5jb2lqpddsjtitzeicjcm2a4cypspa	null	null	null	null	null	6095.92	3416.09375	f03760270	Ramo Cloud	null	null	null	4000.0	1072.28125	2679.82625	3416.09375	null	2026-05-12 15:55:30+00:00	3
f03767350	2026-05-11 22:20:30	2026-05-31 23:35:30	8703	1	269.6513671875	f13dwjgdbcxi2hmpbxjdijghbernii4qtbag5n3sq	TheStarling Lab	null	United States	Education & Training	null	768.0	482.94921875	f03015757	FIDL Enterprise Data	null	null	null	0.0	120.5390625	285.05078125	482.94921875	null	2026-05-29 18:03:00+00:00	3
f03644598	2025-09-08 10:15:30	2026-05-31 23:19:30	10168	4	317.75	f1nplitd46e2m5woeiwlcjqu7kri66hr2rx4sywvi	null	null	null	null	** https://aurorainfra.ai/	410.0	87.25	f03019298	datacap-decentralized-onboarding-to-self-selected-sps	null	null	null	0.0	95.75	322.75	87.25	null	2025-10-15 11:36:00+00:00	3
f03634927	2025-08-10 10:11:00	2026-05-29 16:18:30	155015	14	4844.21875	f16k5n2uqxp3ly5xqnwd6gxyl6xbwzblfau2p3lci	HunanZero Point Realm Media Co., Ltd.	null	China	Information, Media & Telecommunications	http://www.bgyhcm.com/index.html	6912.0	2035.5625	f03251448	Yunphant Allocator	null	null	null	0.0	0.0	4876.4375	2035.5625	null	2026-04-16 07:27:30+00:00	3
f03630410	2025-07-30 14:05:00	2026-05-29 01:07:30	153	8	4.78125	f1egc7pvchnhj6hrgc2woigwqbwv4bar6nz6n3oki	null	null	null	null	https://aurorainfra.ai/	10.0	5.09375	f03019298	datacap-decentralized-onboarding-to-self-selected-sps	null	null	null	0.0	0.25	4.90625	5.09375	null	2025-07-26 08:00:00+00:00	3
f03253574	2025-02-11 21:28:30	2026-05-27 09:48:00	30757	9	961.0706329345703	f410fqslkkgx5ehy4qnghg6uhy55exo2tg5mpck7jpri	null	null	null	null	null	788.0	382.1551513671875	f03015757	FIDL Enterprise Data	null	null	null	0.0	0.0	405.8448486328125	382.1551513671875	null	2025-03-21 11:30:30+00:00	3
f03200311	2024-09-19 16:03:00	2026-05-24 11:57:00	1425	24	44.453125	f1ggmci7w2weizhh36uqetihmh76ewgme6hwgowti	Lighthouse	null	null	null	lighthouse.storage	60.0	10.703125	f02824311	datacap-data-preparation-and-onboarding	null	null	null	0.0	0.375	49.296875	10.703125	null	2026-03-31 06:09:30+00:00	3
f03136439	2025-03-05 01:58:30	2026-05-22 15:43:00	99369	3	3105.28125	f3svae653c6zetlcghrg6e2zc33fyg56imqcj2y35ornyji6kh7vwp7vgteptjfulkes4j4zloocfusj6vctia	Aitrainer	null	China	IT & Technology Services	https://commoncrawl.org/	5084.0	892.8316040039062	f03019859	Herony	null	null	null	0.0	72.4375	4191.168395996094	892.8316040039062	null	2025-11-10 09:49:30+00:00	3

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-05-31	f03649823	137.75	4408	5
2026-05-31	f03535091	3.6875	118	1
2026-05-31	f03644598	0.28125	9	4
2026-05-31	f03771751	2.84375	91	2
2026-05-31	f03767350	21.90234375	704	1
2026-05-30	f03771751	1.71875	55	2
2026-05-30	f03767350	20.640625	667	1
2026-05-30	f03649823	136.84375	4379	5
2026-05-30	f03535091	12.0	384	2
2026-05-30	f03644598	0.1875	6	4

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
arr_eligible_rails	BIGINT	Active recurring rails counted toward 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
arr_filecoin_pay_usd	DOUBLE	End-of-day USD ARR run-rate from the operator’s active stablecoin recurring rails.	not_null

Sample

date	operator	active_rails	recurring_rails	arr_eligible_rails	unique_payers	unique_payees	arr_filecoin_pay_usd
2026-05-31	0x96f1a3026eac5a6c10cd121ef58d3c13d150e441	1	1	1	1	1	46.2528
2026-05-31	0xe6d291a31f5034ed26d91352e784ae5d3a6991eb	1	0	0	1	1	0.0
2026-05-31	0xcb71d6e32e12b618f8e0b4dcf36b6a10b5cedc14	1	0	0	1	1	0.0
2026-05-31	0xd3cb7a77fc4e931feb4b970400edc3181b82bb09	1	0	0	1	1	0.0
2026-05-31	0xe7585412650c57f8b8d0c86ba51e443e3b42576f	1	0	0	1	1	0.0
2026-05-31	0xa5c2ce72e4355d3bd16cb3060de76a085514e643	1	1	1	1	1	11.5632
2026-05-31	0xac405b07220cb8772ef34df0706ab43b66b9ed69	1	1	1	1	1	11.5632
2026-05-31	0x1fef02fa259a27d5dbd99253bb381635c4717503	1	1	1	1	1	11.5632
2026-05-31	0x74d55b94dfe0bb58e3aea354c0f1395da646da81	1	0	0	1	1	0.0
2026-05-31	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	717	560	556	91	16	468.27922092680075

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.
total_value_flow_fil	DOUBLE	FIL value transferred plus gas fees.
protocol_revenue_fil	DOUBLE	Daily total FIL burned on-chain, in FIL.
protocol_revenue_usd	DOUBLE	Daily total FIL burned on-chain, valued with the daily average FIL price, in USD.
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 burnt 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.
arr_filecoin_pay_usd	DOUBLE	End-of-day USD ARR run-rate from active stablecoin recurring Filecoin Pay 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.
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	Protocol revenue over the trailing 365 days, in USD.
annual_block_rewards_usd	DOUBLE	Block reward issuance over the trailing 365 days, in USD.
revenue_coverage_ratio	DOUBLE	Annual 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	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	arr_filecoin_pay_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	annual_protocol_revenue_usd	annual_block_rewards_usd	revenue_coverage_ratio
2026-05-31	38057	0.16558837890625	0.00018310546875	1.978302001953125	1.978485107421875	1748.1809387207031	15374.582638159714	654	8295288.985096001	11951690.915354835	6.063216238654654	2.4579700753166493	2.3380000302880135	2.604912384411127	2.4777702929789545	11951696.978571074	2368.5262364191726	2252.9218187380066	872538732.8988693	401727014.6022148	574445662.380334	78435187.92832482	42265375.117128156	78435187.92832482	94	744	0.9813839205448573	74	482	0	0	1629.3313806550834	0.9511914135027943	168743041.29616725	748405105.8641115	0.16256332397460938	5330	5	13	13735	13831	61384.84497721296	58388.7374615251	0.28565582627477304	0.0038990416249917066	0.0037087349145820936	4.438207286328751	6227833.403262468	2756374.3616621695	45032110.55628947	0.05377248098119581
2026-05-30	42553	0.172332763671875	0.0001220703125	2.644439697265625	2.644561767578125	1749.5026245117188	15381.873255901359	654	6026768.6243929975	12536107.821575942	6.969841193331199	0.10364718302654596	0.10138364382006824	0.11193517428944742	0.10949063457124604	12536114.791417135	2328.3514833731087	2277.5028764435237	872216526.5208324	401665629.7572376	574258536.7853569	78511252.39264375	42263006.590891734	78511252.39264375	94	742	1.6724255872111453	74	482	0	0	1625.7518077151647	0.9781611121462126	251818689.9477352	769420115.891986	0.1673736572265625	5491	5	14	13766	13900	61744.1766206977	60395.75247185384	0.28704961110346866	0.003920006781879881	0.0038343981933843204	4.442027095014223	6227833.403262468	2758269.7237826698	45184384.39872982	0.05365008244549573
2026-05-29	47929	0.268341064453125	0.06097412109375	1.691131591796875	1.752105712890625	1760.1313171386719	15407.536413007561	652	23111533.423269995	16209191.415568486	23.70714374314769	15.658358769551059	15.021172393562805	16.996296284759357	16.304665150596826	16209215.122712228	2952.9892749990413	2832.823134845978	871857965.1699787	401603885.58061695	574071411.1903797	78623272.32338296	42260678.23940837	78623272.32338296	93	748	2.8377317789427865	74	489	0	0	1626.246389744982	0.9593069500216515	291176483.24041814	754010077.4459931	0.261777400970459	8584	7	16	13702	13808	61353.61931744368	58856.95342020637	0.28482751212336443	0.0038887231714804377	0.0037304791651114225	4.443338594832248	6227833.403262468	2758547.132809058	45340846.60316612	0.05349268456096172
2026-05-28	46161	0.19580078125	3.9541015625	1.56268310546875	5.51678466796875	1755.5720825195312	15365.494074568298	647	21256442.334544007	22434830.364334587	24.23248419450406	11.950466852610498	11.595886865602141	12.621282009540995	12.246798395957791	22434854.596818782	10142.23625744272	9841.307930143594	871555321.1520503	401542531.9612995	573884285.5954026	78680390.11629178	42257725.250133365	78680390.11629178	90	720	1.2442071317602925	74	490	0	0	1181.3871227611294	0.970329193714227	502014311.5261324	762486641.8850174	0.196197509765625	6433	5	13	13863	13968	62014.54054203463	60174.5191227107	0.28768677003745197	0.0039413685270502565	0.0038244249449833055	4.439758057133063	6227833.403262468	2756794.494941606	45515983.8545675	0.053277756474846144
2026-05-27	52006	0.210693359375	0.99664306640625	23.2166748046875	24.21331787109375	1746.5019226074219	15217.418231011834	677	12512955.933745002	34277005.67212155	16.183220716470018	0.0012675620365533895	0.0013202419170533343	0.0015000828435475242	0.0015624262892008623	34277021.85534226	6496.540617935933	6766.5368576043875	871186997.8017716	401480517.4207575	573697160.0004253	78809715.56730863	42247583.013875924	78809715.56730863	90	719	1.0210115891476441	74	490	0	0	1180.2151831757076	1.0415600017835702	511372361.1184669	817625524.0522648	0.20957577228546143	6929	6	14	13552	13660	60823.39592988067	63351.21637320931	0.28169800328039174	0.0039032802204730247	0.004065500553397658	4.452664416535921	6227833.403262468	2755127.653202525	45689343.91050463	0.05306774743456509
2026-05-26	43554	0.252777099609375	0.6597900390625	15.822174072265625	16.481964111328125	1794.5601196289062	15652.810874376912	695	15944181.226639997	15581718.223696135	8.300234813517106	0.0016057741286035923	0.0016033752460809846	0.001815624470380261	0.0018129120902689922	15581726.523930948	4974.516874441591	4967.085392406884	869968637.6288782	401419694.0248276	573510034.4054482	79786623.28991303	42241086.47325799	79786623.28991303	89	713	0.5481467935338065	74	490	0	0	1178.3250717438314	0.9985060896922695	226594105.04181185	782561848.4041812	0.24627685546875	8070	5	15	13800	13911	62130.43061247982	62037.613321764096	0.28422818560892943	0.0038762525869600445	0.0038704618132650178	4.466280685247632	6227833.403262468	2752597.1324259317	45863448.851131886	0.052841800264836564
2026-05-25	39295	0.20684814453125	5.362213134765625	4.43731689453125	9.799530029296875	1802.8620910644531	15763.631515128567	691	14675031.058405004	11426801.611206945	4.599005972318148	0.0033640136069370283	0.003281662895903738	0.0035849047733775598	0.0034971466690507822	11426806.210212918	22121.988715479623	21580.44468116494	868991148.0852021	401357563.5942151	573322908.810471	80519831.32487394	42236111.95638354	80519831.32487394	89	711	1.1552908649894489	74	490	0	0	1158.551837412063	0.9755201016834556	142154902.75609756	764060843.3449477	0.2037820816040039	6680	4	9	13888	14007	62605.476763056	61072.90105783761	0.2837934288053629	0.003878431238559895	0.0037834876362122394	4.469584976301563	6227833.403262468	2749531.2676172727	46034870.33284117	0.05260981677298618
2026-05-24	37400	0.146881103515625	6.103515625e-05	3.04925537109375	3.04931640625	1815.8112182617188	15981.357118145417	697	4966688.707085002	11768205.874974094	2.8716437422387315	0.000497508712209688	0.0004790952237069037	0.000566025795164435	0.0005450763942479204	11768208.746617837	1875.2078125092446	1805.8037666130253	868282357.5302919	401294958.117452	573135783.2154939	81001012.79675937	42213989.967668064	81001012.79675937	89	717	1.1234193372115608	75	494	0	0	1156.6678031843985	0.9629886109511517	188961025.05574912	754025008.2508711	0.14374211430549622	4719	6	12	14183	14298	63969.27639215254	61601.68461642928	0.28825301162246453	0.003908929386590224	0.003764254480298657	4.474001705983532	6227833.403262468	2730016.164393077	46203478.57190035	0.05206843127797966
2026-05-23	41947	0.154876708984375	0.0	8.4984130859375	8.4984130859375	1816.5501708984375	15982.871688673302	699	5309974.40511	15649438.337366052	3.2774017226294987	0.000531216409655705	0.0005089286136273365	0.00062751723129753	0.0006011890234311531	15649441.614767775	1876.7476267106451	1798.0065194320473	867963291.1246759	401230988.84105986	572948657.6205167	81070859.53881858	42212114.75985555	81070859.53881858	90	716	1.2486144761002387	76	496	0	0	1157.2796934582234	0.9580438487530651	265612982.56794426	749811311.6480836	0.1473846435546875	4834	6	13	14199	14300	64011.47538125079	61325.800238615586	0.28819465646554826	0.003911137350323784	0.0037470410801060637	4.4763269497378175	6227833.403262468	2729955.142309612	46378294.269058555	0.05189424242199054
2026-05-22	47059	0.2027587890625	0.0001220703125	5.4014892578125	5.401611328125	1826.6695861816406	16068.678776571556	709	7753068.3134159995	12793213.309007615	7.697101479713607	0.000775904797519317	0.0007815234116161628	0.0008820424241503093	0.0008884296201235673	12793221.006109094	1683.8479158776624	1696.0412824702428	867301042.5859281	401166977.3656786	572761532.0255395	81483847.75483468	42210238.01222885	81483847.75483468	89	714	1.7334120728070883	76	496	0	0	1155.6907773544983	1.00724137048103	205807169.16724738	787885995.8327526	0.35111236572265625	11510	7	15	14124	14229	63807.38050013693	64269.433381762465	0.2858197609006275	0.003877848072395157	0.0039059290069565177	4.484319382959936	6227833.403262468	2731031.6172242104	46566649.6401289	0.05172948876077822

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-05-31	f01002224	0.0	0.0	0.0	0	0.0	0	0.03125	1	0.03125	1	0.0	0	0	0	0	0.0	0.0
2026-05-31	f0101020	430.90625	4250.213134765625	0.0	0	0.0	0	0.0	0	0.0	0	0.0	0	0	3	3	9.087598012089778	8.644045198464859
2026-05-31	f0101021	437.59375	4320.603759765625	0.0	0	0.0	0	0.0	0	0.0	0	0.0	0	0	3	3	14.581646746896611	13.869937180379011
2026-05-31	f0101087	1547.96875	1547.9687883257866	0.0	0	0.0	0	0.0	0	0.0	0	0.0	0	0	1	1	2.5360313118958917	2.4122512082495993
2026-05-31	f01016847	553.53125	5526.2421875	0.0	0	0.0	0	5.1875	166	5.1875	166	0.0	0	0	2	2	3.846376285750809	3.65864009610694
2026-05-31	f01019009	576.0625	5734.36328125	0.0	0	0.0	0	5.15625	165	5.15625	165	0.0	0	0	6	6	22.592207995157274	21.48951425706278
2026-05-31	f01021773	1010.25	7383.9375	0.0	0	0.0	0	0.0	0	0.0	0	0.0	0	0	9	9	31.376917937268434	29.845454924111543
2026-05-31	f01045957	1310.34375	1310.34375	0.0	0	0.0	0	0.0	0	0.0	0	0.0	0	0	0	0	0.0	0.0
2026-05-31	f010479	61.46875	441.12109375	0.0	0	0.0	0	0.0	0	0.0	0	0.0	0	0	0	0	0.0	0.0
2026-05-31	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

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
2153	0xd28283fcb6e484fcccd3d5b0d24c6ed7eb28ce86	0x23b1e018f08bb982348b15a86ee926eebf7f4daa	0x80b98d3aa09ffff255c3ba4a241111ff1262f045	USDFC	18	True	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	FWSS	0x0000000000000000000000000000000000000000	0x0000000000000000000000000000000000000000	0	True	6065137	8	0x584b00b8836f05bc9d50cd59de44c2bbf68c746fef87e440eace383c7c5572e6	2026-05-31 20:48:30+00:00	6065137	12	0x584b00b8836f05bc9d50cd59de44c2bbf68c746fef87e440eace383c7c5572e6	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	6065137	2026-05-31 20:48:30+00:00	2026-05-31 20:48:30+00:00	True
2152	0xd28283fcb6e484fcccd3d5b0d24c6ed7eb28ce86	0x32c90c26bca6ed3945de9b29ba4e19d38314d618	0x80b98d3aa09ffff255c3ba4a241111ff1262f045	USDFC	18	True	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	FWSS	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	0	True	6065137	5	0x584b00b8836f05bc9d50cd59de44c2bbf68c746fef87e440eace383c7c5572e6	2026-05-31 20:48:30+00:00	null	null	null	null	null	null	null	False
2150	0xd28283fcb6e484fcccd3d5b0d24c6ed7eb28ce86	0x32c90c26bca6ed3945de9b29ba4e19d38314d618	0x80b98d3aa09ffff255c3ba4a241111ff1262f045	USDFC	18	True	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	FWSS	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	0	True	6063814	57	0x6b38e88a62bb8cd1fbc0e0489aefd325b49fcb61ec45b3b1f27bb85932698e83	2026-05-31 09:47:00+00:00	null	null	null	null	null	null	null	False
2151	0xd28283fcb6e484fcccd3d5b0d24c6ed7eb28ce86	0x23b1e018f08bb982348b15a86ee926eebf7f4daa	0x80b98d3aa09ffff255c3ba4a241111ff1262f045	USDFC	18	True	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	FWSS	0x0000000000000000000000000000000000000000	0x0000000000000000000000000000000000000000	0	True	6063814	60	0x6b38e88a62bb8cd1fbc0e0489aefd325b49fcb61ec45b3b1f27bb85932698e83	2026-05-31 09:47:00+00:00	6063814	64	0x6b38e88a62bb8cd1fbc0e0489aefd325b49fcb61ec45b3b1f27bb85932698e83	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	6063814	2026-05-31 09:47:00+00:00	2026-05-31 09:47:00+00:00	True
2149	0x2001e8df54d84b7d69e4e139a28e2eb4833b49ef	0x23b1e018f08bb982348b15a86ee926eebf7f4daa	0x80b98d3aa09ffff255c3ba4a241111ff1262f045	USDFC	18	True	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	FWSS	0x0000000000000000000000000000000000000000	0x0000000000000000000000000000000000000000	0	True	6061902	5	0x1c6b41e1f962058d2a02db4fbb29ca5eb70b6c124873d88aae742038fe8cac00	2026-05-30 17:51:00+00:00	6061902	9	0x1c6b41e1f962058d2a02db4fbb29ca5eb70b6c124873d88aae742038fe8cac00	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	6061902	2026-05-30 17:51:00+00:00	2026-05-30 17:51:00+00:00	True
2148	0x2001e8df54d84b7d69e4e139a28e2eb4833b49ef	0x89b5899619d93a180d38011b8aec849deea3f573	0x80b98d3aa09ffff255c3ba4a241111ff1262f045	USDFC	18	True	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	FWSS	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	0	True	6061902	2	0x1c6b41e1f962058d2a02db4fbb29ca5eb70b6c124873d88aae742038fe8cac00	2026-05-30 17:51:00+00:00	null	null	null	null	null	null	null	False
2147	0x2001e8df54d84b7d69e4e139a28e2eb4833b49ef	0x23b1e018f08bb982348b15a86ee926eebf7f4daa	0x80b98d3aa09ffff255c3ba4a241111ff1262f045	USDFC	18	True	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	FWSS	0x0000000000000000000000000000000000000000	0x0000000000000000000000000000000000000000	0	True	6061865	17	0x32f78b60d34fdc4dc852f8b512b32e6f19e746278efa8b2c78672ff63c67df65	2026-05-30 17:32:30+00:00	6061865	21	0x32f78b60d34fdc4dc852f8b512b32e6f19e746278efa8b2c78672ff63c67df65	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	6061865	2026-05-30 17:32:30+00:00	2026-05-30 17:32:30+00:00	True
2145	0x2001e8df54d84b7d69e4e139a28e2eb4833b49ef	0x23b1e018f08bb982348b15a86ee926eebf7f4daa	0x80b98d3aa09ffff255c3ba4a241111ff1262f045	USDFC	18	True	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	FWSS	0x0000000000000000000000000000000000000000	0x0000000000000000000000000000000000000000	0	True	6061865	3	0x419d2bcc4473fcd0d70bf64d534d4298aa10481eda49a1d1cadcd77ba5daf3c6	2026-05-30 17:32:30+00:00	6061865	7	0x419d2bcc4473fcd0d70bf64d534d4298aa10481eda49a1d1cadcd77ba5daf3c6	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	6061865	2026-05-30 17:32:30+00:00	2026-05-30 17:32:30+00:00	True
2144	0x2001e8df54d84b7d69e4e139a28e2eb4833b49ef	0x010ecc2436e0c5ea4741cd25a27a5476fe7a252c	0x80b98d3aa09ffff255c3ba4a241111ff1262f045	USDFC	18	True	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	FWSS	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	0	True	6061865	0	0x419d2bcc4473fcd0d70bf64d534d4298aa10481eda49a1d1cadcd77ba5daf3c6	2026-05-30 17:32:30+00:00	null	null	null	null	null	null	null	False
2146	0x2001e8df54d84b7d69e4e139a28e2eb4833b49ef	0x32c90c26bca6ed3945de9b29ba4e19d38314d618	0x80b98d3aa09ffff255c3ba4a241111ff1262f045	USDFC	18	True	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	FWSS	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	0	True	6061865	15	0x32f78b60d34fdc4dc852f8b512b32e6f19e746278efa8b2c78672ff63c67df65	2026-05-30 17:32:30+00:00	null	null	null	null	null	null	null	False

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
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
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
15	0x749cd123a331002e888748a9b1009347c5994b04	0x749cd123a331002e888748a9b1009347c5994b04	True	False	True	PDP	True	https://pdp-main.topblocks.io	C=US;ST=California;L=San Francisco	US	California	San Francisco	0x0000000000000000000000000000000000000000	1048576	1073741824	83333333333333330	30	True	True	0x002408011220ef55a1d38bfc2b452a594c5c0fd8ff4b811f067e532ff4edd0d9a94769b7630d	Enter your available storage capacity in TiB	null	testing	{capacityTib:0x456e74657220796f757220617661696c61626c652073746f7261676520636170616369747920696e20546942,serviceStatus:0x74657374696e67,IPNIPeerID:0x002408011220ef55a1d38bfc2b452a594c5c0fd8ff4b811f067e532ff4edd0d9a94769b7630d,ipniIpfs:0x01,ipniPiece:0x01,paymentTokenAddress:0x0000000000000000000000000000000000000000,location:0x433d55533b53543d43616c69666f726e69613b4c3d53616e204672616e636973636f,minProvingPeriodInEpochs:0x1e,storagePricePerTibPerDay:0x01280f39a3485552,maxPieceSizeInBytes:0x40000000,minPieceSizeInBytes:0x100000,serviceURL:0x68747470733a2f2f7064702d6d61696e2e746f70626c6f636b732e696f}	5501387	0xbdbd8db96b4cc7b03c909907ef2070456fecd73a7d7d1836b636bee9dcfc2f0c	2025-11-17 02:53:30+00:00	5501395	0xb43fe588c101007dabfe99acbd675215b1e9772d7de15c6c14da5ddd352ac6c8	2025-11-17 02:57:30+00:00	False	null	null	null	null	null
26	0x4f1baac6ef581fc7d388501f8d8b1878407a81dc	0x4f1baac6ef581fc7d388501f8d8b1878407a81dc	True	False	True	PDP	True	https://storacha.network	earth	null	null	null	0x4f1baac6ef581fc7d388501f8d8b1878407a81dc	1	1	1	1	null	null	null	null	null	null	{paymentTokenAddress:0x4f1baac6ef581fc7d388501f8d8b1878407a81dc,location:0x6561727468,minProvingPeriodInEpochs:0x01,storagePricePerTibPerDay:0x01,maxPieceSizeInBytes:0x01,minPieceSizeInBytes:0x01,serviceURL:0x68747470733a2f2f73746f72616368612e6e6574776f726b}	5664059	0x03b82f195a1fc27df9efc82202492b6eb13a9450e555713c79f1a78767de94b1	2026-01-12 14:29:30+00:00	5664059	0x03b82f195a1fc27df9efc82202492b6eb13a9450e555713c79f1a78767de94b1	2026-01-12 14:29:30+00:00	False	null	null	null	null	null
11	0x846e8cad00fad118604623a283fc472d902b89c2	0x846e8cad00fad118604623a283fc472d902b89c2	True	False	True	PDP	True	https://la-pdp.laughstorage.com	C=KR;ST=Seoul;L=Seoul	KR	Seoul	Seoul	0x0000000000000000000000000000000000000000	1048576	68719476736	83333333333333330	1440	True	True	0x00240801122021303c1bdc0549d5b949a9a05b5c4d7fe3029cd7c71a1bbcbcc3a0a081134844	5	5.0	testing	{serviceStatus:0x74657374696e67,capacityTib:0x35,IPNIPeerID:0x00240801122021303c1bdc0549d5b949a9a05b5c4d7fe3029cd7c71a1bbcbcc3a0a081134844,ipniIpfs:0x01,ipniPiece:0x01,paymentTokenAddress:0x0000000000000000000000000000000000000000,location:0x433d4b523b53543d53656f756c3b4c3d53656f756c,minProvingPeriodInEpochs:0x05a0,storagePricePerTibPerDay:0x01280f39a3485552,maxPieceSizeInBytes:0x1000000000,minPieceSizeInBytes:0x100000,serviceURL:0x68747470733a2f2f6c612d7064702e6c6175676873746f726167652e636f6d}	5490734	0xdcc72b167d10b74918385c3fe3ca5dc113b21839ecc4ee9f11669164110c3023	2025-11-13 10:07:00+00:00	5490741	0xa6887c460933c10112f84db75c2d05731e11d94c2bb40c6d9fa0eb1362273528	2025-11-13 10:10:30+00:00	False	null	null	null	null	null

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
f01082688	f03338164	f03759652	f03338164	12D3KooWNZ1bNnLikm84dXC4oSWcBX9TEPUAV7Bx2PUpryWmWv8a	[f03759649]	[/dns/f01081439.44943.com/tcp/443/wss]	34359738368	22688	22652	0	50311.30071653098	6533.039417523495	200.0	58.75548004136451	141.2445199586355	43546.95205599874	229.98677677539146	1.322466233354656	0.0	679.65625	6796.5625	True	True	True	True	2026-05-05	2026-05-31	2026-05-05 20:33:30	2026-05-31 23:59:30	2026-06-03 15:15:30+00:00	2026-06-29 05:05:30+00:00	22069	2	689.65625	315.9098153917849
f08240	f08232	f08232	f08232	12D3KooWNp2JjgEN9Q2FnRZSRhvkGEMj4txpnGFQLa1zzp93teQ1	[f02087595, f023832]	[/dns/f08240.rabinovitch.work/tcp/443/wss]	34359738368	1108	1092	0	1048.4042523339444	188.9667041651371	27.358502061729812	5.922476208596357	21.436025853133454	838.2346994421515	20.957162353964204	0.24568637269165822	0.0	33.25	141.40821170806885	True	True	True	True	2020-08-25	2026-05-31	2022-12-12 18:32:00	2026-05-31 23:59:30	2020-08-26 21:54:00+00:00	2025-01-10 00:07:00+00:00	920	15	28.12012767791748	1026.4822275600404
f01081439	f03338164	f03759651	f03338164	12D3KooWNZ1bNnLikm84dXC4oSWcBX9TEPUAV7Bx2PUpryWmWv8a	[f03759648]	[/dns/f01081439.44943.com/tcp/443/wss]	34359738368	27647	27300	0	80433.69122349998	27405.373055058135	299.9790100159665	71.79599744048608	228.1830125754804	52707.2138517034	319.7338947731942	1.370421965246717	0.0	825.4375	8254.375	True	True	True	True	2026-04-16	2026-05-31	2026-04-16 23:42:00	2026-05-31 23:58:30	2026-05-16 14:03:00+00:00	2026-06-29 05:08:30+00:00	27051	4	845.34375	386.0054320820869
f03780816	f03200943	f03741652	f03200943	QmQSH8CqPJZnXUSHNqiEHGiUoqQikPPCamExmw1gAgTjis	null	null	34359738368	8877	8749	0	200065.54771373642	182722.54822950743	0.0	0.0	0.0	17179.162378141384	49.67265052793965	114.1644555596775	0.0	273.40625	2716.6953125	True	True	True	False	2026-05-19	2026-05-31	2026-05-19 15:20:30	2026-05-31 23:51:00	null	null	8948	1	277.6953125	61.9470326291909
f01083688	f03338164	f03696737	f03338164	12D3KooWLGAZMarHVML2KUtY7Hf5H5pfNhXWqCcypqPUYuDeBVFc	[f03696743]	[/dns/f01084868.44943.com/tcp/443/wss]	34359738368	111997	111490	0	255734.1288549872	49429.01915236952	396.00289128938783	284.51662750972855	111.48626377965928	201818.13393592383	4485.704005349278	1.2717613445826863	0.0	3456.78125	34567.53125	True	True	True	True	2025-12-10	2026-05-31	2025-12-10 01:52:30	2026-05-31 23:45:30	2026-01-08 15:51:00+00:00	2026-06-29 04:19:30+00:00	112110	9	3503.4375	7593.915987625255
f01084868	f03338164	f03759653	f03338164	12D3KooWLGAZMarHVML2KUtY7Hf5H5pfNhXWqCcypqPUYuDeBVFc	[f03759650]	[/dns/f01084868.44943.com/tcp/443/wss]	34359738368	51173	50405	1	111208.20549703403	13674.297866994368	299.923665342698	133.19542888485725	166.72823645784072	96651.10209269529	880.9808565666946	1.8246807776778695	0.0	1575.125	15750.6875	True	True	True	True	2026-04-19	2026-05-31	2026-04-19 15:24:00	2026-05-31 23:44:30	2026-05-19 09:45:30+00:00	2026-06-29 04:19:30+00:00	50597	4	1581.15625	1258.9346599397418
f01084788	f03338164	f03696738	f03338164	12D3KooWLGAZMarHVML2KUtY7Hf5H5pfNhXWqCcypqPUYuDeBVFc	[f03696744]	[/dns/f01084868.44943.com/tcp/443/wss]	34359738368	128663	127933	0	286495.01987711113	49263.2928402441	399.2336225043639	330.91507821118483	68.31854429317906	232311.95028304987	4918.457006957676	1.3197468594564816	0.0	3996.65625	39966.5625	True	True	True	True	2026-02-11	2026-05-31	2026-02-11 04:36:30	2026-05-31 23:41:30	2026-03-12 09:46:00+00:00	2026-06-29 04:19:30+00:00	128170	8	4005.3125	8218.737549618918
f03046733	f03123631	f03092523	f03123631	12D3KooWKGWdBKoV26bvFuZ5pSPvzR5UYzVaFe5SzQ6692c2Hwhm	[f03092519, f03092520, f03092521, f03092513, f03092522]	[/dns/market.web3.usc.edu/tcp/443/wss]	34359738368	104372	104356	0	166745.31275204837	7842.775595442685	502.4997310884493	414.9764670257265	87.52326406272283	152068.17359684163	6833.753191389709	0.6103683743472607	0.0	3240.625	32298.988298416138	True	True	True	True	2024-05-09	2026-05-31	2024-08-28 02:39:30	2026-05-31 23:35:30	2024-05-30 02:05:30+00:00	2026-06-03 23:52:00+00:00	108166	2	3376.593385696411	28230.057452125588
f03623017	f03632590	f03622985	f03632590	12D3KooWJLEqAUExUULbfFagCDXwTVabndyVcr3LnvkA8SmYr1Hv	[f03622994, f03622995, f03622988, f03622989, f03622990, f03622997]	[/dns/p-fil-http.aur.lu/tcp/443/wss]	34359738368	29696	29696	0	24699.525691908904	13442.135527374867	20.894243226088786	15.287628013308083	5.606615212780703	10699.883032571224	557.5071319628141	0.0	0.0	928.0	2268.71875	True	True	True	True	2025-07-31	2025-08-20	2025-08-25 16:03:30	2026-05-31 23:19:30	2025-08-29 11:29:00+00:00	2026-06-03 23:05:00+00:00	4767	5	148.96875	1852.0943019151546
f03644168	f03632590	f03644165	f03632590	12D3KooWQKTq2derMYzNrRhwZsrRRCc47GLkX1WS2hvbq3oFbdct	[f03644177, f03644178, f03644179, f03644180, f03644181, f03644182]	[/dns/a-fil-http.aur.lu/tcp/443/wss]	34359738368	73215	73215	0	113977.96043187984	13422.826241926858	193.96085591826423	164.88064217000422	29.080213748260007	97235.98242983429	3319.1517601186983	0.0	0.0	2287.96875	18001.7578125	True	True	True	True	2025-10-08	2025-12-20	2025-10-10 12:50:30	2026-05-31 23:18:30	2025-10-12 11:55:30+00:00	2026-06-03 23:05:00+00:00	55872	6	1745.9765625	8134.151387097618

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