COUNT(*) AS total_transactions

kaia.core.fact_transactions

block_timestamp >= CURRENT_DATE - INTERVAL '30 days';