mlhAverage transaction count per block
    Updated 2022-07-27
    with polygon as (
    select date_trunc('day',block_timestamp) as date,
    sum(tx_count)/count(block_number) as polygon
    from polygon.core.fact_blocks
    group by 1
    ),
    solana as (
    select date_trunc('day',block_timestamp) as date,
    sum(tx_count)/count(block_id) as solana
    from solana.core.fact_blocks
    group by 1
    ),
    flow as(
    select date_trunc('day',block_timestamp) as date,
    sum(tx_count)/count(BLOCK_HEIGHT) as flow
    from flow.core.fact_blocks
    group by 1
    ),
    arbitrum as(
    select date_trunc('day',block_timestamp) as date,
    sum(tx_count)/count(block_number) as arbitrum
    from arbitrum.core.fact_blocks
    group by 1
    ),
    optimism as(
    select date_trunc('day',block_timestamp) as date,
    sum(tx_count)/count(block_number) as optimism
    from optimism.core.fact_blocks
    group by 1
    )

    select polygon.date,
    polygon,
    flow,
    solana,
    Run a query to Download Data