FROM polygon.core.fact_transactions;

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

AND BLOCK_TIMESTAMP <= CURRENT_TIMESTAMP;