The ethereum.yields.pendle_markets table serves as the foundational reference for all Pendle markets, providing essential metadata about markets and their associated tokens.

Market Structure

Each Pendle market consists of several token components:

  1. Market (LP) Token

    • market: Contract address of the liquidity pool
    • market_name: Human-readable market identifier
    • market_decimals: Decimal precision for LP token
  2. Standardized Yield Token (SY)

    • standardized_yield_token: Contract address
    • sy_name: Token name
    • sy_decimals: Decimal precision
  3. Principal Token (PT)

    • principal_token: Contract address
    • pt_name: Token name
    • pt_decimals: Decimal precision
  4. Yield Token (YT)

    • yield_token: Contract address
    • yt_name: Token name
    • yt_decimals: Decimal precision

Understanding Pendle Components

  • Standardized Yield (SY): Wrapped yield-bearing tokens standardized for use in Pendle
  • Principal Token (PT): Represents the right to the underlying asset at maturity
  • Yield Token (YT): Represents the yield-bearing portion of the asset
  • Market: Liquidity pool where these tokens can be traded

Usage Example

SELECT
    market_name,
    standardized_yield_token,
    principal_token,
    yield_token
FROM ethereum.yields.pendle_markets
WHERE market_name LIKE '%stETH%'

This query retrieves all stETH-based Pendle markets and their associated tokens.

Table Columns

Column NameDescription
marketContract address of the liquidity pool
market_nameHuman-readable market identifier
market_decimalsDecimal precision for LP token
standardized_yield_tokenContract address of standardized yield token
sy_nameName of standardized yield token
sy_decimalsDecimal precision of standardized yield token
principal_tokenContract address of principal token
pt_nameName of principal token
pt_decimalsDecimal precision of principal token
yield_tokenContract address of yield token
yt_nameName of yield token
yt_decimalsDecimal precision of yield token