pouya_22Polygon Block Performance - Transactions per block
    Updated 2022-07-26
    with polygon as (select block_number, tx_count, 'Polygon' as network
    from polygon.core.fact_blocks
    order by 1 desc
    limit 1000),

    flow as (select block_height as block_number, tx_count, 'Flow' as network
    from flow.core.fact_blocks
    order by 1 desc
    limit 1000),

    sol as (select block_height as block_number, tx_count, 'Solana' as network
    from solana.core.fact_blocks
    order by 1 desc
    limit 1000),

    near as (select block_id as block_number, tx_count, 'Near' as network
    from near.core.fact_blocks
    order by 1 desc
    limit 1000),

    opt as (select block_number, tx_count, 'Optimism' as network
    from optimism.core.fact_blocks
    order by 1 desc
    limit 1000),

    eth as (select block_number, tx_count, 'Ethereum' as network
    from ethereum.core.fact_blocks
    order by 1 desc
    limit 1000),

    arb as (select block_number, tx_count, 'Arbitrum' as network
    from arbitrum.core.fact_blocks
    order by 1 desc
    limit 1000)

    select row_number() over(order by block_number) as n, * from polygon
    Run a query to Download Data