PapasotAlgorand new wallets
    Updated 2023-01-02
    select
    date_trunc('day',b.block_timestamp) as date,
    count(distinct a.address) as n_wallets,
    sum(n_wallets) over (order by date asc rows between unbounded preceding and current row) as cum_n_wallets
    from algorand.account a
    left join algorand.block b on b.block_id = a.created_at
    where b.block_timestamp >= '2021-10-28'
    group by date
    order by date desc
    Run a query to Download Data