date_trunc('day', block_timestamp::date) as time,

action,

count(distinct tx_id) as action_count

from osmosis.core.fact_liquidity_provider_actions

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

and block_timestamp > CURRENT_DATE - 60

group by 1, 2