DATE_TRUNC('day', block_timestamp) AS date,

SUM(block_reward) AS total_block_rewards

bitcoin.gov.ez_miner_rewards

GROUP BY

date

ORDER BY

date;