BLOCK_TIMESTAMP::date date,

case

when ACTION = 'pool_joined' then 'deposit' else 'withdraw' end as actions,

sum(amount/1e6) as amount,

count(distinct TX_ID) as txs,

count(distinct LIQUIDITY_PROVIDER_ADDRESS) as users

-- pool_exited pool_joined

from osmosis.core.fact_liquidity_provider_actions

where CURRENCY = 'ibc/903A61A498756EA560B85A85132D3AEE21B5DEDD41213725D22ABF276EA6945E'

and TX_STATUS = 'SUCCEEDED' and POOL_ID = 812

group by 1,2