flipside

    Arbitrum - Open Analyitics Bounty: Average Number of Transactions per Day
    piperArbitrum - Open Analyitics Bounty: Average Number of Transactions per Day
    Updated 2022-07-26

    WITH all_blocks AS (
    SELECT
    block_timestamp::date AS date,
    count(tx_hash) AS number_of_tx
    FROM
    arbitrum.core.fact_transactions
    WHERE
    block_timestamp::date <= '2022-07-25'
    GROUP BY date
    )

    SELECT
    avg(number_of_tx) AS avg_number_of_tx
    FROM
    all_blocks

    Run a query to Download Data