-- 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