0-MIDdis buyers by buy swap count
    Updated 2023-05-04
    with tab1 as (
    select
    ORIGIN_FROM_ADDRESS,count(distinct tx_hash)as tx_count
    from ethereum.core.ez_dex_swaps
    where TOKEN_OUT='0xbbbbca6a901c926f240b89eacb641d8aec7aeafd'
    and( PLATFORM='uniswap-v2'or PLATFORM='uniswap-v3')
    and BLOCK_TIMESTAMP>='2022-01-01'
    group by 1)
    select tx_count,count(distinct ORIGIN_FROM_ADDRESS)as swappers
    from tab1
    group by 1

    Run a query to Download Data