kidaMultichain Latency (AVAX)
    Updated 2022-12-16
    with
    eth_transfers as (
    select *
    from ethereum.core.fact_event_logs
    where event_name = 'LogAnySwapOut' and tx_status = 'SUCCESS'
    ),
    bsc_transfers as (
    select *
    from bsc.core.fact_event_logs
    where event_name = 'LogAnySwapOut' and tx_status = 'SUCCESS'
    ),
    polygon_transfers as (
    select *
    from polygon.core.fact_event_logs
    where event_name = 'LogAnySwapOut' and tx_status = 'SUCCESS'
    ),
    optimism_transfers as (
    select *
    from optimism.core.fact_event_logs
    where event_name = 'LogAnySwapOut' and tx_status = 'SUCCESS'
    ),
    processed as (
    select
    date(be.block_timestamp) as date,
    be.tx_hash as dest_hash,
    coalesce(ee.tx_hash, oe.tx_hash, pe.tx_hash, ae.tx_hash) as source_hash,
    case
    when ee.tx_hash is not null then 'ethereum'
    when oe.tx_hash is not null then 'optimism'
    when pe.tx_hash is not null then 'polygon'
    when ae.tx_hash is not null then 'bsc'
    else 'Unknown'
    end as source_chain,
    be.block_timestamp as time_received,
    coalesce(ee.block_timestamp, oe.block_timestamp, pe.block_timestamp, ae.block_timestamp) as time_initiated,
    Run a query to Download Data