KARTODAvalanche Network Overview [JUNE]
Updated 2022-06-26Copy Reference Fork
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
›
⌄
WITH temp AS (
SELECT
AVG("txs") AS "Average transactions per second",
MAX("txs") AS "Maximum transactions per second"
FROM
(select
DATE_TRUNC('second', BLOCK_TIMESTAMP) AS sec,
count(distinct "TX_HASH") "txs"
from avalanche.core.fact_transactions
WHERE BLOCK_TIMESTAMP >= '2022-06-01'
GROUP BY 1
)),
fees AS (
select
AVG(GAS_PRICE*GAS_USED*20/POWER(10,9)) AS "Average Transaction fee ($)"
from avalanche.core.fact_transactions
WHERE BLOCK_TIMESTAMP >= '2022-06-01'
),
tempus AS (
select
AVG("TXs") "Average Daily Transactions",
AVG("add") "Average Daily Unique Addresses"
from
(
SELECT
DATE_TRUNC('day', BLOCK_TIMESTAMP) AS days,
count(distinct "TX_HASH") "TXs",
count(distinct "FROM_ADDRESS") "add"
FROM avalanche.core.fact_transactions
WHERE BLOCK_TIMESTAMP >= '2022-06-01'
GROUP BY 1
)
)
Run a query to Download Data