datavortexmontly repayments
    Updated 2025-05-10
    SELECT
    DATE_TRUNC('month', block_timestamp) AS "Month",
    symbol AS "Stablecoin",
    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
    DATE_TRUNC('month', block_timestamp), symbol
    ORDER BY
    "Month", "Stablecoin";

    Last run: 11 days ago
    Month
    Stablecoin
    Total Repayment Transactions
    Total Repaid Volume
    Avg Repayment Amount
    1
    2022-03-01 00:00:00.000DAI103693.125220953369.312522095
    2
    2022-04-01 00:00:00.000DAI244874583097.234212630466.951484564
    3
    2022-05-01 00:00:00.000DAI218881042889.00147937039.711609451
    4
    2022-05-01 00:00:00.000USN3016165448.2839059220483.216890053
    5
    2022-06-01 00:00:00.000DAI100331330762.808575731237.051653615
    6
    2022-06-01 00:00:00.000USN46311260662.590806124321.0855093
    7
    2022-07-01 00:00:00.000DAI37815799639.38918741797.987802082
    8
    2022-07-01 00:00:00.000USN2184150742.4669011219040.103059179
    9
    2022-08-01 00:00:00.000DAI221783651.1166769583545.932654647
    10
    2022-08-01 00:00:00.000USN121144931.0268881571197.77708172
    11
    2022-09-01 00:00:00.000DAI80138287.4371150931728.592963939
    12
    2022-09-01 00:00:00.000USN117163840.47399541400.345931585
    13
    2022-10-01 00:00:00.000DAI1671972814.0765543411813.257943439
    14
    2022-10-01 00:00:00.000USN62213686.325397273446.55363544
    15
    2022-11-01 00:00:00.000DAI143150127.4258606351049.842138886
    16
    2022-11-01 00:00:00.000USN35112623.4449768193217.812713623
    17
    2022-12-01 00:00:00.000DAI111689.876628669153.625148061
    18
    2022-12-01 00:00:00.000USN97133.479065586792.608785065
    19
    2023-01-01 00:00:00.000DAI8310047.921839731121.059299274
    20
    2023-01-01 00:00:00.000USN127775.16277541647.930231284
    ...
    132
    9KB
    14s