mlhcomparison between daily number of blocks in each day
    Updated 2022-12-12
    with Algorand as(
    select date_trunc('day',block_timestamp) as date,
    count(block_id) as algorand
    from algorand.core.fact_block where date >='2022-01-01'
    group by date
    ),
    Near as(
    select date_trunc('day',block_timestamp) as date,
    count(block_id) as near
    from near.core.fact_blocks where date >='2022-01-01'
    group by date
    ),
    ethereum as(
    select date_trunc('day',block_timestamp) as date,
    count(block_number) as ethereum
    from ethereum.core.fact_blocks where date >='2022-01-01'
    group by date
    ),
    flow as(
    select date_trunc('day',block_timestamp) as date,
    count(ID) as flow
    from flow.core.fact_blocks where date >='2022-01-01'
    group by date
    )
    select Algorand.date,
    algorand,
    ethereum,
    near,
    flow
    from Algorand join Near on Algorand.date=near.date
    join ethereum on Algorand.date=ethereum.date
    join flow on Algorand.date=flow.date

    Run a query to Download Data