Ant-DAO-MentDataDelay
    Updated 2025-03-11
    with
    raw_data as (
    select
    *
    from
    (
    select
    'arbitrum' as block_chain,
    datediff(
    'minute',
    max(block_timestamp),
    current_timestamp()
    ) as data_delay_in_minutes,
    60 as timing_cutoff
    from
    arbitrum.core.fact_event_logs
    where
    block_timestamp > current_date() - 7
    union
    select
    'avalanche' as block_chain,
    datediff(
    'minute',
    max(block_timestamp),
    current_timestamp()
    ) as data_delay_in_minutes,
    60 as timing_cutoff
    from
    avalanche.core.fact_event_logs
    where
    block_timestamp > current_date() - 7
    union
    select
    'axelar' as block_chain,
    datediff(
    'minute',
    Last run: 2 months ago
    BLOCK_CHAIN
    DATA_DELAY_IN_MINUTES
    TIMING_CUTOFF
    COLOR_TYPE
    1
    arbitrum34601
    2
    axelar36601
    3
    avalanche28601
    4
    base24601
    5
    ethereum35601
    6
    polygon101602
    7
    osmosis377603
    8
    optimism19601
    9
    flow47601
    10
    solana47601
    11
    terra922603
    12
    near88602
    13
    gnosis47601
    14
    bsc54601
    15
    cosmos687603
    16
    thorchain49601
    16
    313B
    46s