pool_name,

count(distinct tx_hash) as Swaps,

count(distinct origin_from_address) as Swappers,

sum(case when AMOUNT_OUT_USD is null then AMOUNT_IN_USD else AMOUNT_OUT_USD end) as Swap_Volume_USD

from base.defi.ez_dex_swaps

where (token_in ILIKE '0x04D5ddf5f3a8939889F11E97f8c4BB48317F1938' or Token_out ILIKE '0x04D5ddf5f3a8939889F11E97f8c4BB48317F1938')

group by 1

order by 3 desc