Updated 8 hours ago
    SELECT
    COUNT(DISTINCT sender_id) AS "borrower",
    COUNT(DISTINCT tx_hash) AS "Total borrows transactions",
    SUM(amount_usd) AS "Total borrowed Volume",
    AVG(amount_usd) AS "avg borrowed amount"
    FROM
    near.defi.ez_lending
    WHERE
    symbol IN (
    'USDT',
    'USDt',
    'DAI',
    'FRAX',
    'USDT.e',
    'USDC.e',
    'USN'
    )
    AND actions IN ('borrow')
    Last run: about 8 hours ago
    borrower
    Total borrows transactions
    Total borrowed Volume
    avg borrowed amount
    1
    454774969490739471.411829849.064171553
    1
    45B
    11s