select

proposer,

min(BLOCK_TIMESTAMP) AS minx

from flow.core.fact_transactions

where TX_SUCCEEDED='TRUE'

group by 1

select

monthname(minx) AS Month,

date_trunc('day',minx) AS day,

count(distinct proposer) AS "new addresses number"

from tb2 where minx::date between '2022-12-01' and CURRENT_DATE-1

group by 1,2