DATE | CHAIN | AVG_TIME | |
|---|---|---|---|
1 | 2025-03-18 00:00:00.000 | Cosmos | 5.860535 |
2 | 2024-05-08 00:00:00.000 | Sei | 0.394004 |
3 | 2023-10-20 00:00:00.000 | Optimism | 2 |
4 | 2024-08-24 00:00:00.000 | Polygon | 2.175227 |
5 | 2023-12-20 00:00:00.000 | Optimism | 2 |
6 | 2023-11-03 00:00:00.000 | Optimism | 2 |
7 | 2024-02-06 00:00:00.000 | Sei | 0.429462 |
8 | 2024-11-05 00:00:00.000 | Osmosis | 1.59075 |
9 | 2025-02-18 00:00:00.000 | Avlanche | 1.692889 |
10 | 2023-11-05 00:00:00.000 | Polygon | 2.166011 |
11 | 2024-03-19 00:00:00.000 | Cosmos | 6.182696 |
12 | 2024-04-08 00:00:00.000 | Solana | 0.510718 |
13 | 2024-03-28 00:00:00.000 | Solana | 0.431286 |
14 | 2023-11-05 00:00:00.000 | Arbitrum | 0.264859 |
15 | 2023-08-15 00:00:00.000 | Solana | 0.437493 |
16 | 2024-07-27 00:00:00.000 | Solana | 0.462854 |
17 | 2023-10-16 00:00:00.000 | Arbitrum | 0.289726 |
18 | 2024-01-10 00:00:00.000 | Avlanche | 2.012462 |
19 | 2024-05-25 00:00:00.000 | Sei | 0.394959 |
20 | 2024-06-01 00:00:00.000 | Solana | 0.434808 |
hessBLOCK TIME PER CHAIN DAILY
Updated 2025-03-20
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
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- Credited #M-Zamani
select date(a.block_timestamp) as date,'Sei' as chain, avg(datediff(second,a.block_timestamp, b.block_timestamp)) as avg_time
from sei.core.fact_blocks a, sei.core.fact_blocks b
where a.block_id = b.block_id-1
and a.block_timestamp::date >= '2023-08-15'
and b.block_timestamp::date >= '2023-08-15'
group by 1,2
UNION
select date(a.block_timestamp) as date,'Osmosis' as chain, avg(datediff(second,a.block_timestamp, b.block_timestamp)) as avg_time
from osmosis.core.fact_blocks a, osmosis.core.fact_blocks b
where a.block_id = b.block_id-1
and a.block_timestamp::date >= '2023-08-15'
and b.block_timestamp::date >= '2023-08-15'
group by 1,2
UNION
select date(a.block_timestamp) as date,'Cosmos' as chain, avg(datediff(second,a.block_timestamp, b.block_timestamp)) as avg_time
from cosmos.core.fact_blocks a, cosmos.core.fact_blocks b
where a.block_id = b.block_id-1
and a.block_timestamp::date >= '2023-08-15'
and b.block_timestamp::date >= '2023-08-15'
group by 1,2
UNION
select date(a.block_timestamp) as date,'Avlanche' as chain, avg(datediff(second,a.block_timestamp, b.block_timestamp)) as avg_time
from avalanche.core.fact_blocks a, avalanche.core.fact_blocks b
where a.block_number = b.block_number-1
and a.block_timestamp::date >= '2023-08-15'
and b.block_timestamp::date >= '2023-08-15'
group by 1,2
UNION
select date(a.block_timestamp) as date,'Arbitrum' as chain, avg(datediff(second,a.block_timestamp, b.block_timestamp)) as avg_time
from arbitrum.core.fact_blocks a, arbitrum.core.fact_blocks b
where a.block_number = b.block_number-1
and a.block_timestamp::date >= '2023-08-15'
and b.block_timestamp::date >= '2023-08-15'
group by 1,2
UNION
Last run: 15 days ago
...
4728
211KB
122s