TRANSACTION_DATE | TOTAL_TRANSACTIONS | SUCCESSFUL_TRANSACTIONS | FAILED_TRANSACTIONS | SUCCESS_RATE_PERCENTAGE | |
|---|---|---|---|---|---|
1 | 2025-02-20 00:00:00.000 | 43059141 | 42938498 | 120643 | 99.7198 |
moonshot21Today Transaction Success Rate
Updated 2025-02-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
SELECT
DATE(BLOCK_TIMESTAMP_HOUR) AS transaction_date,
SUM(TRANSACTION_COUNT) AS total_transactions,
SUM(TRANSACTION_COUNT_SUCCESS) AS successful_transactions,
SUM(TRANSACTION_COUNT_FAILED) AS failed_transactions,
CASE
WHEN SUM(TRANSACTION_COUNT) > 0 THEN
SUM(TRANSACTION_COUNT_SUCCESS) / SUM(TRANSACTION_COUNT) * 100
ELSE
0
END AS success_rate_percentage
FROM
eclipse.stats.ez_core_metrics_hourly
WHERE
DATE(BLOCK_TIMESTAMP_HOUR) = CURRENT_DATE()
GROUP BY
DATE(BLOCK_TIMESTAMP_HOUR);
Last run: 11 days ago
1
62B
1s