from terra.msgs

where msg_value:execute_msg:send:contract::string = 'terra1xu8utj38xuw6mjwck4n97enmavlv852zkcvhgp' and msg_value:contract::string = 'terra1kcthelkax4j9x8d3ny6sdag0qmxxynl3qtcrpy' and tx_status = 'SUCCEEDED'

group by 1),

unstake as (select date_trunc('day', block_timestamp) as dt, sum(msg_value:execute_msg:withdraw_voting_tokens:amount/1e6) as unstake

from terra.msgs

where msg_value:execute_msg:withdraw_voting_tokens is not null and msg_value:contract::string = 'terra1xu8utj38xuw6mjwck4n97enmavlv852zkcvhgp' and tx_status = 'SUCCEEDED'

group by 1)

select a.dt, a.stake, concat('-',b.unstake) as unstake

from stake a

join unstake b on a.dt = b.dt