shreexMonthly New Users Uniswap
Updated 2022-04-05
9
1
2
3
4
5
6
7
8
9
›
⌄
select
date_trunc('month',block_timestamp) as date ,
count(distinct from_address) as unique_users
from ethereum.transactions
where block_timestamp >= current_date - interval '12 months' and from_address not in
(select distinct from_address as previus_users from ethereum.transactions where block_timestamp <= current_date - interval '12 months' )
and to_address_name like '%Uniswap%'
GROUP BY 1
ORDER BY 1
Run a query to Download Data