aba2- number of pool actions
    Updated 2022-12-13

    select action,
    count(distinct TX_ID) number_of_transactions,
    count(distinct liquidity_provider_address) as number_of_liquidity_providers
    from osmosis.core.fact_liquidity_provider_actions
    where pool_id[0] = '773' and tx_status = 'SUCCEEDED'
    and action in ('pool_joined', 'pool_exited')
    group by 1


    Run a query to Download Data