messariLuna delegated
Updated 2022-05-05
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
›
⌄
-- Tarik - revised from query by LukeZ (https://app.flipsidecrypto.com/dashboard/top-10-terra-validators-a-60-day-view-oCEL8d)
-- Finally figured out how to get total staked!!!
--
Select * from terra.validator_labels
-- where vp_address = 'terravalcons1hldhklps3zpy6u63pzhn62cgwchajtp42rlrpf'
limit 5
SELECT * FROM terra.validator_voting_power
order by block_timestamp desc
limit 50
-- address = terravalcons1hldhklps3zpy6u63pzhn62cgwchajtp42rlrpf
-------------------------------------
SELECT
day,
sum(votingpower) as Total_Voting_power
from (
select
date_trunc('day', block_timestamp) as day,
address as Validator,
avg(voting_power) as VotingPower
from terra.validator_voting_power
where day >= '2022-03-04T00:00:00Z'
and day <= '2022-05-04T00:00:00Z'
group by day,
address
)
group by day
order by day
Run a query to Download Data