cypherDAILY NEW USERS
    Updated 2022-07-07
    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

    Run a query to Download Data