DATE(BLOCK_TIMESTAMP) AS "DAY",

SWAP_PROGRAM,

COUNT(DISTINCT TX_ID) AS "Swaps"

from solana.core.fact_swaps

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

GROUP BY 1, 2