flipside

    Polygon Block Performance - Polygon Transactions per Block
    rmasPolygon Block Performance - Polygon Transactions per Block
    Updated 2022-07-24
    WITH

    blocks AS (
    SELECT 'NEAR' AS blockchain
    , block_height
    , block_timestamp
    , tx_count

    FROM flipside_prod_db.mdao_near.blocks
    WHERE block_timestamp >= CURRENT_TIMESTAMP - interval '90 days'

    UNION ALL

    SELECT 'Ethereum' AS blockchain
    , block_number AS block_height
    , block_timestamp
    , tx_count

    FROM ethereum.core.fact_blocks
    WHERE block_timestamp >= CURRENT_TIMESTAMP - interval '90 days'

    UNION ALL

    SELECT 'Polygon' AS blockchain
    , block_number AS block_height
    , block_timestamp
    , tx_count

    FROM polygon.core.fact_blocks
    WHERE block_timestamp >= CURRENT_TIMESTAMP - interval '90 days'

    UNION ALL

    SELECT 'Arbitrum' AS blockchain
    , block_number AS block_height
    , block_timestamp
    Run a query to Download Data