afonsoTotal Deposit transactions of Pool NO. 833
    Updated 2023-01-14
    select
    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
    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
    Run a query to Download Data