SELECT SYMBOL, SUM(AMOUNT_DEPOSITED) AS TotalDeposited

FROM ethereum.maker.ez_deposits

GROUP BY SYMBOL

),

TokenLiquidations AS (

SELECT SYMBOL, SUM(NORMALIZED_STABLECOIN_DEBT) AS TotalLiquidated

FROM ethereum.maker.ez_liquidations

GROUP BY SYMBOL

SELECT D.SYMBOL, D.TotalDeposited, L.TotalLiquidated

FROM TokenDeposits D

JOIN TokenLiquidations L ON D.SYMBOL = L.SYMBOL

ORDER BY TOTALDEPOSITED DESC

limit 10;