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
f03649823	2025-10-06 20:03:00	2026-05-15 23:59:30	57022	12	1781.9375	f1lurvvlzrl6ljo64jb7wpojbykjmsw4ln6cdvmfq	qizhenys	null	China	Information, Media & Telecommunications	https://www.qizhenys.com/	5120.0	3284.875	f03251436	Xingchi Allocator	null	null	null	0.0	19.28125	1835.125	3284.875	null	2026-04-25 03:00:30+00:00	3
f03774028	2026-05-08 19:43:00	2026-05-15 23:59:30	62130	3	1941.5625	f1vjvnnlikd4uiyodie2ia5prifbctljzbvw2wgti	null	null	null	null	null	5120.0	2840.875	f03777695	Large Data Onboarding	null	null	null	5120.0	1563.75	2279.125	2840.875	null	2026-05-07 12:11:30+00:00	3
f03644598	2025-09-08 10:15:30	2026-05-15 23:58:30	9209	4	287.78125	f1nplitd46e2m5woeiwlcjqu7kri66hr2rx4sywvi	null	null	null	null	** https://aurorainfra.ai/	410.0	100.125	f03019298	datacap-decentralized-onboarding-to-self-selected-sps	null	null	null	0.0	58.5625	309.875	100.125	null	2025-10-15 11:36:00+00:00	3
f03309602	2025-03-24 23:59:30	2026-05-15 23:55:30	208553	21	6517.28125	f1ucj4c2jvrxlc2pgnebsdhaarrdx4uhptal67etq	NationalMicrobiology Data Center	null	China	Environment	https://nmdc.cn/	6656.0	47.75	f03012911	Marshall-Fil-Data-Pathway	null	null	null	0.0	1549.90625	6608.25	47.75	null	2026-03-20 07:02:30+00:00	3
f03535091	2025-05-09 12:11:00	2026-05-15 23:54:30	146409	4	4575.2109375	f3r3tkbr34pcrzj42hy2pc7e4ujpxhrmuohy4bapnommhzmnn7vlyn6e5jb2lqpddsjtitzeicjcm2a4cypspa	null	null	null	null	null	6095.92	4213.9140625	f03760270	Ramo Cloud	null	null	null	4000.0	1142.875	1882.0059375	4213.9140625	null	2026-05-12 15:55:30+00:00	3
f03136439	2025-03-05 01:58:30	2026-05-15 23:41:30	98267	3	3070.84375	f3svae653c6zetlcghrg6e2zc33fyg56imqcj2y35ornyji6kh7vwp7vgteptjfulkes4j4zloocfusj6vctia	Aitrainer	null	China	IT & Technology Services	https://commoncrawl.org/	5084.0	920.5503540039062	f03019859	Herony	null	null	null	0.0	77.625	4163.449645996094	920.5503540039062	null	2025-11-10 09:49:30+00:00	3
f03767350	2026-05-11 22:20:30	2026-05-15 23:13:00	2284	1	70.748046875	f13dwjgdbcxi2hmpbxjdijghbernii4qtbag5n3sq	TheStarling Lab	null	United States	Education & Training	null	256.0	169.896484375	f03015757	FIDL Enterprise Data	null	null	null	0.0	56.498046875	86.103515625	169.896484375	null	2026-04-08 08:57:00+00:00	3
f03771751	2026-04-30 20:51:00	2026-05-15 21:19:00	88	3	2.535161018371582	f410fjmezxhwkpu4hf6uptnzlseyrtnhqrrpn74cs7yy	null	null	null	null	null	7.8438520431518555	0.0	f03771751	null	null	null	null	0.5664081573486328	0.5664081573486328	7.8438520431518555	0.0	null	2026-05-11 05:08:00+00:00	3
f03630410	2025-07-30 14:05:00	2026-05-15 08:18:30	149	8	4.65625	f1egc7pvchnhj6hrgc2woigwqbwv4bar6nz6n3oki	null	null	null	null	https://aurorainfra.ai/	10.0	5.1875	f03019298	datacap-decentralized-onboarding-to-self-selected-sps	null	null	null	0.0	0.15625	4.8125	5.1875	null	2025-07-26 08:00:00+00:00	3
f03200311	2024-09-19 16:03:00	2026-05-12 13:45:00	1423	24	44.4375	f1ggmci7w2weizhh36uqetihmh76ewgme6hwgowti	Lighthouse	null	null	null	lighthouse.storage	60.0	10.71875	f02824311	datacap-data-preparation-and-onboarding	null	null	null	0.0	0.65625	49.28125	10.71875	null	2026-03-31 06:09:30+00:00	3

Columns

column	type	description	tests
date	DATE	UTC claim date.	not_null
client_id	VARCHAR	Filecoin client actor id address.	not_null
verified_data_onboarded_tibs	DOUBLE	Verified data claimed on the date, in tebibytes.	not_null
verified_claims	HUGEINT	Successful verified claims on the date.	not_null
verified_providers	BIGINT	Providers with at least one successful verified claim on the date.	not_null

Sample

