Lending
Repayments
Lending
Repayments
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.
Table Columns
Unique Key: unique_id
| Column | Data Type | Description |
|---|---|---|
| project | VARCHAR | Name of the lending project |
| protocol | VARCHAR | Underlying protocol that the lending protocol is utilising |
| lending_event | VARCHAR | Type of lending event (always ‘repayments’ for this table) |
| event_name | VARCHAR | Name of the event |
| market_address | VARCHAR | Address of the lending market where the repayment occurred |
| borrower_address | VARCHAR | Address of the original borrower of the debt |
| repayer_address | VARCHAR | Address of the account repaying the debt (may be different from borrower) |
| token_address | VARCHAR | Address of the token being repaid |
| token_name | VARCHAR | Name of the token being repaid |
| token_symbol | VARCHAR | Symbol of the token being repaid |
| token_decimals | INTEGER | Number of decimals of the token |
| raw_amount_str | VARCHAR | Raw amount of tokens repaid, in string to retain precision |
| raw_amount | FLOAT | Raw amount of tokens repaid |
| amount_str | VARCHAR | Normalised amount of tokens repaid, in string to retain precision |
| amount | FLOAT | Normalised amount of tokens repaid |
| usd_amount | FLOAT | USD value of the tokens repaid at the time of the transaction |
| usd_exchange_rate | FLOAT | Hourly USD exchange rate of the token |
| debt_token_address | VARCHAR | Address of the debt token being repaid (if applicable for the protocol) |
| extra_fields | VARIANT | Additional protocol-specific fields from the event |
| transaction_hash | VARCHAR | Transaction hash of the repayment event |
| transaction_index | INTEGER | Index of the transaction in the block |
| transaction_from_address | VARCHAR | Address of the sender of the repayment transaction |
| transaction_to_address | VARCHAR | Address of the recipient of the repayment transaction |
| log_index | INTEGER | Index of the log in the transaction |
| topic0 | VARCHAR | Topic 0 of the event |
| block_number | INTEGER | Block number of the repayment event |
| block_timestamp | TIMESTAMP_NTZ(9) | Timestamp of the block |
| block_hash | VARCHAR | Hash of the block |
| unique_id | VARCHAR | Unique ID of the repayment event |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of when the event was created |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of when the event was last updated |