count(*) as "Total txn count"

from kaia.core.fact_transactions

where block_timestamp >= current_date - interval '30 days';