Skip to content

Lending Events

The arbitrum.lending_events table provides indexed views for lending events based on 5 categories: deposit, borrow, repay, withdraw, and liquidation.

Columns

Name Type Description
account_address text The address that owns the lending position.
block_number integer The block number of the lending event.
category text The category of the lending event (deposit, withdraw, borrow, repay and liquidate).
contract_version text The version of the protocol market address.
liquidated_token_address text The borrowed token address that was repaid in a liquidation event.
liquidator_address text The address that liquidates the loan if the event is a liquidation.
log_index integer The log index of the lending event.
market_address text The address of the lending market contract.
metadata jsonb The metadata of the lending event.
protocol_name text The name of the protocol that facilitated the lending event.
quantity numeric The quantity of the token in the event (i.e. borrow events -> quantity borrowed, liquidation events -> collateral quantity liquidated).
quantity_liquidated numeric The quantity of the borrowed token repaid in a liquidation event.
sender_address text The address that sent the transaction.
timestamp timestamp without time zone The timestamp of the lending event.
token_address text The address of the token used in the lending event.
token_id bigint The NFT token id if the token_address in the lending event is an NFT.
transaction_hash text The transaction hash of the lending event.
__block_number integer The block number at which the event took place in.
__confirmed boolean Flag indicating whether the transfer has been confirmed.

Supported Protocols

Protocol
aave-v3 arbitrum-v1 ge-arb-usdc ge-gmx-usdc
ge-wbtc-usdc ge-weth-usdc granary-v1 halodao-arb
radiant-v1 radiant-v2 riz-gmx-usdc riz-grail-usdc
riz-pendle-usdc riz-rdnt-usdc roe-gmx-usdc roe-gmx-weth
roe-v1 stella-standard thetanuts-v3 zarban-v1

Indexes

Index
account_address, market_address, token_address, timestamp, log_index
protocol_name, timestamp, log_index
protocol_name, contract_version, timestamp, log_index
market_address, token_address, block_number, log_index
__indexer_id, __block_number
__indexer_id WHERE __confirmed = false
transaction_hash, log_index
timestamp, log_index
market_address, token_address, timestamp, 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.