flipside

    Arbitrum - Open Analyitics Bounty: Average TPS per Day
    piperArbitrum - Open Analyitics Bounty: Average TPS per Day
    Updated 2022-07-26

    WITH all_tps AS (
    SELECT
    block_timestamp::date AS date,
    COUNT(tx_hash)/86400 AS tps
    FROM
    arbitrum.core.fact_transactions
    WHERE
    block_timestamp::date <= '2022-07-25'
    GROUP BY date
    )

    SELECT
    avg(tps) AS avg_tps
    FROM
    all_tps

    Run a query to Download Data