flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
Untitled Query
linda20-4DtLke
Untitled Query
Updated 2022-11-10
Copy Reference
Fork
9
1
2
3
4
›
⌄
SELECT
count
(
SLOT_NUMBER
)
as
totaol_blocks
,
totaol_blocks
/
count
(
distinct
date_trunc
(
day
,
SLOT_TIMESTAMP
)
)
as
average_block_day
from
ethereum
.
beacon_chain
.
fact_blocks
Results
Run a query to Download Data