The ethereum.yields.pendle_asset_prices_hourly table provides hourly price and exchange rate data for all Pendle market tokens, including LP tokens, Principal Tokens (PT), Yield Tokens (YT), and Standardized Yield Tokens (SY).

This data is fetched directly from Pendle’s on-chain oracle contracts. Note that all not Pendle assets may have corresponding USD pricing.

Exchange Rates

The table tracks multiple exchange rates for accurate price derivation:

  1. LP Token Rates

    • lp_to_asset_rate: Conversion rate between LP tokens and underlying assets
    • lp_price_usd: USD value of LP tokens
  2. Principal Token Rates

    • pt_to_asset_rate: PT to underlying asset conversion
    • pt_to_sy_rate: PT to standardized yield token conversion
    • pt_price_usd: USD value of principal tokens
  3. Yield Token Rates

    • yt_to_asset_rate: YT to underlying asset conversion
    • yt_price_usd: USD value of yield tokens
  4. Standardized Yield Rates

    • sy_price_usd: USD value of standardized yield tokens

Table Columns

Column NameDescription
marketContract address of the pendle market/liquidity pool token
market_nameName of the market
timestampBlock timestamp when price was recorded
lp_to_asset_rateConversion rate between LP tokens and underlying assets
pt_to_asset_rateConversion rate between principal tokens and underlying assets
yt_to_asset_rateConversion rate between yield tokens and underlying assets
pt_to_sy_rateConversion rate between principal tokens and standardized yield tokens
lp_price_usdUSD price of LP tokens
pt_price_usdUSD price of principal tokens
yt_price_usdUSD price of yield tokens
sy_price_usdUSD price of standardized yield tokens
assetAddress of underlying asset
asset_decimalsDecimal precision of underlying asset
asset_nameName of underlying asset
asset_price_usdUSD price of underlying asset
asset_yield_tokenAddress of yield token for underlying asset
asset_yield_token_nameName of yield token for underlying asset
asset_yield_token_decimalsDecimal precision of yield token
syAddress of standardized yield token
sy_nameName of standardized yield token
sy_decimalsDecimal precision of standardized yield token
ytAddress of yield token
yt_nameName of yield token
yt_decimalsDecimal precision of yield token
ptAddress of principal token
pt_nameName of principal token
pt_decimalsDecimal precision of principal token
block_numberBlock number when oracle data was fetched
_prices_ingested_atTimestamp of price ingestion
_created_atRecord creation timestamp
_updated_atLast update timestamp
_changed_since_full_refreshChange tracking flag