datavortexCollateralization Ratio by Platform
    Updated 2024-09-28
    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