SWAPPER,

SWAP_TO_SYMBOL,

SUM(SWAP_TO_AMOUNT_USD) AS Total_volume

FROM

solana.defi.ez_dex_swaps

WHERE

SWAP_PROGRAM = 'pump.fun'

AND SWAP_TO_SYMBOL IS NOT NULL

AND BLOCK_TIMESTAMP >= '2024-08-01'

AND BLOCK_TIMESTAMP < '2024-09-01'

GROUP BY

SWAPPER,

SWAP_TO_SYMBOL

ORDER BY

Total_volume DESC

LIMIT 10;