COUNT(DISTINCT FACT_TRANSACTIONS_ID)

FROM ethereum.core.fact_transactions

WHERE BLOCK_TIMESTAMP >= DATE_TRUNC('month', CURRENT_DATE) - INTERVAL '30 days';