select s.block_timestamp as fecha,

s.tx_id,

s.swapper,

s.swap_from_amount,

s.swap_from_mint,

upper(t1.symbol) as from_symbol,

s.swap_to_amount,

s.swap_to_mint,

upper(t2.symbol) as to_symbol,

s.swap_program as DEX

from solana.core.fact_swaps s

left join solana.core.dim_tokens t1

on s.swap_from_mint = t1.token_address

left join solana.core.dim_tokens t2

on s.swap_to_mint = t2.token_address

where fecha > '2022-12-20'

and (s.swap_from_mint = 'DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263') or (s.swap_to_mint = 'DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263')

and succeeded = TRUE

select from_symbol,

to_symbol,

DEX,

count(distinct tx_id),

count(distinct swapper)

from bonk_swaps

group by 1,2,3

order by 4 desc