TOKEN_SYMBOL | Repayment Count | Total Repaid Volume (USD) | |
|---|---|---|---|
1 | WXDAI | 47254 | 189423766.586823 |
2 | GNO | 5686 | 153745822.72932 |
3 | WETH | 5987 | 152434470.526102 |
4 | USDC | 3585 | 17915199.4346683 |
5 | FOX | 231 | 4639689.29783632 |
6 | LINK | 340 | 3627639.2116698 |
7 | WBTC | 178 | 3365262.5475786 |
8 | USDT | 435 | 2631889.54321419 |
datavortexTokens involved in payment
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 repayment_data AS (
SELECT
token_symbol,
tx_hash,
amount
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
rd.token_symbol,
COUNT(DISTINCT rd.tx_hash) AS "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
GROUP BY
rd.token_symbol
ORDER BY
"Total Repaid Volume (USD)" DESC,
"Repayment Count" DESC;
Last run: 23 days ago
8
242B
7s