Query editor
WITH deposits_hourly AS (SELECTDATE_TRUNC('hour', evt_block_time) AS hour,SUM(value) AS depositsFROM query_6236671GROUP BY 1),redeems_hourly AS (SELECTDATE_TRUNC('hour', evt_block_time) AS hour,SUM(value) AS redeemsFROM query_6236685GROUP BY 1),hours AS (SELECT "timestamp" AS hourFROM utils.hoursWHERE "timestamp" >= TIMESTAMP '2025-11-06 13:00:00'AND "timestamp" <= TIMESTAMP '2025-11-08 02:00:00')SELECTh.hour as time,COALESCE(d.deposits, 0) AS deposits,-COALESCE(r.redeems, 0) AS redeems,SUM(COALESCE(d.deposits, 0) - COALESCE(r.redeems, 0))OVER (ORDER BY h.hour) AS cumulative_amountFROM hours hLEFT JOIN deposits_hourly d ON h.hour = d.hourLEFT JOIN redeems_hourly r ON h.hour = r.hourORDER BY h.hour DESC;