with unstakes as (select
block_timestamp::date as date,
count(distinct tx_id) as unstakes_count,
count(distinct tx_caller_address) as unstakers_count,
sum(amount/power(10, decimal)) as unstake_volume
from osmosis.core.fact_staking
where currency = 'uosmo'
and action = 'undelegate'
and tx_status = 'SUCCEEDED'
group by 1)
select avg(unstakes_count), avg(unstakers_count), avg(unstake_volume) from unstakes