TOTAL_UNIQUE_PAYERS | TOTAL_REPAYMENT_COUNT | TOTAL_REPAID_VOLUME_USD | |
|---|---|---|---|
1 | 4007 | 63624 | 527783739.877212 |
datavortexTotal Volume Repayed By Borrrowers
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
›
⌄
WITH repayment_data AS (
SELECT
payer,
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
)
SELECT
COUNT(DISTINCT rd.payer) AS total_unique_payers,
COUNT(DISTINCT rd.tx_hash) AS total_repayment_count,
SUM(rd.amount * pd.max_price) AS total_repaid_volume_usd
FROM
repayment_data rd
JOIN
price_data pd
ON
rd.token_symbol = pd.symbol;
Last run: 19 days ago
1
31B
7s