Miners

Miner power and lifetime activity.

Shape

Table
miners
Rows ≈
8,876 · 12 columns · local snapshot
Grain
miner_id
Observed, UTC
Not date-indexed · view built 2026-11-17
Raw sources
None declared · 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-11-17.

Columns

miners column definitions
NameTypeDescription
miner_idVARCHARFilecoin storage provider actor id address.
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_idraw_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
f0151836916119.125161135.28125truetruetrue2021-12-182026-11-162022-11-02 08:24:00+002026-10-23 00:47:30+00534844.18582369964
f0188966813704.8125137035.75truetruetrue2022-08-022026-09-292022-11-18 06:50:30+002026-05-31 08:52:30+00476868.13817196441
f0169724810827.71875108097.8203125truetruetrue2022-01-212026-10-012023-01-06 09:20:00+002026-04-23 21:38:30+00566084.23432272212
f0108391410240.96875102409.6875truetruetrue2024-02-052025-08-042024-02-10 15:19:00+002024-05-25 11:09:00+00376042.942219331450
f036230169441.6562594416.5625truetruetrue2025-07-312026-10-252025-08-24 10:23:00+002026-11-19 22:22:30+00108697.121229761830