flipsidecryptoAll Chains Latency - Top-level Categories
    Updated 2024-10-30
    -- forked from forgash / All Chains Delay - Cats @ https://flipsidecrypto.xyz/forgash/q/all-chains-delay-DkdsNk
    -- forked from All Chains Delay @ https://flipsidecrypto.xyz/edit/queries/ba5b9498-40ec-4d44-9465-5f65b06b363d
    with
    arbitrum as (
    select
    datediff('second', max(block_timestamp), current_timestamp) / 60 as mins_behind,
    'arbitrum' as chain,
    'fact_blocks' as table_name
    from
    arbitrum.core.fact_blocks
    union
    select
    datediff('second', max(block_timestamp), current_timestamp) / 60 as mins_behind,
    'arbitrum' as chain,
    'fact_transactions' as table_name
    from
    arbitrum.core.fact_transactions
    union
    select
    datediff('second', max(block_timestamp), current_timestamp) / 60 as mins_behind,
    'arbitrum' as chain,
    'fact_event_logs' as table_name
    from
    arbitrum.core.fact_event_logs
    union
    select
    datediff('second', max(block_timestamp), current_timestamp) / 60 as mins_behind,
    'arbitrum' as chain,
    'fact_traces' as table_name
    from
    arbitrum.core.fact_traces
    ),
    aurora as (
    select
    datediff('second', max(block_timestamp), current_timestamp) / 60 as mins_behind,
    'aurora' as chain,
    Last run: 9 days ago
    CHAIN
    TABLE_TYPE
    MINS_BEHIND
    HRS_BEHIND
    1
    arbitrumevent_level40.3666670.672777783333
    2
    arbitrumtop_level40.3666670.672777783333
    3
    auroraevent_level36.8166670.613611116667
    4
    auroratop_level36.8166670.613611116667
    5
    avalancheevent_level34.80.58
    6
    avalanchetop_level34.80.58
    7
    axelarevent_level42.750.7125
    8
    axelartop_level42.70.711666666667
    9
    baseevent_level30.40.506666666667
    10
    basetop_level30.40.506666666667
    11
    bitcoinevent_level430.716666666667
    12
    bitcointop_level430.716666666667
    13
    bscevent_level29.450.490833333333
    14
    bsctop_level29.450.490833333333
    15
    cosmosevent_level604.11666710.068611116667
    16
    cosmostop_level589.20833359.820138891667
    17
    ethereumevent_level45.4333330.757222216667
    18
    ethereumtop_level45.4333330.757222216667
    19
    flowevent_level37.80.63
    20
    flowtop_level29.650.494166666667
    34
    1KB
    365s