flipside

    Daily Average Number of Transactions per Hour POLYGON VS. ARBITRUM
    markooDaily Average Number of Transactions per Hour POLYGON VS. ARBITRUM
    WITH
    polygon AS (
    SELECT
    DATE_TRUNC('day', hour) AS date,
    ROUND(AVG(txn)) AS avg_txn
    FROM (
    SELECT
    DATE_TRUNC('hour', block_timestamp) AS hour,
    COUNT(tx_id) AS txn
    FROM
    flipside_prod_db.polygon.transactions
    WHERE
    block_timestamp::date >= '2022-07-23'
    GROUP BY
    hour
    )
    GROUP BY
    date
    ORDER BY
    date
    ),
    arbitrum AS (
    SELECT
    DATE_TRUNC('day', hour) AS date,
    ROUND(AVG(txn)) AS avg_txn
    FROM (
    SELECT
    DATE_TRUNC('hour', block_timestamp) AS hour,
    COUNT(tx_hash) AS txn
    FROM
    flipside_prod_db.mdao_arbitrum.txs
    WHERE
    block_timestamp::date >= '2022-07-23'
    GROUP BY
    hour
    )
    Run a query to Download Data