Ant-DAO-MentDataDelay
    Updated 2023-11-01
    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',
    Run a query to Download Data