sum(amount_usd) as volume,

row_number() over (order by volume desc)as roww

from ethereum.core.ez_token_transfers

join ethereum.core.dim_labels on address=to_address

WHERE contract_address LIKE lower('0x6B175474E89094C44Da98b954EedeAC495271d0F')

and to_address not like '0x0000000000000000000000000000000000000000'

group by 1

having volume>0

order by 2 DESC

limit 10