datavortexCollateralization Ratio by Platform
Updated 2024-09-28
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
WITH platform_stats AS (
SELECT
d.platform,
SUM(d.amount_usd) AS total_collateral_usd,
COALESCE(SUM(b.amount_usd), 0) AS total_borrowed_usd
FROM gnosis.defi.ez_lending_deposits d
LEFT JOIN gnosis.defi.ez_lending_borrows b ON d.platform = b.platform
WHERE d.amount_usd IS NOT NULL
GROUP BY d.platform
)
SELECT
platform,
total_collateral_usd,
total_borrowed_usd,
(CASE WHEN total_collateral_usd > 0 THEN total_borrowed_usd / total_collateral_usd ELSE 0 END) AS platform_collateralization_ratio
FROM platform_stats
WHERE total_collateral_usd > 0
ORDER BY total_collateral_usd DESC;
QueryRunArchived: QueryRun has been archived