satsihDaily New Users (30 Days)
    with
    users_first as (
    SELECT
    tx_signer as user,
    min(block_timestamp) as first_time
    FROM
    near.core.fact_transactions
    GROUP BY
    1
    )
    SELECT
    date_trunc('day', first_time) as first_time,
    count(user) as new_users
    FROM
    users_first
    WHERE
    first_time > dateadd(day, -30, current_date())
    GROUP BY
    1
    ORDER BY
    1 DESC