SELECT
date(block_timestamp) as day,
COUNT(DISTINCT nft_id) as no_of_sales,
round(sum(price),2) as total_sales_volume,
round(avg(price),2) as average_sales_volume,
COUNT(DISTINCT buyer) as no_of_buyers,
count(distinct seller) as no_of_sellers
FROM flow.core.ez_nft_sales
where tx_succeeded = true
GROUP BY day
order by day desc