TRANSACTION_DAY | SUCCESSFUL_TRANSACTIONS | FAILED_TRANSACTIONS | |
|---|---|---|---|
1 | 2025-02-28 00:00:00.000 | 33422 | 135 |
2 | 2025-02-27 00:00:00.000 | 44714 | 105 |
3 | 2025-02-26 00:00:00.000 | 45137 | 76 |
4 | 2025-02-25 00:00:00.000 | 45542 | 108 |
5 | 2025-02-24 00:00:00.000 | 45410 | 138 |
6 | 2025-02-23 00:00:00.000 | 44374 | 46 |
7 | 2025-02-22 00:00:00.000 | 10290 | 7 |
8 | 2025-02-20 00:00:00.000 | 35166 | 273 |
9 | 2025-02-19 00:00:00.000 | 45386 | 230 |
10 | 2025-02-18 00:00:00.000 | 44616 | 118 |
11 | 2025-02-17 00:00:00.000 | 44990 | 131 |
12 | 2025-02-16 00:00:00.000 | 44747 | 54 |
13 | 2025-02-15 00:00:00.000 | 45993 | 446 |
14 | 2025-02-14 00:00:00.000 | 44408 | 110 |
15 | 2025-02-13 00:00:00.000 | 44606 | 121 |
16 | 2025-02-12 00:00:00.000 | 45107 | 192 |
17 | 2025-02-11 00:00:00.000 | 45116 | 118 |
18 | 2025-02-10 00:00:00.000 | 44733 | 110 |
19 | 2025-02-09 00:00:00.000 | 44950 | 128 |
20 | 2025-02-08 00:00:00.000 | 44375 | 77 |
HadisehSuccessful And Failed Transactions
Updated 2025-02-28
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
WITH DailyTransactionSummary AS (
SELECT
DATE_TRUNC('day', BLOCK_TIMESTAMP) AS transaction_day,
COUNT(CASE WHEN TX_SUCCEEDED = TRUE THEN 1 END) AS successful_transactions,
COUNT(CASE WHEN TX_SUCCEEDED = FALSE THEN 1 END) AS failed_transactions
FROM boba.core.fact_transactions
WHERE BLOCK_TIMESTAMP >= '2025-01-01'
GROUP BY transaction_day
)
SELECT
transaction_day,
successful_transactions,
failed_transactions
FROM DailyTransactionSummary
ORDER BY transaction_day DESC;
Last run: 20 days ago
58
2KB
1s