BlockTrackersocket swap for livequery
    Updated 2024-08-30
    with all_swaps as (
    select
    tx_hash
    from (
    select
    block_timestamp,
    tx_hash
    from arbitrum.core.ez_decoded_event_logs
    where event_name ='SocketSwapTokens'
    union all
    select
    block_timestamp,
    tx_hash
    from optimism.core.ez_decoded_event_logs
    where event_name ='SocketSwapTokens'
    union all
    select
    block_timestamp,
    tx_hash
    from ethereum.core.ez_decoded_event_logs
    where event_name ='SocketSwapTokens'
    union all
    select
    block_timestamp,
    tx_hash
    from avalanche.core.ez_decoded_event_logs
    where event_name ='SocketSwapTokens'
    union all
    select
    block_timestamp,
    tx_hash
    from gnosis.core.ez_decoded_event_logs
    where event_name ='SocketSwapTokens'
    union all
    select
    block_timestamp,
    QueryRunArchived: QueryRun has been archived