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