select date_trunc (month,block_timestamp) as date,
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,2
having "Monthly TX Count" > 10