DATE | Daily succeed transactions | Daily failed transactions | |
|---|---|---|---|
1 | 2024-11-27 00:00:00.000 | 27648 | |
2 | 2024-11-28 00:00:00.000 | 43519 | |
3 | 2024-11-29 00:00:00.000 | 43204 | |
4 | 2024-11-30 00:00:00.000 | 43200 | |
5 | 2024-12-01 00:00:00.000 | 43201 | |
6 | 2024-12-02 00:00:00.000 | 43344 | |
7 | 2024-12-03 00:00:00.000 | 44766 | 35 |
8 | 2024-12-04 00:00:00.000 | 45295 | 3 |
9 | 2024-12-05 00:00:00.000 | 45582 | |
10 | 2024-12-06 00:00:00.000 | 45379 | 1 |
11 | 2024-12-07 00:00:00.000 | 44896 | 2 |
12 | 2024-12-08 00:00:00.000 | 44927 | |
13 | 2024-12-09 00:00:00.000 | 45408 | 1 |
14 | 2024-12-10 00:00:00.000 | 45702 | 4 |
15 | 2024-12-11 00:00:00.000 | 45551 | 41 |
16 | 2024-12-12 00:00:00.000 | 45296 | 4 |
17 | 2024-12-13 00:00:00.000 | 45355 | 3 |
18 | 2024-12-14 00:00:00.000 | 45071 | 8 |
19 | 2024-12-15 00:00:00.000 | 44897 | 5 |
20 | 2024-12-16 00:00:00.000 | 45469 | 8 |
MrftiSwell chain succeed vs failed tx copy
Updated 3 hours ago
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
›
⌄
-- forked from berachain succeed vs failed tx @ https://flipsidecrypto.xyz/studio/queries/d726c6ee-57c4-4392-84dd-5e6d86bd74a7
with tbl1 AS
(
SELECT date_trunc (day, block_timestamp) as date,
count (DISTINCT tx_hash) as "Daily succeed transactions"
FROM swell.core.fact_transactions
where TX_SUCCEEDED = 'TRUE'
group by 1
ORDER by 1
),
tbl2 AS
(
SELECT date_trunc (day, block_timestamp) as date2,
count (DISTINCT tx_hash) as "Daily failed transactions"
FROM swell.core.fact_transactions
where TX_SUCCEEDED ='FALSE'
group by 1
ORDER by 1
)
SELECT date,
"Daily succeed transactions",
"Daily failed transactions"
from tbl1 full join tbl2 on date=date2
GROUP by 1,2,3
order by 1
Last run: about 3 hours agoAuto-refreshes every 12 hours
...
110
4KB
14s