zakkisyed(incorrect query)Holder distribution
Updated 2023-04-24
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
›
⌄
WITH user_net_worth AS (
SELECT
user_address,
symbol,
SUM(current_bal * usd_value_now) AS net_worth
FROM ETHEREUM.core.ez_current_balances
WHERE contract_address IN (
'0x6982508145454ce325ddbe47a25d4ec3d2311933',
'0x6b89b97169a797d94f057f4a0b01e2ca303155e4',
'0x5026f006b85729a8b14553fae6af249ad16c9aab',
'0x2f573070e6090b3264fe707e2c9f201716f123c7'
)
GROUP BY user_address, symbol
)
SELECT
symbol,
COUNT(CASE WHEN net_worth > 1000000 THEN user_address ELSE NULL END) AS over_1_million,
COUNT(CASE WHEN net_worth > 100000 AND net_worth <= 1000000 THEN user_address ELSE NULL END) AS over_100k,
COUNT(CASE WHEN net_worth > 10000 AND net_worth <= 100000 THEN user_address ELSE NULL END) AS over_10k,
COUNT(CASE WHEN net_worth <= 1000 THEN user_address ELSE NULL END) AS less_equal_1000
FROM user_net_worth
where symbol in ({{token-symbol}})
GROUP BY symbol;
Run a query to Download Data