select address_name, address

from solana.core.dim_labels

select

address , address_name as TOKEN , count(DISTINCT tx_id) as the_number_of_swaps

from solana.core.fact_swaps join Token_name

on address = swap_to_mint

where block_timestamp:: date >= current_date - 30

and swap_from_mint ='So11111111111111111111111111111111111111112'

and SWAP_TO_MINT != 'So11111111111111111111111111111111111111112'

and swap_program like 'orca'

and SUCCEEDED = true

group by 1 ,2