binhachonCh-ch-ch-ch-changes - Who are the buyers?
    Updated 2022-02-10
    with MIM_enter_transactions as (
    select
    tx_id,
    amount_usd
    from ethereum.dex_swaps
    where token_address = '0x99d8a9c45b2eca8864373a26d1459e3dff1e17f3'
    and direction = 'OUT'
    and amount_usd > 0
    and block_timestamp > '2022-01-23 00:00:00.000'
    ),
    MIM_transactions_with_swappers as (
    select
    distinct tx_id,
    origin_address
    from ethereum.udm_events
    where tx_id in (select tx_id from MIM_enter_transactions)
    ),
    MIM_swappers_with_volume as (
    select
    MIM_enter_transactions.*,
    origin_address
    from MIM_enter_transactions
    inner join MIM_transactions_with_swappers on (MIM_enter_transactions.tx_id = MIM_transactions_with_swappers.tx_id)
    ),
    MIM_volume as (
    select
    origin_address,
    sum(amount_usd) as volume,
    row_number() over (order by volume desc) as rank
    from MIM_swappers_with_volume
    group by origin_address
    qualify rank < 11
    ),
    transaction_count as (
    select
    origin_address,
    Run a query to Download Data