adriaparcerisasAvalanche tx per block hour
Updated 2022-06-27
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
-- What's the average number of transactions per block? What's the max number of transactions we've seen in a block and the minimum?-
-- Show the average time between blocks over time
-- Show transaction gas price over time.
-- Note any other interesting findings about the number of transactions, blocks, or gas for the Avalanche blockchain!
WITH
tpb as (
select
block_number,
block_timestamp,
count(distinct tx_hash) as txs
from avalanche.core.fact_transactions
where block_timestamp>='2022-06-20' and status='SUCCESS'
group by 1,2
)
SELECT
trunc(block_timestamp,'hour') as hour_time,
avg(txs) as avg_tx_per_block
from tpb
group by 1
order by 1 asc
Run a query to Download Data