date	client_id	verified_data_onboarded_tibs	verified_claims	verified_providers
2026-05-15	f03774028	545.625	17460	1
2026-05-15	f03630410	0.0625	2	1
2026-05-15	f03771751	0.3125009536743164	11	1
2026-05-15	f03644598	20.125	644	4
2026-05-15	f03136439	4.46875	143	3
2026-05-15	f03309602	83.5625	2674	4
2026-05-15	f03767350	18.44921875	596	1
2026-05-15	f03535091	33.53125	1073	1
2026-05-15	f03649823	53.28125	1705	2
2026-05-14	f03649823	3.6875	118	1

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-15	0x96f1a3026eac5a6c10cd121ef58d3c13d150e441	1	1	0	1	1	0.0
2026-05-15	0xcb71d6e32e12b618f8e0b4dcf36b6a10b5cedc14	1	0	0	1	1	0.0
2026-05-15	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	656	517	513	81	16	425.9003520773624
2026-05-15	0x47a6a25c09697b0d45b05724030a39aea375743e	1	0	0	1	1	0.0
2026-05-15	0x9fa9d8674a3e3dd64beea17d0bfbf9f5c0bbec7d	1	0	0	1	1	0.0
2026-05-15	0xacc90b5ef7bc8678465205a09cc9ca56acc9ecf3	1	0	0	1	1	0.0
2026-05-15	0xb8b6b17ce0c2ee682a50fa451c405e3e4ff0aea8	1	0	0	1	1	0.0
2026-05-15	0x56e53c5e7f27504b810494cc3b88b2aa0645a839	12	8	8	1	10	567.1241597282818
2026-05-15	0xac405b07220cb8772ef34df0706ab43b66b9ed69	1	1	0	1	1	0.0
2026-05-15	0x74d55b94dfe0bb58e3aea354c0f1395da646da81	1	0	0	1	1	0.0

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-15	64417	0.2005615234375	0.000152587890625	3.08013916015625	3.080291748046875	1860.6611633300781	16219.62121871431	719	11938088.293448	9450493.397255732	4.980359398715762	0.001194269281375381	0.0012225413167868612	0.0013100110103145617	0.0013410230092419635	9450498.37761513	1804.8466054699522	1847.5728883425816	864928753.3966556	400721914.87469846	571451652.8606994	82113452.02169825	42197981.27881745	82113452.02169825	84	678	1.9270656170028237	77	499	0	0	993.0245118056448	1.0236730826559657	225340339.92334494	799552418.9163764	0.7416191110387444	24308	9	16	13976	14082	63386.82122875788	64887.382687005185	0.28175882488027604	0.003816438853380056	0.003906785725807561	4.501265532506595	6159530.6177261695	2732125.4515995174	47795041.76867285	0.05063751468611837
2026-05-14	58175	0.223419189453125	0.330718994140625	3.007232666015625	3.33795166015625	1843.0509033203125	16036.277761284466	718	15411953.811297	10352209.561156118	9.186306375333269	0.001546217386754453	0.0016205398172468646	0.0016706027815718628	0.0017509040769637261	10352218.747462494	1834.6375597595672	1922.8235572021456	864603497.9969589	400658528.0534697	571264527.2657222	82189999.8517945	42196176.43221199	82189999.8517945	83	670	2.4211101433855315	77	499	0	0	987.0797222057809	1.0480672582840478	213820530.73867595	818432729.8188154	0.6337299346923828	20776	7	14	13747	13847	62369.19644704571	65367.112721634374	0.2769772082275366	0.0037981019855096066	0.003980666334636252	4.50416671098763	6159530.6177261695	2732967.049414352	47972070.233965315	0.050487460308112304
2026-05-13	55640	0.244171142578125	0.0645751953125	4.654998779296875	4.719573974609375	1866.9231567382812	16267.489638153667	723	15040043.117045	9617252.904165931	4.476814102233684	0.0015103673935382119	0.0016258972547781132	0.0016643208692115443	0.0017916268213271063	9617257.380980033	1714.9926729419392	1846.1745737033696	864257252.5005698	400596158.8570227	571077401.670745	82288585.19431911	42194341.79465222	82288585.19431911	81	643	1.9140176611892068	77	499	4	9	976.691968327544	1.0764912310303913	238146259.31010452	840294220.6376307	0.44635009765625	14629	6	14	13686	13795	62185.55261278845	66942.2020844458	0.27583080508759006	0.0037330946614525557	0.004018643667660043	4.507832737425766	6159530.6177261695	2733738.4438563213	48166824.436980225	0.050320667401732716
2026-05-12	56016	0.2747802734375	6.857025146484375	3.384796142578125	10.2418212890625	1870.1686096191406	16297.440485771018	724	14448853.236905003	19291487.441364598	5.006179010190642	0.0014566005802978182	0.0016034651405585122	0.0015947766785749202	0.0017555731101986313	19291492.447543606	18465.206621943275	20326.996660568744	863794183.7392951	400533973.3044099	570890276.0757679	82504057.80067672	42192626.80197928	82504057.80067672	77	618	1.9872075316559028	73	490	2	11	967.9997120966805	1.1008269269195718	263357380.92682928	858865621.5331011	0.4931354532018304	16162	8	15	13988	14091	63587.521757770955	69998.85616703841	0.2813127749141574	0.003810241815013165	0.004194416788041394	4.512633720656515	6159530.6177261695	2735255.657346138	48349585.145915955	0.050179784042113706
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.3700056048667	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

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-15	f01002224	354.375	354.375	0.0	0	0.0	0	0.15625	5	0.15625	5	0.0	0	0	0	0	0.0	0.0
2026-05-15	f0101020	430.90625	4250.213134765625	0.0	0	0.0	0	0.0	0	0.0	0	0.0	0	0	0	0	0.0	0.0
2026-05-15	f0101021	437.59375	4320.603759765625	0.0	0	0.0	0	0.0	0	0.0	0	0.0	0	0	2	2	9.003008575483248	9.21613754164303
2026-05-15	f0101087	1745.15625	1745.1562883257866	0.0	0	0.0	0	0.0	0	0.0	0	0.0	0	0	3	3	14.100279277332776	14.434076354137275
2026-05-15	f01016847	577.625	5766.96875	0.0	0	0.0	0	0.0	0	0.0	0	0.0	0	0	9	9	45.875167979786944	46.96117462322875
2026-05-15	f01019009	600.25	5976.23828125	0.0	0	0.0	0	0.0625	2	0.0625	2	0.0	0	0	7	7	23.674388416121474	24.234834169925755
2026-05-15	f01021773	1010.75	7388.9375	0.0	0	0.0	0	0.0	0	0.0	0	0.0	0	0	7	7	29.244637333498808	29.936948050338465
2026-05-15	f01045957	1588.1875	1588.1875	0.0	0	0.0	0	0.0	0	0.0	0	0.0	0	0	1	1	5.629198172113625	5.7624586457288824
2026-05-15	f010479	61.71875	443.62109375	0.0	0	0.0	0	0.1875	6	0.1875	6	0.0	0	0	0	0	0.0	0.0
2026-05-15	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
1986	0x1721eb5d0b038b07f356d7c3858e6f1fb10089ea	0x89b5899619d93a180d38011b8aec849deea3f573	0xeb466342c4d449bc9f53a865d5cb90586f405215	0x47a6a25c09697b0d45b05724030a39aea375743e	FWSS	0x47a6a25c09697b0d45b05724030a39aea375743e	0x0000000000000000000000000000000000000000	0	False	6018762	39	0xcad15982101534f3c78e6f8bc907370a60e0fe1fdc9887e88cd433fe4ca5ccf2	2026-05-15 18:21:00+00:00	null	null	null	null	null	null	null	False
1982	0x10b948c0f51d00c4a219a7d47f539b4b40690e82	0x010ecc2436e0c5ea4741cd25a27a5476fe7a252c	0x80b98d3aa09ffff255c3ba4a241111ff1262f045	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	FWSS	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	0	True	6018534	0	0xc7c99e69acc40034c0d07d7410898ac010268b394cc0a279a435eff05b4032a9	2026-05-15 16:27:00+00:00	null	null	null	null	null	null	null	False
1985	0x10b948c0f51d00c4a219a7d47f539b4b40690e82	0x23b1e018f08bb982348b15a86ee926eebf7f4daa	0x80b98d3aa09ffff255c3ba4a241111ff1262f045	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	FWSS	0x0000000000000000000000000000000000000000	0x0000000000000000000000000000000000000000	0	True	6018534	26	0x2aab317abc0e898a800211fcbd4063bc83eac908f08123d60fdbe0570470406a	2026-05-15 16:27:00+00:00	6018534	30	0x2aab317abc0e898a800211fcbd4063bc83eac908f08123d60fdbe0570470406a	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	6018534	2026-05-15 16:27:00+00:00	2026-05-15 16:27:00+00:00	True
1984	0x10b948c0f51d00c4a219a7d47f539b4b40690e82	0x32c90c26bca6ed3945de9b29ba4e19d38314d618	0x80b98d3aa09ffff255c3ba4a241111ff1262f045	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	FWSS	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	0	True	6018534	24	0x2aab317abc0e898a800211fcbd4063bc83eac908f08123d60fdbe0570470406a	2026-05-15 16:27:00+00:00	null	null	null	null	null	null	null	False
1983	0x10b948c0f51d00c4a219a7d47f539b4b40690e82	0x23b1e018f08bb982348b15a86ee926eebf7f4daa	0x80b98d3aa09ffff255c3ba4a241111ff1262f045	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	FWSS	0x0000000000000000000000000000000000000000	0x0000000000000000000000000000000000000000	0	True	6018534	3	0xc7c99e69acc40034c0d07d7410898ac010268b394cc0a279a435eff05b4032a9	2026-05-15 16:27:00+00:00	6018534	7	0xc7c99e69acc40034c0d07d7410898ac010268b394cc0a279a435eff05b4032a9	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	6018534	2026-05-15 16:27:00+00:00	2026-05-15 16:27:00+00:00	True
1980	0x52208d61d5e063c58f32a9ac8a090edad15c917c	0x010ecc2436e0c5ea4741cd25a27a5476fe7a252c	0x80b98d3aa09ffff255c3ba4a241111ff1262f045	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	FWSS	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	0	True	6018479	13	0x3b0435d61e1bdcb42b1b0d9f655eb05dd565710c16791d545d3dc3498abdfd3c	2026-05-15 15:59:30+00:00	null	null	null	null	null	null	null	False
1981	0x52208d61d5e063c58f32a9ac8a090edad15c917c	0x23b1e018f08bb982348b15a86ee926eebf7f4daa	0x80b98d3aa09ffff255c3ba4a241111ff1262f045	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	FWSS	0x0000000000000000000000000000000000000000	0x0000000000000000000000000000000000000000	0	True	6018479	16	0x3b0435d61e1bdcb42b1b0d9f655eb05dd565710c16791d545d3dc3498abdfd3c	2026-05-15 15:59:30+00:00	6018479	20	0x3b0435d61e1bdcb42b1b0d9f655eb05dd565710c16791d545d3dc3498abdfd3c	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	6018479	2026-05-15 15:59:30+00:00	2026-05-15 15:59:30+00:00	True
1979	0xd28283fcb6e484fcccd3d5b0d24c6ed7eb28ce86	0x23b1e018f08bb982348b15a86ee926eebf7f4daa	0x80b98d3aa09ffff255c3ba4a241111ff1262f045	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	FWSS	0x0000000000000000000000000000000000000000	0x0000000000000000000000000000000000000000	0	True	6018056	19	0x5787ffb186f0a3f218cb1cf191e672efb481c2407d58dd5996252b6292390211	2026-05-15 12:28:00+00:00	6018056	23	0x5787ffb186f0a3f218cb1cf191e672efb481c2407d58dd5996252b6292390211	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	6018056	2026-05-15 12:28:00+00:00	2026-05-15 12:28:00+00:00	True
1978	0xd28283fcb6e484fcccd3d5b0d24c6ed7eb28ce86	0x32c90c26bca6ed3945de9b29ba4e19d38314d618	0x80b98d3aa09ffff255c3ba4a241111ff1262f045	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	FWSS	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	0	True	6018056	16	0x5787ffb186f0a3f218cb1cf191e672efb481c2407d58dd5996252b6292390211	2026-05-15 12:28:00+00:00	null	null	null	null	null	null	null	False
1977	0xd28283fcb6e484fcccd3d5b0d24c6ed7eb28ce86	0x23b1e018f08bb982348b15a86ee926eebf7f4daa	0x80b98d3aa09ffff255c3ba4a241111ff1262f045	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	FWSS	0x0000000000000000000000000000000000000000	0x0000000000000000000000000000000000000000	0	True	6017354	110	0xd55f26c42dbed78003b675c5a8aa2af102da926a8f548b920a5290acaf216ee4	2026-05-15 06:37:00+00:00	6017354	114	0xd55f26c42dbed78003b675c5a8aa2af102da926a8f548b920a5290acaf216ee4	0x8408502033c418e1bbc97ce9ac48e5528f371a9f	6017354	2026-05-15 06:37:00+00:00	2026-05-15 06:37: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
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
18	0x4de3d41c4fc6a80c9a5c908f3c6f4e48975637fd	0x4de3d41c4fc6a80c9a5c908f3c6f4e48975637fd	True	False	True	PDP	True	https://storacha.network	earth	null	null	null	0x4de3d41c4fc6a80c9a5c908f3c6f4e48975637fd	1	1	1	1	null	null	null	null	null	null	{paymentTokenAddress:0x4de3d41c4fc6a80c9a5c908f3c6f4e48975637fd,location:0x6561727468,minProvingPeriodInEpochs:0x01,storagePricePerTibPerDay:0x01,maxPieceSizeInBytes:0x01,minPieceSizeInBytes:0x01,serviceURL:0x68747470733a2f2f73746f72616368612e6e6574776f726b}	5535714	0x5327e820ed39045e15c47fc11903e69b7da122aae06cfe0e968f8842aaada2c6	2025-11-29 00:57:00+00:00	5535714	0x5327e820ed39045e15c47fc11903e69b7da122aae06cfe0e968f8842aaada2c6	2025-11-29 00:57:00+00:00	False	null	null	null	null	null
29	0x4a30c03e35bde301c361cd66fa01a25cf542ebc5	0x4a30c03e35bde301c361cd66fa01a25cf542ebc5	True	False	True	PDP	True	https://sp.reiers.io	C=NO;ST=Viken;L=Drammen	NO	Viken	Drammen	0x80b98d3aa09ffff255c3ba4a241111ff1262f045	1048576	68719476736	83333333333333333	1440	True	True	0x002408011220dab53646cc1648db7c9b0fdc047c159c4fcc1a99c536e23c9dcdb20e0096e0a7	null	null	null	{IPNIPeerID:0x002408011220dab53646cc1648db7c9b0fdc047c159c4fcc1a99c536e23c9dcdb20e0096e0a7,ipniPeerId:0x002408011220dab53646cc1648db7c9b0fdc047c159c4fcc1a99c536e23c9dcdb20e0096e0a7,ipniIpfs:0x01,ipniPiece:0x01,paymentTokenAddress:0x80b98d3aa09ffff255c3ba4a241111ff1262f045,location:0x433d4e4f3b53543d56696b656e3b4c3d4472616d6d656e,minProvingPeriodInEpochs:0x05a0,storagePricePerTibPerDay:0x01280f39a3485555,maxPieceSizeInBytes:0x1000000000,minPieceSizeInBytes:0x100000,serviceURL:0x68747470733a2f2f73702e7265696572732e696f}	6015864	0x3e5aea216e13e74b788b90795475c2400180837b29d0fc592cfbbebcd1a383ef	2026-05-14 18:12:00+00:00	6015864	0x3e5aea216e13e74b788b90795475c2400180837b29d0fc592cfbbebcd1a383ef	2026-05-14 18:12:00+00:00	False	null	null	null	null	null
10	0x74075b4a9e00304c2dddbae4a76399830c917544	0x74075b4a9e00304c2dddbae4a76399830c917544	True	False	True	PDP	True	https://mokanla.meje.dev	C=NG;ST=Lagos;L=Lagos	NG	Lagos	Lagos	0x0000000000000000000000000000000000000000	1048576	1073741824	83333333333333330	30	True	True	0x00240801122024a43e835a090adfcdcb65b95c6f934a345e4e206562f66888faeccc1ae98111	1	1.0	testing	{capacityTib:0x31,serviceStatus:0x74657374696e67,IPNIPeerID:0x00240801122024a43e835a090adfcdcb65b95c6f934a345e4e206562f66888faeccc1ae98111,ipniIpfs:0x01,ipniPiece:0x01,paymentTokenAddress:0x0000000000000000000000000000000000000000,location:0x433d4e473b53543d4c61676f733b4c3d4c61676f73,minProvingPeriodInEpochs:0x1e,storagePricePerTibPerDay:0x01280f39a3485552,maxPieceSizeInBytes:0x40000000,minPieceSizeInBytes:0x100000,serviceURL:0x68747470733a2f2f6d6f6b616e6c612e6d656a652e646576}	5488948	0x133bec4c34cd4566d5771fd25770e311ec5ab325ead44842026558828e37150a	2025-11-12 19:14:00+00:00	5724256	0x92b0a31ad528d5ca5078c4eaf64a8e92440e7ceea67eaba4bc5e24d914e9f494	2026-02-02 12:08:00+00:00	False	null	null	null	null	null
28	0x4a30c03e35bde301c361cd66fa01a25cf542ebc5	0x4a30c03e35bde301c361cd66fa01a25cf542ebc5	True	True	False	PDP	True	https:	C=NO	NO	null	null	0x80b98d3aa09ffff255c3ba4a241111ff1262f045	1048576	68719476736	83333333333333333	1440	True	True	0x002408011220dab53646cc1648db7c9b0fdc047c159c4fcc1a99c536e23c9dcdb20e0096e0a7	null	null	null	{IPNIPeerID:0x002408011220dab53646cc1648db7c9b0fdc047c159c4fcc1a99c536e23c9dcdb20e0096e0a7,ipniPeerId:0x002408011220dab53646cc1648db7c9b0fdc047c159c4fcc1a99c536e23c9dcdb20e0096e0a7,ipniIpfs:0x01,ipniPiece:0x01,paymentTokenAddress:0x80b98d3aa09ffff255c3ba4a241111ff1262f045,location:0x433d4e4f,minProvingPeriodInEpochs:0x05a0,storagePricePerTibPerDay:0x01280f39a3485555,maxPieceSizeInBytes:0x1000000000,minPieceSizeInBytes:0x100000,serviceURL:0x68747470733a}	5994847	0x117bff8749e42d47e07964e0e94991311e47c54b0d1f61d9033a9b3bc9754d46	2026-05-07 11:03:30+00:00	5994847	0x117bff8749e42d47e07964e0e94991311e47c54b0d1f61d9033a9b3bc9754d46	2026-05-07 11:03:30+00:00	False	null	null	null	null	null
2	0x86d026029052c6582d277d9b28700edc9670b150	0x86d026029052c6582d277d9b28700edc9670b150	True	False	True	PDP	True	https://pdp-main.660688.xyz:8443	C=CN;ST=Zhejiang;L=Hangzhou	CN	Zhejiang	Hangzhou	0x0000000000000000000000000000000000000000	1048576	1073741824	83333333333333330	30	True	True	0x002408011220b45c4247d808f10ebfa3532764d0dd5893524bc91108c8486ba7b9b9195eee8c	12	12.0	prod	{capacityTib:0x3132,serviceStatus:0x70726f64,IPNIPeerID:0x002408011220b45c4247d808f10ebfa3532764d0dd5893524bc91108c8486ba7b9b9195eee8c,ipniPeerId:0x002408011220b45c4247d808f10ebfa3532764d0dd5893524bc91108c8486ba7b9b9195eee8c,ipniIpfs:0x01,ipniPiece:0x01,paymentTokenAddress:0x0000000000000000000000000000000000000000,location:0x433d434e3b53543d5a68656a69616e673b4c3d48616e677a686f75,minProvingPeriodInEpochs:0x1e,storagePricePerTibPerDay:0x01280f39a3485552,maxPieceSizeInBytes:0x40000000,minPieceSizeInBytes:0x100000,serviceURL:0x68747470733a2f2f7064702d6d61696e2e3636303638382e78797a3a38343433}	5476431	0xe4e00123e5b0c83a1272ad9358108adb614b1c0c1706f394e080ca0671424f81	2025-11-08 10:55:30+00:00	5874396	0x49bcc4b898aee83edb8d878c56a4cb03aa16570989e734377e4e8739dd1b7d7e	2026-03-26 15:18:00+00:00	False	null	null	null	null	null
25	0x7b7fd1531767736acb4fbb5b20a5aba8c675028a	0x7b7fd1531767736acb4fbb5b20a5aba8c675028a	True	False	True	PDP	True	https://storacha.network	earth	null	null	null	0x7b7fd1531767736acb4fbb5b20a5aba8c675028a	1	1	1	1	null	null	null	null	null	null	{paymentTokenAddress:0x7b7fd1531767736acb4fbb5b20a5aba8c675028a,location:0x6561727468,minProvingPeriodInEpochs:0x01,storagePricePerTibPerDay:0x01,maxPieceSizeInBytes:0x01,minPieceSizeInBytes:0x01,serviceURL:0x68747470733a2f2f73746f72616368612e6e6574776f726b}	5549432	0x9fa2b6db8d630aba1fa5967eb6f31b381bed42e5614890576e0cfe8dcdd057de	2025-12-03 19:16:00+00:00	5549432	0x9fa2b6db8d630aba1fa5967eb6f31b381bed42e5614890576e0cfe8dcdd057de	2025-12-03 19:16:00+00:00	False	null	null	null	null	null
21	0x3fa2a4c02478f1e57d3dd2868484164647c45038	0x3fa2a4c02478f1e57d3dd2868484164647c45038	True	False	True	PDP	True	https://storacha.network	earth	null	null	null	0x3fa2a4c02478f1e57d3dd2868484164647c45038	1	1	1	1	null	null	null	null	null	null	{paymentTokenAddress:0x3fa2a4c02478f1e57d3dd2868484164647c45038,location:0x6561727468,minProvingPeriodInEpochs:0x01,storagePricePerTibPerDay:0x01,maxPieceSizeInBytes:0x01,minPieceSizeInBytes:0x01,serviceURL:0x68747470733a2f2f73746f72616368612e6e6574776f726b}	5543204	0x65b202618e4abda7774d050adb9d620e62efc0e88782728f71de8a270f3ad1e8	2025-12-01 15:22:00+00:00	5543204	0x65b202618e4abda7774d050adb9d620e62efc0e88782728f71de8a270f3ad1e8	2025-12-01 15:22:00+00:00	False	null	null	null	null	null
19	0x21f15b5a2711ef55d9463cf66cc793eb17ce087f	0x21f15b5a2711ef55d9463cf66cc793eb17ce087f	True	False	True	PDP	True	https://storacha.network	earth	null	null	null	0x21f15b5a2711ef55d9463cf66cc793eb17ce087f	1	1	1	1	null	null	null	null	null	null	{paymentTokenAddress:0x21f15b5a2711ef55d9463cf66cc793eb17ce087f,location:0x6561727468,minProvingPeriodInEpochs:0x01,storagePricePerTibPerDay:0x01,maxPieceSizeInBytes:0x01,minPieceSizeInBytes:0x01,serviceURL:0x68747470733a2f2f73746f72616368612e6e6574776f726b}	5535854	0x4baa606cadf93908dec2736947e13cf91554d2d851a53e758d6ccaaacd8787ca	2025-11-29 02:07:00+00:00	5535854	0x4baa606cadf93908dec2736947e13cf91554d2d851a53e758d6ccaaacd8787ca	2025-11-29 02:07:00+00:00	False	null	null	null	null	null

