action,

count (distinct tx_id) as no_transactions,

count (distinct liquidity_provider_address) as no_users,

sum(AMOUNT/pow(10,decimal)) as volume,

avg(AMOUNT/pow(10,decimal)) as avg_volume,

no_users/count(distinct date_trunc(day, block_timestamp)) as average_sender_day,

volume/count(distinct date_trunc(day, block_timestamp)) as average_volume_day

from osmosis.core.fact_liquidity_provider_actions

where tx_status = 'SUCCEEDED'

and action in ('pool_joined','pool_exited')

and currency = 'ibc/D189335C6E4A68B513C10AB227BF1C1D38C746766278BA3EEB4FB14124F1D858'

group by 1