keshanTop TOKE Holders 2
    Updated 2022-06-22
    /*
    Deployer Address - 0x9e0bcE7ec474B481492610eB9dd5D69EB03718D5
    TOKE Contract - 0x2e9d63788249371f1DFC918a52f8d799F4a38C94
    DeGenesis ("DeFi") Contract - 0xc803737D3E12CC4034Dde0B2457684322100Ac38
    Manager Contract - 0xA86e412109f77c45a3BC1c5870b880492Fb86A14
    TOKE pool = 0x96f98ed74639689c3a11daf38ef86e59f43417d3
    Treasury Address (Multisig) - 0x8b4334d4812C530574Bd4F2763FcD22dE94A969B
    Rewards Contract - 0x79dD22579112d8a5F7347c5ED7E609e60da713C5
    */
    with top_20 as (select distinct user_address
    from (
    select user_address,
    Row_number() over (partition by balance_date order by balance desc) as RowNum
    from flipside_prod_db.ethereum.erc20_balances
    where contract_address=lower('0x2e9d63788249371f1DFC918a52f8d799F4a38C94')
    and date_trunc('month', balance_date)='2022-1-1')
    where RowNum <= 20)

    select balance, case when label is null then
    case when user_address=lower('0x8b4334d4812C530574Bd4F2763FcD22dE94A969B') then 'Treasury Address (Multisig)'
    when user_address=lower('0x96f98ed74639689c3a11daf38ef86e59f43417d3') then 'TOKE Pool'
    else user_address end else case when address_name is not null then address_name else label end end as user_address
    from flipside_prod_db.ethereum.erc20_balances top_20
    where balance_date='2022-6-21' and contract_address=lower('0x2e9d63788249371f1DFC918a52f8d799F4a38C94') and user_address in (select * from top_20)
    Run a query to Download Data