Datasets

Columns

column	type	description	tests
client_id	VARCHAR	Filecoin client actor id address.	not_null, unique
first_claim_at	TIMESTAMP WITH TIME ZONE	Timestamp of the first successful verified claim.
last_claim_at	TIMESTAMP WITH TIME ZONE	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
f03759102	2026-03-03 14:37:00+00:00	2026-04-20 23:59:00+00:00	86991	6	5436.9375	f1wr4csvsjcuiemkjbp4k44qu5hsywhwshgfcnz7i	立遺伝学研究所 (National Institute of Genetics, Japan)	null	Japan	Life Science / Healthcare	null	6912.0	1326.0	f03018029	NonEntropy	null	null	null	2048.0	1690.25	5586.0	1326.0	null	2026-04-13 02:40:30+00:00	3
f03290407	2024-12-29 11:09:30+00:00	2026-04-20 23:55:00+00:00	299759	31	9367.46875	f1llzvof7lq7amv6lfnumtj2uhz5dnhbswh7vvkaq	zzflk	null	China	Information, Media & Telecommunications	http://www.zzflk.com/	10752.0	681.53125	f03012911	Marshall-Fil-Data-Pathway	null	null	null	0.0	241.3125	10070.46875	681.53125	null	2026-03-20 07:06:00+00:00	3
f03136439	2025-03-05 01:58:30+00:00	2026-04-20 23:50:30+00:00	92483	3	2890.09375	f3svae653c6zetlcghrg6e2zc33fyg56imqcj2y35ornyji6kh7vwp7vgteptjfulkes4j4zloocfusj6vctia	Aitrainer	null	China	IT & Technology Services	https://commoncrawl.org/	5084.0	1097.8628540039062	f03019859	Herony	null	null	null	0.0	177.71875	3986.1371459960938	1097.8628540039062	null	2025-11-10 09:49:30+00:00	3
f03644104	2026-04-05 13:49:00+00:00	2026-04-20 22:14:30+00:00	17261	2	539.40625	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null
f03753456	2026-02-17 00:45:00+00:00	2026-04-20 21:53:30+00:00	144144	4	4504.5	f1i4i2s26mu3zh2tu34emv4l4evodewpfiyw3bheq	GuangxiShanhai Xingchen Culture Media Co., Ltd.	null	China	Information, Media & Telecommunications	null	4515.839999999999	0.058749999999236024	f03251444	Starry Manual Allocator	null	null	null	0.0	29.4375	4515.78125	0.058749999999236024	null	2026-02-28 11:04:00+00:00	3
f03535091	2025-05-09 12:11:00+00:00	2026-04-20 07:55:00+00:00	106536	4	3329.1796875	f3r3tkbr34pcrzj42hy2pc7e4ujpxhrmuohy4bapnommhzmnn7vlyn6e5jb2lqpddsjtitzeicjcm2a4cypspa	null	null	null	null	null	965.9200000000001	344.3828125	f03760270	Ramo Cloud	null	null	null	0.0	164.90625	621.5371875000001	344.3828125	null	2026-03-06 21:23:30+00:00	3
f03253574	2025-02-11 21:28:30+00:00	2026-04-20 07:54:00+00:00	29530	9	922.7268829345703	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+00:00	2026-04-20 06:21:30+00:00	1391	24	43.46875	f1ggmci7w2weizhh36uqetihmh76ewgme6hwgowti	Lighthouse	null	null	null	lighthouse.storage	60.0	11.90625	f02824311	datacap-data-preparation-and-onboarding	null	null	null	0.0	0.4375	48.09375	11.90625	null	2026-03-31 06:09:30+00:00	3
f03644598	2025-09-08 10:15:30+00:00	2026-04-20 01:06:00+00:00	6797	4	212.40625	f1nplitd46e2m5woeiwlcjqu7kri66hr2rx4sywvi	null	null	null	null	** https://aurorainfra.ai/	410.0	192.40625	f03019298	datacap-decentralized-onboarding-to-self-selected-sps	null	null	null	0.0	5.96875	217.59375	192.40625	null	2025-10-15 11:36:00+00:00	3
f03542902	2025-04-27 09:50:00+00:00	2026-04-19 04:14:30+00:00	140348	12	4385.875	f17qnsd4mirtgjimjkhna2yuyhr5b6xkrwcq6z2zi	Xmov	null	China	IT & Technology Services	https://www.xmov.ai/home	3840.0	35.28125	f03012494	Storify Data Fortress	null	null	null	0.0	336.09375	3804.71875	35.28125	null	2026-03-05 14: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-04-20	f03200311	0.0625	2	2
2026-04-20	f03759102	77.9375	1247	2
2026-04-20	f03644104	1.1875	38	1
2026-04-20	f03644598	0.5	16	2
2026-04-20	f03753456	0.3125	10	1
2026-04-20	f03253574	1.0625	34	1
2026-04-20	f03136439	11.78125	377	3
2026-04-20	f03290407	92.3125	2954	3
2026-04-20	f03535091	0.03125	1	1
2026-04-19	f03290407	101.0	3232	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_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-04-20	0x56e53c5e7f27504b810494cc3b88b2aa0645a839	12	8	8	1	10	567.1241597282818
2026-04-20	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	483	377	374	66	16	308.32037931424287
2026-04-20	0xcb71d6e32e12b618f8e0b4dcf36b6a10b5cedc14	1	0	0	1	1	0.0
2026-04-20	0x96f1a3026eac5a6c10cd121ef58d3c13d150e441	1	0	0	1	1	0.0
2026-04-19	0x56e53c5e7f27504b810494cc3b88b2aa0645a839	12	8	8	1	10	567.1241597282818
2026-04-19	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	480	374	371	66	16	305.6908848172162
2026-04-19	0xcb71d6e32e12b618f8e0b4dcf36b6a10b5cedc14	1	0	0	1	1	0.0
2026-04-19	0x96f1a3026eac5a6c10cd121ef58d3c13d150e441	1	0	0	1	1	0.0
2026-04-18	0x56e53c5e7f27504b810494cc3b88b2aa0645a839	12	8	8	1	10	567.1241597282818
2026-04-18	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	480	374	371	66	16	305.24430662028203

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.
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.
total_value_flow_fil	DOUBLE	FIL value transferred plus gas fees.
protocol_revenue_fil	DOUBLE	Daily protocol revenue from burned FIL, in FIL.
protocol_revenue_usd	DOUBLE	Daily protocol revenue from burned FIL, 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.
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.
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.

