Lending
Our tables track user positions, pool data, and specific lending-related events.
Last updated
Our tables track user positions, pool data, and specific lending-related events.
Last updated
Key Tables:
Pools: Contains information about different lending pools, including the token types, interest rates, and liquidity.
Position Snapshot: Snapshot of user positions in lending pools, including the amounts borrowed and supplied.
Pool Snapshot: Tracks the state of the pool over time, including Total Value Locked, fees earned, and interest rates.
Events: Tracks lending events like deposits, withdrawals, borrowing, and repayments.
Liquidations: Tracks liquidation events.
| Property | Description | Type |
|---|---|---|
| Property | Description | Type |
|---|---|---|
| Property | Description | Type |
|---|---|---|
| Property | Description | Type |
|---|---|---|
chain_id
The standard id of the chain.
number
creation_block_number
The block this pool was created in.
number
timestamp
The timestamp of the block that this pool was created in.
number
underlying_token_address
The contract address of the underlying token.
string
underlying_token_symbol
The symbol of the underlying token.
string
receipt_token_address
The contract address of the receipt token.
string
receipt_token_symbol
The symbol of the receipt token.
string
pool_address
The contract address of the pool.
string
pool_type
The type of the pool (collateral_only, isolated, supply_pool, cdp).
string
timestamp
The timestamp of the snapshot.
number
block_date
The timestamp truncated (ie, YYYY-MM-DD format for daily snapshots and YYYY-MM-DD HH:00:00 for hourly snapshots).
date
chain_id
The standard id of the chain.
number
pool_address
The contract address of the pool.
string
underlying_token_address
The contract address of the underlying token.
string
underlying_token_symbol
The symbol of the underlying token.
string
user_address
The address of the user who has the position.
string
supplied_amount
The amount supplied by the user in the underlying token, decimal normalized.
number
supplied_amount_usd
(Optional) The supplied amount in USD.
number
borrowed_amount
The amount borrowed by the user in the underlying token, decimal normalized.
number
borrowed_amount_usd
(Optional) The borrowed amount in USD.
number
collateral_amount
(Optional) The amount of collateral-only tokens of this asset, decimal normalized.
number
collateral_amount_usd
(Optional) The amount of collateral-only tokens in USD.
number
timestamp
The timestamp of the snapshot.
number
block_date
The timestamp truncated (ie, YYYY-MM-DD format for daily snapshots and YYYY-MM-DD HH:00:00 for hourly snapshots).
date
chain_id
The standard id of the chain.
number
pool_address
The contract address of the pool.
string
underlying_token_address
The contract address of the underlying token.
string
underlying_token_symbol
The symbol of the underlying token.
string
underlying_token_price_usd
(Optional) The token price of the underlying asset in USD.
number
available_amount
The amount of token's available to borrow (liquidity or net supply or supply - borrow).
number
available_amount_usd
(Optional) The available amount of token's in this pool in USD.
number
supplied_amount
The total amount of the underlying token supplied in this pool, decimal normalized.
number
supplied_amount_usd
(Optional) The supplied amount in USD.
number
collateral_amount
(Optional) The amount of collateral only tokens in this pool.
number
collateral_amount_usd
(Optional) The amount of collateral only tokens in the pool.
number
collateral_factor
The collateral factor of the pool (defined as a decimal percentage, between 0-100).
number
supply_index
The supply index of the pool.
number
supply_apr
The current annual percentage rate for supplied amount, as a decimal percentage.
number
borrowed_amount
The amount of underlying tokens borrowed from this pool in the underlying token, decimal normalized.
number
borrowed_amount_usd
(Optional) The borrowed amount in USD.
number
borrow_index
The borrow index of the pool.
number
borrow_apr
The current annual percentage rate for borrow, as a decimal percentage.
number
total_fees_usd
(Optional) The total revenue or fees accrued in this pool during the given snapshot period (ie, user_fees_usd + protocol_fees_usd = total_fees_usd).
number
user_fees_usd
(Optional) The portion of total revenue or fees accrued to users of the protocol during the given snapshot period.
number
protocol_fees_usd
(Optional) The portion of total revenue or fees accrued to protocol during the given snapshot period.
number
timestamp
The timestamp of the transaction.
number
chain_id
The standard id of the chain.
number
block_number
The block number of the trade.
number
log_index
The event log. For transactions that don't emit event, create arbitrary index starting from 0.
number
transaction_hash
The hash of the transaction.
string
user_address
The address that initiates the transaction (ie, the transaction signer).
string
taker_address
The address that receives the output of the event (ie, account that receives aTokens in an Aave Deposit).
string
pool_address
The contract address of the pool.
string
token_address
The address of the underlying token that was interacted with (ie, USDC and not aUSDC in Aave).
string
amount
The amount of token_address transacted, decimal normalized.
number
amount_usd
The amount of token_address transacted, in USD.
number
event_type
The type of lending event, corresponds to the action taken by the user (ie, deposit, withdrawal, borrow, repay, liquidation, flashloan).
string
timestamp
The timestamp of the transaction.
number
chain_id
The standard id of the chain.
number
block_number
The block number of the trade.
number
log_index
The event log. For transactions that don't emit event, create arbitrary index starting from 0.
number
transaction_hash
The hash of the transaction.
string
liquidator_address
The address that initiates the liquidation.
string
user_address
The address that was liquidated.
string
pool_address
The contract address of the pool.
string
token_address
The address of the underlying token that was repaid by the liquidator (ie, USDC and not aUSDC in Aave).
string
amount
The amount of token_address transacted, decimal normalized.
number
amount_usd
The amount of token_address transacted, in USD.
number
profit_usd
The amount of profit the liquidator made from liquidating user_address (can be negative).
number