DATE | Average Time | |
|---|---|---|
1 | 2025-03-10 00:00:00.000 | 0.52254 |
2 | 2025-01-14 00:00:00.000 | 1.037664 |
3 | 2025-02-18 00:00:00.000 | 0.493679 |
4 | 2025-02-01 00:00:00.000 | 1.079938 |
5 | 2025-02-28 00:00:00.000 | 0.513379 |
6 | 2025-03-11 00:00:00.000 | 0.68583 |
7 | 2025-03-12 00:00:00.000 | 0.839344 |
8 | 2025-02-03 00:00:00.000 | 1.078426 |
9 | 2025-02-21 00:00:00.000 | 0.502863 |
10 | 2025-01-25 00:00:00.000 | 1.158453 |
11 | 2025-01-16 00:00:00.000 | 1.038995 |
12 | 2025-02-04 00:00:00.000 | 1.120358 |
13 | 2025-02-26 00:00:00.000 | 0.592913 |
14 | 2025-03-06 00:00:00.000 | 0.704833 |
15 | 2025-03-05 00:00:00.000 | 0.754594 |
16 | 2025-02-09 00:00:00.000 | 1.04687 |
17 | 2025-02-19 00:00:00.000 | 0.521167 |
18 | 2025-03-16 00:00:00.000 | 0.98582 |
19 | 2025-02-08 00:00:00.000 | 1.077536 |
20 | 2025-02-16 00:00:00.000 | 0.909869 |
0xHaM-dBlock Time
Updated 2025-03-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
with evenTb as (
select
date(a.block_timestamp) as date,
avg(datediff(second,a.block_timestamp, b.block_timestamp)) as avg_time
from monad.testnet.fact_blocks a, monad.testnet.fact_traces 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
)
select
date,
avg(avg_time) as "Average Time"
from evenTb a join ethereum.core.dim_dates b on a.date = b.date_day
-- where date >= current_date() - 31
-- AND date < current_date()
group by 1
Last run: 14 days ago
74
3KB
24s