WITH distinct_wallets AS (
SELECT DISTINCT swapper AS wallet
FROM solana.defi.fact_swaps_jupiter_summary
WHERE block_timestamp >= CURRENT_DATE - INTERVAL '30 DAYS'
UNION
SELECT DISTINCT dca_requester AS wallet
FROM solana.defi.fact_swaps_jupiter_summary
WHERE block_timestamp >= CURRENT_DATE - INTERVAL '30 DAYS'
UNION
SELECT DISTINCT limit_requester AS wallet
FROM solana.defi.fact_swaps_jupiter_summary
WHERE block_timestamp >= CURRENT_DATE - INTERVAL '30 DAYS'
)
SELECT
COUNT(wallet) AS total_unique_wallets_swaps_DCA_LO
FROM
distinct_wallets;