adambalaTop TOKE Holders
    Updated 2022-06-23

    with
    a as (
    select distinct user_address,
    max(balance) as balance
    from flipside_prod_db.ethereum.erc20_balances
    where contract_address = '0x2e9d63788249371f1dfc918a52f8d799f4a38c94'
    and balance_date between '2022-01-01' and '2022-01-31'
    and label is null
    group by 1
    order by 2 desc
    limit 20

    ),
    now as (
    select
    user_address ,
    balance ,
    amount_usd
    from ethereum.erc20_balances
    where lower(contract_address) = lower('0xae7ab96520de3a18e5e111b5eaab095312d7fe84' )
    and balance_date::date = current_date - 1
    and user_address in ( select user_address from a)
    ),
    b as (
    select
    now.user_address,
    now.balance as now,
    a.balance as past
    from now inner join a on NOW.user_address=A.user_address
    group by 1,2,3
    )
    select
    *
    from A

    Run a query to Download Data