SELECT
swap_program,
TO_CHAR(COUNT(DISTINCT swapper), '999,999,999') AS total_unique_swappers_past_30days
FROM
solana.defi.fact_swaps
WHERE
block_timestamp >= CURRENT_DATE - INTERVAL '30 DAYS'
GROUP BY
swap_program
ORDER BY
COUNT(DISTINCT swapper) DESC;