select

concat(SYMBOL_IN, '-->', SYMBOL_OUT) as SwapPairs,

sum(AMOUNT_IN_USD) as VolumeUSD

from optimism.velodrome.ez_swaps

where BLOCK_TIMESTAMP >= CURRENT_DATE - 17

group by 1

)

select Top 10 SwapPairs,

VolumeUSD

from tab1

where VolumeUSD is not null

order by VolumeUSD desc