DATE_TRUNC('day', block_timestamp) AS day,

COUNT(tx_hash) AS total_nft_sales,

SUM(total_price_usd) AS total_volume_usd

FROM aptos.nft.ez_nft_sales

WHERE block_timestamp >= CURRENT_DATE - INTERVAL '30 days'

GROUP BY day

ORDER BY day ASC;