nitsDistribution by Voting Power
Updated 2022-03-17
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
33
34
35
36
›
⌄
⌄
⌄
with pre_format as (
select
address,
voting_power,
CASE
when voting_power < 1e2 then '1 - 0-100'
when voting_power < 1e3 then '2 - 100-1k'
when voting_power < 1e4 then '3 - 1k-10k'
when voting_power < 1e5 then '4 - 10k-100k'
when voting_power < 1e6 then '5 - 100k-1M'
when voting_power >= 1e5 then '6 - 1M-1B'
end as class
-- row_number() over (order by balance desc) as sort,
-- ntile(4) over (order by balance desc) as quartile
from terra.validator_voting_power
where block_id = (select max(block_id) from terra.validator_voting_power)
-- and address_label != 'hashed'
)
select
address,
voting_power,
row_number() over (order by voting_power desc) as sort
from pre_format
order by sort
/*select
class,
count(address),
sum(voting_power)
from pre_format
group by class
order by class
*/
/*
Run a query to Download Data