Sbhn_NPres new wallets
Updated 2023-01-20
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
with new_user as (
select tx_sender, min(block_timestamp) as min_date
from terra.core.fact_transactions
where tx_succeeded = TRUE
group by 1
)
select date_trunc('month',min_date) as date,
count(DISTINCT tx_sender) as new_wallets,
sum(new_wallets) over (order by date) as cum_new
from new_user
group by 1
Run a query to Download Data