<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.
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 |