flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
block id lookup
nickpayiatis_
block id lookup
Updated 2022-11-29
Copy Reference
Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
select
block_id
::
STRING
as
"Block ID"
,
block_timestamp
as
"Time of Block"
from
algorand
.
core
.
dim_block
where
BLOCK_DATE
=
'{{block_date}}'
and
(
BLOCK_HOUR
=
'{{block_hour}}'
or
'{{block_hour}}'
=
'all'
)
order
by
block_id
Results
Run a query to Download Data