DATE(BLOCK_TIMESTAMP) AS "DAY",

COUNT(DISTINCT SWAPPER) AS "Swapers",

COUNT(DISTINCT TX_ID) AS "Swaps"

from solana.core.fact_swaps

where ( SWAP_PROGRAM = 'raydium v4')

and BLOCK_TIMESTAMP >= CURRENT_DATE() - interval '6 month'

GROUP BY 1