WITH

active_users as (

SELECT

distinct from_address as users,

min(trunc(block_timestamp,'week')) as weeks

from base.core.fact_transactions

group by 1

),

news as (

select

trunc(weeks,'week') as date,

count(distinct users) as new_users,

sum(new_users) over (order by date) as "Total unique users"

from active_users

group by 1

order by 1 asc

),

actives as (

trunc(block_timestamp,'week') as weeks,

count(distinct from_address) as active_users

from base.core.fact_transactions

group by 1 order by 1

date,

active_users, new_users, "Total unique users"

from news x join actives y on x.date=y.weeks

order by 1 desc