SELECT
BLOCK_TIMESTAMP::DATE AS date,
SUM(PRICE) AS total_sales,
COUNT(DISTINCT TX_ID ) AS sales_volume,
SUM(Price)/COUNT(DISTINCT TX_ID) Avg_sale_price,
COUNT(DISTINCT BUYER) unique_wallet_buyers,
COUNT(DISTINCT SELLER) unique_wallet_sellers
FROM flow.nft.ez_nft_sales
WHERE NFT_COLLECTION ='A.e3ad6030cbaff1c2.DimensionX'
AND date >'2022-09-07'
GROUP BY date
ORDER BY date DESC