SELECT

project_name,

COUNT(DISTINCT tx_hash) AS total_transactions,

SUM(price_usd) AS total_volume_usd

FROM arbitrum.nft.ez_nft_sales

WHERE block_timestamp >= CURRENT_TIMESTAMP - INTERVAL '30 day'

GROUP BY project_name

SELECT

project_name AS "Collection Name",

total_transactions AS "Total Transactions",

total_volume_usd AS "Total Volume (USD)"

FROM collection_trading_activity

ORDER BY total_volume_usd DESC

LIMIT 10;