with base as (

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

tx_hash,

from_address as user

from optimism.core.fact_transactions

where block_timestamp >= '2022-01-01'

and status = 'SUCCESS'

, new_users as (

select user,

min(date) as min_date

from base

group by 1

, daily_new_users as (

select min_date,

count(user) as new_count

from new_users

group by 1

)

, all_users as (

select date, count(distinct user) as all_count

from base

group by 1

, base_period as (

select date,

-- case when date < '2022-06-01' then 'Before 1st Airdrop'