MufasaBottom validators eclipsce score
Updated 2023-02-08Copy Reference Fork
999
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
›
⌄
/*SQL CREDIT: https://app.flipsidecrypto.com/velocity/queries/cbf599a4-0b81-4d3c-aceb-733424ba3f5b */
WITH
votes as (
SELECT
voter as label,
COUNT(distinct tx_id) as n_votes
FROM terra.core.fact_governance_votes
-- WHERE NOT delegator_address is NULL
GROUP by 1
),
blocks as (
SELECT
voter as label,
max(block_id) - MIN(block_id) AS block_duration
from terra.core.fact_governance_votes
GROUP by 1
),
-- thanks to jackguy for getting val_addresses
validator_addresses as (
SELECT *
FROM values
('terravaloper188e99yz54744uhr8xjfxmmplhnuw75xea55zfp', 'terra188e99yz54744uhr8xjfxmmplhnuw75xeamclej'),
('terravaloper120ppepaj2lh5vreadx42wnjjznh55vvktp78wk', 'terra120ppepaj2lh5vreadx42wnjjznh55vvktwj679'),
('terravaloper1lelhxdzwn9ddecv6sv0kcxj5tguurxnzcfs5wf', 'terra1lelhxdzwn9ddecv6sv0kcxj5tguurxnzcxuf76'),
('terravaloper1kxyzu575tex8dv6d5uk26t4q8x5lusw082w3t8', 'terra1kxyzu575tex8dv6d5uk26t4q8x5lusw089zvm5'),
('terravaloper1rr2g4z2ch4cqwl8s70yj94a5l2vakg0v36nmjh', 'terra1rr2g4z2ch4cqwl8s70yj94a5l2vakg0v34lxzy'),
('terravaloper1gtw2uxdkdt3tvq790ckjz8jm8qgwkdw3uptstn', 'terra1gtw2uxdkdt3tvq790ckjz8jm8qgwkdw3uw8dmq'),
('terravaloper183kevvgrqvav9sa0lwzhr54jngxw6sac90jvs2', 'terra183kevvgrqvav9sa0lwzhr54jngxw6sac9q73qe'),
('terravaloper1ge3vqn6cjkk2xkfwpg5ussjwxvahs2f6at87yp', 'terra1ge3vqn6cjkk2xkfwpg5ussjwxvahs2f6aytr5j'),
('terravaloper14rw9dq3tj9y0k9pg2jquh922fdv5nupr0nn7k8', 'terra14rw9dq3tj9y0k9pg2jquh922fdv5nupr0ulrx5'),
('terravaloper1cqc26lnatzxvu0z5nd4yx8m4ecllkm7jlakwrw', 'terra1cqc26lnatzxvu0z5nd4yx8m4ecllkm7jlj6nna'),
('terravaloper18vnm040mwk0d6plc60v5m9h2376gkcphknuwzs', 'terra18vnm040mwk0d6plc60v5m9h2376gkcphkusnjr'),
('terravaloper1tz203ptlsfs8c63f2j0d0872pt5frjrvtfg0vd', 'terra1tz203ptlsfs8c63f2j0d0872pt5frjrvtxyju7'),
('terravaloper1ltegerwren4tcaxpwxpkgs94ztnrcu0sk9cajz', 'terra1ltegerwren4tcaxpwxpkgs94ztnrcu0sk25qz3'),
('terravaloper1jt8pcx4sesgztjkjsvjjqtvyfgcehqx09u4exq', 'terra1jt8pcx4sesgztjkjsvjjqtvyfgcehqx09neykn'),
('terravaloper17kh8ngu3s74epwympaxrp4ukahm5rvtf5zc8ma', 'terra17kh8ngu3s74epwympaxrp4ukahm5rvtf5d56tw'),
Run a query to Download Data