Query editor
WITH mints_burns AS (SELECTDATE_TRUNC('day', evt_block_time) AS block_date,SUM(CASEWHEN "from" = 0x0000000000000000000000000000000000000000THEN value / POWER(10, 18) -- mintWHEN "to" = 0x0000000000000000000000000000000000000000THEN -value / POWER(10, 18) -- burnEND) AS daily_amountFROM erc20_ethereum.evt_TransferWHERE contract_address = 0x7C135549504245B5eAe64fc0E99Fa5ebabb8e35DAND evt_block_time >= TIMESTAMP '2026-01-01'AND ("from" = 0x0000000000000000000000000000000000000000OR "to" = 0x0000000000000000000000000000000000000000)GROUP BY 1),filled_days AS (SELECTd.block_date,COALESCE(m.daily_amount, 0) AS daily_amountFROM (SELECT DISTINCT block_date FROM mints_burns) dLEFT JOIN mints_burns mON d.block_date = m.block_date),running_supply AS (SELECTblock_date,SUM(daily_amount) OVER (ORDER BY block_dateROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS total_supplyFROM filled_days)SELECTblock_date AS date,total_supplyFROM running_supplyORDER BY date DESC;