date(BLOCK_TIMESTAMP) as dt,

ACTION,

sum(AMOUNT/1e8) 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=712--wBTC

and CURRENCY='ibc/D1542AA8762DB13087D8364F3EA6509FD6F009A34F00426AF9E4F9FA85CBBF1F'

group by 1,2