Lending Market Updates
The ethereum.lending_market_updates table provides indexed views to fetch historical updates make to mutable data for lending markets. The table tracks changes to a market's Max ltv, liquidation_threshold, whether the market is active, and protocol specific changes tracked in metadata.
Columns
| Name | Type | Description |
|---|---|---|
| block_number | integer |
The block number the market address was updated at. |
| contract_version | text |
The version of the protocol's market address. |
| deposit_token_address | text |
The deposit token address associated with the market. |
| is_active | boolean |
Whether the market is active or not. |
| liquidation_threshold | numeric |
The liquidation threshold of the market. |
| log_index | integer |
The log index the market address was updated at. |
| ltv | numeric |
The loan to value ratio of the market. |
| market_address | text |
The market address that was updated. |
| metadata | json |
The metadata of the market. |
| protocol_name | text |
The protocol that the market address belongs to. |
| timestamp | timestamp without time zone |
The timestamp the market address was updated at. |
| transaction_hash | text |
The transaction hash the market address was updated at. |
| __block_number | integer |
The block number at which the event took place in. |
| __confirmed | boolean |
Flag indicating whether the transfer has been confirmed. |
| __last_modified | timestamp |
The date at which this row was last updated (in ISO-8601 format). |
Supported Protocols
| Protocol | |||
|---|---|---|---|
| aave-amm | aave-arc | aave-rwa | aave-v1 |
| aave-v2 | aave-v3 | compound-v2 | compound-v3 |
| cream-v1 | strike-v1 |
Indexes
| Index |
|---|
| transaction_hash, log_index |
| block_number, log_index |
| __last_modified |
| __indexer_id, __block_number |
| __indexer_id WHERE __confirmed = false |
| deposit_token_address, market_address, block_number, log_index |
Got questions? Join our Discord
Discord is the primary home of the Transpose developer community. Join us to ask questions, share your work, and get help.