tcsUntitled Query
9
1
2
3
4
5
6
7
8
9
›
⌄
SELECT
10*ROUND(balance/10) AS rounded_balance_nearest_10
, COUNT(DISTINCT user_address) AS number_users
, 100*COUNT(DISTINCT user_address)/(SELECT total_holders FROM total_holders_table) AS percent_users
FROM ethereum.erc20_balances e
WHERE contract_address = '0x7e9d8f07a64e363e97a648904a89fb4cd5fb94cd'
AND balance_date > '2022-03-20'
GROUP BY 1
ORDER BY 2 DESC
Run a query to Download Data