Select count (tx_id) number_of_swaps, count(distinct swapper) as number_of_unique_wallets, date_trunc('day', block_timestamp) as day,
case
WHEN swap_program like ('%raydium%') then 'Raydium'
WHEN swap_program like ('%jupiter%') then 'Jupiter'
WHEN swap_program like ('%orca%') then 'Orca'
end as DEX
FROM solana.fact_swaps
WHERE block_timestamp >= '2022-01-01' AND DEX is not null AND SUCCEEDED = 'TRUE'
Group by 4, 3