SUM(SWAP_FROM_AMOUNT_USD) AS total_volume_from,

SUM(SWAP_TO_AMOUNT_USD) AS total_volume_to

FROM

solana.defi.ez_dex_swaps

WHERE

SWAP_PROGRAM = 'pump.fun'

AND BLOCK_TIMESTAMP >= '2024-08-01'

AND BLOCK_TIMESTAMP < '2024-09-01';