DATE | TOTAL_TRANSACTIONS | SUCCESSFUL_TRANSACTIONS | FAILED_TRANSACTIONS | SUCCESS_PERCENTAGE | FAILURE_PERCENTAGE | |
|---|---|---|---|---|---|---|
1 | 2024-02-24 00:00:00.000 | 4692 | 4692 | 0 | 100 | 0 |
2 | 2024-02-25 00:00:00.000 | 43207 | 43207 | 0 | 100 | 0 |
3 | 2024-02-26 00:00:00.000 | 43217 | 43217 | 0 | 100 | 0 |
4 | 2024-02-27 00:00:00.000 | 43272 | 43272 | 0 | 100 | 0 |
5 | 2024-02-28 00:00:00.000 | 43904 | 43899 | 5 | 99.99 | 0.01 |
6 | 2024-02-29 00:00:00.000 | 435613 | 394313 | 41300 | 90.52 | 9.48 |
7 | 2024-03-01 00:00:00.000 | 855464 | 771791 | 83673 | 90.22 | 9.78 |
8 | 2024-03-02 00:00:00.000 | 550450 | 516644 | 33806 | 93.86 | 6.14 |
9 | 2024-03-03 00:00:00.000 | 520551 | 485325 | 35226 | 93.23 | 6.77 |
10 | 2024-03-04 00:00:00.000 | 476026 | 448287 | 27739 | 94.17 | 5.83 |
11 | 2024-03-05 00:00:00.000 | 360079 | 344041 | 16038 | 95.55 | 4.45 |
12 | 2024-03-06 00:00:00.000 | 459008 | 441808 | 17200 | 96.25 | 3.75 |
13 | 2024-03-07 00:00:00.000 | 311896 | 303512 | 8384 | 97.31 | 2.69 |
14 | 2024-03-08 00:00:00.000 | 273933 | 269353 | 4580 | 98.33 | 1.67 |
15 | 2024-03-09 00:00:00.000 | 245980 | 241459 | 4521 | 98.16 | 1.84 |
16 | 2024-03-10 00:00:00.000 | 244213 | 239535 | 4678 | 98.08 | 1.92 |
17 | 2024-03-11 00:00:00.000 | 247957 | 243051 | 4906 | 98.02 | 1.98 |
18 | 2024-03-12 00:00:00.000 | 241528 | 235667 | 5861 | 97.57 | 2.43 |
19 | 2024-03-13 00:00:00.000 | 210601 | 205056 | 5545 | 97.37 | 2.63 |
20 | 2024-03-14 00:00:00.000 | 308097 | 293347 | 14750 | 95.21 | 4.79 |
rezarwzTxn Success %
Updated 2025-04-09
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
›
⌄
SELECT
date_trunc('day', BLOCK_TIMESTAMP) AS date,
COUNT(*) AS total_transactions,
COUNT(
CASE
WHEN STATUS = 'SUCCESS' THEN 1
END
) AS successful_transactions,
COUNT(
CASE
WHEN STATUS != 'SUCCESS' THEN 1
END
) AS failed_transactions,
ROUND(
(successful_transactions / total_transactions) * 100,
2
) AS success_percentage,
ROUND(
(failed_transactions / total_transactions) * 100,
2
) AS failure_percentage
FROM
blast.core.fact_transactions
where date_trunc('day', BLOCK_TIMESTAMP) is not null
GROUP BY
date_trunc('day', BLOCK_TIMESTAMP)
ORDER BY
date_trunc('day', BLOCK_TIMESTAMP) ASC;
Last run: 18 days ago
...
405
23KB
10s