with first_transactions as (select
min(block_timestamp) as first_transaction,
tx_from[0] as address
from terra.transactions
group by address)
select count(distinct(address)) as n_new_users,
date(date_trunc('day', first_transaction)) as date
from first_transactions
where date <= current_date()
group by date
order by date