SELECT
DISTINCT
project_name,
nft_address,
SUM(price_usd) AS total_nft_volume,
COUNT(DISTINCT tx_hash) AS total_nft_sale,
COUNT(DISTINCT seller_address) AS total_nft_seller,
COUNT(DISTINCT buyer_address) AS total_nft_buyer,
FROM
base.nft.ez_nft_sales
WHERE
block_timestamp > current_timestamp - interval '30 day'
GROUP
BY
1, 2
ORDER
BY
total_nft_volume
DESC
LIMIT
10