COUNT(DISTINCT BLOCK_NUMBER) AS total_block_count

FROM

aptos.core.fact_transactions;

WHERE

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