select

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

count(distinct from_address) as active_users,

b.new_users

from gnosis.core.fact_transactions

join (SELECT

date(min_date) as bdate,

count(distinct from_address) as new_users

from (

select

min(block_timestamp) as min_date,

from_address

from gnosis.core.fact_transactions

group by from_address)

group by bdate

) b

on b.bdate = date(block_timestamp)

where status = 'SUCCESS' and block_timestamp >= '2022-08-01'

group by date, new_users