NavidApplications on Algorand
Updated 2022-06-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
with transactions_count as
(
select
block_id,
count(tx_id) as transactions_count
from
flipside_prod_db.algorand.transactions
where block_timestamp >= '2021-07-01' and block_timestamp <= '2022-06-30'
group by block_id
order by block_id
)
select
block_id,
avg(transactions_count) over (order by block_id asc) as avg_transactions_count
from transactions_count
order by block_id asc
Run a query to Download Data