piperGnosis: Transactions Success Rate
Updated 2022-07-27
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
33
34
35
36
›
⌄
⌄
/*
Twitter: @der_piper
Discrod: piper#6707
Gnosis - Some Numbers and Charts
*/
WITH successful_tx AS (
SELECT
block_timestamp::date AS date,
count(tx_hash) AS success
FROM
gnosis.core.fact_transactions
WHERE
status = 'SUCCESS'
GROUP BY date
),
failed_tx AS (
SELECT
block_timestamp::date AS date,
count(tx_hash) AS failed
FROM
gnosis.core.fact_transactions
WHERE
status != 'SUCCESS'
GROUP BY date
),
all_tx AS (
SELECT
a.date,
a.success,
b.failed
FROM
successful_tx a
Run a query to Download Data