datavortexborrows
    Updated 12 hours ago
    SELECT
    symbol AS "Stablecoin",
    COUNT(DISTINCT sender_id) AS "Borrower",
    COUNT(DISTINCT tx_hash) AS "Total Borrow 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')
    GROUP BY
    symbol;

    Last run: about 12 hours ago
    Stablecoin
    Borrower
    Total Borrow Transactions
    Total Borrowed Volume
    Avg Borrowed Amount
    1
    FRAX448442425556320.21780315775.439597244
    2
    DAI90613584220265054.9274716215.03643459
    3
    USDC.e16862105322717343.66553344818.100459286
    4
    USDt166421012178207047.2198998481.203465634
    5
    USDT.e12681330621380712.28336284562.678677628
    6
    USN330159022612993.09775216106.120439994
    6
    309B
    3s