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