The ethereum.yields.pendle_market_interest_rates table provides detailed interest rate information for Pendle markets.

Interest Rate Tracking

The table captures key yield metrics:

  • implied_apy: Annualized percentage yield implied by current market prices
  • Market-specific rates for different yield tokens
  • Historical rate tracking with full blockchain context

Market Components

Each interest rate entry includes information about the market’s token components:

  1. Standardized Yield Tokens (SY)

    • standardized_yield_token: Contract address
    • sy_name: Human-readable name
  2. Yield Tokens (YT)

    • yield_token: Contract address
    • yt_name: Token name
  3. Principal Tokens (PT)

    • principal_token: Contract address
    • pt_name: Token name

Sample Query

Fetch market interest rates for market by contract address.

select * from ethereum.yields.pendle_market_interest_rates
where market = '0x9a63fa80b5ddfd3cab23803fdb93ad2c18f3d5aa' -- Pendle: PT Syrup USDC 28AUG2025 / SY Syrup USDC

Table Columns

Column NameDescription
marketAddress of the Pendle market (liquidity pool)
market_nameHuman-readable market name
implied_apyAnnualized percentage yield implied by market prices
block_timestampBlock timestamp
block_numberBlock number
block_hashBlock hash
transaction_hashTransaction hash
transaction_indexTransaction index in block
log_indexLog index in transaction
standardized_yield_tokenAddress of standardized yield token (SY)
sy_nameName of standardized yield token
yield_tokenAddress of yield token (YT)
yt_nameName of yield token
principal_tokenAddress of principal token (PT)
pt_nameName of principal token
unique_idUnique identifier for rate record
_created_atRecord creation timestamp
_updated_atLast update timestamp
_changed_since_full_refreshChange tracking flag