Query editor
WITH pump_graduates AS (SELECTtoken_bought_mint_address AS token_mint,MIN(block_time) AS launch_date,MAX(amount_usd) AS peak_single_trade_usdFROM dex_solana.tradesWHERE block_time >= CURRENT_TIMESTAMP - INTERVAL '30' DAYAND project = 'raydium'-- Cryptographically targets only verified Pump.fun smart contract mint patternsAND token_bought_mint_address LIKE '%pump'GROUP BY token_bought_mint_address)SELECTtoken_mint,launch_date,peak_single_trade_usdFROM pump_graduatesWHERE launch_date >= CURRENT_TIMESTAMP - INTERVAL '30' DAYAND peak_single_trade_usd >= 15000ORDER BY launch_date DESCLIMIT 200