mlhcomparison between daily number of blocks in each day
    Updated 2022-07-23
    with polygon as(
    select date_trunc('day',block_timestamp) as date,
    count(block_number) as polygon
    from polygon.core.fact_blocks
    group by date
    ),
    solana as(
    select date_trunc('day',block_timestamp) as date,
    count(block_id) as solana
    from solana.core.fact_blocks
    group by date
    ),
    ethereum as(
    select date_trunc('day',block_timestamp) as date,
    count(block_number) as ethereum
    from ethereum.core.fact_blocks
    group by date
    ),
    arbitrum as(
    select date_trunc('day',block_timestamp) as date,
    count(block_number) as arbitrum
    from arbitrum.core.fact_blocks
    group by date
    )
    select polygon.date,
    polygon,
    ethereum,
    solana,
    arbitrum
    from polygon join solana on polygon.date=solana.date
    join ethereum on polygon.date=ethereum.date
    join arbitrum on polygon.date=ethereum.date


    Run a query to Download Data