keshanTop TOKE Holders 2
Updated 2022-06-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
›
⌄
⌄
/*
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