maybeyonasmine_whale_daily
    Updated 2021-10-30
    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