CryptoIcicleFlow-2.When Do Transactions Fail? - Events
Updated 2022-05-29
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
-- Payout 27.99 FLOW
-- Grand Prize 83.96 FLOW
-- Level Intermediate
-- Q2. Do times of high transaction volume lead to more transaction failures?
-- Create a visualization that shows the relationship between transaction volume and success rate of transactions since May 9th.
-- Are there any noticeable patterns to when transactions are more likely to fail?
-- Were there specific events that seem to cause transaction failures?
select
block_timestamp::date as date,
event_contract as type,
count(distinct tx_id) as n_txns
from flow.core.fact_events
where block_timestamp >= '2022-05-09' and tx_succeeded = 'FALSE'
group by type, date
Run a query to Download Data