jackguy2023-07-20 12:10 PM
    SELECT
    date_trunc('week', block_timestamp) as week,
    sum(total_reward - fees) as block_rewards_btc,
    sum(fees) as fees_btc
    FROM bitcoin.core.ez_miner_rewards
    WHERE block_timestamp > '2021-01-01'
    GROUP BY 1
    Run a query to Download Data