WITH
users as (
select
distinct liquidity_provider_address as users,
action,
count(distinct tx_id) as txs,
sum(amount/1e18) as volume
from osmosis.core.fact_liquidity_provider_actions
where currency = 'ibc/EA1D43981D5C9A1C4AAEA9C23BB1D4FA126BA9BC7020A25E0AE4AA841EA25DC5' and tx_status = 'SUCCEEDED' and action in ('pool_joined','pool_exited')
and block_timestamp>='2022-09-26'
group by 1,2
)
SELECT
action,
avg(txs) as avg_tx_per_user,
avg(volume) as avg_volume_per_user
from users
group by 1 order by 1 desc