TRANSACTION_STATUS | FAILED_TRANSACTIONS | |
|---|---|---|
1 | Failed | 332458 |
2 | Successful | 12365127 |
par_rnMantle 04
Updated 2025-03-28
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
SELECT
'Failed' AS transaction_status,
COUNT(DISTINCT TX_HASH) AS failed_transactions
FROM mantle.core.fact_transactions
WHERE TX_SUCCEEDED NOT IN ('true', TRUE)
and block_timestamp >= current_date - 30
UNION ALL
SELECT
'Successful' AS transaction_status,
COUNT(DISTINCT TX_HASH) AS successful_transactions
FROM mantle.core.fact_transactions
WHERE TX_SUCCEEDED IN ('true', TRUE)
and block_timestamp >= current_date - 30
Last run: 20 days ago
2
43B
3s