LI.FInb_swaps_jumper_users
    Updated 2024-05-27
    -- forked from nb_swaps_jumper_users @ https://flipsidecrypto.xyz/edit/queries/08cf41ed-dcd3-4c37-8cd6-752646ac9095

    with chain_logs as (
    SELECT
    *,
    'arbitrum' as chain
    FROM
    arbitrum.core.fact_decoded_event_logs
    UNION
    ALL
    SELECT
    *,
    'optimism' as chain
    FROM
    optimism.core.fact_decoded_event_logs
    UNION
    ALL
    SELECT
    *,
    'bnb' as chain
    FROM
    bsc.core.fact_decoded_event_logs
    UNION
    ALL
    SELECT
    *,
    'base' as chain
    FROM
    base.core.fact_decoded_event_logs
    UNION
    ALL
    SELECT
    *,
    'ethereum' as chain
    FROM
    ethereum.core.fact_decoded_event_logs
    QueryRunArchived: QueryRun has been archived