sakshamUntitled Query
Updated 2022-11-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
SELECT date, 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