select

from_address

,min(block_timestamp) as date

from gnosis.core.fact_transactions

group by 1

)

select

count(from_address)

,date_trunc('day',date)

from new_users

group by 2