Query editor
SELECT date_trunc('day', i.block_time) AS date,SUM(o.value * (DATE_DIFF('day', o.block_time, i.block_time))) AS cddFROM bitcoin.inputs iJOIN bitcoin.outputs oON i.spent_tx_id = o.tx_id AND i.spent_output_number = o.indexWHERE i.block_time >= TIMESTAMP '2026-05-25'AND i.block_time < TIMESTAMP '2026-05-26'GROUP BY 1 ORDER BY 1