SIGNERS[0] as address,

min(BLOCK_TIMESTAMP) as BLOCK_TIMESTAMP

from solana.core.fact_transactions

group by 1)

select count(distinct address) as users_count

from tab1

where BLOCK_TIMESTAMP::date>='2024-01-01'