mlhUntitled Query
    Updated 2022-07-23
    with polygon as (
    select min(datediff(second, table_1.block_timestamp, table_2.block_timestamp)) AS min_difference
    from polygon.core.fact_blocks table_1 join polygon.core.fact_blocks table_2
    on table_1.block_number = table_2.block_number - 1
    ),
    solana as (
    select min(datediff(second, table_1.block_timestamp, table_2.block_timestamp)) AS min_difference
    from solana.core.fact_blocks table_1 join solana.core.fact_blocks table_2
    on table_1.block_id = table_2.block_id - 1
    ),
    ethereum as(
    select min(datediff(second, table_1.block_timestamp, table_2.block_timestamp)) AS min_difference
    from ethereum.core.fact_blocks table_1 join ethereum.core.fact_blocks table_2
    on table_1.block_number = table_2.block_number - 1
    ),
    arbitrum as(
    select min(datediff(second, table_1.block_timestamp, table_2.block_timestamp)) AS min_difference
    from arbitrum.core.fact_blocks table_1 join arbitrum.core.fact_blocks table_2
    on table_1.block_number = table_2.block_number - 1
    )

    select *, 'Polygon' as Chain from polygon union
    select *, 'Ethereum' as Chain from ethereum union
    select *, 'Solana' as Chain from solana union
    select *, 'Arbitrum' as Chain from arbitrum

    Run a query to Download Data