COUNT(DISTINCT SWAPPER) AS unique_swappers

FROM

solana.defi.ez_dex_swaps

WHERE

SWAP_PROGRAM = 'Raydium Liquidity Pool V4'

AND BLOCK_TIMESTAMP >= '2024-08-01'

AND BLOCK_TIMESTAMP < '2024-09-01';