SELECT
project_name
, SUM(price_usd) AS Volume
, SUM(total_fees_usd) AS Fees
, SUM(platform_fee_usd) AS Platform_Fees
, SUM(creator_fee_usd) AS Creator_Fees
, SUM(tx_fee_usd) AS Transaction_fees
FROM
base.nft.ez_nft_sales
WHERE 1=1
AND block_timestamp >= CURRENT_DATE - INTERVAL '30 days'
GROUP BY
1
ORDER BY
Volume DESC
LIMIT
20