adriaparcerisaseclipse score 3
Updated 2023-04-13
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
›
⌄
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
),
-- voting as (
-- SELECT
-- voter as label,
-- avg(VOTE_WEIGHT) as voting_power
-- FROM terra.core.fact_governance_votes
-- 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'),
Run a query to Download Data