0xaimanUntitled Query
Updated 2021-12-18
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
›
⌄
with staker as (Select date_trunc('day',block_timestamp) as t1,msg_value:sender as staker, sum(msg_value:execute_msg:send:amount/1000000) as staked--date_trunc('day',block_timestamp) as date, avg(price_usd) as avg_price
from terra.msgs
where --tx_id='CE4F155EF6FBD573384939432841DF3A19CECF44CB28959EE08E1C3BFE909EA9' and
msg_value:contract='terra14z56l0fp2lsf86zy3hty2z47ezkhnthtr9yq76' and
msg_value:execute_msg:send:contract='terra1f32xyep306hhcxxxf7mlyh0ucggc00rm2s9da5'
group by 1,2 order by 1
),
unstaker as (Select date_trunc('day',block_timestamp) as t2, msg_value:sender as unstaker, sum(msg_value:execute_msg:withdraw_voting_tokens:amount/1000000) as unstaked --date_trunc('day',block_timestamp) as date, avg(price_usd) as avg_price
from terra.msgs
where --tx_id='C5EE23400B9C1F8DB071AC51240063A10FF37514B4DB3900C7218CD4B9DA16F7' and
msg_value:contract='terra1f32xyep306hhcxxxf7mlyh0ucggc00rm2s9da5'
group by 1,2 order by 1
)
select t1, unstaker, staked,unstaked
from staker
inner join unstaker on staker.t1=unstaker.t2 and staker.staker=unstaker.unstaker
limit 10
Run a query to Download Data