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
f03774028	2026-05-08 19:43:00	2026-05-11 23:59:30	17828	2	557.125	f1vjvnnlikd4uiyodie2ia5prifbctljzbvw2wgti	null	null	null	null	null	5120.0	4402.59375	f03777695	Large Data Onboarding	null	null	null	5120.0	503.3125	717.40625	4402.59375	null	2026-05-07 12:11:30+00:00	3
f03309602	2025-03-24 23:59:30	2026-05-11 23:59:00	193822	21	6056.9375	f1ucj4c2jvrxlc2pgnebsdhaarrdx4uhptal67etq	NationalMicrobiology Data Center	null	China	Environment	https://nmdc.cn/	6656.0	471.9375	f03012911	Marshall-Fil-Data-Pathway	null	null	null	0.0	1387.0	6184.0625	471.9375	null	2026-03-20 07:02:30+00:00	3
f03535091	2025-05-09 12:11:00	2026-05-11 23:55:00	136505	4	4265.7109375	f3r3tkbr34pcrzj42hy2pc7e4ujpxhrmuohy4bapnommhzmnn7vlyn6e5jb2lqpddsjtitzeicjcm2a4cypspa	null	null	null	null	null	2095.92	449.1328125	f03760270	Ramo Cloud	null	null	null	0.0	781.0	1646.7871875	449.1328125	null	2026-04-21 23:15:30+00:00	3
f03136439	2025-03-05 01:58:30	2026-05-11 23:40:30	97498	3	3046.8125	f3svae653c6zetlcghrg6e2zc33fyg56imqcj2y35ornyji6kh7vwp7vgteptjfulkes4j4zloocfusj6vctia	Aitrainer	null	China	IT & Technology Services	https://commoncrawl.org/	5084.0	946.2691040039062	f03019859	Herony	null	null	null	0.0	93.09375	4137.730895996094	946.2691040039062	null	2025-11-10 09:49:30+00:00	3
f03767350	2026-05-11 22:20:30	2026-05-11 23:31:00	48	1	1.484375	f13dwjgdbcxi2hmpbxjdijghbernii4qtbag5n3sq	TheStarling Lab	null	United States	Education & Training	null	256.0	243.109375	f03015757	FIDL Enterprise Data	null	null	null	0.0	0.0	12.890625	243.109375	null	2026-04-08 08:57:00+00:00	3
f03630410	2025-07-30 14:05:00	2026-05-11 21:02:00	147	8	4.59375	f1egc7pvchnhj6hrgc2woigwqbwv4bar6nz6n3oki	null	null	null	null	https://aurorainfra.ai/	10.0	5.21875	f03019298	datacap-decentralized-onboarding-to-self-selected-sps	null	null	null	0.0	0.0	4.78125	5.21875	null	2025-07-26 08:00:00+00:00	3
f03644598	2025-09-08 10:15:30	2026-05-11 08:17:00	7124	4	222.625	f1nplitd46e2m5woeiwlcjqu7kri66hr2rx4sywvi	null	null	null	null	** https://aurorainfra.ai/	410.0	181.5	f03019298	datacap-decentralized-onboarding-to-self-selected-sps	null	null	null	0.0	7.34375	228.5	181.5	null	2025-10-15 11:36:00+00:00	3
f03200311	2024-09-19 16:03:00	2026-05-10 16:19:30	1422	24	44.40625	f1ggmci7w2weizhh36uqetihmh76ewgme6hwgowti	Lighthouse	null	null	null	lighthouse.storage	60.0	10.71875	f02824311	datacap-data-preparation-and-onboarding	null	null	null	0.0	0.8125	49.28125	10.71875	null	2026-03-31 06:09:30+00:00	3
f03771751	2026-04-30 20:51:00	2026-05-07 01:59:30	66	3	1.9394559860229492	f410fjmezxhwkpu4hf6uptnzlseyrtnhqrrpn74cs7yy	null	null	null	null	null	7.8438520431518555	0.0	f03771751	null	null	null	null	4.843849182128906	1.9394559860229492	7.8438520431518555	0.0	null	2026-05-11 05:08:00+00:00	3
f03770592	2026-04-12 23:16:00	2026-05-03 08:29:30	12	4	0.375	f1nk464agzj7eta4x74vq3q4bwww7khcevxiiysma	null	null	null	null	null	10.0	9.59375	f03019296	datacap-decentralized-onboarding-to-the-mix	null	null	null	0.0	0.03125	0.40625	9.59375	null	2026-04-12 11:17:00+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-11	f03535091	154.375	4940	1
2026-05-11	f03309602	124.78125	3993	4
2026-05-11	f03767350	1.484375	48	1
2026-05-11	f03774028	53.8125	1722	2
2026-05-11	f03644598	0.46875	15	4
2026-05-11	f03630410	0.15625	5	2
2026-05-11	f03136439	6.0625	194	3
2026-05-10	f03644598	0.09375	3	3
2026-05-10	f03774028	159.96875	5119	2
2026-05-10	f03136439	6.8125	218	3

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_usdfc	DOUBLE	End-of-day ARR run-rate from the operator’s active ARR-eligible rails.	not_null

