maybeyonasmine_whale_daily
Updated 2021-10-30
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
›
⌄
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'
and msg_value:sender::string in (
'terra1ynfvr22snnmm3ykcfl08awd9gsd0c59acxgut2',
'terra1hugk5nhcx9v7m74gt996zqtvx3m8t4lplj4luv',
'terra1e5ncelsh4qhqt3s97vn43hxlhmt7zd43yszdnf',
'terra175uue3ztzdemameswa7dpu60asrauzc8u08kmn',
'terra1rjm8p9apslsarjfksw7j9zgwqk2wedcxfhnfqa',
'terra1cwk4s0jtvt69mawaqsay2a9h20cgqd9h5c2qgk',
'terra1e5ag4a5wlckwzlz4wu87p6nxjp427zpmc474zg',
'terra1fz4r2czzlq0nhyql2wn42yn52yj38su9d0fyhx',
'terra1r44vpq5wrgjjr9de9tdtl49xv2743e9us6zhmz',
'terra1tz69qmwzun58svxfdyue5ejjpvxw55jge7rmwt'
)
order by block_timestamp DESC
),
unstake as (
select
block_timestamp,
tx_id,
msg_value:sender::string as user,
msg_value:execute_msg:withdraw_voting_tokens:amount/pow(10,6) as mine_unstaked
from terra.msgs
where
tx_status = 'SUCCEEDED'
and msg_value:contract::string = 'terra1xu8utj38xuw6mjwck4n97enmavlv852zkcvhgp'
and msg_value:execute_msg:withdraw_voting_tokens is not null
Run a query to Download Data