Query editor
SELECT date_trunc('day', block_time) AS date,SUM(output_value) AS block_reward_btc,SUM(fee) AS fees_btc,SUM(output_value) + SUM(fee) AS total_miner_revenue_btc,COUNT(*) AS block_countFROM bitcoin.transactionsWHERE block_time >= TIMESTAMP '2021-01-01'AND block_time < TIMESTAMP '2026-05-28'AND is_coinbase = trueGROUP BY 1 ORDER BY 1