kidaCeler Latency (Optimism)
    Updated 2023-01-07
    with
    origin_bridge_txs as (
    select
    block_timestamp,
    tx_hash,
    event_inputs:token as token_address,
    event_inputs:transferId as transferId,
    event_inputs:amount as bridged_amount
    from optimism.core.fact_event_logs
    where origin_to_address in (
    '0x9d39fc627a6d9d9f8c831c16995b209548cc3401' --v2
    )
    and tx_status = 'SUCCESS'
    and event_name = 'Send'
    ),

    polygon_relay_txs as (
    select
    block_timestamp,
    tx_hash,
    event_inputs:token as token_address,
    event_inputs:srcTransferId as srcTransferId,
    event_inputs:amount as received_amount
    from polygon.core.fact_event_logs b
    where b.origin_to_address in (
    '0x88dcdc47d2f83a99cf0000fdf667a468bb958a78', --v2
    '0xa251c4691c1ffd7d9b128874c023427513d8ac5c' --2.0
    )
    and b.tx_status = 'SUCCESS'
    and b.event_name = 'Relay'
    ),

    ethereum_relay_txs as (
    select
    block_timestamp,
    tx_hash,
    Run a query to Download Data