Papasotuniswap monthly new users
Updated 2022-11-27
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
select
platform,
date_trunc('month',block_timestamp) as date,
count(distinct (from_address)) as Sending_Users,
count(distinct (to_address)) as Receiving_Users,
sum(Receiving_Users) over (order by date asc rows between unbounded preceding and current row) as cum_n_wallets
from ethereum.dex_swaps
where
date > '2021-04-04' AND
platform = 'uniswap-v2' OR
platform = 'uniswap-v3'
group by date,platform
order by date
Run a query to Download Data