EVENT_TYPE

,count(distinct TX_ID) as tx_count

,tx_count/86400 as tps

,tx_count/1440 as tpm

,tx_count/24 as tph

from flow.core.fact_events

where BLOCK_TIMESTAMP>='2022-01-01'

and BLOCK_TIMESTAMP<>current_date

group by 1

order by 4 desc

limit 10