select sum(TX_COUNT) as "TX count by day" ,count(distinct(MINER)) as"Active miners per day",sum(TX_COUNT)/count(distinct(MINER)) "Average tx done by miners", date_trunc('day',BLOCK_TIMESTAMP) as date
from ethereum.core.fact_blocks
group by 4
order by 4 desc