SUM(br.block_reward) AS daily_cumulative_supply,

MAX(bd.difficulty) AS max_difficulty

FROM bitcoin.gov.ez_miner_rewards br

INNER JOIN bitcoin.core.fact_blocks bd ON br.block_hash = bd.block_hash

WHERE YEAR(br.block_timestamp) = 2024

GROUP BY DATE(br.block_timestamp)

ORDER BY DATE(br.block_timestamp) DESC;