2844Top TOKE Holders-January
    Updated 2022-06-22
    select
    case when USER_ADDRESS='0x8b4334d4812c530574bd4f2763fcd22de94a969b' then 'Top Holder'
    when USER_ADDRESS='0x96f98ed74639689c3a11daf38ef86e59f43417d3' then 'Second Holder'
    when USER_ADDRESS='0xa760e26aa76747020171fcf8bda108dfde8eb930' then 'Third Holder'
    when USER_ADDRESS='0xd4e7a6e2d03e4e48dfc27dd3f46df1c176647e38' then 'Forth Holder'
    when USER_ADDRESS='0x5fa464cefe8901d66c09b85d5fcdc55b3738c688' then 'Fifth Holder'
    end As "Holder",
    balance as "January Balance"
    from ethereum.erc20_balances
    where contract_address = lower('0x2e9d63788249371f1DFC918a52f8d799F4a38C94')
    and balance_date::date ='2022-01-30'
    order by "January Balance" DESC
    limit 5



    Run a query to Download Data