Repayments

Repayment events are payments made by borrowers to repay their debts.

The <chain>.lending.repayments table contains repayment events from Aave v1, v2, v3 and Compound v2 and v3 and Morpho Blue protocols, consolidated into a single table for easy querying.

This table tracks all debt repayment activities across major lending protocols, providing comprehensive information about repayment amounts, tokens, participants, and transaction details.

​

Sample Query

Total repayments of all lending projects on Ethereum in the past 90 days.

select
    project, 
    sum(usd_amount) as usd 
from ethereum.lending.repayments
where block_timestamp  >= current_date - 90
group by all
order by usd desc

Total repayments by token of Aave on Ethereum in the past 90 days.

select
    project, 
    token_address,
    token_name,
    token_symbol,
    sum(usd_amount) as usd 
from ethereum.lending.repayments
where project = 'aave'
and block_timestamp  >= current_date - 90
group by all
order by usd desc

​

Table Columns

Unique Key: unique_id