select

min(block_timestamp) as min_date,

TX_SENDER as wallet

from terra.core.fact_transactions

where block_timestamp <='2023-01-03'

group by 2)

select

date_trunc('week',min_date) as date,

when date >= '2022-01-01' and date < '2022-12-18' then 'other days'

when date >= '2022-12-18' and date <= '2023-01-03' then 'holidays'

end as time_frame,

count(distinct wallet) as new_wallet

from tab1

group by 1,2