0xaimanANC reward Claimer Staking Position
Updated 2022-02-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
35
36
›
⌄
select st_pos as staking_position, count(sender) as n_user from
(select case when a>1 then 'Added ANC on top of Reward for Staking' else 'Use solely ANC reward for staking' end as St_pos,
case when b>1 then 'Added ANC on top of Reward for LP' else 'Use solely ANC reward for LP' end as lp,
sender
from (with data1 as (with rc as (select sender, sum(CLAIM_0_AMOUNT) as staking_reward, sum(CLAIM_1_AMOUNT) as borrow_reward
from anchor.reward_claims
group by 1
),
st as (select sender, sum(amount) as ANC_staked
from anchor.gov_staking
where event_type='stake'
group by 1 )
select rc.sender, staking_reward+borrow_reward as tot_ANC_reward, ANC_staked
from rc inner join st on st.sender=rc.sender
),
data2 as (
select msg_value:sender as sender, sum(msg_value:execute_msg:provide_liquidity:assets[0]:amount/1000000) as ANC_lp
from terra.msgs
where --tx_id='426494A85E93D782A85F8265B80B17B972D3212E0B21947EFEC4E7AADFC778F2' and
msg_value:execute_msg:provide_liquidity:assets[0]:info:token:contract_addr='terra14z56l0fp2lsf86zy3hty2z47ezkhnthtr9yq76'
group by 1
)
select data2.sender,TOT_ANC_REWARD, ANC_STAKED, ANC_lp, (ANC_STAKED/TOT_ANC_REWARD) as a, (ANC_lp/TOT_ANC_REWARD) as b
from data1
inner join data2 on data1.sender=data2.sender))
group by 1 order by 1
Run a query to Download Data