bachiTerra - who validates validators
Updated 2021-12-15Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
WITH top_validators as (SELECT
DATE_TRUNC('day', block_timestamp) as day, address, AVG(voting_power) as voting_power_average
FROM terra.validator_voting_power GROUP BY day, address
ORDER BY day DESC, voting_power_average DESC),
rank_table as (SELECT tv.*, vl.label, RANK() OVER(PARTITION BY day ORDER BY voting_power_average DESC) as rank FROM top_validators tv
LEFT JOIN (SELECT * FROM terra.validator_labels) vl ON tv.address = vl.vp_address WHERE day >= DATEADD(day, -60, GETDATE())
AND label IS NOT NULL)
SELECT *
FROM rank_table
WHERE rank <= 10
ORDER BY day DESC, voting_power_average DESC
Run a query to Download Data