pyor-subscriptionstotal_borrowers_cumulative_monthly
    Updated 2023-06-01
    SELECT date(date) as date , users as new_users ,'compound' as coin, sum(users) OVER (
    ORDER BY date ASC ROWS BETWEEN unbounded preceding AND CURRENT ROW) AS total_users
    FROM
    (SELECT date, count(USER) AS users
    FROM
    (SELECT min(date) AS date,
    account AS USER
    FROM
    (SELECT date_trunc('month', min(block_timestamp)) AS date,
    borrower AS account
    FROM ethereum.compound.ez_borrows
    GROUP BY 2) a
    GROUP BY 2) b
    GROUP BY 1
    ORDER BY 1) c
    Run a query to Download Data