yasmin-n-d-r-hpool osmo first
    Updated 2023-01-02
    with firstes as (
    SELECT
    MIN(BLOCK_TIMESTAMP) as firsts,
    tx_from
    FROM
    osmosis.core.fact_transactions
    GROUP by
    2
    )
    SELECT
    date_trunc('week', firsts) as week,
    POOL_ID[0] as pools,
    count(
    DISTINCT LIQUIDITY_PROVIDER_ADDRESS
    ) as users
    FROM
    osmosis.core.fact_liquidity_provider_actions
    LEFT OUTER JOIN firstes ON LIQUIDITY_PROVIDER_ADDRESS = tx_from
    AND firsts = BLOCK_TIMESTAMP
    GROUP BY
    1,
    2
    order by users
    desc limit 300







    Run a query to Download Data