,sum(AMOUNT_OUT_USD) as buy_volume

,rank()over(order by buy_volume ) as rank

from ethereum.core.ez_dex_swaps

where BLOCK_TIMESTAMP>='2023-03-01' and BLOCK_TIMESTAMP<='2023-03-10'

and TOKEN_OUT='0x95ad61b0a150d79219dcf64e1e6cc01f0b64c4ce'

and PLATFORM in ('uniswap-v2','uniswap-v3')

and AMOUNT_IN_USD is not null

group by 1

order by 2 desc

limit 20