kidaStargate Latency (Polygon)
    Updated 2023-01-07
    with
    origin_swaps as (
    select
    block_timestamp,
    tx_hash,
    replace(data, '0x') as trunc_data,
    tokenflow_eth.hextoint(substr(trunc_data, 1, 64)) as dstChainId,
    substr(trunc_data, 153, 40) as recipient,
    substr(trunc_data, 193, 64) as amount,
    substr(trunc_data, 321, 64) as dstFee,
    substr(trunc_data, 385, 64) as protocolFee,
    data
    from polygon.core.fact_event_logs
    where topics[0] = '0x34660fc8af304464529f48a778e03d03e4d34bcd5f9b6f0cfbf3cd238c642f7f' -- Swap
    ),

    origin_nonces as (
    select
    block_timestamp,
    tx_hash,
    replace(data, '0x') as trunc_data,
    substr(trunc_data, 65, 64) as nonce
    from polygon.core.fact_event_logs
    where topics[0] = '0x8d3ee0df6a4b7e82a7f20a763f1c6826e6176323e655af64f32318827d2112d4' -- SendMsg
    ),

    origin_deposits as (
    select
    s.block_timestamp,
    s.tx_hash,
    s.dstChainId,
    s.recipient,
    s.amount,
    s.dstFee,
    s.protocolFee,
    n.nonce,
    Run a query to Download Data