HadisehFLOW Speed (redux) 4
Updated 2022-12-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
with tb1 as (select date(block_timestamp) as date,
EVENT_TYPE,
count(DISTINCT tx_id) as total_transaction,
total_transaction/86400 as per_second,
total_transaction/1440 as per_minute,
total_transaction/24 as per_hour
from flow.core.fact_events
where block_timestamp::date >= '2022-01-01'
and TX_SUCCEEDED = 'TRUE'
group by date,event_type)
select event_type,
avg(total_transaction) as average_transaction,
avg(per_second) as average_per_second,
avg(per_minute) as average_per_minute,
avg(per_hour) as average_per_hour
from tb1
group by event_type
order by average_transaction desc
limit 10
Run a query to Download Data