Query editor
SELECT date_trunc('day', i.block_time) AS date,SUM(o.value) AS lost_btcFROM bitcoin.inputs iJOIN bitcoin.outputs o ON i.spent_tx_id = o.tx_id AND i.spent_output_number = o.indexWHERE i.block_time >= TIMESTAMP '2026-05-22' AND i.block_time < TIMESTAMP '2026-05-23'AND DATE_DIFF('day', o.block_time, i.block_time) > 365GROUP BY 1 ORDER BY 1