count(distinct tx_id) as total_transactions,

count(distinct liquidity_provider_address) as total_users,

count(distinct iff(action = 'pool_joined', tx_id, null)) as total_deposits,

count(distinct iff(action = 'pool_exited', tx_id, null)) as total_withdraws,

count(distinct iff(action = 'pool_joined', liquidity_provider_address, null)) as total_depositors,

count(distinct iff(action = 'pool_exited', liquidity_provider_address, null)) as total_withdrawers,

count(distinct iff(action = 'lp_tokens_minted', tx_id, null)) as total_add_liquidities,

count(distinct iff(action = 'lp_tokens_burned', tx_id, null)) as total_remove_liquidities,

count(distinct iff(action = 'pool_joined', amount, null)) as total_deposit_volume,

count(distinct iff(action = 'pool_exited', amount, null)) as total_withdraw_volume,

count(distinct iff(action = 'lp_tokens_minted', amount, null)) as total_add_liquidity_volume,

count(distinct iff(action = 'lp_tokens_burned', amount, null)) as total_remove_liquidity_volume

from osmosis.mars.ez_liquidity_provider_actions

where tx_succeeded = 1