Papasotuniswap monthly new users
    Updated 2022-11-27
    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