Query editor
WITH trades_in_window AS (SELECTtoken_bought_mint_address AS token_mint,amount_usd,token_bought_amount,block_timeFROM dex_solana.tradesWHERE block_time >= CURRENT_TIMESTAMP - INTERVAL '30' DAYAND token_bought_mint_address LIKE '%pump'AND token_bought_amount > 0AND amount_usd > 0AND token_bought_amount > 0.001),token_stats AS (SELECTtoken_mint,MIN(block_time) as launch_date,MAX(amount_usd / token_bought_amount) * 1000000000 AS peak_market_cap_usdFROM trades_in_windowGROUP BY token_mint)SELECTtoken_mint AS token_mint_address,launch_date,peak_market_cap_usdFROM token_statsWHERE peak_market_cap_usd >= 1000000AND launch_date > CURRENT_TIMESTAMP - INTERVAL '29' DAYORDER BY peak_market_cap_usd DESCLIMIT 200