select date_trunc('hour',BLOCK_TIMESTAMP) as date,count(tx_id) as number_of_actions
,count(DISTINCT LIQUIDITY_PROVIDER_ADDRESS ) as number_of_unique_address
from osmosis.core.fact_liquidity_provider_actions
where POOL_ID= '812' and CURRENCY !='uosmo' and TX_STATUS='SUCCEEDED'
GROUP BY date