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