concat(symbol_in, '→', symbol_out) as pairs,

sum(AMOUNT_IN_USD) as "Sell Volume"

from ethereum.core.ez_dex_swaps

where BLOCK_TIMESTAMP between '2023-01-01' and '2023-01-16'

and EVENT_NAME = 'Swap'

and SYMBOL_IN in ('WETH', 'ETH')

and symbol_in is not null and symbol_out is not NULL

and AMOUNT_IN_USD > 0

group by 1

order by 2 desc