pouya_22The Unstakeeeeers - Averages
    Updated 2022-07-15
    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
    Run a query to Download Data