sum(TX_COUNT) as tx_count1 ,

count(distinct(MINER)) as miners,

count(DISTINCT(block_number)) as total_block,

sum(TX_COUNT)/count(distinct(MINER)) average_tx_per_miner,

sum(tx_count1) over (order by date) as cumu_tx,

sum(total_block) over (order by date) as cumu_block,

sum(miners) over (order by date) as cumu_miners

from ethereum.core.fact_blocks

where block_timestamp >= '2022-01-01'

group by 1

order by 1 desc