2844Top TOKE Holders-January
Updated 2022-06-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
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