> ## Documentation Index
> Fetch the complete documentation index at: https://docs.allium.so/llms.txt
> Use this file to discover all available pages before exploring further.

# Pendle Events

> Track yield trading activities and strategies in Pendle markets

The `yields.pendle_events` table captures yield trading activities from Pendle's router contracts, providing detailed information about different yield management strategies and their execution. Events are mapped to strategies: `long_yield` / `short_yield` (YT/PT swaps), `mint_pt_yt` / `redeem_pt_yt`, `mint_sy` / `redeem_sy`, and `add_liquidity` / `remove_liquidity`.

### Table Columns

| Column Name        | Data Type         | Description                                                                                                                                       |
| ------------------ | ----------------- | ------------------------------------------------------------------------------------------------------------------------------------------------- |
| strategy           | VARCHAR(16777216) | Type of yield strategy (long\_yield, short\_yield, mint\_pt\_yt, redeem\_pt\_yt, mint\_sy, redeem\_sy, add\_liquidity, remove\_liquidity).        |
| event\_name        | VARCHAR(16777216) | Name of the Pendle router event that produced this record.                                                                                        |
| receiver           | VARCHAR(16777216) | Address receiving tokens from the event.                                                                                                          |
| caller             | VARCHAR(16777216) | Address initiating the transaction.                                                                                                               |
| market             | VARCHAR(16777216) | Pendle market (liquidity pool) address.                                                                                                           |
| market\_name       | VARCHAR(16777216) | Human-readable market name.                                                                                                                       |
| lp\_amount\_str    | VARCHAR(16777216) | Amount of liquidity pool tokens, as a string to retain precision.                                                                                 |
| lp\_amount         | FLOAT             | Amount of liquidity pool tokens.                                                                                                                  |
| lp\_amount\_usd    | FLOAT             | USD value of the liquidity pool tokens.                                                                                                           |
| sy                 | VARCHAR(16777216) | Standardized yield token address.                                                                                                                 |
| sy\_name           | VARCHAR(16777216) | Name of the standardized yield token.                                                                                                             |
| sy\_amount\_str    | VARCHAR(16777216) | Amount of standardized yield tokens, as a string to retain precision.                                                                             |
| sy\_amount         | FLOAT             | Amount of standardized yield tokens.                                                                                                              |
| sy\_amount\_usd    | FLOAT             | USD value of the standardized yield tokens.                                                                                                       |
| pt                 | VARCHAR(16777216) | Principal token address.                                                                                                                          |
| pt\_name           | VARCHAR(16777216) | Name of the principal token.                                                                                                                      |
| pt\_amount\_str    | VARCHAR(16777216) | Amount of principal tokens, as a string to retain precision.                                                                                      |
| pt\_amount         | FLOAT             | Amount of principal tokens.                                                                                                                       |
| pt\_amount\_usd    | FLOAT             | USD value of the principal tokens.                                                                                                                |
| yt                 | VARCHAR(16777216) | Yield token address.                                                                                                                              |
| yt\_name           | VARCHAR(16777216) | Name of the yield token.                                                                                                                          |
| yt\_amount\_str    | VARCHAR(16777216) | Amount of yield tokens, as a string to retain precision.                                                                                          |
| yt\_amount         | FLOAT             | Amount of yield tokens.                                                                                                                           |
| yt\_amount\_usd    | FLOAT             | USD value of the yield tokens.                                                                                                                    |
| token              | VARCHAR(16777216) | Address of the token being swapped in or out.                                                                                                     |
| token\_name        | VARCHAR(16777216) | Name of the token being swapped.                                                                                                                  |
| token\_symbol      | VARCHAR(16777216) | Symbol of the token being swapped.                                                                                                                |
| token\_amount\_str | VARCHAR(16777216) | Amount of tokens being swapped, as a string to retain precision.                                                                                  |
| token\_amount      | FLOAT             | Amount of tokens being swapped.                                                                                                                   |
| token\_amount\_usd | FLOAT             | USD value of the swapped tokens.                                                                                                                  |
| usd\_amount        | FLOAT             | Total USD value of the event.                                                                                                                     |
| extra\_fields      | VARIANT           | JSON object containing additional fields from the onchain event that are not part of the standard schema.                                         |
| transaction\_hash  | VARCHAR(66)       | Hash of the transaction that produced this record. Uniquely identifies a transaction within the blockchain.                                       |
| transaction\_index | NUMBER(38,0)      | Zero-based position of the transaction within its block. The first transaction in a block has index 0.                                            |
| log\_index         | NUMBER(38,0)      | Zero-based position of this event log within its transaction. The first log emitted by a transaction has index 0.                                 |
| block\_timestamp   | TIMESTAMP\_NTZ(9) | Timestamp (UTC) of the block that contains this record.                                                                                           |
| block\_number      | NUMBER(38,0)      | Sequential number of the block that contains this record.                                                                                         |
| block\_hash        | VARCHAR(66)       | Cryptographic hash of the block header that contains this record. Uniquely identifies a block.                                                    |
| unique\_id         | VARCHAR(16777216) | Allium's deterministic unique identifier for this row, generated from the fields that uniquely identify the record. Stable across full refreshes. |
| \_created\_at      | TIMESTAMP\_NTZ(9) | Timestamp of when the entry was created in the database.                                                                                          |
| \_updated\_at      | TIMESTAMP\_NTZ(9) | Timestamp of when the entry was last updated in the database.                                                                                     |