OneDataAnalystFLOW Transactions - Minute timeframe
Updated 2022-06-04Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
WITH succeeded_txs
AS (SELECT Date_trunc('minute', block_timestamp) AS date,
Count(tx_id) / ( 1 ) AS succeed_txs
FROM flow.core.fact_events
WHERE tx_succeeded = 'true'
AND date >= '2022-05-09'
AND DATE < CURRENT_DATE
GROUP BY 1 ),
unsucceeded_txs
AS (SELECT Date_trunc('minute', block_timestamp) AS date,
Count(tx_id) / ( 1 ) AS unsucceed_txs
FROM flow.core.fact_events
WHERE tx_succeeded = 'false'
AND date >= '2022-05-09'
AND DATE < CURRENT_DATE
GROUP BY 1
)
SELECT succeeded_txs.date AS Date,
succeed_txs AS successful_tpm,
Round(( unsucceed_txs / ( successful_tpm + unsucceed_txs ) ) * 100, 2) AS unsuccessful_transaction_percent
FROM succeeded_txs
JOIN unsucceeded_txs
ON succeeded_txs.date = unsucceeded_txs.date
Run a query to Download Data