banbannardAvalanche vs Near
Updated 2022-07-20Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with base as (select date_trunc('minute', block_timestamp) as minute,
count(distinct(tx_hash)) as count_tx
from avalanche.core.fact_transactions
group by 1),
base2 as (select date_trunc('hour',minute) as day,
count_tx
from base)
select avg(count_tx) as "TPM by Hour",
'Average TPM by Hour' as "Min, Avg and Max"
from base2
union
select max(count_tx),
'Max TPM by Hour'
from base2
union
select min(count_tx),
'Min TPM by Hour'
from base2
order by 1 asc
Run a query to Download Data