select
case when
LOWER(SYMBOL_in)>LOWER(SYMBOL_OUT)
then concat(SYMBOL_OUT,' => ',SYMBOL_in)
else
concat(SYMBOL_in,' => ',SYMBOL_OUT)
end AS path ,
count(DISTINCT tx_hash ) as txs,
count(DISTINCT origin_from_address) as users,
sum(amount_in_usd) as usd_volume
from base.defi.ez_dex_swaps
group by 1
having usd_volume is not null
order by 4 desc