barbodDaily number of newcomers
    Updated 2022-04-25

    WITH join_date_per_terra_user as (
    SELECT
    msg_value:sender::string sender_address,
    MIN(DATE(block_timestamp)) join_date,
    DATEDIFF(day, MIN(DATE(block_timestamp)), CURRENT_DATE) user_age_days
    FROM terra.msgs
    WHERE tx_id is not null
    GROUP BY 1
    ORDER BY 2
    )

    SELECT
    date_trunc('day',join_date) as dt,
    COUNT(sender_address) new_terra_users,
    sum(new_terra_users) over(order by dt asc) as cumulative
    FROM
    join_date_per_terra_user
    WHERE join_date >= '2022-01-01'
    GROUP BY 1
    ORDER BY 1
    Run a query to Download Data