select

tx_from as user_address,

min(block_timestamp) as min_date

from solana.core.fact_transfers a

join solana.core.dim_labels b

on b.address = a.tx_to

where label ='orca'

and label_type = 'dex'

and label_subtype = 'pool'

and address_name not like '%aquafarm%'

and block_timestamp::date between '2022-12-10' and '2023-01-07'

group by 1

select date_trunc('day', min_date) as day,

iff(min_date >= '2022-12-24', 'After BONK', 'Before BONK') as timespan,

count(distinct user_address) as new_users_count

from t

group by 1, 2

order by 1