project_name ,

sum(PRICE_USD) as "volume of sold usd"

FROM ethereum.core.ez_nft_sales

WHERE block_timestamp::date >= current_date - 30

AND project_name IS NOT NULL

GROUP BY 1

ORDER BY "volume of sold usd" DESC