(

select

block_timestamp,

TX_ID,

'normal_unstake' as "stake"

from

osmosis.core.fact_staking

where

action='undelegate'

and TX_STATUS='SUCCEEDED'

)

select

block_timestamp::date as "date",

count(distinct tx_id) as unstakes,

lag(unstakes,1) over (order by "date" asc) as unstakes_lag,

unstakes-unstakes_lag as change_in_unstake

from unstakes

group by "date"