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).
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).
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.
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).
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...