mlhTop 5 borrowing pools for ethereum
Updated 2022-07-09Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
with borrow AS (
SELECT
LENDING_POOL_ADDRESS,
'Borrow' AS action,
SUM(AMOUNT_USD*0.3/100) AS fees_usd
FROM ethereum.sushi.ez_borrowing
WHERE BLOCK_TIMESTAMP > CURRENT_DATE() - INTERVAL'90 day'
GROUP BY 1
)
SELECT
case
when LENDING_POOL_ADDRESS = '0x6eafe077df3ad19ade1ce1abdf8bdf2133704f89' then 'Kashi Medium Risk SushiBar/USDC'
when LENDING_POOL_ADDRESS = '0x77f3a4fa35bac0ea6cfac69037ac4d3a757240a1' then 'Kashi Medium Risk SushiBar/Dai'
when LENDING_POOL_ADDRESS = '0xff7d29c7277d8a8850c473f0b71d7e5c4af45a50' then 'Kashi Medium Risk WETH/USDT'
when LENDING_POOL_ADDRESS = '0x5f92e4300024c447a103c161614e6918e794c764' then 'Kashi Medium Risk WETH/DAI'
when LENDING_POOL_ADDRESS = '0x418bc3ff0ba33ad64931160a91c92fa26b35acb0' then 'Kashi Medium Risk WBTC/DAI'
end as LENDING_POOL_ADDRESS,
SUM(fees_usd) AS total_fees
FROM borrow
GROUP BY 1
ORDER BY 2 DESC
LIMIT 6
Run a query to Download Data