OneDataAnalystDaily New Pools - Since May 2022
    Updated 2022-07-10
    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
    Run a query to Download Data