Query editor
WITH latest_month AS (SELECTDATE_TRUNC('month', MAX(block_time)) AS latest_monthFROM dex_solana.tradesWHEREproject = 'raydium'), withdraws AS (SELECT DISTINCTaccount_arguments[3] AS token_addressFROM solana.instruction_callsWHEREexecuting_account = '6EF8rrecthR5Dkzon8Nwu78hRvfCKubJ14M5uBEwF6P'AND BYTEARRAY_SUBSTRING(data, 1, 8) = 0xb712469c946da122 /* global:withdraw sha256 first 8 byte */AND tx_success = TRUE), token_volumes AS (SELECTDATE_TRUNC('month', t.block_time) AS trade_month,CASEWHEN t.token_bought_mint_address IN (SELECTtoken_addressFROM withdraws)THEN t.token_bought_mint_addressWHEN t.token_sold_mint_address IN (SELECTtoken_addressFROM withdraws)THEN t.token_sold_mint_addressEND AS token_address,SUM(t.amount_usd) AS token_volumeFROM dex_solana.trades AS tWHEREt.project = 'raydium'AND t.block_time BETWEEN TRY_CAST('2024-01-01' AS TIMESTAMP) AND TRY_CAST('2025-01-31' AS TIMESTAMP)AND (t.token_bought_mint_address IN (SELECTtoken_addressFROM withdraws)OR t.token_sold_mint_address IN (SELECTtoken_addressFROM withdraws))GROUP BY1,2)SELECTtrade_month,token_address,token_volume,SUM(token_volume) OVER (PARTITION BY trade_month ORDER BY token_volume) AS cumulative_volumeFROM token_volumesWHERENOT token_address IS NULL