distinct origin_from_address as user,

min(block_timestamp)::date as min_date

from optimism.core.fact_event_logs

join optimism.core.dim_labels

on address = contract_address

where label_type in ('defi', 'dex')

group by 1

min_date as day,

iff(day >= date('2022-12-23'), 'After BONK', 'Before BONK') as timespan,

count(distinct user) as new_users_count,

sum(new_users_count) over (order by day) as cumulative_new_users_count

from t

where min_date >= '2022-12-01'

group by 1, 2

order by 1