TRANSACTION_STATUS | TOTAL_TRANSACTIONS | |
---|---|---|
1 | Successful | 3089007 |
2 | Failed | 3333 |
par_rnSwell 05
Updated 2025-02-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
WITH transaction_status AS (
SELECT
COUNT(DISTINCT CASE WHEN TX_SUCCEEDED = TRUE THEN TX_HASH END) AS successful_transactions,
COUNT(DISTINCT CASE WHEN TX_SUCCEEDED = FALSE THEN TX_HASH END) AS failed_transactions
FROM swell.core.fact_transactions
)
SELECT
'Successful' AS transaction_status, successful_transactions AS total_transactions
FROM transaction_status
UNION ALL
SELECT
'Failed' AS transaction_status, failed_transactions AS total_transactions
FROM transaction_status
Last run: 24 days ago
2
40B
1s