DATE_TRUNC('day', BLOCK_TIMESTAMP) AS sale_day,

COUNT(*) AS total_nfts_sold

FROM

polygon.nft.ez_nft_sales;

WHERE

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

AND BLOCK_TIMESTAMP < CURRENT_TIMESTAMP()

GROUP BY

sale_day

ORDER BY

sale_day;