Query editor
WITHfrxETHSupplyChange AS (SELECTDATE_TRUNC('day', "evt_block_time") AS "day",SUM(CASE "from" WHEN '\x0000000000000000000000000000000000000000'THEN tr."value" / 1e18 -- mintELSE -tr."value" / 1e18 -- burnEND) AS "supplyChange"FROM erc20."ERC20_evt_Transfer" trWHEREcontract_address = '\x5E8422345238F34275888049021821E8E08CAa1f' -- frxETH tokenAND (tr."from" = '\x0000000000000000000000000000000000000000' -- mintOR tr."to" = '\x0000000000000000000000000000000000000000' -- burn)GROUP BY 1),supply AS (SELECT"day",SUM("supplyChange") over (ORDER BY "day") AS "supply"FROM frxETHSupplyChangeORDER BY 1 DESC)SELECT"day",round("supply") AS "frxETH supply"FROM supplyWHERE "day" > '2022-10-12 00:00:00'ORDER BY 1 DESC;