ErsvanCurrent top 20 holders for toke (June)
Updated 2022-06-21
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
27
28
29
30
31
32
›
⌄
SELECT
BALANCE_DATE,
USER_ADDRESS,
SYMBOL,
BALANCE
FROM (
SELECT
ROW_NUMBER() OVER (
partition by USER_ADDRESS order by BALANCE ASC
) AS RN,
*
FROM
flipside_prod_db.ethereum.erc20_balances
WHERE
BALANCE_DATE BETWEEN '2022-6-01' AND CURRENT_DATE
AND CONTRACT_ADDRESS = '0x2e9d63788249371f1dfc918a52f8d799f4a38c94'
AND USER_ADDRESS IN (
SELECT DISTINCT USER_ADDRESS FROM flipside_prod_db.ethereum.erc20_balances WHERE
BALANCE_DATE BETWEEN '2022-6-01' AND CURRENT_DATE
AND CONTRACT_ADDRESS = '0x2e9d63788249371f1dfc918a52f8d799f4a38c94'
)
)
WHERE RN = 1
AND LABEL_SUBTYPE IS NULL
ORDER BY BALANCE DESC
LIMIT 20
Run a query to Download Data