date_trunc('day', block_timestamp) as day,

--msg_value:sender,

sum(msg_value:execute_msg:send:amount /1e6) as halo_staked,

sum(halo_staked) over (order by day) as total_staked

from terra.msgs

where msg_value:contract = 'terra1w8kvd6cqpsthupsk4l0clwnmek4l3zr7c84kwq' -- halo token

and msg_value:execute_msg:send:contract = 'terra1lzdqv40fd8am5ac5tr9kvrmplqywmrgh4dslvk' --angel governance

and tx_status = 'SUCCEEDED'

group by day),

unstake as (

select

date_trunc('day', block_timestamp) as day,

sum(msg_value:execute_msg:withdraw_voting_tokens:amount /1e6) as halo_unstaked,

sum(halo_unstaked) over (order by day) as total_unstaked

from terra.msgs

where msg_value:contract = 'terra1lzdqv40fd8am5ac5tr9kvrmplqywmrgh4dslvk' -- angel governance

and msg_value:execute_msg:withdraw_voting_tokens is not null

and tx_status = 'SUCCEEDED'

group by day

),

total_staked as (

select

s.day,

s.total_staked,

case when u.total_unstaked is null then 0 else u.total_unstaked end as total_unstaked_nonull,

s.total_staked - total_unstaked_nonull as net_staked

from stake s

left outer join unstake u

on s.day = u.day ),