mlhTop 5 borrowing pools for ethereum
    Updated 2022-07-09
    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