date_trunc ('day', block_timestamp) as DATE,

address_name AS swapped_to_token,

COUNT(tx_id) AS count_tx_id

FROM solana.core.fact_swaps a

LEFT JOIN solana.core.dim_labels b

ON a.swap_to_mint = b.address

WHERE swap_from_mint = 'So11111111111111111111111111111111111111112'

AND succeeded = 'TRUE'

AND swap_program = 'orca'

AND block_timestamp = between ('2022-01-01') - ('2022-02-01')

GROUP BY swapped_to_token

ORDER BY count_tx_id DESC

LIMIT 3