Query editor
WITH 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),combined_volumes AS (SELECTDATE_TRUNC('day', t.block_time) as trade_date,SUM(CASEWHEN (t.project = 'raydium' AND (t.token_bought_mint_address IN (SELECT token_address FROM withdraws)OR t.token_sold_mint_address IN (SELECT token_address FROM withdraws)))THEN t.amount_usdELSE 0END) as pumpfun_tokens_totalvolume,SUM(CASEWHEN t.project = 'raydium'THEN t.amount_usdELSE 0END) as raydium_totalvolumeFROM dex_solana.trades tWHERE t.block_time >= CURRENT_DATE - INTERVAL '7' DAYGROUP BY DATE_TRUNC('day', t.block_time))SELECTtrade_date,pumpfun_tokens_totalvolume,raydium_totalvolumeFROM combined_volumesORDER BY trade_date DESC