DATE_TRUNC('day', BLOCK_TIMESTAMP) AS date,

COUNT(DISTINCT BUYER_ADDRESS) AS unique_buyers,

COUNT(DISTINCT SELLER_ADDRESS) AS unique_sellers

FROM

polygon.nft.ez_nft_sales;

WHERE

BLOCK_TIMESTAMP >= DATEADD(day, -30, CURRENT_TIMESTAMP)

GROUP BY

DATE_TRUNC('day', BLOCK_TIMESTAMP)

ORDER BY

DATE_TRUNC('day', BLOCK_TIMESTAMP);