maybeyonasangel_protocol_viz
    Updated 2021-08-17
    with redelegationOUT as(
    select
    block_id,
    block_timestamp,
    tx_id,
    msg_value:delegator_address as delegator,
    msg_value:amount:amount/1000000 as amount,
    'redelegate' as event,
    'out' as t_type
    from terra.msgs
    where
    msg_type = 'staking/MsgBeginRedelegate' and
    msg_value:validator_src_address = 'terravaloper1hqyygjq0vdqk0xdpkffgamzr4f7tqqg5u9mg66'
    ),
    redelegationIN as(
    select
    block_id,
    block_timestamp,
    tx_id,
    msg_value:delegator_address as delegator,
    msg_value:amount:amount/1000000 as amount,
    'redelegate' as event,
    'in' as t_type
    from terra.msgs
    where
    msg_type = 'staking/MsgBeginRedelegate' and
    msg_value:validator_dst_address = 'terravaloper1hqyygjq0vdqk0xdpkffgamzr4f7tqqg5u9mg66'
    ),
    delegation as(
    select
    block_id,
    block_timestamp,
    tx_id,
    msg_value:delegator_address as delegator,
    msg_value:amount:amount/1000000 as amount,
    'delegate' as event,
    Run a query to Download Data