mlhUntitled Query
Updated 2022-11-30
99
1
2
3
4
5
6
7
8
9
10
›
⌄
SELECT hour,
avg(transactions)/ 60 as avg_tps
FROM (SELECT date_trunc('hour', block_timestamp) as hour,
count(DISTINCT block_hash) as transactions
FROM avalanche.core.fact_transactions
GROUP BY 1
)
where hour>= CURRENT_DATE - 90
GROUP BY 1
Run a query to Download Data