datavortexTop Users By repayment Volume
    Updated 9 hours ago
    SELECT
    sender_id AS "User",
    COUNT(DISTINCT tx_hash) AS "Total Repayment Transactions",
    SUM(amount_usd) AS "Total Repaid Volume",
    AVG(amount_usd) AS "Avg Repayment Amount"
    FROM
    near.defi.ez_lending
    WHERE
    symbol IN (
    'USDT',
    'USDt',
    'DAI',
    'FRAX',
    'USDT.e',
    'USDC.e',
    'USN'
    )
    AND actions IN ('repay')
    AND amount_usd IS NOT NULL
    GROUP BY
    sender_id
    ORDER BY
    "Total Repaid Volume" DESC
    LIMIT 10;

    Last run: about 9 hours ago
    User
    Total Repayment Transactions
    Total Repaid Volume
    Avg Repayment Amount
    1
    senlinear.near8341393329.5047234498714.813309921
    2
    nbiv.near2725313885.5890618937551.318113402
    3
    d879751c547c15bc6bca2c6823e388f3eb9f5b66650ff9f2885e6cb03b5e97e01221049819.37299591754151.61441632
    4
    b522c17b8fddc50a270eede8cef3a87ccac6a2e838b8e50ca2134086cddef1977419128835.8605126258497.781898819
    5
    b43dfe70c1a1418d3ea0edfd7dda5dc2ebd1f3b68517f0783b2c91f96e6587e51016332831.56986331633283.15698633
    6
    858de8addcda96c5dae4e6b212441c7de56de1e1138b176d9f651c2eb471198823814194004.986488159638.676413815
    7
    hellothere.near2211487122.0475132522141.911250602
    8
    a9619033e4961a601741e38f242cd7b6f27ab8fc0ac0c9a9746638e3f4fe75ed5710095189.6680272177108.590667144
    9
    v1.near727546816.6332787104816.897684426
    10
    ampr.near207214646.50633922360732.325316961
    10
    794B
    3s