Query editor
WITHstaked AS (SELECTDATE_TRUNC('day', evt_block_time) AS "date",contract_address,SUM(TRY_CAST(value AS DOUBLE)) / 1e6 AS staked_amountFROM erc20_arbitrum.evt_TransferWHERE contract_address IN (0xaf88d065e77c8cc2239327c5edb3a432268e5831, -- USDC0xFd086bC7CD5C481DCC9C85ebE478A1C0b69FCbb9, -- USDT0xFF970A61A04b1cA14834A43f5dE4533eBDDB5CC8 -- USDC.e)AND "to" = 0x2df1c51e09aecf9cacb7bc98cb1742757f163df7GROUP BYDATE_TRUNC('day', evt_block_time),contract_address),redeemed AS (SELECTDATE_TRUNC('day', evt_block_time) AS "date",contract_address,SUM(TRY_CAST(value AS DOUBLE)) / 1e6 AS redeemed_amountFROM erc20_arbitrum.evt_TransferWHERE contract_address IN (0xaf88d065e77c8cc2239327c5edb3a432268e5831, -- USDC0xFd086bC7CD5C481DCC9C85ebE478A1C0b69FCbb9, -- USDT0xFF970A61A04b1cA14834A43f5dE4533eBDDB5CC8 -- USDC.e)AND "from" = 0x2df1c51e09aecf9cacb7bc98cb1742757f163df7GROUP BYDATE_TRUNC('day', evt_block_time),contract_address),combined AS (SELECTs."date",s.contract_address,(s.staked_amount - COALESCE(r.redeemed_amount, TRY_CAST(0 AS DOUBLE))) AS date_amountFROM staked sLEFT JOIN redeemed rON s."date" = r."date" AND s.contract_address = r.contract_address),cumulative_all_time AS (SELECT"date",contract_address,date_amount,SUM(date_amount) OVER (PARTITION BY contract_address ORDER BY "date") / 1e6 AS cumulative_all_time_amountFROM combined)SELECTc."date",c.contract_address,c.date_amount,SUM(c.date_amount) OVER (PARTITION BY c.contract_address ORDER BY c."date") / 1e6 AS cumulative_amount_m,SUM(c.date_amount) OVER (PARTITION BY c.contract_address ORDER BY c."date") AS cumulative_amount,