DATE | CHAIN | SUCCESS_RATE | |
|---|---|---|---|
1 | 2025-03-18 00:00:00.000 | Avalanche | 89.7142 |
2 | 2025-03-09 00:00:00.000 | Ethereum | 98.2562 |
3 | 2025-03-19 00:00:00.000 | Avalanche | 87.5513 |
4 | 2025-02-26 00:00:00.000 | Ethereum | 98.4437 |
5 | 2025-03-17 00:00:00.000 | Sei | 97.7543 |
6 | 2025-03-07 00:00:00.000 | Solana | 56.4797 |
7 | 2025-03-25 00:00:00.000 | Near | 99.6339 |
8 | 2025-03-11 00:00:00.000 | Sei | 97.1341 |
9 | 2025-03-24 00:00:00.000 | Polygon | 92.0248 |
10 | 2025-03-17 00:00:00.000 | Atom | 95.4851 |
11 | 2025-03-12 00:00:00.000 | Optimism | 92.5613 |
12 | 2025-03-08 00:00:00.000 | Ethereum | 98.2242 |
13 | 2025-02-27 00:00:00.000 | Ethereum | 98.432 |
14 | 2025-03-24 00:00:00.000 | Optimism | 97.0145 |
15 | 2025-03-13 00:00:00.000 | Avalanche | 87.2965 |
16 | 2025-03-01 00:00:00.000 | Optimism | 95.0909 |
17 | 2025-03-12 00:00:00.000 | Flow | 89.2129 |
18 | 2025-03-26 00:00:00.000 | Near | 98.8334 |
19 | 2025-03-23 00:00:00.000 | Sei | 98.9187 |
20 | 2025-02-27 00:00:00.000 | Near | 99.9994 |
0xHaM-dAverage Daily Success Rate
Updated 2025-03-27
999
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- forked from https://flipsidecrypto.xyz/hess/q/KxzDIIGvccRt/average-daily-success-rate
with
chains as (
select date(block_timestamp) as date,
'Aptos' as chain,
case when SUCCESS = 'true' then 'SUCCESS' else 'FAIL' end as status,
count(DISTINCT TX_HASH) as total_tx,
total_tx/86400 as tps
from aptos.core.fact_transactions
where block_timestamp::date >= '2025-03-01'
group by 1,2,3
UNION
select date(block_timestamp) as date,
'Sei' as chain,
case when TX_SUCCEEDED = 'true' then 'SUCCESS' else 'FAIL' end as status,
count(DISTINCT tx_id) as total_tx,
total_tx/86400 as tps
from sei.core.fact_transactions
where block_timestamp::date >= '2025-03-01'
group by 1,2,3
UNION
select date(block_timestamp) as date,
'Arbitrum' as chain,
status,
count(DISTINCT tx_hash) as total_tx,
total_tx/86400 as tps
from arbitrum.core.fact_transactions
where block_timestamp::date >= '2025-03-01'
group by 1,2,3
UNION
select date(block_timestamp) as date,
'Optimism' as chain,
status,
count(DISTINCT tx_hash) as total_tx,
total_tx/86400 as tps
from optimism.core.fact_transactions
Last run: 2 months ago
...
434
19KB
926s