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