Query editor
WITHpump_wallets AS (SELECTtrader_id AS wallet,COUNT(*) AS trade_countFROMdex_solana.tradesWHEREproject = 'pumpdotfun'AND block_time between timestamp '2024-01-31 00:00:00' and timestamp '2025-02-13 00:00:00'GROUP BYtrader_idHAVINGCOUNT(*) >= 10),pump_tokens AS (SELECT DISTINCTCOALESCE(token_sold_mint_address, token_bought_mint_address) AS token_addressFROMdex_solana.tradesWHEREproject = 'pumpdotfun'),datasales AS (SELECTblock_time,tx_id,trader_id AS wallet,token_sold_mint_address AS token_address,CASEWHEN token_sold_symbol IS NULL THEN token_sold_mint_addressELSE token_sold_symbolEND AS asset,-token_sold_amount AS amount,amount_usd,amount_usd AS usd_volume,amount_usd / token_sold_amount AS token_price,amount_usd / NULLIF(token_sold_amount, 0) AS tp,'sell' AS actionFROMdex_solana.tradesWHEREtoken_sold_mint_address IN (SELECT token_address FROM pump_tokens)AND token_sold_mint_address NOT IN ('So11111111111111111111111111111111111111112','DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263')AND token_sold_symbol NOT IN ('WETH')AND trader_id IN (SELECT wallet FROM pump_wallets)AND block_time < timestamp '2025-02-13 00:00:00'UNION ALLSELECTblock_time,tx_id,trader_id AS wallet,token_bought_mint_address AS token_address,CASEWHEN token_bought_symbol IS NULL THEN token_bought_mint_addressELSE token_bought_symbolEND AS asset,token_bought_amount AS amount,