Repayments

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

Last updated

Was this helpful?