select pool_ids as contracts, min(block_timestamp::date) as date

from osmosis.core.fact_swaps

group by 1

), total_contracts as (

select count(contracts) as contracts , date from pools where date >= '2022-05-01' and date <= '2022-05-31'

group by date

)

select sum(contracts) over(ORDER BY date ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) as cummulative_contracts, date

from total_contracts