flipside
FLIPSIDEAI
IDG PLAYBOOK
JOURNEYS
INSIGHTS
About
Log in
GET STARTED
flipside
exact-rose
Mrfti
exact-rose
Updated 2025-06-23
Copy Reference
Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
with
tbl1
as
(
SELECT
date_trunc
(
day
,
block_timestamp
)
as
date
,
count
(
DISTINCT
block_number
)
as
"Block count"
FROM
swell
.
core
.
fact_blocks
where
date
=
current_date
-
2
group
by
1
order
by
1
)
SELECT
24
*
60
*
60
/
"Block count"
as
"Block Time"
from
tbl1
Results
Last run: 3 months ago
Block Time
1
2
1
1
5B
1s