trunc(BLOCK_TIMESTAMP,'day') as date,

action,

count(DISTINCT LIQUIDITY_PROVIDER_ADDRESS) AS users,

count(distinct tx_id) as lp_actions

from osmosis.core.fact_liquidity_provider_actions where ACTION in ('pool_joined','pool_exited')

and POOL_ID[0]='877'

group by 1,2