KARTODAvalanche Network Overview [JUNE]
    Updated 2022-06-26
    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