MLDZMNsne6
    Updated 2023-02-25
    with tb1 as (select
    distinct ORIGIN_FROM_ADDRESS as wallets
    from ethereum.core.fact_event_logs
    where ORIGIN_TO_ADDRESS='0x881d40237659c251811cec9c364ef91dc08d300c'
    and EVENT_NAME='Swap')

    select
    USER_ADDRESS,
    CURRENT_BAL as blnce,
    row_number() over (order by blnce desc) as rank1
    from ethereum.core.ez_current_balances
    where USER_ADDRESS in (select wallets from tb1)
    and CONTRACT_ADDRESS= lower('0x85F17Cf997934a597031b2E18a9aB6ebD4B9f6a4')
    order by 2 desc limit 10


    Run a query to Download Data