count(TX_HASH) as n_txs

from polygon.core.fact_transactions

where BLOCK_TIMESTAMP >= current_date() - 30