Skip to content

Lending Market Updates

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


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


transaction_hash, log_index
block_number, log_index
__indexer_id WHERE __confirmed = false
__indexer_id, __block_number
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.