Query editor
WITH DailyBalances AS (SELECTDATE_TRUNC('day', evt_block_time) AS day,SUM(CASE WHEN "to" = 0xcf0c122c6b73ff809c693db761e7baebe62b6a2e THEN value ELSE 0 END) - SUM(CASE WHEN "from" = 0xcf0c122c6b73ff809c693db761e7baebe62b6a2e THEN value ELSE 0 END) AS net_flowFROM floki_ethereum.FLOKI_evt_TransferWHEREcontract_address = 0xcf0c122c6b73ff809c693db761e7baebe62b6a2eGROUP BYDATE_TRUNC('day', evt_block_time)), CumulativeBalances AS (SELECTday,SUM(net_flow) OVER (ORDER BY day) AS cumulative_net_flowFROM DailyBalances)SELECTday,cumulative_net_flowFROM CumulativeBalancesORDER BYday