BLOCK_TIMESTAMP::date as date,

COUNT(DISTINCT miner) as number_of_miner,

sum(tx_count) as total_transaction

FROM ethereum.core.fact_blocks

WHERE network = 'mainnet'

and blockchain = 'ethereum'

and date < '2022-09-15'

GROUP BY date

ORDER by DATE