SYMBOL_OUT,sum(amount_in_usd)as buy_volume,rank()over(order by buy_volume)as rank

from ethereum.core.ez_dex_swaps

where TOKEN_IN='0x95ad61b0a150d79219dcf64e1e6cc01f0b64c4ce'

and( PLATFORM='uniswap-v2'or PLATFORM='uniswap-v3')

and BLOCK_TIMESTAMP>='2022-01-01'

and amount_out_usd is not null

group by 1

order by 2 desc

limit 10