Afonso_DiazNear New Wallets
Updated 2024-03-25
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
›
⌄
with
t1 as (
select
tx_signer,
min(block_timestamp::date) as min_date
from near.core.fact_transactions
group by tx_signer
),
t2 as (
select
min_date,
count(*) as new_wallets_count
from t1
group by min_date
)
select
min_date as day,
new_wallets_count,
sum(new_wallets_count) over (order by min_date) as cumulative_new_wallets_count
from t2
where day > current_date - 90
order by day asc
QueryRunArchived: QueryRun has been archived