select Min(Date_trunc('month',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

group by 1