date_trunc('day', block_timestamp ) as block_day,

sum(cast(rtrim(attribute_value, 'uosmo') as integer)/1e6) as total_delegated

from osmosis.core.fact_msg_attributes

where msg_type = 'delegate'

and attribute_key = 'amount'

group by block_day),

daily_unbond as (

select

date_trunc('day', block_timestamp ) as block_day,

sum(cast(rtrim(attribute_value, 'uosmo') as integer)/1e6) as total_unbonded

from osmosis.core.fact_msg_attributes

where msg_type = 'unbond'

and attribute_key = 'amount'

group by block_day),

net_delegated as (select

d.block_day,

d.total_delegated,

u.total_unbonded,

d.total_delegated - u.total_unbonded as net_delegated,

sum(net_delegated) over (order by d.block_day asc rows between unbounded preceding and current row) as OSMO_staked

from daily_delegated d, daily_unbond u

where d.block_day = u.block_day)

select * from net_delegated

where block_day > current_date() - 60