MONTH_NAME | TRANSACTION_SUCCESS_RATE | TRANSACTION_FAILURE_RATE | |
|---|---|---|---|
1 | Janth 2025 | 98.2627 | 1.7373 |
2 | Febth 2025 | 97.4823 | 2.5177 |
3 | Marth 2025 | 97.5501 | 2.4499 |
4 | Aprth 2025 | 96.5061 | 3.4939 |
5 | Mayth 2025 | 96.0732 | 3.9268 |
Echo5577hidden-aqua
Updated 2025-05-12
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
›
⌄
WITH success_rate AS (
SELECT
DATE_TRUNC('month', BLOCK_TIMESTAMP_HOUR) AS month_block_time,
TO_CHAR(DATE_TRUNC('month', BLOCK_TIMESTAMP_HOUR), 'Month YYYY') AS month_name,
CASE
WHEN SUM(TRANSACTION_COUNT) > 0 THEN
(SUM(TRANSACTION_COUNT_SUCCESS) / SUM(TRANSACTION_COUNT)) * 100
ELSE 0
END AS transaction_success_rate
FROM
aptos.stats.ez_core_metrics_hourly
WHERE
YEAR(BLOCK_TIMESTAMP_HOUR) = YEAR(CURRENT_DATE())
AND MONTH(BLOCK_TIMESTAMP_HOUR) <= 9 -- Filter for months up to September
GROUP BY
DATE_TRUNC('month', BLOCK_TIMESTAMP_HOUR) -- Group by the same expression used in the SELECT
),
failure_rate AS (
SELECT
DATE_TRUNC('month', BLOCK_TIMESTAMP_HOUR) AS month_block_time,
TO_CHAR(DATE_TRUNC('month', BLOCK_TIMESTAMP_HOUR), 'Month YYYY') AS month_name,
CASE
WHEN SUM(TRANSACTION_COUNT) > 0 THEN
(SUM(TRANSACTION_COUNT_FAILED) / SUM(TRANSACTION_COUNT)) * 100
ELSE 0
END AS transaction_failure_rate
FROM
aptos.stats.ez_core_metrics_hourly
WHERE
YEAR(BLOCK_TIMESTAMP_HOUR) = YEAR(CURRENT_DATE())
AND MONTH(BLOCK_TIMESTAMP_HOUR) <= 9 -- Filter for months up to September
GROUP BY
DATE_TRUNC('month', BLOCK_TIMESTAMP_HOUR) -- Group by the same expression used in the SELECT
)
Last run: 20 days ago
5
151B
4s