SELECT
project_name,
SUM(total_price_usd) AS SalesVolume
FROM
aptos.nft.ez_nft_sales
WHERE
block_timestamp >= current_timestamp - INTERVAL '1 month'
AND project_name IS NOT NULL
AND project_name <> ''
GROUP BY
project_name
ORDER BY
SalesVolume DESC
LIMIT
10;