User | Total Borrowed Volume | Total Repaid Volume | Repaid % of Borrowed | |
|---|---|---|---|---|
1 | senlinear.near | 41293499.4568187 | 41393329.5047234 | 100.24% |
2 | b43dfe70c1a1418d3ea0edfd7dda5dc2ebd1f3b68517f0783b2c91f96e6587e5 | 32780473.0636603 | 16332831.5698633 | 49.82% |
3 | nbiv.near | 25198068.3914269 | 25313885.5890618 | 100.46% |
4 | 858de8addcda96c5dae4e6b212441c7de56de1e1138b176d9f651c2eb4711988 | 22421139.9132071 | 14194004.9864881 | 63.31% |
5 | d879751c547c15bc6bca2c6823e388f3eb9f5b66650ff9f2885e6cb03b5e97e0 | 21046164.1165183 | 21049819.3729959 | 100.02% |
6 | b522c17b8fddc50a270eede8cef3a87ccac6a2e838b8e50ca2134086cddef197 | 18905312.4257973 | 19128835.8605126 | 101.18% |
7 | hellothere.near | 11427432.6992937 | 11487122.0475132 | 100.52% |
8 | a9619033e4961a601741e38f242cd7b6f27ab8fc0ac0c9a9746638e3f4fe75ed | 10033068.5736697 | 10095189.6680272 | 100.62% |
9 | v1.near | 8662295.93575928 | 7546816.6332787 | 87.12% |
10 | 3fc98d2b4c64319ab2f6d8d63f758b8deedd74c3ce84a1f778d1ad5b5d7a2ce5 | 8020868.26 | 3353131.01230663 | 41.81% |
11 | lig2.near | 7673326.916 | 3770793.43442891 | 49.14% |
12 | ampr.near | 7174697.50377314 | 7214646.50633922 | 100.56% |
13 | pepip.near | 7001840.4973634 | 7086207.25240239 | 101.20% |
14 | neilw.near | 6855630.46938866 | 6870388.07875144 | 100.22% |
15 | whaler.near | 6825879.00615999 | 6825415.81047552 | 99.99% |
datavortexrepayment %
Updated 1 day 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
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
WITH BorrowedVolumes AS (
SELECT
sender_id,
SUM(amount_usd) AS total_borrowed
FROM
near.defi.ez_lending
WHERE
symbol IN ('USDT', 'USDt', 'DAI', 'FRAX', 'USDT.e', 'USDC.e', 'USN')
AND actions IN ('borrow')
AND amount_usd IS NOT NULL
GROUP BY
sender_id
),
RepaidVolumes AS (
SELECT
sender_id,
SUM(amount_usd) AS total_repaid
FROM
near.defi.ez_lending
WHERE
symbol IN ('USDT', 'USDt', 'DAI', 'FRAX', 'USDT.e', 'USDC.e', 'USN')
AND actions IN ('repay')
AND amount_usd IS NOT NULL
GROUP BY
sender_id
)
SELECT
bv.sender_id AS "User",
COALESCE(bv.total_borrowed, 0) AS "Total Borrowed Volume",
COALESCE(rv.total_repaid, 0) AS "Total Repaid Volume",
CASE
WHEN COALESCE(bv.total_borrowed, 0) = 0 THEN '0%'
ELSE TO_CHAR((COALESCE(rv.total_repaid, 0) / bv.total_borrowed) * 100, 'FM999999999.00') || '%'
END AS "Repaid % of Borrowed"
FROM
BorrowedVolumes bv
Last run: 1 day ago
15
1KB
11s