dan-smithmissed slots
Updated 2023-09-16
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
›
⌄
⌄
/**
###
### Test for latest blocks
###
SELECT
slot_timestamp
,slot_number
FROM ethereum.beacon_chain.fact_blocks
ORDER BY 2 DESC
LIMIT 10
**/
SELECT
dt
,DATE_PART(epoch_second, dt) AS epoch
,missed_percent
FROM (
SELECT
dt
,SUM(missed_slots) AS missed
,COUNT(DISTINCT slot_number) AS attested
,missed + attested AS total
,missed / total AS missed_percent
FROM (
SELECT
slot_timestamp
,date_trunc('day',slot_timestamp) AS dt
,slot_number
,LAG(slot_number,1) OVER(ORDER BY slot_number) AS prev_slot
,slot_number - prev_slot - 1 AS missed_slots
FROM ethereum.beacon_chain.fact_blocks
WHERE slot_timestamp >= '2020-06-20'
ORDER BY slot_number
)
Run a query to Download Data