select block_timestamp, value as pool1

from osmosis.core.fact_swaps , table(flatten(input => pool_ids))

),

new_pools_since_may as (

select *, value as pool

from osmosis.core.fact_swaps , table(flatten(input => pool_ids))

where block_timestamp >= '2022-05-01'

and (select min(block_timestamp) from allpools where pool1=value) >= '2022-05-01'

select count(distinct pool) as no_of_pools from new_pools_since_may