--select * from bitcoin.gov.ez_miner_rewards order by block_timestamp desc limit 10
SELECT
DISTINCT DATE_TRUNC('day', BLOCK_TIMESTAMP) AS date,
COUNT(block_hash) AS total_blocks,
sum(TOTAL_REWARD) as total_reward,
sum(fees) as total_fees
FROM
bitcoin.gov.ez_miner_rewards
WHERE
EXTRACT(YEAR FROM BLOCK_TIMESTAMP) = 2024
GROUP BY
DATE_TRUNC('day', BLOCK_TIMESTAMP)
ORDER BY
date desc;