Query editor
with d as (selectDATE_TRUNC('day', "evt_block_time") as "day",SUM(case "from"when '\x0000000000000000000000000000000000000000' then"value" / 1e18else-"value" / 1e18end) as "totalDebtChange"from liquity."LUSD_evt_Transfer"where"from" = '\x0000000000000000000000000000000000000000' or"to" = '\x0000000000000000000000000000000000000000'group by 1order by 1),c as (selectDATE_TRUNC('day', "block_time") as "day",SUM(casewhen "to" = '\xdf9eb223bafbe5c5271415c75aecd68c21fe3d7f' then"value" / 1e18else-"value" / 1e18end) as "totalCollateralChange"from ethereum."traces"where "success" and ("from" = '\xdf9eb223bafbe5c5271415c75aecd68c21fe3d7f' or"to" = '\xdf9eb223bafbe5c5271415c75aecd68c21fe3d7f')group by 1order by 1),p as (select DATE_TRUNC('day', "minute") as "day", AVG("price") as "priceETH"from prices."layer1_usd_eth"group by 1order by 1),t as (selectCOALESCE(d."day", c."day") as "day",SUM(d."totalDebtChange") over (order by d."day") as "totalDebt",SUM(c."totalCollateralChange") over (order by c."day") as "totalCollateral","priceETH"from