Query editor
WITH gained_dates AS (SELECT DATE_ADD('day', 365, date_trunc('day', o.block_time)) AS measurement_date,SUM(o.value) AS gained_btcFROM bitcoin.outputs oLEFT JOIN bitcoin.inputs iON i.spent_tx_id = o.tx_id AND i.spent_output_number = o.indexWHERE date_trunc('day', o.block_time) >= DATE '2026-05-22' - INTERVAL '365' DAYAND date_trunc('day', o.block_time) < DATE '2026-05-23' - INTERVAL '365' DAYAND (i.block_time IS NULLOR i.block_time >= date_trunc('day', o.block_time) + INTERVAL '365' DAY)GROUP BY 1)SELECT measurement_date AS date, gained_btc FROM gained_datesWHERE measurement_date >= DATE '2026-05-22' AND measurement_date < DATE '2026-05-23'ORDER BY 1