Query editor
SELECTDATE_TRUNC('day', evt_block_time) AS date,SUM(CASEWHEN "from" = 0x2Df1c51E09aECF9cacB7bc98cB1742757f163dF7THEN -(value / 1e6)ELSE value / 1e6END) AS amount,SUM(SUM(CASEWHEN "from" = 0x2Df1c51E09aECF9cacB7bc98cB1742757f163dF7THEN -(value / 1e6)ELSE value / 1e6END)) OVER (ORDER BY DATE_TRUNC('day', evt_block_time)) AS cumulative_amountFROM erc20_arbitrum.evt_transferWHEREcontract_address = 0xaf88d065e77c8cC2239327C5EDb3A432268e5831AND ("from" = 0x2Df1c51E09aECF9cacB7bc98cB1742757f163dF7OR "to" = 0x2Df1c51E09aECF9cacB7bc98cB1742757f163dF7)AND evt_block_time >= CAST('2024-11-01' /* Added condition to start from September 2024 */ AS TIMESTAMP)GROUP BY1ORDER BY1 DESC