DATE_TRUNC('day', BLOCK_TIMESTAMP) AS transaction_date,

PLATFORM_NAME,

COUNT(*) AS transaction_count

FROM

aptos.nft.ez_nft_sales;

WHERE

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

GROUP BY

transaction_date, PLATFORM_NAME

ORDER BY

transaction_date, PLATFORM_NAME;