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 LOWER(contract_address) = LOWER('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('0x2e9d63788249371f1dfc918a52f8d799f4a38c94' )
    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
    count(distinct user_address) as holders,
    case when now > past then 'add more TOKE'
    Run a query to Download Data