flipside

    osmosis - total distinct pools per day
    LittlerDataosmosis - total distinct pools per day
    Updated 2022-07-13
    --table stolen from popex404
    select
    DATE_TRUNC('DAY',BLOCK_TIMESTAMP) AS DAY,
    count (Distinct pool_ids[0])
    from osmosis.core.fact_swaps
    where block_timestamp > '2022-05-01'
    group by 1
    Run a query to Download Data