Date | Transaction Success Rate % | LAG_SUCCESS_RATE | Transaction Success Rate Change % | |
|---|---|---|---|---|
1 | 2024-12-23 00:00:00.000 | 95.01 | 90.82 | 4.61 |
2 | 2024-12-16 00:00:00.000 | 90.82 | 94.89 | -4.29 |
3 | 2024-12-09 00:00:00.000 | 94.89 | 96.54 | -1.71 |
4 | 2024-12-02 00:00:00.000 | 96.54 | 95.99 | 0.57 |
5 | 2024-11-25 00:00:00.000 | 95.99 | 96.63 | -0.66 |
6 | 2024-11-18 00:00:00.000 | 96.63 | 96.25 | 0.39 |
7 | 2024-11-11 00:00:00.000 | 96.25 | 95.6 | 0.68 |
8 | 2024-11-04 00:00:00.000 | 95.6 | 94.83 | 0.81 |
9 | 2024-10-28 00:00:00.000 | 94.83 | 95.43 | -0.63 |
10 | 2024-10-21 00:00:00.000 | 95.43 | 95.05 | 0.4 |
11 | 2024-10-14 00:00:00.000 | 95.05 | 97.12 | -2.13 |
12 | 2024-10-07 00:00:00.000 | 97.12 | 97.99 | -0.89 |
13 | 2024-09-30 00:00:00.000 | 97.99 | 98.66 | -0.68 |
14 | 2024-09-23 00:00:00.000 | 98.66 | 97.18 | 1.52 |
15 | 2024-09-16 00:00:00.000 | 97.18 | 94.71 | 2.61 |
16 | 2024-09-09 00:00:00.000 | 94.71 | 94.91 | -0.21 |
17 | 2024-09-02 00:00:00.000 | 94.91 | 64.19 | 47.86 |
18 | 2024-08-26 00:00:00.000 | 64.19 | 96.68 | -33.61 |
19 | 2024-08-19 00:00:00.000 | 96.68 | 97.27 | -0.61 |
20 | 2024-08-12 00:00:00.000 | 97.27 | 97.26 | 0.01 |
Mrftioriginal-indigo
Updated 2025-02-05
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
WITH transaction_data AS
(
SELECT
date_trunc({{period_type}}, BLOCK_TIMESTAMP) AS "Date",
COUNT(DISTINCT tx_hash) AS "Total Transactions",
COUNT(DISTINCT CASE WHEN TX_SUCCEEDED = 'TRUE' THEN tx_hash END) AS "Total Succeeded Transactions"
FROM
berachain.testnet.fact_transactions
WHERE
BLOCK_TIMESTAMP::date >= '{{start_day}}'
AND date_trunc({{period_type}}, BLOCK_TIMESTAMP) <= '{{target_day}}'
GROUP BY 1
)
SELECT
"Date",
ROUND(100 * "Total Succeeded Transactions" / NULLIF("Total Transactions", 0), 2) AS "Transaction Success Rate %",
LAG(ROUND(100 * "Total Succeeded Transactions" / NULLIF("Total Transactions", 0), 2)) OVER (ORDER BY "Date") AS lag_success_rate,
ROUND(100 * (ROUND(100 * "Total Succeeded Transactions" / NULLIF("Total Transactions", 0), 2) - lag_success_rate) / NULLIF(lag_success_rate, 0), 2) AS "Transaction Success Rate Change %"
FROM transaction_data
ORDER BY 1 DESC
Last run: about 1 month ago
30
1KB
112s