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