Query editor
with"dataAddresses" (contract, symbol) AS (VALUES(0x3Ff7AB26F2dfD482C40bDaDfC0e88D01BFf79713, 'oBMX-Vault'),(0x000000000000000000000000000000000000dEaD, 'Burn-Address')),bmx_price AS (SELECTdate_trunc('day', evt_block_time) AS day, token, AVG(price / 1e18) AS priceFROM aerodrome_base.PriceFetcher_evt_PriceFetchedWHERE token = 0x548f93779fBC992010C07467cBaf329DD5F059B7GROUP BY 1, 2),supply AS (SELECTSUM(CASE WHEN "from" = 0x0000000000000000000000000000000000000000 THEN (value/1e18) END) AS totalValue, 'mint' AS typeFROM erc20_base.evt_transferWHERE contract_address = 0x548f93779fBC992010C07467cBaf329DD5F059B7AND ("from" = 0x0000000000000000000000000000000000000000 OR "to" = 0x0000000000000000000000000000000000000000)UNION ALLSELECTSUM(CASE WHEN "to" = 0x0000000000000000000000000000000000000000 THEN (value/1e18) END) AS totalValue, 'burn' AS typeFROM erc20_base.evt_transferWHERE contract_address = 0x548f93779fBC992010C07467cBaf329DD5F059B7AND ("from" = 0x0000000000000000000000000000000000000000 OR "to" = 0x0000000000000000000000000000000000000000)UNION ALLSELECTSUM(CASE WHEN "to" = 0x000000000000000000000000000000000000dEaD THEN (value/1e18) END) AS totalValue, 'buyback' AS typeFROM erc20_base.evt_transferWHERE contract_address = 0x548f93779fBC992010C07467cBaf329DD5F059B7AND "to" = 0x000000000000000000000000000000000000dEaD),supply_flow AS (SELECTSUM(CASE WHEN type = 'mint' THEN totalValue ELSE 0 END) AS bmx_minted, SUM(CASE WHEN type = 'burn' THEN (-1)*totalValue ELSE 0 END) AS bmx_burned, SUM(CASE WHEN type = 'buyback' THEN (-1)*totalValue ELSE 0 END) AS bmx_buybackFROM supply),oBMX_balance AS (SELECT-balance AS oBMXFROM tokens_base.balancesWHERE blockchain = 'base' AND token_address = 0x548f93779fBC992010C07467cBaf329DD5F059B7AND address = 0x3Ff7AB26F2dfD482C40bDaDfC0e88D01BFf79713 --oBMX Vault, burned on April 11th 2025ORDER BY block_time DESCLIMIT 1),bmx_supply AS (SELECTbmx_minted, oBMX, bmx_buyback, bmx_burned