nitsTop 3 Fastest growing pools over time
    Updated 2022-04-01
    with top_3_pools as
    (SELECT pool_name as pn,count(DISTINCT from_address) as new_users from
    (SELECT pool_name, from_address, min(block_timestamp) as first_use from ethereum.dex_swaps
    where platform like '%uniswap%'
    GROUP BY 1,2)
    where first_use >= CURRENT_DATE -30
    GROUP by 1
    order by 2 desc
    limit 3 )

    SELECT date(first_use) as day, pool_name, count(DISTINCT from_address) as unique_users,
    sum(unique_users) over (partition by pool_name order by day) as cumulative_users
    FROM
    (SELECT pool_name, from_address, min(block_timestamp) as first_use from ethereum.dex_swaps
    GROUP BY 1,2)
    where first_use >= CURRENT_DATE -30
    and pool_name in (SELECT pn from top_3_pools)
    GROUP by 1,2
    order by 1 ,2
    limit 1000
    Run a query to Download Data