nitsTop 3 Fastest growing pools over time
Updated 2022-04-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
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