nitsNEAR Distribution
Updated 2022-09-08
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
›
⌄
with withdrawal as
(SELECT tx_signer as addr, sum(deposit)/pow(10,24)*(-1) as amt from mdao_near.transfers
GROUP by 1 ),
deposits as
(SELECT tx_receiver as addr, sum(deposit)/pow(10,24) as amt from mdao_near.transfers
GROUP by 1)
SELECT distribution, count(DISTINCT addr) as total_addresses, sum(net_balance) as net_wealth_in_category from
(SELECT addr, sum(amt) as net_balance,
case when net_balance < 1 then 'a-less than 1 NEAR'
when net_balance >= pow(10,0) and net_balance < pow(10,1) then 'b- 1-10 NEAR'
when net_balance >= pow(10,1) and net_balance < pow(10,2) then 'c- 10-100 NEAR'
when net_balance >= pow(10,2) and net_balance < pow(10,3) then 'd- 100-1k NEAR'
when net_balance >= pow(10,3) and net_balance < pow(10,4) then 'e- 1k-10k NEAR'
when net_balance >= pow(10,4) and net_balance < pow(10,5) then 'f- 10k-100k NEAR'
when net_balance >= pow(10,5) and net_balance < pow(10,6) then 'g- 100k-1M NEAR'
when net_balance >= pow(10,6) and net_balance < pow(10,7) then 'h- 1M-10M NEAR'
when net_balance >= pow(10,7) then 'i- 10M+ NEAR'
end as distribution
from
(SELECT * from deposits
UNION ALL
SELECT * FROM withdrawal)
GROUP by 1 )
GROUP by 1
limit 100
Run a query to Download Data