LTirrell2022-01-01_solana_fails
Updated 2023-02-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
›
⌄
-- When Do Transactions Fail?
-- 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 throughout the month of December.
-- Are there any noticeable patterns to when transactions are more likely to fail?
select
date_trunc('minute', block_timestamp) as datetime,
count(
case
when succeeded = 'FALSE' then succeeded
end
) as fails,
count(
case
when succeeded = 'TRUE' then succeeded
end
) as success,
count(tx_id) as tx_count,
success / (tx_count) as success_rate
from
solana.core.fact_transactions
where
block_timestamp :: date >= '2021-12-01'
and block_timestamp :: date < '2022-01-01'
group by
datetime
order by
datetime
Run a query to Download Data