KuramaBlock utilization both in AVAX and ETH
Updated 2022-08-24
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
⌄
-- max number of transactions in a single block AVAX (360)
--select max(tx_count) from avalanche.core.fact_blocks
-- avg number of transactions per block in AVAX
/*
select to_date(block_timestamp) as date, avg(tx_count) as avg_transactions_per_block from avalanche.core.fact_blocks
group by date
order by date
*/
-- avg number of transactions per block in ETH
/*
select to_date(block_timestamp) as date, avg(tx_count) as avg_transactions_per_block from ethereum.core.fact_blocks
where to_date(block_timestamp) between current_date - 116 and current_date
group by date
order by date
*/
-- max number of transactions in a single block ETH all time (1431)
-- select max(tx_count) from ethereum.core.fact_blocks
-- max number of transactions in a single block ETH (same period as AVAX) (1414)
--select max(tx_count) from ethereum.core.fact_blocks
--where to_date(block_timestamp) between current_date - 116 and current_date
-- avg number of transactions per block in AVAX -> hourly, we see a trend
--select date_trunc('hour', block_timestamp) as date, avg(tx_count) as avg_transactions_per_block from avalanche.core.fact_blocks
--group by date
Run a query to Download Data