Columns

column	type	description	tests
provider_id	VARCHAR	Filecoin storage provider actor id address.	not_null, unique
owner_id	VARCHAR	Current owner actor id address.
worker_id	VARCHAR	Current worker actor id address.
beneficiary_id	VARCHAR	Current beneficiary actor id address.
peer_id	VARCHAR	Current libp2p peer id.
control_addresses	VARCHAR	Current JSON array of control addresses.
multi_addresses	VARCHAR	Current JSON array of multiaddrs.
sector_size	BIGINT	Current sector size in bytes.
live_sectors	BIGINT	Current live sector count.
active_sectors	BIGINT	Current active sector count.
faulty_sectors	BIGINT	Current faulty sector count.
actor_balance_fil	DOUBLE	Current miner actor balance, in FIL.
available_balance_fil	DOUBLE	Current available miner balance, in FIL.
market_escrow_fil	DOUBLE	Current market escrow balance, in FIL.
market_locked_fil	DOUBLE	Current market locked balance, in FIL.
market_available_fil	DOUBLE	Current market available balance, in FIL.
initial_pledge_fil	DOUBLE	Current initial pledge, in FIL.
locked_funds_fil	DOUBLE	Current locked funds, in FIL.
pre_commit_deposits_fil	DOUBLE	Current pre-commit deposits, in FIL.
fee_debt_fil	DOUBLE	Current fee debt, in FIL.
raw_power_tibs	DOUBLE	Current raw byte power, in tebibytes.
quality_adjusted_power_tibs	DOUBLE	Current quality adjusted power, in tebibytes.
has_power	BOOLEAN	Whether the provider currently has positive power.	not_null
has_sector_activity	BOOLEAN	Whether the provider has sector lifecycle activity.	not_null
has_verified_claims	BOOLEAN	Whether the provider has successful verified claims.	not_null
has_market_deals	BOOLEAN	Whether the provider has market deal activity.	not_null
first_sector_activity_date	DATE	First date with sector lifecycle activity.
last_sector_activity_date	DATE	Most recent date with sector lifecycle activity.
first_verified_claim_at	TIMESTAMP	First successful verified claim timestamp.
last_verified_claim_at	TIMESTAMP	Most recent successful verified claim timestamp.
first_market_deal_start_at	TIMESTAMP WITH TIME ZONE	First observed market deal start timestamp.
last_market_deal_start_at	TIMESTAMP WITH TIME ZONE	Most recent market deal start timestamp.
verified_claims	BIGINT	Total successful verified claims.
verified_clients	BIGINT	Clients with at least one successful verified claim.
verified_data_onboarded_tibs	DOUBLE	Verified data successfully claimed, in tebibytes.
total_block_rewards_fil	DOUBLE	Total block rewards allocated to the provider, in FIL.

