Sbhn_NPPolygon Debt
Updated 2022-08-10Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
SELECT
CASE WHEN address_name is null THEN a.debt_token_symbol ELSE address_name END as token,
sum(debt_to_cover_amount_usd) as debt_usd,
count(*) as events
FROM flipside_prod_db.aave.liquidations a
left outer JOIN polygon.core.dim_labels b
ON b.address = a.debt_token_symbol
WHERE borrower LIKE lower('{{User}}')
and token is not null
GROUP BY 1
ORDER BY 2 DESC
LIMIT 10
Run a query to Download Data