Skip to content
Dune Analytics

@mikeghen1 / Block Times (last 30 days)

Block Times (last 30 days)

The time between blocks averaged over 1 hour. These values indicate the time between when data is put on chain. Difficulty retargets to keep this time at 300 second (5 minutes).

Loading
 

About queries and results

Dune Analytics lets you explore, create, and share Ethereum analytics. You can find an endless amount of great queries and dashboards on Dune.

We have decoded Ethereum smart contract data so you can do powerful analysis with simple SQL queries and visualise the query results into beautiful graphs.

Dune Analytics is free for everyone forever. If you want extra features like private queries, export your results and more check out our Pro plan.

Sign up to get started

SQL query results

The time between blocks averaged over 1 hour. These values indicate the time between when data is put on chain. Difficulty retargets to keep this time at 300 second (5 minutes).

Loading
 

SQL query

1-- -- Tellor Miner Transfers
2with tellor_submits as (
3    SELECT logs.block_time, 
4           encode(topic3, 'hex') as challenge
5    FROM ethereum."logs" AS logs
6    WHERE contract_address = '\x0ba45a8b5d5575935b8158a88c631e9f9c95a2e5'
7      AND topic1 = '\x0e4e65dc389613b6884b7f8c615e54fd3b894fbbbc534c990037744eea942000'
8      --AND block_time > NOW() - INTERVAL '180 days'
9), 
10tellor_submits_last_times as (
11    SELECT block_time,
12           challenge,
13           LAG(block_time,1) OVER (
14               PARTITION BY challenge
15               ORDER BY block_time DESC
16           ) last_block_time
17    FROM tellor_submits
18),
19challenge_times as (
20SELECT challenge, min(block_time) as block_started_at, EXTRACT('epoch' FROM SUM(last_block_time - block_time)) as block_time 
21from tellor_submits_last_times
22GROUP BY 1)
23
24select DATE_TRUNC('hour', block_started_at) as "date", 300 as target_time, AVG(block_time) as block_time
25FROM challenge_times...