Query editor
SELECTprojecttoken_bought_symbol,token_bought_mint_address,COUNT (*) AS trade_count,SUM(amount_usd) AS total_volume_usdFROM dex_solana.tradesWHERE block_time >= CURRENT_DATE - INTERVAL '7' DAYAND project = 'pumpswap'AND token_bought_symbol NOT IN ('SOL')GROUP BY project, token_bought_symbol, token_bought_mint_addressORDER BY total_volume_usdLIMIT 10