ThatGuyOAB: MakerDAO (Sep 1) - Health - 3. new users
    Updated 2022-09-06
    SELECT
    first_date,
    count(*) as count,
    count(*) over (order by first_date) as cum_count
    FROM (
    SELECT
    DEPOSITOR,
    min(BLOCK_TIMESTAMP)::date as first_date
    FROM
    ethereum.maker.ez_deposits f
    GROUP BY 1
    HAVING
    first_date >= '{{StartDate}}'
    ORDER BY 1 DESC
    )
    GROUP BY 1
    ORDER BY 1 DESC
    Run a query to Download Data