WITH

active_users as (

SELECT

distinct ORIGIN_FROM_ADDRESS as users,

label_type,

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

from base.core.fact_event_logs x

join base.core.dim_labels y on x.contract_address=y.address

group by 1,2

),

data as (

select

trunc(weeks,'week') as date,

label_type as sector,

count(distinct users) as new_users,

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

from active_users

group by 1,2

order by 1 asc

'All time' as period,sector,

"Total unique users" as users from data where date ='2023-10-16'

select 'Past week' as period,sector,new_users from data where date ='2023-10-16'