nitsBlock Stats
    Updated 2022-06-28
    with ava as
    (
    SELECT avg(tx_count) as avg_txs_per_block,
    max(tx_count) as max_txs_per_block,
    min(tx_count) as min_txs_per_block, 'avalnche' as chain
    from avalanche.core.fact_blocks),
    opt as
    (
    SELECT avg(tx_count) as avg_txs_per_block,
    max(tx_count) as max_txs_per_block,
    min(tx_count) as min_txs_per_block, 'optimism' as chain
    from optimism.core.fact_blocks),
    arb as
    (
    SELECT avg(tx_count) as avg_txs_per_block,
    max(tx_count) as max_txs_per_block,
    min(tx_count) as min_txs_per_block, 'arbitrum' as chain
    from arbitrum.core.fact_blocks)
    ,
    poly as
    (
    SELECT avg(tx_count) as avg_txs_per_block,
    max(tx_count) as max_txs_per_block,
    min(tx_count) as min_txs_per_block, 'polygon' as chain
    from polygon.core.fact_blocks)
    ,
    bsc as
    (
    SELECT avg(tx_count) as avg_txs_per_block,
    max(tx_count) as max_txs_per_block,
    min(tx_count) as min_txs_per_block, 'bsc' as chain
    from bsc.core.fact_blocks)
    ,
    osm as
    (
    SELECT avg(tx_count) as avg_txs_per_block,
    Run a query to Download Data