CryptoIcicle3. Solana: Active Wallet Growth - 2022
    Updated 2022-01-29
    -- 3. Active Wallet Growth

    -- What is the number of unique active wallets (signers) over the past 7 days?
    -- Create a visualization showing the number of active wallets per day since the start of 2022.
    -- What trends do you see?

    -- Payout 0.57 SOL
    -- Grand Prize 1.71 SOL
    -- Level Beginner

    select
    date_trunc('day',block_timestamp) as date,
    count(distinct(tx_from_address)) as n_wallets,
    sum(n_wallets) over (order by date asc rows between unbounded preceding and current row) as cum_n_wallets
    from solana.transactions
    where block_timestamp >= '2022-01-01'
    group by date
    order by date desc
    Run a query to Download Data