flipside

    os 2
    cheeyoung-kekos 2
    Updated 2022-10-27
    SELECT pool_ids[0] as pool_id, CONCAT('https://app.osmosis.zone/pool/', pool_ids[0]) as pool_link, COUNT(DISTINCT TRADER) as users
    FROM osmosis.core.fact_swaps
    WHERE not pool_ids[0] = 1
    GROUP BY 1,2 ORDER by 3 DESC

    Run a query to Download Data