flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
Daily blocks
flipsidecrypto
Daily blocks
Updated 2023-12-13
Copy Reference
Fork
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
with
base
as
(
Select
block_timestamp
::
Date
as
block_Date
,
count
(
1
)
block_count
from
sei_testnet
.
silver
.
blocks
group
by
1
)
select
*
,
sum
(
block_count
)
Over
(
order
by
block_Date
)
as
total_blocks
from
base
Results
Run a query to Download Data