select distinct signer

from solana.core.ez_signers

where first_tx_date >= '2023-01-01'

and first_tx_date < '2024-01-01'

and num_txs > 100

select

case

when s.swap_program ilike'%jupiter%' then 'jupiter'

when s.swap_program ilike'%orca%' then 'orca'

when s.swap_program ilike'%raydium%' then 'raydium'

when s.swap_program ilike'%saber%' then 'saber'

else s.swap_program

end as dex,

count(distinct s.swapper) as users

from solana.defi.fact_swaps s

inner join acquired_users a on s.swapper = a.signer

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

and block_timestamp::date < '2024-01-01'

group by 1

order by 2 desc

limit 5