0-MIDmine per miner 1 month before
Updated 2022-09-17
99
1
2
3
4
5
6
7
8
9
10
›
⌄
select BLOCK_TIMESTAMP::date as date,count(distinct MINER)as unique_miners,count(BLOCK_NUMBER)as mined_block
,mined_block/unique_miners as mined_block_per_unique_miner
,avg(mined_block)over(order by date asc)as daily_avg_mined_blocks
,avg(unique_miners)over(order by date asc)as daily_avg_un_miners
,avg(mined_block_per_unique_miner)over(order by date asc)as avg_mined_by_each
,max(mined_block_per_unique_miner)over(order by date asc)as max_mined_by_each
,min(mined_block_per_unique_miner)over(order by date asc)as min_mined_by_each
from ethereum.core.fact_blocks
where date>='2022-08-15' and date<'2022-09-15'
group by 1
Run a query to Download Data