select event_type,
count (distinct tx_id) as "Monthly TX Count",
"Monthly TX Count"/1440 as "Transactions Per Minute (TPM)",
"Monthly TX Count"/86400 as "Transactions Per Second (TPS)"
from flow.core.fact_events
where block_timestamp >= '2022-01-01'
and block_timestamp::date != CURRENT_DATE
group by 1
order by 2 DESC
limit 10