FROM base.core.fact_transactions

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