Month | Repayers | Total Repay Transactions | Total Repaid Volume | Avg Repaid Amount | |
|---|---|---|---|---|---|
1 | 2022-03-01 00:00:00.000 | 38 | 74 | 3693.125220953 | 369.312522095 |
2 | 2022-04-01 00:00:00.000 | 873 | 7554 | 74583097.2342126 | 30466.951484564 |
3 | 2022-05-01 00:00:00.000 | 951 | 8482 | 87208337.2853849 | 35037.499913775 |
4 | 2022-06-01 00:00:00.000 | 540 | 4504 | 42591425.3993818 | 29052.81405142 |
5 | 2022-07-01 00:00:00.000 | 247 | 1933 | 19950381.8560881 | 33473.79506055 |
6 | 2022-08-01 00:00:00.000 | 206 | 1098 | 928582.143565115 | 2715.152466565 |
7 | 2022-09-01 00:00:00.000 | 166 | 738 | 302127.911110493 | 1533.644218835 |
8 | 2022-10-01 00:00:00.000 | 162 | 649 | 2186500.40195161 | 9548.036689745 |
9 | 2022-11-01 00:00:00.000 | 163 | 709 | 262750.870837454 | 1476.128487851 |
10 | 2022-12-01 00:00:00.000 | 75 | 250 | 8823.355694255 | 441.167784713 |
11 | 2023-01-01 00:00:00.000 | 79 | 332 | 17823.084615141 | 187.611417001 |
12 | 2023-02-01 00:00:00.000 | 53 | 201 | 30234.333722738 | 392.653684711 |
13 | 2023-03-01 00:00:00.000 | 91 | 478 | 2346453.88299288 | 7900.518124555 |
14 | 2023-04-01 00:00:00.000 | 59 | 282 | 880440.560827865 | 3167.052377079 |
15 | 2023-05-01 00:00:00.000 | 47 | 280 | 557400.77291915 | 2079.853630295 |
16 | 2023-06-01 00:00:00.000 | 50 | 173 | 477249.473746796 | 2758.667478305 |
17 | 2023-07-01 00:00:00.000 | 36 | 187 | 677767.55039723 | 3624.425403194 |
18 | 2023-08-01 00:00:00.000 | 58 | 1394 | 2277736.29937513 | 1633.957173153 |
19 | 2023-09-01 00:00:00.000 | 45 | 475 | 568174.518376198 | 1196.156880792 |
20 | 2023-10-01 00:00:00.000 | 71 | 695 | 816110.656416306 | 1175.95195449 |
datavortexmonthly repayments
Updated 2 days ago
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
›
⌄
SELECT
DATE_TRUNC('month', block_timestamp) AS "Month",
COUNT(DISTINCT sender_id) AS "Repayers",
COUNT(DISTINCT tx_hash) AS "Total Repay Transactions",
SUM(amount_usd) AS "Total Repaid Volume",
AVG(amount_usd) AS "Avg Repaid Amount"
FROM
near.defi.ez_lending
WHERE
symbol IN (
'USDT',
'USDt',
'DAI',
'FRAX',
'USDT.e',
'USDC.e',
'USN'
)
AND actions IN ('repay')
GROUP BY
DATE_TRUNC('month', block_timestamp)
ORDER BY
"Month";
Last run: 2 days ago
38
3KB
4s