Pendle Events

The ethereum.yields.pendle_events table captures all yield trading activities from Pendle’s Router V4 contract, providing detailed information about different yield management strategies and their execution.

​

Strategy Types

Events are mapped to specific strategies based on the type of operation:

1. Yield Position Strategies

   • long_yield: Buying YT or selling PT
   • short_yield: Selling YT or buying PT

2. Token Management

   • mint_pt_yt: Minting principal and yield tokens
   • redeem_pt_yt: Redeeming principal and yield tokens
   • mint_sy: Minting standardized yield tokens
   • redeem_sy: Redeeming standardized yield tokens

3. Liquidity Operations

   • add_liquidity: Adding tokens to markets
   • remove_liquidity: Removing tokens from markets

​

Strategy Mapping Logic

The strategy field is determined by the following rules:

​

Usage Example

This query fetches the strategies that have been used in a market.

select
  date(block_timestamp) as date,
  strategy, 
  sum(usd_amount) as usd 
from ethereum.yields.pendle_events
where market = '0x9a63fa80b5ddfd3cab23803fdb93ad2c18f3d5aa'
group by all
order by 1 desc

This query finds the largest yield trading positions in the last 30 days.

​

Table Columns