case when

LOWER(symbol_in)>LOWER(symbol_out) then concat(SYMBOL_OUT,'/',SYMBOL_in) else concat(SYMBOL_in,'/',SYMBOL_OUT) end AS pair,

symbol_in,

symbol_out,

count(distinct tx_hash) as n_swaps,

count(distinct origin_from_address) as n_wallets,

sum(coalesce(amount_out_usd,0)) as swapped_amount_usd

from optimism.sushi.ez_swaps

where date(block_timestamp) >= '2022-07-01'

group by pair, symbol_in, symbol_out

order by swapped_amount_usd DESC

limit 10