select

tx_sender,

min(block_timestamp)::date as min_date

from terra.core.fact_transactions

group by tx_sender

),

t2 as (

select

date_trunc('week', min_date)::date as week,

count(distinct tx_sender) as new_wallets,

sum(new_wallets) over (order by week) as cumulative_new_wallets

from t1

group by week

),

t3 as (

select

date_trunc('week', block_timestamp)::date as week,

count(distinct tx_sender) as active_wallets

from terra.core.fact_transactions

group by week

select week,

active_wallets,

new_wallets,

from t2 join t3

using (week)

order by week asc