shreexMonthly New Users Uniswap
    Updated 2022-04-05
    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