Query editor
WITH-- Define key addressesAddresses AS (SELECT0x548f93779fBC992010C07467cBaf329DD5F059B7 AS bmx_token,0x0000000000000000000000000000000000000000 AS zero_address,0x000000000000000000000000000000000000dEaD AS dead_address,0x3Ff7AB26F2dfD482C40bDaDfC0e88D01BFf79713 AS obmx_vault),-- Get all relevant transfers for the BMX tokentransfers AS (SELECTevt_block_time,date_trunc('day', evt_block_time) AS block_date,"from","to",value / 1e18 AS amount -- Apply token decimalsFROM erc20_base.evt_TransferWHERE contract_address = (SELECT bmx_token FROM Addresses)),-- Calculate daily changes in supply componentsdaily_changes AS (SELECTblock_date,-- Mints: Increase supplySUM(CASE WHEN "from" = (SELECT zero_address FROM Addresses) THEN amount ELSE 0 END) AS daily_mint,-- Burns to Zero Address: Decrease supplySUM(CASE WHEN "to" = (SELECT zero_address FROM Addresses) THEN amount ELSE 0 END) AS daily_burn_zero,-- Burns to Dead Address (Buyback): Decrease supplySUM(CASE WHEN "to" = (SELECT dead_address FROM Addresses) THEN amount ELSE 0 END) AS daily_buyback_burn,-- Net change in oBMX Vault balance (Tokens entering increase balance, tokens leaving decrease it)SUM(CASEWHEN "to" = (SELECT obmx_vault FROM Addresses) THEN amount -- Transfer INWHEN "from" = (SELECT obmx_vault FROM Addresses) THEN -amount -- Transfer OUTELSE 0END) AS daily_obmx_vault_changeFROM transfersGROUP BY 1),-- Generate a complete series of dates from the first transfer date until todaydate_series AS (SELECT dt AS block_dateFROM UNNEST(SEQUENCE((SELECT MIN(CAST(block_date AS date)) FROM daily_changes),DATE_TRUNC('day', CAST( NOW() AS date) ), -- Use CURRENT_DATE for Dune SQLINTERVAL '1' DAY)) AS t(dt)),-- Calculate cumulative values over timecumulative_supply AS (SELECTd.block_date,-- Calculate running totals using window functionsSUM(COALESCE(dc.daily_mint, 0)) OVER (ORDER BY d.block_date ASC ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS total_minted,