DATE_TRUNC('day', BLOCK_TIMESTAMP) AS date,

COUNT(DISTINCT BLOCK_NUMBER) AS block_count

FROM

aptos.core.fact_transactions;

WHERE

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

GROUP BY

DATE_TRUNC('day', BLOCK_TIMESTAMP)

ORDER BY

date;