platform_name,

DATE_TRUNC('day', block_timestamp) AS SaleDate,

SUM(total_price_usd) AS TotalSalesVolume,

COUNT(DISTINCT ez_nft_sales_id) AS DailySales,

COUNT(DISTINCT buyer_address) AS UniqueBuyers,

COUNT(DISTINCT seller_address) AS UniqueSellers

aptos.nft.ez_nft_sales

block_timestamp >= current_timestamp - INTERVAL '1 month'

GROUP BY

platform_name,

DATE_TRUNC('day', block_timestamp)

ORDER BY

SaleDate DESC,

platform_name;