DISTINCT project_name as hot_projects,

sum (price_usd) as price_volume,

sum (total_fees_usd) as total_fees

from avalanche.nft.ez_nft_sales

WHERE block_timestamp >= '2024-01-01'

and platform_name = 'joepegs'

GROUP by 1

ORDER by 2 DESC

LIMIT 10