zakkisyedEthereum - Miner/Validators Activity
    Updated 2022-09-25

    select count (miners), date_trunc(day,block_timestamp) as dt, merge_status

    from
    (

    select distinct miner as miners, block_timestamp,
    case when block_number > 15537393 then 'post_merge'
    else 'pre_merge' end as merge_status
    from ethereum.core.fact_blocks
    -- where block_number > 14537393
    )
    group by 2,3
    order by 2 desc
    Run a query to Download Data