datavortexrepayments
    Updated 2025-01-21
    SELECT
    COUNT(DISTINCT sender_id) AS "repayer",
    COUNT(DISTINCT tx_hash) AS "Total Repay Transactions",
    SUM(amount_usd) AS "Total Repaid Volume",
    AVG(amount_usd) AS "Avg Repaid Amount"
    FROM
    near.defi.ez_lending
    WHERE
    symbol IN (
    'USDT',
    'USDt',
    'DAI',
    'FRAX',
    'USDT.e',
    'USDC.e',
    'USN'
    )
    AND actions = 'repay';

    QueryRunArchived: QueryRun has been archived