WITH t1 AS (
select Min(Date_trunc('day',BLOCK_TIMESTAMP)) AS Date, POOL_ID
from osmosis.core.fact_liquidity_provider_actions
group by 2)
select date, count(pool_id) AS pools,
SUM(pools) over (Order by date) AS ACC_Pools
from t1
where date >= '2022-05-01'
group by 1