select min(BLOCK_TIMESTAMP::date)as date

,TX_SENDER

from terra.core.fact_transactions

-- where BLOCK_TIMESTAMP>='2022-12-11' and BLOCK_TIMESTAMP<='2023-01-07'

where TX_SUCCEEDED='TRUE'

group by 2)

select date

,case

when date>='2022-12-11' and date <'2022-12-25' then 'TWO WEEKS BEFORE HOLIDAYS'

when date>='2022-12-25' and date <='2023-01-07' then 'DURING THE HOLIDAYS' end as time_status

,count( *) as new_wallets

from tab1

where date>='2022-12-11' and date<='2023-01-07'

group by 1,2