michaelglasspol2
Updated 2022-07-28
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
with base as (select block_number,
count(distinct(tx_hash)) as count_tx
from arbitrum.core.fact_transactions
group by 1)
select avg(count_tx) as "Transaction per Block",
'Average TX per Block' as "Min, Avg and Max"
from base
union
select max(count_tx),
'Max TX per Block'
from base
union
select min(count_tx),
'Min TX per Block'
from base
order by 1 asc
Run a query to Download Data