SELECT SWAP_PROGRAM, Count(*) AS Swaps, COUNT(DISTINCT SWAPPER) AS Swappers, Count(*)/COUNT(DISTINCT SWAPPER) AS swap_per_swapper
FROM algorand.defi.fact_swap
WHERE 1=1
--AND SWAP_PROGRAM = LOWER('{{dex}}')
AND BLOCK_TIMESTAMP::DATE >= CURRENT_DATE - {{Days}} AND BLOCK_TIMESTAMP::DATE < CURRENT_DATE
GROUP BY 1