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),raydium_trades AS (SELECTDATE(block_time) AS trade_date,token_bought_mint_address,token_sold_mint_address,amount_usdFROM dex_solana.tradesWHEREproject = 'raydium'AND block_time >= NOW() - INTERVAL '6' MONTH)SELECTtrade_date AS date,SUM(CASEWHEN token_bought_mint_address IN (SELECT token_address FROM withdraws)OR token_sold_mint_address IN (SELECT token_address FROM withdraws)THEN amount_usdELSE 0END) AS pumpfun_volume,SUM(CASEWHEN token_bought_mint_address NOT IN (SELECT token_address FROM withdraws)AND token_sold_mint_address NOT IN (SELECT token_address FROM withdraws)THEN amount_usdELSE 0END) AS other_volumeFROM raydium_tradesGROUP BY trade_dateORDER BY trade_date;