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 (SELECTtoken_addressFROM withdraws)OR t.token_sold_mint_address IN (SELECTtoken_addressFROM withdraws)))THEN t.amount_usdELSE 0END) AS pumpfun_tokens_totalvolume,SUM(CASE WHEN t.project = 'raydium' THEN t.amount_usd ELSE 0 END) AS raydium_totalvolumeFROM dex_solana.trades AS tWHEREt.block_time BETWEEN CAST('2024-05-15' AS TIMESTAMP) AND CAST('2025-02-24' AS TIMESTAMP)GROUP BYDATE_TRUNC('day', t.block_time))SELECTtrade_date,pumpfun_tokens_totalvolume AS "PF Volume",raydium_totalvolume AS "Ray Volume"FROM combined_volumesORDER BYtrade_date DESC