Query editor
WITH created AS (SELECT date_trunc('day', block_time) AS date, COUNT(*) AS utxos_createdFROM bitcoin.outputsWHERE block_time >= TIMESTAMP '2009-01-03' AND block_time < TIMESTAMP '2026-05-26'GROUP BY 1), spent AS (SELECT date_trunc('day', block_time) AS date, COUNT(*) AS utxos_spentFROM bitcoin.inputsWHERE block_time >= TIMESTAMP '2009-01-03' AND block_time < TIMESTAMP '2026-05-26'GROUP BY 1)SELECT COALESCE(c.date, s.date) AS date,COALESCE(c.utxos_created, 0) AS utxos_created,COALESCE(s.utxos_spent, 0) AS utxos_spent,COALESCE(c.utxos_created, 0) - COALESCE(s.utxos_spent, 0) AS net_utxo_changeFROM created c FULL OUTER JOIN spent s ON c.date = s.dateORDER BY 1