select

TX_SENDER,

min(BLOCK_TIMESTAMP) AS minx

from terra.core.fact_transactions

where TX_SUCCEEDED='TRUE'

group by 1

select

iff(minx::date ilike '2022%', '2022', '2023') as type,

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

count(distinct TX_SENDER) AS "new addresses number"

from tb2 where minx::date >= '2022-01-01'

group by 1,2