maybeyonasmine_staker_validators
Updated 2021-10-31
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 stake as (
-- select
-- block_timestamp,
-- tx_id,
-- msg_value:sender::string as user,
-- msg_value:execute_msg:send:amount/pow(10,6) as mine_staked
-- from terra.msgs
-- where
-- tx_status = 'SUCCEEDED'
-- -- and msg_value:execute_msg:send:msg::string = 'eyJzdGFrZV92b3RpbmdfdG9rZW5zIjp7fX0='
-- and msg_value:execute_msg:send:contract = 'terra1xu8utj38xuw6mjwck4n97enmavlv852zkcvhgp'
-- order by mine_staked desc
-- -- limit 1000
-- ),
-- mine_stakers as (
-- select
-- distinct user
-- from stake
-- )
-- select * from terra.staking
-- where delegator_address in (select * from mine_stakers)
-- limit 100
with delegated as(
select
delegator_address as address,
action as event,
sum(event_amount) as amount
from terra.staking
where action = 'delegate'
group by delegator_address, action
),
redelegated as(
select
Run a query to Download Data