project_name,

round(sum(price_usd),2) as trade_volume

from

ethereum.core.ez_nft_sales

where

price_usd > 0

and block_Timestamp >= '2022-01-01'

and block_timestamp < '2023-01-01'

and project_name is not null

group by

project_name

order by

trade_volume desc

limit

10