date_trunc('day',block_timestamp) as dt,

when swap_program='raydium v4' then 'Raydium'

when swap_program='jupiter aggregator v2' then 'Jupiter'

when swap_program='orca' then 'Orca'

end as program,

count(distinct swapper) as unq_wlt,

count(tx_id) as qntty_swaps

from solana.fact_swaps

where block_timestamp::date >= '2022-01-01'

and succeeded='TRUE'

group by 1,2 having program is not null