DATE | CHAIN | SUCCESS_RATE | |
|---|---|---|---|
1 | 2023-11-01 00:00:00.000 | BSC | 94.589015113 |
2 | 2023-11-01 00:00:00.000 | Osmosis | 67.908114216 |
3 | 2023-11-01 00:00:00.000 | Near | 96.161324207 |
4 | 2023-11-01 00:00:00.000 | Arbitrum | 94.621673561 |
5 | 2023-11-01 00:00:00.000 | Atom | 97.47158047 |
6 | 2023-11-01 00:00:00.000 | Sei | 99.521021505 |
7 | 2023-11-01 00:00:00.000 | Zksync | 98.070460739 |
8 | 2023-11-01 00:00:00.000 | Base | 95.820424482 |
9 | 2023-11-01 00:00:00.000 | Optimism | 96.159369017 |
10 | 2023-11-01 00:00:00.000 | Ethereum | 97.9769925 |
11 | 2023-11-01 00:00:00.000 | Avalanche | 93.439766729 |
12 | 2023-11-01 00:00:00.000 | Flow | 92.531657888 |
13 | 2023-11-01 00:00:00.000 | Solana | 49.789565905 |
14 | 2023-11-01 00:00:00.000 | Polygon | 93.59724207 |
15 | 2023-11-02 00:00:00.000 | Optimism | 96.692576087 |
16 | 2023-11-02 00:00:00.000 | Solana | 50.408358212 |
17 | 2023-11-02 00:00:00.000 | Avalanche | 94.134398134 |
18 | 2023-11-02 00:00:00.000 | BSC | 93.912531908 |
19 | 2023-11-02 00:00:00.000 | Ethereum | 98.020932882 |
20 | 2023-11-02 00:00:00.000 | Atom | 95.277090078 |
hessAverage Daily Success Rate
Updated 2024-02-14
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
›
⌄
with zk_import as ( select * from (
SELECT
livequery.live.udf_api (
'https://api.dune.com/api/v1/query/3145198/results?api_key=nPlMJ4JjTsMZcIo0C6kGSt5rpbcoXujU') as resp)
,
table(FLATTEN(parse_json(resp:data:"result":"rows"))))
,
chains as ( select TO_TIMESTAMP(value:"date") as date,
'Zksync' as chain,
value:"status"::string as status,
value:"total_tx" as total_tx,
total_tx/86400 as tps
from zk_import
where date >= '2023-11-01'
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 >= '2023-11-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 >= '2023-11-01'
group by 1,2,3
UNION
select date(block_timestamp) as date,
'Optimism' as chain,
status,
Last run: about 1 year ago
...
420
20KB
1167s