flipside
FLIPSIDEAI
IDG PLAYBOOK
JOURNEYS
INSIGHTS
About
Log in
GET STARTED
flipside
What's going on with Avalanche?
misaghlb
What's going on with Avalanche?
Updated 2022-11-25
Copy Reference
Fork
9
1
2
3
4
5
6
›
⌄
select
date_trunc
(
'day'
,
BLOCK_TIMESTAMP
)
as
block_date
,
count
(
BLOCK_NUMBER
)
as
block_count
,
86400
/
count
(
BLOCK_NUMBER
)
as
time_per_block
from
avalanche
.
core
.
fact_blocks
group
by
1
order
by
1
desc
Results
Run a query to Download Data