bachihot contracts 4
    Updated 2022-07-11
    with allpools as (
    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

    Run a query to Download Data