h4wkTx per min Flow
Updated 2022-06-04
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
-- Q4. One of Flow's main features is its speed compared to other blockchains.
-- Blockchain performance can be measured as Transactions per minute.
-- Measure the transactions per minute of Flow since May 9th
-- and 'Successful transactions per minute'
-- and create a chart showing how that metric has fluctuated during that time period.
-- What types of events have raised or decreased the blockchain's performance over that time period?
-- Are there bursts of transaction volume or interest on the chain?
-- Compare Flow's speed to at least two other blockchains.
select date_trunc(day, block_timestamp) as date,
count(distinct proposer) as unique_user,
count(*)/1440 as tx_per_min,
case when tx_succeeded = True then 'Success'
else 'Fail' end as type
from flow.core.fact_transactions
where block_timestamp::date < CURRENT_DATE and block_timestamp::date >= '2022-05-09'
group by date, type
Run a query to Download Data