Afonso_DiazOvertime
    Updated 2024-09-06
    with

    swappers as (

    select
    distinct origin_from_address as user
    from
    ethereum.core.ez_token_transfers
    where
    to_address = lower('0x37a8f295612602f2774d331e562be9e61B83a327')
    and tx_hash in (
    select
    tx_hash
    from
    ethereum.uniswapv3.ez_swaps
    )

    union

    select
    distinct origin_from_address as user
    from
    ethereum.core.ez_native_transfers
    where
    to_address = lower('0x37a8f295612602f2774d331e562be9e61B83a327')
    and tx_hash in (
    select
    tx_hash
    from
    ethereum.uniswapv3.ez_swaps
    )
    ),


    lps as (
    select
    QueryRunArchived: QueryRun has been archived