ORIGIN_FROM_ADDRESS,sum(amount_out_usd)as buy_volume,rank()over(order by buy_volume)as rank

from ethereum.core.ez_dex_swaps

where TOKEN_OUT='0xbbbbca6a901c926f240b89eacb641d8aec7aeafd'

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