MONTH | monthly borrowed(usd) | PERCENTAGE_CHANGE | cumulative borrowed volume | |
|---|---|---|---|---|
1 | 2022-01-01 00:00:00.000 | 4 | 4 | |
2 | 2022-04-01 00:00:00.000 | 1904034.76 | 47600769 | 1904038.76 |
3 | 2022-05-01 00:00:00.000 | 1938756.01 | 1.823561772 | 3842794.77 |
4 | 2022-06-01 00:00:00.000 | 2914377.67 | 50.322044392 | 6757172.44 |
5 | 2022-07-01 00:00:00.000 | 1566571.94 | -46.246776589 | 8323744.38 |
6 | 2022-08-01 00:00:00.000 | 1262916.39 | -19.383441146 | 9586660.77 |
7 | 2022-09-01 00:00:00.000 | 16239704.6 | 1185.889131584 | 25826365.37 |
8 | 2022-10-01 00:00:00.000 | 2529230.29 | -84.425638567 | 28355595.66 |
9 | 2022-11-01 00:00:00.000 | 1039271.06 | -58.909591424 | 29394866.72 |
10 | 2022-12-01 00:00:00.000 | 1488535.2 | 43.228774214 | 30883401.92 |
11 | 2023-01-01 00:00:00.000 | 870603.3 | -41.512750253 | 31754005.22 |
12 | 2023-02-01 00:00:00.000 | 1362730.07 | 56.527096784 | 33116735.29 |
13 | 2023-03-01 00:00:00.000 | 1419447.06 | 4.16201207 | 34536182.35 |
14 | 2023-04-01 00:00:00.000 | 1048816.8 | -26.110889969 | 35584999.15 |
15 | 2023-05-01 00:00:00.000 | 5081784.16 | 384.525434757 | 40666783.31 |
16 | 2023-06-01 00:00:00.000 | 4056523.75 | -20.175205749 | 44723307.06 |
17 | 2023-07-01 00:00:00.000 | 6341775.99 | 56.335236297 | 51065083.05 |
18 | 2023-08-01 00:00:00.000 | 1160565.77 | -81.699672587 | 52225648.82 |
19 | 2023-09-01 00:00:00.000 | 817620.98 | -29.549793632 | 53043269.8 |
20 | 2023-10-01 00:00:00.000 | 8195501.96 | 902.359548063 | 61238771.76 |
datavortexMonthly Borrowing Volume
Updated 2025-04-16
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
›
⌄
⌄
WITH monthly_volume AS (
SELECT
DATE_TRUNC('month', block_timestamp) AS month,
SUM(amount_usd) AS "monthly borrowed(usd)"
FROM gnosis.defi.ez_lending_borrows
GROUP BY month
)
SELECT
month,
"monthly borrowed(usd)",
("monthly borrowed(usd)" - LAG("monthly borrowed(usd)") OVER (ORDER BY month)) / NULLIF(LAG("monthly borrowed(usd)") OVER (ORDER BY month), 0) * 100 AS percentage_change,
SUM("monthly borrowed(usd)") OVER (ORDER BY month) AS "cumulative borrowed volume"
FROM monthly_volume
ORDER BY month;
/*WITH weekly_volume AS (
SELECT
DATE_TRUNC('month', block_timestamp) AS borrow_week,
SUM(amount_usd) AS weekly_borrowed_usd
FROM gnosis.defi.ez_lending_borrows
WHERE amount_usd IS NOT NULL
GROUP BY borrow_week
)
SELECT
borrow_week,
weekly_borrowed_usd,
(weekly_borrowed_usd - LAG(weekly_borrowed_usd) OVER (ORDER BY borrow_week)) / NULLIF(LAG(weekly_borrowed_usd) OVER (ORDER BY borrow_week), 0) * 100 AS pct_change
FROM weekly_volume
ORDER BY borrow_week;
*/
Last run: 19 days ago
38
2KB
1s