Rodolfo-Lima Top TOKE Holders- Today
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
25
26
›
⌄
-- Q1. Identify the top holders of the TOKE token in January 2022, have they kept their position today?
SELECT
USER_ADDRESS,
(CASE
WHEN
USER_ADDRESS = LOWER('0x8b4334d4812C530574Bd4F2763FcD22dE94A969B') THEN 'Tokemak Treasury'
WHEN
USER_ADDRESS = LOWER('0x96F98Ed74639689C3A11daf38ef86E59F43417D3') THEN 'TOKE Pool'
WHEN
USER_ADDRESS = LOWER('0x79dD22579112d8a5F7347c5ED7E609e60da713C5') THEN 'Tokemak Rewards'
WHEN
NAME IS NULL THEN USER_ADDRESS
ELSE
NAME
END) AS LABEL_NAME,
SUM(BALANCE) AS TOKE_POSITION
FROM
ethereum.erc20_balances
LEFT JOIN ethereum.core.dim_contracts ON USER_ADDRESS = ADDRESS
WHERE CONTRACT_ADDRESS = LOWER('0x2e9d63788249371f1DFC918a52f8d799F4a38C94') -- TOKE contract
AND DATE_TRUNC('day',BALANCE_DATE) = CURRENT_DATE --Im considering positons in the last day of Jan
GROUP BY 1,2
ORDER BY 3 DESC
LIMIT 5
Run a query to Download Data