Updated 2024-08-15
    with tab1 as (
    select
    ORIGIN_FROM_ADDRESS
    from ethereum.defi.ez_dex_swaps
    where platform in ('uniswap-v2', 'uniswap-v3')
    and block_timestamp > '2024-01-01'

    UNION ALL

    select
    ORIGIN_FROM_ADDRESS
    from arbitrum.defi.ez_dex_swaps
    where platform in ('uniswap-v2', 'uniswap-v3')
    and block_timestamp > '2024-01-01'

    UNION ALL

    select
    ORIGIN_FROM_ADDRESS

    from optimism.defi.ez_dex_swaps
    where platform in ('uniswap-v2', 'uniswap-v3')
    and block_timestamp > '2024-01-01'

    UNION ALL

    select
    ORIGIN_FROM_ADDRESS
    from bsc.defi.ez_dex_swaps
    where platform in ('uniswap-v2', 'uniswap-v3')
    and block_timestamp > '2024-01-01'


    UNION ALL

    select
    QueryRunArchived: QueryRun has been archived