TRANSACTION_STATUS | TOTAL_TRANSACTIONS | |
---|---|---|
1 | 0 | |
2 | Failed | 22168 |
3 | Successful | 14282377 |
par_rnBOBA 04
Updated 2025-03-03
99
1
2
3
4
5
6
7
8
9
10
›
⌄
SELECT
CASE
WHEN TX_SUCCEEDED = TRUE THEN 'Successful'
WHEN TX_SUCCEEDED = FALSE THEN 'Failed'
END AS transaction_status,
COUNT(DISTINCT TX_HASH) AS total_transactions
FROM boba.core.fact_transactions
WHERE BLOCK_TIMESTAMP >= '2024-01-01'
GROUP BY transaction_status
Last run: 16 days ago
3
51B
2s