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.core.ez_nft_sales
WHERE NFT_COLLECTION ='A.ca63ce22f0d6bdba.Cryptoys'
GROUP BY date
ORDER BY date DESC