flipside

    Top Borrowers by Total Borrowed Amount
    datavortexTop Borrowers by Total Borrowed Amount
    Updated 2025-04-16
    /*
    SELECT
    borrower,
    SUM(amount_usd) AS total_borrowed_usd
    FROM gnosis.defi.ez_lending_borrows
    WHERE amount_usd IS NOT NULL
    GROUP BY borrower
    HAVING SUM(amount_usd) > 1000
    ORDER BY total_borrowed_usd DESC
    LIMIT 10;
    */
    WITH borrow_data AS (
    SELECT
    borrower,
    amount,
    token_symbol
    FROM
    gnosis.defi.ez_lending_borrows
    WHERE
    amount IS NOT NULL
    ),
    price_data AS (
    SELECT
    symbol,
    MAX(price) AS max_price
    FROM
    gnosis.price.ez_prices_hourly
    GROUP BY
    symbol
    )

    SELECT
    bd.borrower,
    SUM(bd.amount * pd.max_price) AS total_borrowed_usd
    FROM
    borrow_data bd
    Last run: 24 days ago
    BORROWER
    TOTAL_BORROWED_USD
    1
    		0x65ae0ed283fa71fd0d22f13512d7e0bd9e54c14a28865630.9078064
    2
    		0x8f8888e07d5bf2c5f4f7c14ecef37cd6d49d458127839518.9448015
    3
    		0x2374da9a66e6321612fb9cca715359db1ae5ee8a27177282.6208188
    4
    		0xba89d61dd463c7d584a4a6c4645d4692abda28da23021680.8705022
    5
    		0x8d1d236f45a7decb769d88963b0f699cdbe5d83320533357.9811088
    6
    		0x402d130c64bca6aeeddda244687bd6111b06b31019559540.2572455
    7
    		0x7bfe60847e646edfd4846d2798cf1e6abc987f0617524336.4439544
    8
    		0xac5e7a21855222e7aa894dfb069b7f061c7fd61e16925576.7838113
    9
    		0x56babdb63d71879f8d77e2c9515060d3ae29cd9e15455678.6409627
    10
    		0x5ead411fc6c417689ebb1cf827f6169abf2feed812803627.5013554
    10
    641B
    7s