block_timestamp::date as day,

count(distinct(iff(action = 'lp_tokens_minted', liquidity_provider_address, null))) as deposit_count,

count(distinct(iff(action = 'lp_tokens_burned', liquidity_provider_address, null))) as withdraw_count,

sum(deposit_count) over (order by day) as cumulative_deposit_count,

sum(withdraw_count) over (order by day) as cumulative_withdraw_count

from osmosis.core.fact_liquidity_provider_actions

where action in ('lp_tokens_burned', 'lp_tokens_minted')

and pool_id[0] = 833

and year(block_timestamp) >= 2022

and tx_succeeded = 1

group by 1

order by 1 asc