german3. validators
Updated 2021-11-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
›
⌄
--For addresses that are staking MINE right now, what validators do they prefer for their LUNA staking?
--Are there any trends or commonalities?
with mine_stakers as (
SELECT
msg_value:sender as mine_staker
FROM terra.msgs
WHERE msg_value:execute_msg:send:contract::string = 'terra19nek85kaqrvzlxygw20jhy08h3ryjf5kg4ep3l'
and block_timestamp <= '2021-11-03'
),
addresses as (
SELECT
count(delegator_address) as number,
action,
currency,
event_amount,
validator_address_label
FROM terra.staking a
inner join mine_stakers b on a.delegator_address = b.mine_staker
WHERE action != 'undelegate'
GROUP BY 2,3,4,5)
SELECT
sum(number) as total_users,
validator_address_label,
action
FROM addresses
group by 2,3
HAVING total_users > 500
order by 2
Run a query to Download Data