LTirrell2022-01-01_solana_2
Updated 2022-01-19
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
30
31
32
›
⌄
-- 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(distinct tx_id)
-- -- where succeeded='FALSE'
-- limit 10
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
from
solana.transactions
where
block_timestamp :: date >= '2021-12-01'
and block_timestamp :: date < '2022-01-01'
group by
datetime
Run a query to Download Data