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