NuveveCryptoArchivedTerra Top 10 Validators
Updated 2023-02-02
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
›
⌄
with delegate as (
select
validator_label as validator,
sum(amount) as total_stake
from terra.core.ez_staking
where action = 'Delegate'
group by validator
),
undelegate as (
select
validator_label as validator,
sum(amount) as total_stake
from terra.core.ez_staking
where action = 'Undelegate'
group by validator
)
select
delegate.validator as validator,
delegate.total_stake - undelegate.total_stake as total_stake
from delegate
inner join undelegate on delegate.validator = undelegate.validator
order by 2 desc
limit 10
Run a query to Download Data