date_trunc('day', block_timestamp) as day,

msg_value:delegator_address as address,

msg_value:amount:amount/POW(10,6) as amount_staked,

msg_type

FROM terra.msgs

WHERE msg_value:validator_address = 'terravaloper1hqyygjq0vdqk0xdpkffgamzr4f7tqqg5u9mg66'

AND msg_type in ('staking/MsgUndelegate','staking/MsgDelegate')

AND tx_status = 'SUCCEEDED'

ORDER BY 1 DESC