elsina2024-07-19: daily new user
    Updated 2024-07-19
    with new_users AS (
    SELECT
    sender as user,
    MIN(block_timestamp) AS date
    FROM
    axelar.defi.ez_bridge_satellite
    GROUP BY
    user
    )

    SELECT
    date::date as day,
    COUNT(*) AS new_user,
    SUM(new_user) OVER (ORDER BY day ASC) AS cum_new_users
    FROM
    new_users
    where
    date >= '2024-01-01'
    group by day









    QueryRunArchived: QueryRun has been archived