Sample

date	operator	active_rails	recurring_rails	arr_eligible_rails	unique_payers	unique_payees	arr_usdfc
2026-05-11	0xac405b07220cb8772ef34df0706ab43b66b9ed69	1	1	0	1	1	0.0
2026-05-11	0xa5c2ce72e4355d3bd16cb3060de76a085514e643	1	1	0	1	1	0.0
2026-05-11	0x1fef02fa259a27d5dbd99253bb381635c4717503	1	0	0	1	1	0.0
2026-05-11	0x74d55b94dfe0bb58e3aea354c0f1395da646da81	1	0	0	1	1	0.0
2026-05-11	0x96f1a3026eac5a6c10cd121ef58d3c13d150e441	1	1	0	1	1	0.0
2026-05-11	0xcb71d6e32e12b618f8e0b4dcf36b6a10b5cedc14	1	0	0	1	1	0.0
2026-05-11	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	574	479	475	72	16	390.70019233710934
2026-05-11	0x9fa9d8674a3e3dd64beea17d0bfbf9f5c0bbec7d	1	0	0	1	1	0.0
2026-05-11	0x8245b106f87207f555c7b692a908cc0efb6fc125	1	0	0	1	1	0.0
2026-05-11	0x56e53c5e7f27504b810494cc3b88b2aa0645a839	12	8	8	1	10	567.1241597282818

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.
usdfc_paid	DOUBLE	Gross USDFC paid through Filecoin Pay rails on the date.
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_usdfc	DOUBLE	End-of-day ARR run-rate from active ARR-eligible 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	usdfc_paid	active_payers	active_datasets	new_payers	new_datasets	arr_usdfc	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-11	43030	0.281280517578125	0.368804931640625	2.318695068359375	2.6875	1879.5504455566406	16353.83567791732	727	10157955.287305998	14623204.596153162	3.586294236880845	0.0010295967333508991	0.0011672634740042692	0.0011447810875660686	0.00129784905678342	14623208.1824474	3328.810021939871	3773.90314542257	863244692.7693869	400470385.78265214	570703150.4807907	82821300.860472	42174161.59535734	82821300.860472	75	596	1.2699103094336917	71	479	1	4	957.8243520653917	1.133709379793119	384718622.90592337	884175738.5261323	0.3331451416015625	10917	7	13	14108	14207	64204.47179994618	72789.21190426179	0.28295416714669075	0.0038339433468075434	0.004346577533871136	4.519213894555232	6159530.6177261695	2717111.7284891615	48540824.44985385	0.049672652492516414
2026-05-10	48319	0.212615966796875	3.0517578125e-05	2.917572021484375	2.9176025390625	1882.0285339355469	16375.719321067649	726	12051636.233889002	11664937.693490006	3.593103542119569	0.001206852984981248	0.001419664141938176	0.0013306496151020088	0.0015652905263133683	11664941.286593549	1833.851455232032	2157.2247697382213	862888547.361165	400406181.31085217	570516024.8858135	82929445.0119386	42170832.7853354	82929445.0119386	74	588	1.0068164422823802	70	475	1	2	954.4238574963017	1.1763356097265107	336594789.24390244	917235464.7038327	0.367919921875	12056	6	14	13909	13999	63248.18651157529	74401.09404418999	0.27837625192597826	0.0037717920006571834	0.004436893242854643	4.518050325850082	6159530.6177261695	2717704.8217495824	48729726.547753796	0.049512508678269306
2026-05-09	58967	0.177581787109375	0.01190185546875	5.554840087890625	5.566741943359375	1885.436279296875	16402.365201766806	728	19451123.816034995	32476225.26914937	5.407960536806073	0.0020964141688986212	0.002599454155900611	0.0022945530495127233	0.0028451369719676347	32476230.67710991	1864.989121164788	2312.4980710601535	862539668.9782356	400342933.1243406	570328834.3166714	83029718.49066967	42168998.933880165	83029718.49066967	73	588	1.1920499999993652	69	475	0	2	953.3700056048668	1.2399525792492943	926985997.1114982	966017143.2020906	0.4786376953125	15684	6	11	14443	14547	65811.65346455942	81603.3294580412	0.28930910463418635	0.003918288127712274	0.0048584914701987215	4.524070493198558	6159530.6177261695	2718554.9458666085	48907943.816334985	0.04936770705040883
2026-05-08	52887	0.24603271484375	0.049652099609375	9.10369873046875	9.153350830078125	1891.9771423339844	16430.876466144255	735	15822857.966852996	33691987.50535481	6.373205150890321	0.001595565391119478	0.0018243857673881224	0.0018395137408539859	0.00210331880248059	33691993.878559954	1923.109601944959	2198.9031640089643	862125027.1859894	400277121.47087604	570141773.6958592	83193352.99776019	42167133.944759004	83193352.99776019	73	586	1.5269335247310265	69	473	0	1	951.4847957357553	1.1434102153018624	624763087.5958188	889415027.3449477	0.28204345703125	9242	6	11	13935	14027	63516.626497554666	72625.55957881696	0.27867092545520583	0.0037750850170303785	0.00431647077210554	4.528168995334331	6159530.6177261695	2719195.704027911	49074803.2348715	0.049230171061437136
2026-05-07	44103	0.228118896484375	0.043243408203125	2.345916748046875	2.38916015625	1900.6864318847656	16515.24849446994	736	8483138.704866998	29159907.400001336	5.099405593703075	0.000849413523211777	0.0009199230243112311	0.001018242150863132	0.001102766053642926	29159912.49940693	1870.4237274498462	2025.6869064117247	861347451.4045843	400213604.8443785	569954648.100882	83722209.66729257	42165210.83515706	83722209.66729257	73	585	2.4520658961608337	69	472	0	12	950.2858265074173	1.0830096286115691	832932533.2160279	841950141.9686412	0.2286396035924554	7494	6	14	14005	14123	63959.242285449924	69268.47523384249	0.2788402686331554	0.0037819714045053106	0.004095911446212871	4.528729185403238	6159530.6177261695	2726675.4474112955	49229118.99260668	0.04922805424204871
2026-05-06	53464	0.2347412109375	0.0029296875	1.51153564453125	1.51446533203125	1901.64111328125	16515.841494238004	737	12151132.632518997	48000203.985566266	34.167151360880105	0.001218232868248258	0.001310287245435036	0.0014520193589736762	0.0015617395456779372	48000238.15271763	1833.750442543369	1972.3157031794892	861038834.403033	400149645.60209304	569767522.5059048	83781612.2553087	42163340.41142961	83781612.2553087	73	717	11.011792727621858	69	604	1	103	1046.0118402969392	1.0755638594114985	1044103282.6759582	835728329.0243902	0.233123779296875	7639	6	13	14170	14272	64687.773312863916	69575.83112112005	0.2818164585714242	0.003824912805555975	0.0041139379790562465	4.532495327414792	6159530.6177261695	2728578.3707896313	49368743.031760275	0.049138541349463806
2026-05-05	37769	0.17120361328125	3.0517578125e-05	0.85638427734375	0.856414794921875	1904.3194274902344	16539.7287946539	737	4371893.190192003	6876330.239584858	2.331031106039319	0.00044087765174342903	0.0004205951861407661	0.000506540745832586	0.00048323746608350135	6876332.570615964	1831.5406337107372	1747.2810670118652	860746134.7858111	400084957.8287802	569580396.9109277	83824332.25468317	42161506.660987064	83824332.25468317	72	615	4.1228284722218875	68	502	0	36	971.1281566346966	0.9539952512393021	177802624.2369338	741178424.2473868	0.167633056640625	5493	5	13	14127	14238	64573.055749690124	61602.388543215086	0.28117331465315804	0.0038126154024931405	0.003637216988780276	4.535261676477744	6159530.6177261695	2729064.1545334007	49511121.4898079	0.04902159488381615
2026-05-04	37645	0.159423828125	0.0001220703125	0.8843994140625	0.884521484375	1904.8206481933594	16538.857745785266	733	4155499.6493270006	10522132.62883026	2.45879565903157	0.000415745421042039	0.0003919097845365945	0.000488803593265495	0.0004607793645381427	10522135.087625919	1973.2780367443906	1860.1454906537376	860467286.846962	400020384.77303046	569393271.3159505	83853313.08343905	42159675.120353356	83853313.08343905	72	580	0.889527083332956	68	467	0	3	945.4394868587398	0.9426677112986548	181823573.31358886	732287507.2926829	0.159271240234375	5219	4	11	14233	14342	65066.88419368007	61336.45080419101	0.2832256932658241	0.0038419750669651653	0.0036217058432425485	4.536806874472184	6159530.6177261695	2728920.2966099367	49666627.793974265	0.048882466109973106
2026-05-03	34100	0.159454345703125	0.000213623046875	3.309417724609375	3.30963134765625	1905.0694885253906	16540.492991668172	732	5044616.671037001	5580528.274084463	1.4162848896692648	0.0005049352422704111	0.00046595096083553285	0.000554515254318517	0.0005117030738157561	5580529.690369353	1978.207745578338	1825.4772545483975	860190270.1308576	399955317.8888368	569206145.7209734	83880110.59840932	42157701.84231661	83880110.59840932	72	577	1.074722916666171	68	464	0	3	942.8429151945701	0.9227935026686042	96620398.2543554	716734439.8954704	0.1590576171875	5212	5	13	14228	14336	65048.25363952004	60026.105818488475	0.2830541401178727	0.0038404952758567795	0.003543984087590105	4.537406085345984	6159530.6177261695	2730360.1968127172	49826041.1370988	0.048768997283258224
2026-05-02	35641	0.158782958984375	0.0	1.322113037109375	1.322113037109375	1908.1109924316406	16549.349979956634	735	6397271.729191002	6738156.654040573	1.6665475636690854	0.0006414021285125862	0.0005916615036778571	0.0006995983966552109	0.0006453446612276366	6738158.320588137	1996.5473197982074	1841.715418274641	859879437.777515	399890269.6351973	569019020.1259961	83940747.3108808	42155723.63457103	83940747.3108808	72	576	0.7071465277773252	68	463	0	0	941.6527202162756	0.9224501718600813	113025821.83972125	716333467.7909408	0.159271240234375	5219	5	15	14119	14247	64678.00891832492	59662.24044227669	0.2812397317331065	0.003816592081308271	0.0035206160213226397	4.539763383050812	6159530.6177261695	2736837.4748196327	49992919.10295232	0.04873941365752696

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-11	f01002224	354.53125	354.53125	0.0	0	0.0	0	0.0	0	0.0	0	0.0	0	0	0	0	0.0	0.0
2026-05-11	f0101020	430.90625	4250.213134765625	0.0	0	0.0	0	0.0	0	0.0	0	0.0	0	0	4	4	27.327330879869077	30.98125134321772
2026-05-11	f0101021	437.59375	4320.603759765625	0.0	0	0.0	0	0.0	0	0.0	0	0.0	0	0	4	4	20.392107818986	23.118723908137028
2026-05-11	f0101087	1845.4375	1845.4375383257866	0.0	0	0.0	0	0.0	0	0.0	0	0.0	0	0	0	0	0.0	0.0
2026-05-11	f01016847	577.75	5768.21875	0.0	0	0.0	0	0.0	0	0.0	0	0.0	0	0	5	5	13.65253464639471	15.478006586568215
2026-05-11	f01019009	600.4375	5978.11328125	0.0	0	0.0	0	0.03125	1	0.03125	1	0.0	0	0	3	3	11.846230566200713	13.4301827080937
2026-05-11	f01021773	1010.75	7388.9375	0.0	0	0.0	0	0.0	0	0.0	0	0.0	0	0	9	9	34.40679785073785	39.00730945202723
2026-05-11	f01045957	1588.1875	1588.1875	0.0	0	0.0	0	0.0	0	0.0	0	0.0	0	0	0	0	0.0	0.0
2026-05-11	f010479	61.90625	445.49609375	0.0	0	0.0	0	0.0	0	0.0	0	0.0	0	0	0	0	0.0	0.0
2026-05-11	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.
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	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
1865	0xd28283fcb6e484fcccd3d5b0d24c6ed7eb28ce86	0x23b1e018f08bb982348b15a86ee926eebf7f4daa	0x80b98d3aa09ffff255c3ba4a241111ff1262f045	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	FWSS	0x0000000000000000000000000000000000000000	0x0000000000000000000000000000000000000000	0	True	6007405	62	0xa3b5778b815ed733f59988776c109ad07f38d86ab28c613a81e816413caa4241	2026-05-11 19:42:30+00:00	6007405	66	0xa3b5778b815ed733f59988776c109ad07f38d86ab28c613a81e816413caa4241	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	6007405	2026-05-11 19:42:30+00:00	2026-05-11 19:42:30+00:00	True
1864	0xd28283fcb6e484fcccd3d5b0d24c6ed7eb28ce86	0x32c90c26bca6ed3945de9b29ba4e19d38314d618	0x80b98d3aa09ffff255c3ba4a241111ff1262f045	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	FWSS	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	0	True	6007405	59	0xa3b5778b815ed733f59988776c109ad07f38d86ab28c613a81e816413caa4241	2026-05-11 19:42:30+00:00	null	null	null	null	null	null	null	False
1862	0xb2613e02f232d00bcf060c2c70a9b60d0930959a	0x010ecc2436e0c5ea4741cd25a27a5476fe7a252c	0x80b98d3aa09ffff255c3ba4a241111ff1262f045	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	FWSS	0x0000000000000000000000000000000000000000	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	0	True	6006868	44	0xbead5e56005b5185b79fc7299548ac82e0ba484b36fb1aa6136760513083cea9	2026-05-11 15:14:00+00:00	null	null	null	null	null	null	null	False
1860	0xb2613e02f232d00bcf060c2c70a9b60d0930959a	0x010ecc2436e0c5ea4741cd25a27a5476fe7a252c	0x80b98d3aa09ffff255c3ba4a241111ff1262f045	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	FWSS	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	0	True	6006868	35	0xbead5e56005b5185b79fc7299548ac82e0ba484b36fb1aa6136760513083cea9	2026-05-11 15:14:00+00:00	null	null	null	null	null	null	null	False
1861	0xb2613e02f232d00bcf060c2c70a9b60d0930959a	0x23b1e018f08bb982348b15a86ee926eebf7f4daa	0x80b98d3aa09ffff255c3ba4a241111ff1262f045	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	FWSS	0x0000000000000000000000000000000000000000	0x0000000000000000000000000000000000000000	0	True	6006868	38	0xbead5e56005b5185b79fc7299548ac82e0ba484b36fb1aa6136760513083cea9	2026-05-11 15:14:00+00:00	6006868	42	0xbead5e56005b5185b79fc7299548ac82e0ba484b36fb1aa6136760513083cea9	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	6006868	2026-05-11 15:14:00+00:00	2026-05-11 15:14:00+00:00	True
1863	0xb2613e02f232d00bcf060c2c70a9b60d0930959a	0x1d60d2f5960af6341e842c539985fa297e10d6ea	0x80b98d3aa09ffff255c3ba4a241111ff1262f045	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	FWSS	0x0000000000000000000000000000000000000000	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	0	True	6006868	46	0xbead5e56005b5185b79fc7299548ac82e0ba484b36fb1aa6136760513083cea9	2026-05-11 15:14:00+00:00	null	null	null	null	null	null	null	False
1859	0x10b948c0f51d00c4a219a7d47f539b4b40690e82	0x23b1e018f08bb982348b15a86ee926eebf7f4daa	0x80b98d3aa09ffff255c3ba4a241111ff1262f045	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	FWSS	0x0000000000000000000000000000000000000000	0x0000000000000000000000000000000000000000	0	True	6006858	3	0x679534e5f265e75d4961df334c86861174a8ceeebaccc119bbc0464f1b7243c9	2026-05-11 15:09:00+00:00	6006858	7	0x679534e5f265e75d4961df334c86861174a8ceeebaccc119bbc0464f1b7243c9	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	6006858	2026-05-11 15:09:00+00:00	2026-05-11 15:09:00+00:00	True
1858	0x10b948c0f51d00c4a219a7d47f539b4b40690e82	0x89b5899619d93a180d38011b8aec849deea3f573	0x80b98d3aa09ffff255c3ba4a241111ff1262f045	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	FWSS	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	0	True	6006858	0	0x679534e5f265e75d4961df334c86861174a8ceeebaccc119bbc0464f1b7243c9	2026-05-11 15:09:00+00:00	null	null	null	null	null	null	null	False
1854	0xb2613e02f232d00bcf060c2c70a9b60d0930959a	0x32c90c26bca6ed3945de9b29ba4e19d38314d618	0x80b98d3aa09ffff255c3ba4a241111ff1262f045	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	FWSS	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	0	True	6006824	2438	0x0983650eaca4d88eac53f914ddfe4d5ec33279021c9047f87f475801002d708e	2026-05-11 14:52:00+00:00	null	null	null	null	null	null	null	False
1856	0xb2613e02f232d00bcf060c2c70a9b60d0930959a	0x32c90c26bca6ed3945de9b29ba4e19d38314d618	0x80b98d3aa09ffff255c3ba4a241111ff1262f045	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	FWSS	0x0000000000000000000000000000000000000000	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	0	True	6006824	2447	0x0983650eaca4d88eac53f914ddfe4d5ec33279021c9047f87f475801002d708e	2026-05-11 14:52:00+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
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
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
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
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
17	0x994b21f3ae6960ebcfa0926ea0acf1bb9321b2f4	0x994b21f3ae6960ebcfa0926ea0acf1bb9321b2f4	True	False	True	PDP	True	https://pdp-mainnet.pixelguardian.eu	C=LT;ST=Vilnius;L=Vilnius	LT	Vilnius	Vilnius	0x0000000000000000000000000000000000000000	1048576	1073741824	83333333333333330	1440	True	True	0x0024080112208041e48c61fcde12d41424751290423e3000b183fb313b6568e4dc2bfe672661	40	40.0	testing	{capacityTib:0x3430,serviceStatus:0x74657374696e67,IPNIPeerID:0x0024080112208041e48c61fcde12d41424751290423e3000b183fb313b6568e4dc2bfe672661,ipniIpfs:0x01,ipniPiece:0x01,paymentTokenAddress:0x0000000000000000000000000000000000000000,location:0x433d4c543b53543d56696c6e6975733b4c3d56696c6e697573,minProvingPeriodInEpochs:0x05a0,storagePricePerTibPerDay:0x01280f39a3485552,maxPieceSizeInBytes:0x40000000,minPieceSizeInBytes:0x100000,serviceURL:0x68747470733a2f2f7064702d6d61696e6e65742e706978656c677561726469616e2e6575}	5513445	0x54f474fce4bbda664db4a07c4e558ba02aa4f62b4fb445f47491829e0617f388	2025-11-21 07:22:30+00:00	5513469	0xfcc4c0f33145109c09d0a239d29140c02412a36e8f569489f5348fc2d20f163a	2025-11-21 07:34: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
14	0xbd0ffc89500920349140b8e6016416cc7ed96c52	0xbd0ffc89500920349140b8e6016416cc7ed96c52	True	False	True	PDP	True	https://pdp.superusey.com	C=US;ST=Arizona;L=Chandler	US	Arizona	Chandler	0x0000000000000000000000000000000000000000	1048576	1073741824	83333333333333330	30	True	True	0x002408011220c418280613d40f3b8d3ba2ec5eeeb7ef5a0c8f40874e62bf25504fb593e5c42e	10	10.0	testing	{capacityTiB:0x3130,serviceStatus:0x74657374696e67,IPNIPeerID:0x002408011220c418280613d40f3b8d3ba2ec5eeeb7ef5a0c8f40874e62bf25504fb593e5c42e,ipniIpfs:0x01,ipniPiece:0x01,paymentTokenAddress:0x0000000000000000000000000000000000000000,location:0x433d55533b53543d4172697a6f6e613b4c3d4368616e646c6572,minProvingPeriodInEpochs:0x1e,storagePricePerTibPerDay:0x01280f39a3485552,maxPieceSizeInBytes:0x40000000,minPieceSizeInBytes:0x100000,serviceURL:0x68747470733a2f2f7064702e7375706572757365792e636f6d}	5494849	0x09d68ccf9f142433d700c888599a9d799c333113ed61edab46481932bd46e3f3	2025-11-14 20:24:30+00:00	5494861	0x1d07708af095238628ff8aa7eacb893551d093df551c275810ef7312b323805f	2025-11-14 20:30:30+00:00	False	null	null	null	null	null
22	0xd3c7dc643a8720b18a7adccc2f66add8434eb108	0xd3c7dc643a8720b18a7adccc2f66add8434eb108	True	False	True	PDP	True	https://storacha.network	earth	null	null	null	0xd3c7dc643a8720b18a7adccc2f66add8434eb108	1	1	1	1	null	null	null	null	null	null	{paymentTokenAddress:0xd3c7dc643a8720b18a7adccc2f66add8434eb108,location:0x6561727468,minProvingPeriodInEpochs:0x01,storagePricePerTibPerDay:0x01,maxPieceSizeInBytes:0x01,minPieceSizeInBytes:0x01,serviceURL:0x68747470733a2f2f73746f72616368612e6e6574776f726b}	5545695	0x3c7483a6e25ca4341042701120b5c005d09157b536f5ec22b562d1f97bcb294c	2025-12-02 12:07:30+00:00	5545695	0x3c7483a6e25ca4341042701120b5c005d09157b536f5ec22b562d1f97bcb294c	2025-12-02 12:07: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
f03644166	f03632590	f03644164	f03632590	12D3KooWQKTq2derMYzNrRhwZsrRRCc47GLkX1WS2hvbq3oFbdct	[f03644171, f03644172, f03644173, f03644174, f03644175, f03644176]	[/dns/a-fil-http.aur.lu/tcp/443/wss]	34359738368	72405	72402	3	102950.28828099219	3985.650255009888	189.30804083218163	163.51686227412554	25.79117855805609	96147.88584861014	2816.752177372164	0.0	0.0	2262.5625	17103.2109375	True	True	True	True	2025-10-08	2025-11-23	2025-10-10 12:40:00	2026-05-11 23:59:30	2025-10-12 11:55:00+00:00	2026-05-14 08:02:00+00:00	52774	6	1649.1484375	6405.084908472052
f03644168	f03632590	f03644165	f03632590	12D3KooWQKTq2derMYzNrRhwZsrRRCc47GLkX1WS2hvbq3oFbdct	[f03644177, f03644178, f03644179, f03644180, f03644181, f03644182]	[/dns/a-fil-http.aur.lu/tcp/443/wss]	34359738368	73215	73213	2	102923.17505558362	4069.6704399391997	188.97499226665585	163.1399634871703	25.835028779485555	96038.93749346961	2814.5671221748075	0.0	0.0	2287.90625	17079.7578125	True	True	True	True	2025-10-08	2025-12-20	2025-10-10 12:50:30	2026-05-11 23:59:30	2025-10-12 11:55:30+00:00	2026-05-14 08:02:00+00:00	52597	6	1643.6328125	6629.48199636961
f01084868	f03338164	f03759653	f03338164	12D3KooWLGAZMarHVML2KUtY7Hf5H5pfNhXWqCcypqPUYuDeBVFc	[f03759650]	[/dns/f01084868.44943.com/tcp/443/wss]	34359738368	32038	30662	7	110292.7424797145	50302.08094430103	299.9263121549758	85.54426392416416	214.38204823081162	59770.33797159632	216.15547513701296	4.168088680146975	0.0	925.0	9249.4375	True	True	True	True	2026-04-19	2026-05-11	2026-04-19 15:24:00	2026-05-11 23:59:00	2026-05-19 09:45:30+00:00	2026-06-09 19:08:00+00:00	30544	3	954.5	335.7656694467785
f01081439	f03338164	f03759651	f03338164	12D3KooWNZ1bNnLikm84dXC4oSWcBX9TEPUAV7Bx2PUpryWmWv8a	[f03759648]	[/dns/f01081439.44943.com/tcp/443/wss]	34359738368	10336	10111	0	80049.45180818724	60741.90554687717	299.9790100159665	27.448531349621504	272.53047866634495	19270.563905970706	36.09448368625296	0.8878716531040771	0.0	300.46875	3004.6875	True	True	True	True	2026-04-16	2026-05-11	2026-04-16 23:42:00	2026-05-11 23:56:30	2026-05-16 14:03:00+00:00	2026-06-09 14:19:00+00:00	10045	3	313.90625	48.75000523653245
f03741653	f03200943	f03741652	f03286739	Qmaco51xxrAmLZNxPb2r7fdanb6iMyN4oFx8epiHjiv6gS	null	null	34359738368	65831	63146	0	201105.85936893348	80819.55032168323	0.0	0.0	0.0	119550.19950666478	688.2029902065816	47.906550378882955	0.0	1811.6875	18116.875	True	True	True	False	2026-02-06	2026-05-11	2026-02-06 16:15:00	2026-05-11 23:55:00	null	null	62736	1	1960.5	1733.4091238982894
f01082688	f03338164	f03759652	f03338164	12D3KooWSKu6rwdpUvvqtJUcpXPFRWk9LMnMaHiwbND61f4CQsFf	[f03759649]	[/ip4/54.79.16.86/tcp/4949]	34359738368	4851	4720	8	50017.29207840844	40889.76216064461	200.0	13.446611439008189	186.5533885609918	9112.651051478702	12.954918779070237	1.9239475060565205	0.0	123.09375	1230.9375	True	True	True	True	2026-05-05	2026-05-11	2026-05-05 20:33:30	2026-05-11 23:48:30	2026-06-03 15:15:30+00:00	2026-06-07 18:35:00+00:00	4303	1	134.46875	9.416436336526461
f01858258	f01857658	f03742345	f01857658	12D3KooWAwbTPeBQEobAavzy5VecX4oBaP1yN8KAXC1t6NhxHY7g	[f03742458, f03742461]	[/ip4/183.60.248.131/tcp/12888]	34359738368	115031	115007	0	207646.964961612	2677.335760108127	826.9159340639991	822.6106723474767	4.305261716522409	196393.3854073874	8576.095851093778	0.14794302270957452	0.0	3591.75	35841.30596923828	True	True	True	True	2022-06-10	2026-05-11	2023-03-15 22:22:00	2026-05-11 23:40:30	2023-01-12 10:43:00+00:00	2026-05-15 07:31:30+00:00	114229	9	3566.8777465820312	101865.87394190484
f02063867	f02066082	f03742347	f02066082	12D3KooWP9QL4z6Qsmz6A2Ufmz1oeNiqB1hCLrNjE4jDoo3LBkP9	[f03742460, f03742464]	[/ip4/183.60.248.132/tcp/14888]	34359738368	115533	115516	0	208880.02461861275	2038.7600964303128	844.2416584602056	837.0011862045867	7.240472255618897	198428.85462266835	8412.040279999872	0.36961951420424327	0.0	3608.125	36061.05987548828	True	True	True	True	2023-03-16	2026-05-11	2023-03-16 09:33:00	2026-05-11 23:40:30	2023-03-22 09:07:30+00:00	2026-05-16 10:43:00+00:00	115156	9	3595.7566528320312	100166.86125212986
f03046733	f03123631	f03092523	f03123631	12D3KooWKGWdBKoV26bvFuZ5pSPvzR5UYzVaFe5SzQ6692c2Hwhm	[f03092519, f03092520, f03092521, f03092513, f03092522]	[/dns/market.web3.usc.edu/tcp/443/wss]	34359738368	95562	95562	0	159401.3944939319	17907.18947904633	412.4997310884493	392.8637275294248	19.636003559024516	135130.63408170588	6362.387509957869	1.1834232218457812	0.0	2976.5625	29670.922868728638	True	True	True	True	2024-05-09	2026-05-11	2024-08-28 02:39:30	2026-05-11 23:31:00	2024-05-30 02:05:30+00:00	2026-05-14 23:54:00+00:00	99511	2	3108.426393508911	25779.826330610842
f02063327	f02066051	f03742346	f02066051	12D3KooWBWerJoMTuZMgEV9etWiTcgKzYEbrzdj6KYaXQNU8j4vw	[f03742459, f03742462]	[/ip4/183.60.248.130/tcp/13888]	34359738368	115707	115697	0	207948.6349206853	1609.513551127919	830.5788571961813	828.7500452677074	1.8288119284738968	197830.45439359717	8508.493598695986	0.17337726421869964	0.0	3613.40625	36109.23175048828	True	True	True	True	2023-03-17	2026-05-11	2023-03-17 19:33:00	2026-05-11 23:29:30	2023-03-22 09:07:30+00:00	2026-05-18 04:34:00+00:00	115476	9	3605.8035278320312	101538.99581030937

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	null	null	null	null
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	null	null	null	null
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	null	null	null	null