zpokoHolder Ranges by Token ($)
Updated 2023-07-17
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
SELECT
COUNT(DISTINCT CASE WHEN usd_value_now BETWEEN 1 AND 10 THEN user_address END) AS count_1_10,
COUNT(DISTINCT CASE WHEN usd_value_now BETWEEN 10 AND 100 THEN user_address END) AS count_10_100,
COUNT(DISTINCT CASE WHEN usd_value_now BETWEEN 100 AND 1000 THEN user_address END) AS count_100_1000,
COUNT(DISTINCT CASE WHEN usd_value_now BETWEEN 1000 AND 10000 THEN user_address END) AS count_1000_10000,
COUNT(DISTINCT CASE WHEN usd_value_now BETWEEN 10000 AND 100000 THEN user_address END) AS count_10000_100000,
COUNT(DISTINCT CASE WHEN usd_value_now >= 100000 THEN user_address END) AS count_100000_plus
FROM
{{network}}.core.ez_current_balances
WHERE
contract_address = '{{token_address}}'
Run a query to Download Data