datavortexTop borrowers
    Updated 2025-01-21
    WITH BorrowerVolumes AS (
    SELECT
    sender_id,
    symbol,
    SUM(amount_usd) AS total_borrowed
    FROM
    near.defi.ez_lending
    WHERE
    symbol IN (
    'USDT',
    'USDt',
    'DAI',
    'FRAX',
    'USDT.e',
    'USDC.e',
    'USN'
    )
    AND actions IN ('borrow')
    AND amount_usd IS NOT NULL
    GROUP BY
    sender_id, symbol
    ),
    TopBorrowers AS (
    SELECT
    sender_id,
    SUM(total_borrowed) AS total_borrowed
    FROM
    BorrowerVolumes
    GROUP BY
    sender_id
    ORDER BY
    total_borrowed DESC
    LIMIT 10
    )
    SELECT
    tb.sender_id AS "Borrower",
    QueryRunArchived: QueryRun has been archived