DATE | TRANSACTIONS | SUCCESS_RATE | |
|---|---|---|---|
1 | 2025-03-28 00:00:00.000 | 690 | 0 |
2 | 2025-03-29 00:00:00.000 | 2469 | 61.5634 |
3 | 2025-03-30 00:00:00.000 | 3333 | 99.7 |
4 | 2025-03-31 00:00:00.000 | 1426 | 99.5792 |
5 | 2025-04-01 00:00:00.000 | 1948 | 98.768 |
6 | 2025-04-02 00:00:00.000 | 2629 | 97.2233 |
7 | 2025-04-03 00:00:00.000 | 3337 | 97.4228 |
8 | 2025-04-04 00:00:00.000 | 5224 | 97.7412 |
9 | 2025-04-05 00:00:00.000 | 4563 | 97.918 |
10 | 2025-04-06 00:00:00.000 | 4532 | 98.2789 |
11 | 2025-04-07 00:00:00.000 | 4578 | 98.0341 |
12 | 2025-04-08 00:00:00.000 | 12179 | 97.3397 |
13 | 2025-04-09 00:00:00.000 | 13364 | 96.8797 |
14 | 2025-04-10 00:00:00.000 | 11792 | 97.6425 |
15 | 2025-04-11 00:00:00.000 | 10470 | 97.9465 |
16 | 2025-04-12 00:00:00.000 | 11800 | 97.822 |
17 | 2025-04-13 00:00:00.000 | 9354 | 98.7706 |
18 | 2025-04-14 00:00:00.000 | 12122 | 98.6306 |
19 | 2025-04-15 00:00:00.000 | 12300 | 98.0325 |
20 | 2025-04-16 00:00:00.000 | 14478 | 97.9417 |
Afonso_DiazSuccess Rate Overtime
Updated 4 days ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
›
⌄
with
main as (
select
tx_hash,
block_timestamp,
from_address as user,
tx_fee,
tx_succeeded
from
mezo.testnet.fact_transactions
)
select
date_trunc('day', block_timestamp) as date,
count(distinct tx_hash) as transactions,
(count(distinct iff(tx_succeeded, tx_hash, null)) / transactions) * 100 as success_rate
from
main
group by 1
order by 1
Last run: 4 days ago
35
1KB
1s