filecoindataportal.xyz

Datasets / miners

Miners

Filecoin miners metrics and latest details.

Download ParquetAsset codeMarkdown

Shape

Table
miners
Rows ≈
8,876 · 31 columns · local snapshot
Grain
miner_id
Observed, UTC
Not date-indexed · view built 2026-10-29
Raw sources
raw.rpc_miners · raw assets

Query

DuckDB, reads the published file
select *
from 'https://data.filecoindataportal.xyz/miners.parquet'
limit 10;

The published file is rebuilt daily; counts and sample here come from the local snapshot built 2026-10-29.

Columns

miners column definitions
NameTypeDescription
miner_idVARCHARFilecoin storage provider actor id address.
owner_idVARCHARCurrent owner actor id address.
worker_idVARCHARCurrent worker actor id address.
beneficiary_idVARCHARCurrent beneficiary actor id address.
peer_idVARCHARCurrent libp2p peer id.
control_addressesVARCHARCurrent JSON array of control addresses.
multi_addressesVARCHARCurrent JSON array of multiaddrs.
sector_sizeBIGINTCurrent sector size in bytes.
live_sectorsBIGINTCurrent live sector count.
active_sectorsBIGINTCurrent active sector count.
faulty_sectorsBIGINTCurrent faulty sector count.
actor_balance_filDOUBLECurrent storage provider actor balance, in FIL.
available_balance_filDOUBLECurrent available storage provider balance, in FIL.
market_escrow_filDOUBLECurrent market escrow balance, in FIL.
market_locked_filDOUBLECurrent market locked balance, in FIL.
market_available_filDOUBLECurrent market available balance, in FIL.
initial_pledge_filDOUBLECurrent initial pledge, in FIL.
locked_funds_filDOUBLECurrent locked funds, in FIL.
pre_commit_deposits_filDOUBLECurrent pre-commit deposits, in FIL.
fee_debt_filDOUBLECurrent fee debt, in FIL.
raw_power_tibsDOUBLECurrent raw byte power, in tebibytes.
quality_adjusted_power_tibsDOUBLECurrent quality adjusted power, in tebibytes.
has_powerBOOLEANWhether the provider currently has positive power.
has_sector_activityBOOLEANWhether the provider has sector lifecycle activity.
has_market_dealsBOOLEANWhether the provider has market deal activity.
first_sector_activity_dateDATEFirst date with sector lifecycle activity.
last_sector_activity_dateDATEMost recent date with sector lifecycle activity.
first_market_deal_start_atTIMESTAMP WITH TIME ZONEFirst observed market deal start timestamp.
last_market_deal_start_atTIMESTAMP WITH TIME ZONEMost recent market deal start timestamp.
total_block_rewards_filDOUBLETotal minted block rewards allocated to the provider on observable tipsets, in FIL. Partial when unobservable_win_count > 0, null when all wins are unobservable.
unobservable_win_countHUGEINTLifetime winning proofs on tipsets whose rewards are unobservable and excluded from total_block_rewards_fil.

Sample

5 rows from the local snapshot, exactly as stored.

miners sample rows
miner_idowner_idworker_idbeneficiary_idpeer_idcontrol_addressesmulti_addressessector_sizelive_sectorsactive_sectorsfaulty_sectorsactor_balance_filavailable_balance_filmarket_escrow_filmarket_locked_filmarket_available_filinitial_pledge_fillocked_funds_filpre_commit_deposits_filfee_debt_filraw_power_tibsquality_adjusted_power_tibshas_powerhas_sector_activityhas_market_dealsfirst_sector_activity_datelast_sector_activity_datefirst_market_deal_start_atlast_market_deal_start_attotal_block_rewards_filunobservable_win_count
f01518369f01829322f01869550f0182932212D3KooWGcWttoCPEZUqhp7YJPbnRBUrqvJSpA6xzUN5tPPZs2CM["f01518485", "f01518492", "f01518493"]["/ip4/192.168.200.11/tcp/1111"]343597383685043895043040885542.55072447477709.37811329329452590.22528051070872576.171642268860514.053638241848148835321.921950458442510.062023298141.188637424826661015726.59375157209.6875truetruetrue2021-12-182026-10-282022-11-02 08:24:00+002026-10-23 00:47:30+00520702.12094145384
f01889668f01893240f01880962f0189324012D3KooWSfwyDq1s1QVTs3ZntdEYR1agxudcosXWJNQbaB3HA8Nm["f01893143", "f01893140", "f01880958"]["/ip4/45.207.224.5/tcp/44925"]687194767362192772192770676003.93218750512474.7524613664382784.1606296562772743.932858446151440.22777121012541630417.91753967943111.262186459610013704.8125137035.75truetruetrue2022-08-022026-09-292022-11-18 06:50:30+002026-05-31 08:52:30+00464276.5143046511
f01697248f03066523f01813570f0306652312D3KooWJmosyoJmjmwbEGzqwfuAJPJ8LcE2NE1tj4vyHu41WUbS["f01813572"]["/dns/retrieval.simpleipfs.com/tcp/443/wss"]343597383683464873464870685434.90728116052596.1384103060713165.08579848710043164.88970648254740.19609200455306564650224.075702600632614.6931682537650010827.71875108097.8203125truetruetrue2022-01-212026-10-012023-01-06 09:20:00+002026-04-23 21:38:30+00556618.56456172131
f01083914f01916370f03848868f0191637012D3KooWCxDDxmFrDVsvpVZGLQnbJynLnXKSauYRCwPnZo7QUdJu["f03848869"]["/ip4/46.19.166.62/tcp/13363"]343597383683277113277110938574.2958752858350094.965667290032018.9508819093972018.69353888886330.25734302053365354559345.183002370929134.147205624740010240.96875102409.6875truetruetrue2024-02-052025-08-042024-02-10 15:19:00+002024-05-25 11:09:00+00366938.514062950850
f03230423f03231797f03230396f0323179712D3KooWEUC6VQGjFYUeCznk1wq2AbtAK8YRJVfDPP3ky6iAUfZ4["f03230397"]["/ip4/113.23.169.21/tcp/35180"]687194767361575291575290436787.00488418527460.47971602784751406.8825989756291406.50863141396120.3739675616677687406203.751036848530122.774131308917009845.562598419.765625truetruetrue2024-10-252025-10-272024-11-05 10:42:30+002025-11-06 06:44:30+00202589.42026442130