REPAYMENT_MONTH | REPAYMENT_COUNT | TOTAL_REPAID | CUMULATIVE_REPAYMENT_COUNT | CUMULATIVE_TOTAL_REPAID | |
|---|---|---|---|---|---|
1 | 2022-01-01 00:00:00.000 | 1 | 7.988193643 | 1 | 7.988193643 |
2 | 2022-04-01 00:00:00.000 | 676 | 994112.963956032 | 677 | 994120.952149675 |
3 | 2022-05-01 00:00:00.000 | 1793 | 5020723.32105976 | 2470 | 6014844.27320944 |
4 | 2022-06-01 00:00:00.000 | 1732 | 8524302.27837624 | 4202 | 14539146.5515857 |
5 | 2022-07-01 00:00:00.000 | 1309 | 5695652.46441974 | 5511 | 20234799.0160054 |
6 | 2022-08-01 00:00:00.000 | 1782 | 4751973.46131152 | 7293 | 24986772.4773169 |
7 | 2022-09-01 00:00:00.000 | 2014 | 68165323.2451209 | 9307 | 93152095.7224378 |
8 | 2022-10-01 00:00:00.000 | 2000 | 12214672.7016983 | 11307 | 105366768.424136 |
9 | 2022-11-01 00:00:00.000 | 1923 | 4524455.4218262 | 13230 | 109891223.845962 |
10 | 2022-12-01 00:00:00.000 | 1709 | 3691005.82983061 | 14939 | 113582229.675793 |
11 | 2023-01-01 00:00:00.000 | 2249 | 2934975.10874838 | 17188 | 116517204.784541 |
12 | 2023-02-01 00:00:00.000 | 1831 | 1294037.40789222 | 19019 | 117811242.192434 |
13 | 2023-03-01 00:00:00.000 | 1760 | 1696112.33114753 | 20779 | 119507354.523581 |
14 | 2023-04-01 00:00:00.000 | 1740 | 846100.962813875 | 22519 | 120353455.486395 |
15 | 2023-05-01 00:00:00.000 | 1487 | 760107.472925594 | 24006 | 121113562.959321 |
16 | 2023-06-01 00:00:00.000 | 1726 | 864683.637145443 | 25732 | 121978246.596466 |
17 | 2023-07-01 00:00:00.000 | 1777 | 829210.759735444 | 27509 | 122807457.356201 |
18 | 2023-08-01 00:00:00.000 | 1752 | 592215.633470023 | 29261 | 123399672.989671 |
19 | 2023-09-01 00:00:00.000 | 1577 | 572687.527436807 | 30838 | 123972360.517108 |
20 | 2023-10-01 00:00:00.000 | 2153 | 2083186.65928749 | 32991 | 126055547.176396 |
datavortexmonthly repayments
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
36
›
⌄
WITH repayment_data AS (
SELECT
DATE_TRUNC('month', block_timestamp) AS repayment_month,
tx_hash,
amount,
token_symbol
FROM
gnosis.defi.ez_lending_repayments
WHERE
amount IS NOT NULL
),
price_data AS (
SELECT
symbol,
MAX(price) AS max_price
FROM
gnosis.price.ez_prices_hourly
GROUP BY
symbol
),
monthly_repayments AS (
SELECT
rd.repayment_month,
COUNT(DISTINCT rd.tx_hash) AS repayment_count,
SUM(rd.amount * pd.max_price) AS total_repaid
FROM
repayment_data rd
JOIN
price_data pd
ON
rd.token_symbol = pd.symbol
GROUP BY
rd.repayment_month
)
SELECT
Last run: 19 days ago
38
3KB
6s