select

TX_SENDER,

min(BLOCK_TIMESTAMP) AS minx

from terra.core.fact_transactions

where TX_SUCCEEDED='TRUE'

group by 1

select

iff( minx::date >= '2023-01-14', 'After Announce', ' Before Announce') as type ,

date_trunc('day',minx)::date AS day,

count(distinct TX_SENDER) AS "new addresses number"

from tb2 where minx::date ilike '2023%'

group by 1,2