Query editor
SELECTtime,UST AS "UST",three_pool AS "USDC/USDT/DAI",TRY_CAST(UST / total AS REAL) AS "UST%",TRY_CAST(three_pool / total AS REAL) AS "USDC/USDT/DAI%",0.5 AS ideal,totalFROM(SELECTtime,UST AS UST,three_pool AS three_pool,SUM(UST + three_pool) AS totalFROM(SELECTtime,SUM(UST) OVER (ORDER BYtime) AS UST,SUM(three_pool) OVER (ORDER BYtime) AS three_poolFROM(SELECTDATE_TRUNC('hour', evt_block_time) AS time,SUM((CASEWHEN contract_address = 0xa693b19d2931d498c5b318df961919bb4aee87a5 THEN value / 1e6ELSE 0END) * (CASEWHEN "to" = 0xceaf7747579696a2f0bb206a14210e3c9e6fb269 THEN 1ELSE -1END)) AS UST,SUM((CASEWHEN contract_address = 0x6c3F90f043a72FA612cbac8115EE7e52BDe6E490 THEN value / 1e18ELSE 0END) * (CASEWHEN "to" = 0xceaf7747579696a2f0bb206a14210e3c9e6fb269 THEN 1ELSE -1END)) AS three_poolFROMerc20_ethereum.evt_TransferWHERE