winnie-fs1.2. New wallets over time copy
Updated 2024-04-12
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
-- forked from mar1na-catscatscode / 1.2. New wallets over time @ https://flipsidecrypto.xyz/mar1na-catscatscode/q/wOwfnmtjMsbj/1.2.-new-wallets-over-time
-- Source query: https://flipsidecrypto.xyz/mo115/q/nUqIBPD0U4cP/1.e
-- Analyst: mo115
select
FIRST_TX_DATE
, count (distinct SIGNER) as "New Wallets"
, sum("New Wallets") over (order by FIRST_TX_DATE) as "Cumulative New Wallets Last 30d"
from solana.core.ez_signers
where FIRST_TX_DATE >= current_date - 30
group by 1
;
QueryRunArchived: QueryRun has been archived