mz0111osmosis 907 1
    Updated 2023-02-17
    SELECT
    date_trunc('day', BLOCK_TIMESTAMP ) as date,
    POOL_ID[0] as pool,
    count(*),
    ROW_NUMBER() OVER (PARTITION BY pool ORDER BY date) as rank
    FROM osmosis.core.fact_liquidity_provider_actions
    where date >= CURRENT_DATE - 17
    GROUP BY 1,2
    QUALIFY rank <= 10


    Run a query to Download Data