Query editor
WITHc AS (SELECTDATE_TRUNC('hour', evt_block_time) AS hour,SUM(CASE "from"WHEN 0x0000000000000000000000000000000000000000 THEN value / 1e18ELSE -(value/1e18)END) AS lusdSupplyChangeFROMliquity_ethereum.LUSD_evt_TransferWHERE"from" = 0x0000000000000000000000000000000000000000OR to = 0x0000000000000000000000000000000000000000GROUP BY1)SELECThour,SUM(lusdSupplyChange) OVER (ORDER BYhour) AS lusdSupplyFROMcORDER BY1/* v1 codewith c as (selectDATE_TRUNC('hour', "evt_block_time") as "hour",SUM(case "from"when '\x0000000000000000000000000000000000000000' then"value" / 1e18else-"value" / 1e18end) as "lusdSupplyChange"from liquity."LUSD_evt_Transfer"where"from" = '\x0000000000000000000000000000000000000000' or"to" = '\x0000000000000000000000000000000000000000'group by 1)select"hour",SUM("lusdSupplyChange") over (order by "hour") as "lusdSupply"from corder by 1;*/