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
select *
from 'https://data.filecoindataportal.xyz/miners.parquet'
limit 10;Columns
| Name | Type | Description |
|---|---|---|
| miner_id | VARCHAR | Filecoin storage provider actor id address. |
| 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. |
| has_sector_activity | BOOLEAN | Whether the provider has sector lifecycle activity. |
| has_market_deals | BOOLEAN | Whether the provider has market deal activity. |
| first_sector_activity_date | DATE | First date with sector lifecycle activity. |
| last_sector_activity_date | DATE | Most recent date with sector lifecycle activity. |
| 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. |
| total_block_rewards_fil | DOUBLE | Total 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_count | HUGEINT | Lifetime winning proofs on tipsets whose rewards are unobservable and excluded from total_block_rewards_fil. |
Sample
| miner_id | raw_power_tibs | quality_adjusted_power_tibs | has_power | has_sector_activity | has_market_deals | first_sector_activity_date | last_sector_activity_date | first_market_deal_start_at | last_market_deal_start_at | total_block_rewards_fil | unobservable_win_count |
|---|---|---|---|---|---|---|---|---|---|---|---|
| f01518369 | 16119.125 | 161135.28125 | true | true | true | 2021-12-18 | 2026-11-16 | 2022-11-02 08:24:00+00 | 2026-10-23 00:47:30+00 | 534844.1858236996 | 4 |
| f01889668 | 13704.8125 | 137035.75 | true | true | true | 2022-08-02 | 2026-09-29 | 2022-11-18 06:50:30+00 | 2026-05-31 08:52:30+00 | 476868.1381719644 | 1 |
| f01697248 | 10827.71875 | 108097.8203125 | true | true | true | 2022-01-21 | 2026-10-01 | 2023-01-06 09:20:00+00 | 2026-04-23 21:38:30+00 | 566084.2343227221 | 2 |
| f01083914 | 10240.96875 | 102409.6875 | true | true | true | 2024-02-05 | 2025-08-04 | 2024-02-10 15:19:00+00 | 2024-05-25 11:09:00+00 | 376042.94221933145 | 0 |
| f03623016 | 9441.65625 | 94416.5625 | true | true | true | 2025-07-31 | 2026-10-25 | 2025-08-24 10:23:00+00 | 2026-11-19 22:22:30+00 | 108697.12122976183 | 0 |