select min(block_timestamp::date) as min_date,

from_address as new_users

from gnosis.core.fact_transactions

where block_timestamp >= current_date-30

group by new_users)

select date_trunc('day',min_date)as date,

count(new_users) as total_new_users

from tab1

group by date order by date asc