Sample

date	transactions	onboarded_pibs	terminated_pibs	expired_pibs	removed_pibs	raw_power_pibs	quality_adjusted_power_pibs	gas_used_millions	total_value_fil	total_gas_fee_fil	total_value_flow_fil	protocol_revenue_fil	protocol_revenue_usd	circulating_fil	mined_fil	vested_fil	locked_fil	burnt_fil	pledge_collateral_fil	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	block_rewards_fil_per_qap_tib_day	block_rewards_usd_per_qap_tib_day	reward_per_wincount_fil
2026-04-20	43181	0.180999755859375	2.01593017578125	0.72369384765625	2.7396240234375	1951.5914611816406	16956.654751582915	5567056.326765	7991745.502430512	1.3684597743794622	7991746.870890286	2667.0713886743392	2460.5492667611175	854775039.8637131	399114846.59357184	566773512.9862702	86058679.49992852	42121259.177973725	86058679.49992852	65	377	0	3	875.4445390425253	0.9225659565056212	191895828.59930313	712940164.0487804	0.18084716796875	4679	9	14	14242	14334	65550.47248372769	60474.63434634564	0.003775162862174484	0.0034828367369065015	4.573076076721619
2026-04-19	47558	0.213104248046875	0.0	7.228302001953125	7.228302001953125	1955.4344177246094	16963.57029225296	9843936.222857997	12975152.581933921	2.646470167841042	12975155.22840409	1889.3489246515196	1746.977417423883	854505461.7261083	399049296.12108815	566586387.3912929	86078248.64146118	42118592.10658505	86078248.64146118	65	374	0	0	872.8150445454987	0.9246452016512005	186939534.08710802	714409735.6689895	0.212249755859375	5706	10	16	14280	14394	65903.7977131523	60937.630326057624	0.0037939641446613557	0.0035080707415978234	4.578560352449096
2026-04-18	40482	0.20648193359375	9.1552734375e-05	2.917633056640625	2.917724609375	1960.616455078125	16972.409873159602	4535350.134810998	13574749.71694454	1.2412339081925314	13574750.958178448	1796.2932197969747	1731.970386333662	854155653.188433	398983392.323375	566399261.7963158	86176917.1353707	42116702.7576604	86176917.1353707	65	374	0	0	872.3684663485645	0.9641913509696469	244375716.4390244	744813266.8013937	0.20765113830566406	5562	12	16	14024	14122	64708.33827463676	62391.220100022925	0.0037232035443745216	0.003589880655385448	4.5820944819881575
2026-04-17	43832	0.198699951171875	0.0155029296875	0.52569580078125	0.54119873046875	1964.9830322265625	16997.888121661003	11320232.806666	21630839.146033898	2.8565367916974465	21630842.00257069	1783.671144029394	1771.6210907174332	853852622.7551011	398918683.9851003	566212136.2013386	86229909.92867066	42114906.46444061	86229909.92867066	65	374	0	1	871.9301516792889	0.9932442404799243	356408465.67247385	767175024.4738677	0.19955448620021343	5304	10	15	14117	14217	65159.56160001104	64719.359271407804	0.0037435464876322965	0.0037182559878096285	4.583214574102204
2026-04-16	44730	0.161224365234375	7.24835205078125	1.150543212890625	8.398895263671875	1964.8703918457031	16992.981124240905	4010609.764604002	18651901.75164413	1.6600755451016744	18651903.411719676	5074.30062996516	4947.270720280762	853588866.0167629	398853524.4235003	566025010.6063615	86243165.18157575	42113122.793296576	86243165.18157575	65	373	0	3	870.7551019580509	0.9749660260698291	293013611.82229966	752923968.1219512	0.16085829306393862	4128	10	16	14153	14246	65325.01131652958	63689.66668624346	0.0037541356573859057	0.003660154723208582	4.585498477925704
2026-04-15	46055	0.135345458984375	0.00250244140625	0.79522705078125	0.7977294921875	1970.8576354980469	16968.61627534707	4404365.999548002	8067222.50401165	1.202536186642194	8067223.706547836	1744.4740324620604	1575.951878615613	853271298.5470457	398788199.4121838	565837885.0113842	86313356.34562919	42108048.49266661	86313356.34562919	65	370	0	8	868.1185091103724	0.9033965821729063	172803026.80487806	697470630.4076655	0.13543705642223358	2711	8	17	14151	14259	65446.18299631383	59123.85803513249	0.0037664996983397506	0.0034026429542354133	4.5898157652229346
2026-04-14	49282	0.28973388671875	0.00054931640625	0.320892333984375	0.321441650390625	1977.2680053710938	17034.2975027528	5915929.666035999	11408211.587484056	1.6918765872790689	11408213.279360643	1777.5650319966924	1597.3266997933763	853008810.3046119	398722753.2291875	565650759.4164071	86325017.28412189	42106304.01863415	86325017.28412189	65	362	0	16	861.832551771377	0.8986038041033811	214183747.40069687	693470157.0487804	0.291656494140625	6850	9	18	14350	14447	66311.47207617608	59587.74106334696	0.0038015830672750496	0.0034161170058683594	4.5899821468938935
2026-04-13	45055	0.258880615234375	3.0517578125e-05	3.08563232421875	3.085662841796875	1970.029541015625	16962.452660004812	10602474.273976998	12624167.061212827	2.188581256634586	12624169.249794083	2504.906756892923	2186.556009113149	852766058.507535	398656441.7571113	565463633.82143	86316109.57917754	42104526.45360215	86316109.57917754	65	346	0	13	849.6913275652771	0.872909142464586	160236225.41463414	673504658.5017421	0.2611083984375	5698	10	16	13887	13990	64212.43973178697	56051.62570183307	0.0036968392444465888	0.0032270047746992994	4.589881324645245
2026-04-12	41393	0.25982666015625	0.0	3.71014404296875	3.71014404296875	1965.0768127441406	16911.509658647905	5254004.722119	9296796.503247079	1.4431646323005396	9296797.94641171	3469.0458488609374	3011.281528735311	852431353.159396	398592229.31737953	565276508.2264528	86401981.7993644	42102021.54684526	86401981.7993644	65	623	0	0	839.7613681420706	0.8680431622787766	189386117.9512195	669538898.7735192	0.259429931640625	5639	7	16	14164	14260	65464.75831746463	56826.23582770784	0.0037802910168760395	0.0032814557686231295	4.5907965159512365
2026-04-11	41786	0.2708740234375	3.0517578125e-05	2.26739501953125	2.267425537109375	1969.6727905273438	16954.187906191888	5701138.53858	7323158.3807620695	1.42197602950475	7323159.802738099	2893.3304584150355	2611.379936561787	852027028.4260952	398526764.55906206	565089382.6314756	86557185.2252194	42098552.500996396	86557185.2252194	65	624	0	0	839.1411738334072	0.9025515661257371	154128106.4703833	695983857.7909408	0.270843505859375	6105	7	15	14296	14403	66152.83255860217	59706.34262942003	0.0038104081365003812	0.00343908983117667	4.592989832576697

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-04-20	f01002224	386.75	386.75	0.0	0	0.0	0	0.0	0	0.0	0	0.0	0	0	1	1	5.145091729883623	4.7466864730892455
2026-04-20	f0101020	430.90625	4250.213134765625	0.0	0	0.0	0	0.0	0	0.0	0	0.0	0	0	4	4	5.7235833939411584	5.280383188471014
2026-04-20	f0101021	437.59375	4320.603759765625	0.0	0	0.0	0	0.0	0	0.0	0	0.0	0	0	4	4	27.828351192888125	25.67348943624118
2026-04-20	f0101087	2146.78125	2146.7812883257866	0.0	0	0.0	0	6.375	204	6.375	204	0.0	0	0	1	1	7.624631118632032	7.034225100963286
2026-04-20	f01016847	578.28125	5773.53125	0.0	0	0.0	0	0.0625	2	0.0625	2	0.0	0	0	3	3	31.105848112175995	28.69719651652822
2026-04-20	f01019009	601.71875	5990.50390625	0.0	0	0.0	0	0.0625	2	0.0625	2	0.0	0	0	6	6	32.04813371207063	29.566517132296486
2026-04-20	f01021773	1010.75	7388.9375	0.0	0	0.0	0	0.0	0	0.0	0	0.0	0	0	3	3	10.862638291377422	10.021500285459199
2026-04-20	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-04-20	f010479	62.625	449.87109375	0.0	0	0.0	0	0.0	0	0.0	0	0.03125	1	1	0	0	0.0	0.0
2026-04-20	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
1337	0x4714c4f258978d9a261be4994da5431a5e483e4d	0x89b5899619d93a180d38011b8aec849deea3f573	0x80b98d3aa09ffff255c3ba4a241111ff1262f045	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	FWSS	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	0	True	5947306	7	0x1c37b38a35431f7f8cf8e204a559c0df80461af31a01a8528d0d86c8604248d9	2026-04-20 22:53:00+00:00	null	null	null	null	null	null	null	False
1338	0x4714c4f258978d9a261be4994da5431a5e483e4d	0x23b1e018f08bb982348b15a86ee926eebf7f4daa	0x80b98d3aa09ffff255c3ba4a241111ff1262f045	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	FWSS	0x0000000000000000000000000000000000000000	0x0000000000000000000000000000000000000000	0	True	5947306	9	0x1c37b38a35431f7f8cf8e204a559c0df80461af31a01a8528d0d86c8604248d9	2026-04-20 22:53:00+00:00	5947306	13	0x1c37b38a35431f7f8cf8e204a559c0df80461af31a01a8528d0d86c8604248d9	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	5947306	2026-04-20 22:53:00+00:00	2026-04-20 22:53:00+00:00	True
1336	0xf382e9425224c123746f7312fb0dbec81b51a10c	0x23b1e018f08bb982348b15a86ee926eebf7f4daa	0x80b98d3aa09ffff255c3ba4a241111ff1262f045	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	FWSS	0x0000000000000000000000000000000000000000	0x0000000000000000000000000000000000000000	0	True	5946757	30	0x74b56311b69261a9e9f88b5f2e8cbd9b0640c8378f841456c6fec393c8cfc05a	2026-04-20 18:18:30+00:00	5946757	34	0x74b56311b69261a9e9f88b5f2e8cbd9b0640c8378f841456c6fec393c8cfc05a	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	5946757	2026-04-20 18:18:30+00:00	2026-04-20 18:18:30+00:00	True
1335	0xf382e9425224c123746f7312fb0dbec81b51a10c	0x32c90c26bca6ed3945de9b29ba4e19d38314d618	0x80b98d3aa09ffff255c3ba4a241111ff1262f045	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	FWSS	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	0	True	5946757	28	0x74b56311b69261a9e9f88b5f2e8cbd9b0640c8378f841456c6fec393c8cfc05a	2026-04-20 18:18:30+00:00	null	null	null	null	null	null	null	False
1333	0xf382e9425224c123746f7312fb0dbec81b51a10c	0x010ecc2436e0c5ea4741cd25a27a5476fe7a252c	0x80b98d3aa09ffff255c3ba4a241111ff1262f045	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	FWSS	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	0	True	5946093	1041	0xee1f5bebc2ebf1859a699434727e446efb013d5064ed05947490e54a9e40e3ef	2026-04-20 12:46:30+00:00	null	null	null	null	null	null	null	False
1334	0xf382e9425224c123746f7312fb0dbec81b51a10c	0x23b1e018f08bb982348b15a86ee926eebf7f4daa	0x80b98d3aa09ffff255c3ba4a241111ff1262f045	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	FWSS	0x0000000000000000000000000000000000000000	0x0000000000000000000000000000000000000000	0	True	5946093	1043	0xee1f5bebc2ebf1859a699434727e446efb013d5064ed05947490e54a9e40e3ef	2026-04-20 12:46:30+00:00	5946093	1047	0xee1f5bebc2ebf1859a699434727e446efb013d5064ed05947490e54a9e40e3ef	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	5946093	2026-04-20 12:46:30+00:00	2026-04-20 12:46:30+00:00	True
1331	0xf382e9425224c123746f7312fb0dbec81b51a10c	0x32c90c26bca6ed3945de9b29ba4e19d38314d618	0x80b98d3aa09ffff255c3ba4a241111ff1262f045	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	FWSS	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	0	True	5937739	72	0xe81a0b3a2dd1df4824cd9f9ac8f14a69912d8d7c0587d8d43eadfc133b3cf995	2026-04-17 15:09:30+00:00	null	null	null	null	null	null	null	False
1332	0xf382e9425224c123746f7312fb0dbec81b51a10c	0x23b1e018f08bb982348b15a86ee926eebf7f4daa	0x80b98d3aa09ffff255c3ba4a241111ff1262f045	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	FWSS	0x0000000000000000000000000000000000000000	0x0000000000000000000000000000000000000000	0	True	5937739	74	0xe81a0b3a2dd1df4824cd9f9ac8f14a69912d8d7c0587d8d43eadfc133b3cf995	2026-04-17 15:09:30+00:00	5937739	78	0xe81a0b3a2dd1df4824cd9f9ac8f14a69912d8d7c0587d8d43eadfc133b3cf995	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	5937739	2026-04-17 15:09:30+00:00	2026-04-17 15:09:30+00:00	True
1330	0x1721eb5d0b038b07f356d7c3858e6f1fb10089ea	0x89b5899619d93a180d38011b8aec849deea3f573	0xeb466342c4d449bc9f53a865d5cb90586f405215	0x96f1a3026eac5a6c10cd121ef58d3c13d150e441	FWSS	0x96f1a3026eac5a6c10cd121ef58d3c13d150e441	0x0000000000000000000000000000000000000000	0	False	5934925	21	0x226ff7891ba46f89d38a586234947c87698681ad4c1b568cf15400581488ebbf	2026-04-16 15:42:30+00:00	null	null	null	null	null	null	null	False
1329	0x305025d07c1dee47f25a4990179eff2becddca0b	0x23b1e018f08bb982348b15a86ee926eebf7f4daa	0x80b98d3aa09ffff255c3ba4a241111ff1262f045	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	FWSS	0x0000000000000000000000000000000000000000	0x0000000000000000000000000000000000000000	0	True	5934008	8	0x1165dc46bf93fd3a582e5ef0b3b61ad43271fd1b201b664a0edbb9438819a30b	2026-04-16 08:04:00+00:00	5934008	12	0x1165dc46bf93fd3a582e5ef0b3b61ad43271fd1b201b664a0edbb9438819a30b	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	5934008	2026-04-16 08:04:00+00:00	2026-04-16 08:04:00+00:00	True

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
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
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
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
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 WITH TIME ZONE	First successful verified claim timestamp.
last_verified_claim_at	TIMESTAMP WITH TIME ZONE	Most recent successful verified claim 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	first_sector_activity_date	last_sector_activity_date	first_verified_claim_at	last_verified_claim_at	verified_claims	verified_clients	verified_data_onboarded_tibs	total_block_rewards_fil
f03230401	f03757667	f03756504	f03757667	12D3KooWRpdDBcZvyDMGH8WLyFwAbJ8HWch1bbW2ShmH3kS99VUF	[f03756505]	[/ip4/14.238.44.27/tcp/13003]	68719476736	28097	28077	0	106629.40183548316	4502.461915325389	162.31244126315184	160.81121453620213	1.5012267269497102	101170.86755795049	953.4689454803843	2.603416726898829	0.0	1710.625	17106.25	True	True	True	2026-03-03	2026-04-20	2026-03-03 14:41:30+00:00	2026-04-20 23:59:00+00:00	27676	1	1729.75	1343.1419244480746
f01233054	f03757668	f03756502	f03757668	12D3KooWFtzeYVUSvGhPpqumswexNwhN2vw12vfaMLb77eDXodxN	[f03756503]	[/ip4/148.153.245.20/tcp/13004]	68719476736	28429	28341	0	106794.81745312749	3281.5526611038076	162.0341566994051	160.8107467323354	1.2234099670696992	102433.22256262052	1075.5447041283921	4.497525274773359	0.0	1736.5	17365.0	True	True	True	2026-03-03	2026-04-20	2026-03-03 14:37:00+00:00	2026-04-20 23:59:00+00:00	28091	1	1755.6875	1567.825472169063
f01084788	f03338164	f03696738	f03338164	12D3KooWRJi4nBAvjjKhU5L9Tcbzzhr8jr69VpN1j1zDja1G4Zk9	[f03696744]	[/ip4/15.188.172.88/tcp/4949]	34359738368	93429	91978	19	201410.7604062164	33902.450699503475	399.67871681582665	241.680451129057	157.99826568676966	165823.22396009945	1681.154608349088	3.9311382643681565	0.0	2654.09375	26540.9375	True	True	True	2026-02-11	2026-04-20	2026-02-11 04:36:30+00:00	2026-04-20 23:55:00+00:00	92582	6	2893.1875	2960.456222207898
f01084868	f03338164	f03759653	f03338164	12D3KooWLGAZMarHVML2KUtY7Hf5H5pfNhXWqCcypqPUYuDeBVFc	[f03759650]	[/dns/f01084868.44943.com/tcp/443/wss]	34359738368	691	595	5	49999.93636288813	48733.85907806445	100.0	2.6356554839278195	97.36434451607218	1265.46196364818	0.0	0.6153211755006164	0.0	6.65625	66.5625	True	True	True	2026-04-19	2026-04-20	2026-04-19 15:24:00+00:00	2026-04-20 23:53:30+00:00	453	1	14.15625	0.0
f01858258	f01857658	f03742345	f01857658	12D3KooWAwbTPeBQEobAavzy5VecX4oBaP1yN8KAXC1t6NhxHY7g	[f03742458, f03742461]	[/ip4/183.60.248.131/tcp/12888]	34359738368	113186	113147	0	202103.09802221472	861.6897728071317	826.9239675149845	817.7993822834318	9.124585231552715	192977.0640780799	8264.060168567792	0.28400275989493046	0.0	3531.375	35237.55596923828	True	True	True	2022-06-10	2026-04-20	2023-03-15 22:22:00+00:00	2026-04-20 23:50:30+00:00	112341	9	3507.8777465820312	99006.01812773141
f02063327	f02066051	f03742346	f02066051	12D3KooWBWerJoMTuZMgEV9etWiTcgKzYEbrzdj6KYaXQNU8j4vw	[f03742459, f03742462]	[/ip4/183.60.248.130/tcp/13888]	34359738368	114040	113943	1	203095.23409091844	158.0631847362463	830.5814801265058	824.4164889707592	6.16499115574652	194739.0255491328	8197.861354289475	0.28400275989493046	0.0	3560.53125	35580.48175048828	True	True	True	2023-03-17	2026-04-20	2023-03-17 19:33:00+00:00	2026-04-20 23:50:30+00:00	113767	9	3552.3972778320312	98732.65323398905
f02063867	f02066082	f03742347	f02066082	12D3KooWP9QL4z6Qsmz6A2Ufmz1oeNiqB1hCLrNjE4jDoo3LBkP9	[f03742460, f03742464]	[/ip4/183.60.248.132/tcp/14888]	34359738368	114185	114149	0	204212.83523117393	85.16055254018615	844.2530462152446	833.4484186869654	10.804627528279184	195929.0885294756	8198.302143146575	0.2840060115981865	0.0	3562.53125	35605.12237548828	True	True	True	2023-03-16	2026-04-20	2023-03-16 09:33:00+00:00	2026-04-20 23:48:00+00:00	113738	9	3551.4441528320312	97416.36439583174
f01083688	f03338164	f03696737	f03338164	12D3KooWAHTU5Ad25sEr27XXoPUvoQHiahQAzWsTYKt8EZCPeDFB	[f03696743]	[/ip4/13.58.114.145/tcp/4949]	34359738368	86615	85713	12	201043.14264986574	45953.91560842013	396.6570195841273	221.12755202306073	175.52946756106655	153573.09068060032	1512.4845611600035	3.6517996852808734	0.0	2678.53125	26785.03125	True	True	True	2025-12-10	2026-04-20	2025-12-10 01:52:30+00:00	2026-04-20 23:43:30+00:00	86575	7	2705.46875	2745.658514530494
f03741653	f03200943	f03741652	f03286739	Qmaco51xxrAmLZNxPb2r7fdanb6iMyN4oFx8epiHjiv6gS	null	null	34359738368	32766	32766	0	100428.46002028798	42330.83606669807	0.0	0.0	0.0	57594.10425576094	242.39864418416158	261.1210536448001	0.0	1023.9375	10239.375	True	True	True	2026-02-06	2026-04-20	2026-02-06 16:15:00+00:00	2026-04-20 07:55:00+00:00	32767	1	1023.96875	861.0889861733203
f03706409	f03706309	f03706310	f03706309	12D3KooWS8P8mzWVcFPmj63aEtyYEuSaM5xy3HdZu4EepmUHLWYi	[f03706311]	[/dns/deal.00pc.co.kr/tcp/443/wss]	68719476736	2080	2071	0	7315.957589071744	10.548020662590986	0.1	0.0	0.1	7167.188533951548	137.55694664046732	0.6640878171377539	0.0	129.4375	1276.1640625	True	True	True	2025-11-29	2026-04-20	2026-01-06 22:16:00+00:00	2026-04-20 07:54:00+00:00	4079	1	127.5390625	252.1975403659064

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