Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| market | VARCHAR(16777216) | Contract address of the Pendle market. |
| market_name | VARCHAR(16777216) | Human-readable market name. |
| implied_apy | FLOAT | Implied annualized yield derived from the market’s PT/YT pricing. |
| standardized_yield_token | VARCHAR(16777216) | Address of the Standardized Yield (SY) token. |
| sy_name | VARCHAR(16777216) | Name of the standardized yield token. |
| yield_token | VARCHAR(16777216) | Address of the Yield Token (YT). |
| yt_name | VARCHAR(16777216) | Name of the yield token. |
| principal_token | VARCHAR(16777216) | Address of the Principal Token (PT). |
| pt_name | VARCHAR(16777216) | Name of the principal token. |
| transaction_hash | VARCHAR(66) | Hash of the transaction that produced this observation. |
| transaction_index | NUMBER(38,0) | Zero-based position of the transaction within its block. |
| log_index | NUMBER(38,0) | Zero-based position of the event log within its transaction. |
| block_timestamp | TIMESTAMP_NTZ(9) | Timestamp (UTC) of the block that contains this record. |
| block_number | NUMBER(38,0) | Number of the block that contains this record. |
| block_hash | VARCHAR(16777216) | Hash of the block that contains this record. |
| unique_id | VARCHAR(16777216) | Allium’s deterministic unique identifier for this row. |
| _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. |