date(BLOCK_TIMESTAMP) as dt,

ACTION,

sum(AMOUNT/1e18) as vol,

count(distinct tx_id) as no_txn,

count(distinct LIQUIDITY_PROVIDER_ADDRESS) as users

from osmosis.core.fact_liquidity_provider_actions

where BLOCK_TIMESTAMP>='2022-01-01'

and TX_STATUS='SUCCEEDED'

and POOL_ID=704--wETH

and CURRENCY='ibc/EA1D43981D5C9A1C4AAEA9C23BB1D4FA126BA9BC7020A25E0AE4AA841EA25DC5'

group by 1,2