flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
total number of transactions over time
nickpayiatis_
total number of transactions over time
Updated 2023-01-03
Copy Reference
Fork
9
1
2
3
4
›
⌄
select
block_timestamp
::
Date
as
date
,
count
(
*
)
as
Transactions
,
sum
(
Transactions
)
over
(
order
by
date
asc
rows
between
unbounded
preceding
and
current
row
)
as
Cumulative_transactions
from
algorand
.
transactions
group
by
block_timestamp
::
Date
Results
Run a query to Download Data