DATE(BLOCK_TIMESTAMP) AS "DAY",

CASE

WHEN SWAP_PROGRAM = 'raydium v4' THEN 'Raydium'

ELSE 'Other'

END AS "dist",

COUNT(DISTINCT TX_ID) AS "Swaps"

from solana.core.fact_swaps

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

GROUP BY 1, 2