Sample

provider_id	owner_id	worker_id	beneficiary_id	peer_id	control_addresses	multi_addresses	sector_size	live_sectors	active_sectors	faulty_sectors	actor_balance_fil	available_balance_fil	market_escrow_fil	market_locked_fil	market_available_fil	initial_pledge_fil	locked_funds_fil	pre_commit_deposits_fil	fee_debt_fil	raw_power_tibs	quality_adjusted_power_tibs	has_power	has_sector_activity	has_verified_claims	has_market_deals	first_sector_activity_date	last_sector_activity_date	first_verified_claim_at	last_verified_claim_at	first_market_deal_start_at	last_market_deal_start_at	verified_claims	verified_clients	verified_data_onboarded_tibs	total_block_rewards_fil
f03623016	f03632590	f03622984	f03632590	12D3KooWQKTq2derMYzNrRhwZsrRRCc47GLkX1WS2hvbq3oFbdct	[f03622996, f03622993, f03622986, f03622991, f03622992, f03622987]	[/dns/a-fil-http.aur.lu/tcp/443/wss]	34359738368	302139	302139	0	381673.26282221405	83153.91685806667	689.7665326094344	618.9299202965203	70.8366123129141	287209.83960768924	11309.506356458127	0.0	0.0	9441.84375	58971.3046875	True	True	True	True	2025-07-31	2025-09-28	2025-08-20 11:25:00	2026-05-15 23:59:30	2025-08-24 10:23:00+00:00	2026-05-18 23:42:00+00:00	176108	8	5503.3359375	38914.233509781356
f01082688	f03338164	f03759652	f03338164	12D3KooWNZ1bNnLikm84dXC4oSWcBX9TEPUAV7Bx2PUpryWmWv8a	[f03759649]	[/dns/f01081439.44943.com/tcp/443/wss]	34359738368	8366	8308	2	50033.94856364673	34216.361116418295	200.0	22.37380400389528	177.6261959961047	15791.07276398511	25.110044415897377	1.4046388274237476	0.0	232.15625	2321.5625	True	True	True	True	2026-05-05	2026-05-15	2026-05-05 20:33:30	2026-05-15 23:59:30	2026-06-03 15:15:30+00:00	2026-06-13 15:58:00+00:00	7852	2	245.375	33.514697747565954
f03644166	f03632590	f03644164	f03632590	12D3KooWQKTq2derMYzNrRhwZsrRRCc47GLkX1WS2hvbq3oFbdct	[f03644171, f03644172, f03644173, f03644174, f03644175, f03644176]	[/dns/a-fil-http.aur.lu/tcp/443/wss]	34359738368	72405	72405	0	112892.6576166603	12810.192973834579	194.30976391504245	165.04105186218453	29.26871205285792	97179.34558798223	2903.119054843502	0.0	0.0	2262.65625	17957.7421875	True	True	True	True	2025-10-08	2025-11-23	2025-10-10 12:40:00	2026-05-15 23:58:30	2025-10-12 11:55:00+00:00	2026-05-18 23:47:30+00:00	55807	6	1743.9296875	6607.573549722263
f01083688	f03338164	f03696737	f03338164	12D3KooWLGAZMarHVML2KUtY7Hf5H5pfNhXWqCcypqPUYuDeBVFc	[f03696743]	[/dns/f01084868.44943.com/tcp/443/wss]	34359738368	97951	97437	0	253785.0508062195	75804.64237177707	396.14458680110823	249.02477924945947	147.11980755164876	174593.56183500402	3385.1119069634537	1.7346924749647727	0.0	3044.21875	30441.90625	True	True	True	True	2025-12-10	2026-05-15	2025-12-10 01:52:30	2026-05-15 23:55:30	2026-01-08 15:51:00+00:00	2026-06-14 03:54:00+00:00	98170	8	3067.8125	5627.224099136149
f03644168	f03632590	f03644165	f03632590	12D3KooWQKTq2derMYzNrRhwZsrRRCc47GLkX1WS2hvbq3oFbdct	[f03644177, f03644178, f03644179, f03644180, f03644181, f03644182]	[/dns/a-fil-http.aur.lu/tcp/443/wss]	34359738368	73215	73215	0	112870.20440784458	12901.866901025709	193.9739049925594	164.65894713599621	29.314957856563183	97065.24078033233	2903.0967264865326	0.0	0.0	2287.96875	17946.3515625	True	True	True	True	2025-10-08	2025-12-20	2025-10-10 12:50:30	2026-05-15 23:55:00	2025-10-12 11:55:30+00:00	2026-05-18 23:47:30+00:00	55675	6	1739.8203125	6935.010592568175
f03741653	f03200943	f03741652	f03286739	Qmaco51xxrAmLZNxPb2r7fdanb6iMyN4oFx8epiHjiv6gS	null	null	34359738368	73101	72846	0	201380.8734097442	67118.00907319035	0.0	0.0	0.0	133331.2965194501	891.1240571268232	40.44375997695211	0.0	2240.4375	22404.375	True	True	True	False	2026-02-06	2026-05-15	2026-02-06 16:15:00	2026-05-15 23:54:30	null	null	72640	1	2270.0	2008.2132598127112
f01081439	f03338164	f03759651	f03338164	12D3KooWNZ1bNnLikm84dXC4oSWcBX9TEPUAV7Bx2PUpryWmWv8a	[f03759648]	[/dns/f01081439.44943.com/tcp/443/wss]	34359738368	13493	13134	0	80119.22088075406	54757.754587108626	299.9790100159665	35.8145118892489	264.1644981267176	25272.230872412634	87.85449456252611	1.3809266702685972	0.0	383.0	3830.0	True	True	True	True	2026-04-16	2026-05-15	2026-04-16 23:42:00	2026-05-15 23:50:30	2026-05-16 14:03:00+00:00	2026-06-13 16:15:30+00:00	12969	4	405.28125	98.31075681881033
f01084788	f03338164	f03696738	f03338164	12D3KooWLGAZMarHVML2KUtY7Hf5H5pfNhXWqCcypqPUYuDeBVFc	[f03696744]	[/dns/f01084868.44943.com/tcp/443/wss]	34359738368	114712	114319	0	284316.9572968864	75377.95715040858	399.2389315280634	295.470850353414	103.76808117464941	205268.97166556824	3668.4545347962558	1.5739461133362351	0.0	3546.8125	35468.125	True	True	True	True	2026-02-11	2026-05-15	2026-02-11 04:36:30	2026-05-15 23:46:30	2026-03-12 09:46:00+00:00	2026-06-14 03:54:00+00:00	114304	7	3572.0	5972.521877593812
f02063867	f02066082	f03742347	f02066082	12D3KooWP9QL4z6Qsmz6A2Ufmz1oeNiqB1hCLrNjE4jDoo3LBkP9	[f03742460, f03742464]	[/ip4/183.60.248.132/tcp/14888]	34359738368	115803	115785	0	209450.34221686656	2011.2535352743628	844.2416584602056	837.8832749011663	6.358383559039339	198941.24788509452	8496.91174775542	0.9290487422401036	0.0	3616.4375	36144.18487548828	True	True	True	True	2023-03-16	2026-05-15	2023-03-16 09:33:00	2026-05-15 23:41:30	2023-03-22 09:07:30+00:00	2026-05-19 02:12:00+00:00	115399	9	3603.3504028320312	100740.18148615886
f01084868	f03338164	f03759653	f03338164	12D3KooWLGAZMarHVML2KUtY7Hf5H5pfNhXWqCcypqPUYuDeBVFc	[f03759650]	[/dns/f01084868.44943.com/tcp/443/wss]	34359738368	37221	36426	10	110434.70321924823	40506.10127302582	299.9263121549758	97.7300474487839	202.19626470619187	69605.97493720954	320.95452548006125	1.6724835327955339	0.0	1138.3125	11382.5625	True	True	True	True	2026-04-19	2026-05-15	2026-04-19 15:24:00	2026-05-15 23:38:00	2026-05-19 09:45:30+00:00	2026-06-14 03:54:00+00:00	36711	3	1147.21875	502.26364442212235

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