mohammadh1.5 )The Unstakeeeeers (enter a LP position)
    Updated 2022-07-17
    select count(distinct DELEGATOR_ADDRESS),
    CASE
    when DELEGATOR_ADDRESS=LIQUIDITY_PROVIDER_ADDRESS then 'unstakers that create liquidity' else 'unstakers that not create liquidity' end as activity
    from osmosis.core.fact_staking a join osmosis.core.fact_liquidity_provider_actions b
    where a.block_timestamp>= '2022-01-01'
    and b.block_timestamp>= '2022-01-01'
    and a.ACTION ='undelegate'
    and b.ACTION='pool_joined'
    and b.TX_STATUS='SUCCEEDED'
    and b.CURRENCY ='uosmo'
    group by activity

    Run a query to Download Data