select date_trunc('day', block_timestamp) as block_day, sum(msg_value:coins[0]:amount/1e6) as zap_UST
from terra.msgs
where msg_value:contract::string = 'terra1g7jjjkt5uvkjeyhp8ecdz4e4hvtn83sud3tmh2' and msg_value:execute_msg:zap_into_strategy::string is not null
group by 1