from solana.fact_swaps

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

and swap_program = 'raydium v4'

and succeeded = 'TRUE'

group by 1

order by number_of_swaps desc

limit 10)

select f.block_timestamp::date as dt, d.address_name, count(distinct tx_id) as number_of_swaps

from solana.fact_swaps f

join solana.dim_labels d on

f.swap_from_mint = d.address

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

and f.swap_program = 'raydium v4'

and f.succeeded = 'TRUE'

and f.swap_from_mint in (select swap_from_mint from top_ten_tokens)

group by 1, 2