select min(BLOCK_TIMESTAMP::date) as date

,TRADER

from terra.core.ez_swaps

where FROM_CURRENCY='uluna'

and 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(distinct TRADER) as new_buyer

from tab1

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

group by 1,2