scottincryptoTerra Validators by Size
Updated 2021-06-27
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with pre_format as (
select
address_label,
balance
-- row_number() over (order by balance desc) as sort,
-- ntile(4) over (order by balance desc) as quartile
from terra.daily_balances
where date = CURRENT_DATE
AND address_label_subtype = 'validator'
AND balance_type = 'staked'
-- and balance > 100
-- and address_label != 'hashed'
)
select
address_label,
balance,
balance * 100 / t.s as "% of Total"
from pre_format p cross join (SELECT SUM(balance) AS s FROM pre_format) t
order by balance desc
Run a query to Download Data