flipside
GROWTH MCP
IDG PLAYBOOK
JOURNEYS
INSIGHTS
About
Log in
BECOME A PARTNER
flipside
Untitled Query
hurimaas
Untitled Query
Updated 2022-07-27
Copy Reference
Fork
9
1
2
3
›
⌄
SELECT
TIMESTAMPDIFF
(
SECOND
,
MIN
(
block_timestamp
)
,
MAX
(
block_timestamp
)
)
/
(
COUNT
(
DISTINCT
(
block_timestamp
)
)
-
1
)
as
avgtime
FROM
flow
.
core
.
fact_blocks
Results
Run a query to Download Data