| market_contract_factory | VARCHAR(16777216) | Address of the Pendle market factory that created this market. |
| market | VARCHAR(16777216) | Contract address of the Pendle market (liquidity pool token). |
| market_name | VARCHAR(16777216) | Human-readable market name. |
| market_decimals | NUMBER(38,0) | Decimal precision of the market LP token. |
| expiry | TIMESTAMP_NTZ(9) | Maturity date of the market, after which PT can be redeemed 1:1 for the underlying. |
| standardized_yield_token | VARCHAR(16777216) | Address of the Standardized Yield (SY) token. |
| sy_name | VARCHAR(16777216) | Name of the standardized yield token. |
| sy_symbol | VARCHAR(16777216) | Symbol of the standardized yield token. |
| sy_decimals | NUMBER(38,0) | Decimal precision of the standardized yield token. |
| yield_token | VARCHAR(16777216) | Address of the Yield Token (YT). |
| yt_name | VARCHAR(16777216) | Name of the yield token. |
| yt_symbol | VARCHAR(16777216) | Symbol of the yield token. |
| yt_decimals | NUMBER(38,0) | Decimal precision of the yield token. |
| principal_token | VARCHAR(16777216) | Address of the Principal Token (PT). |
| pt_name | VARCHAR(16777216) | Name of the principal token. |
| pt_symbol | VARCHAR(16777216) | Symbol of the principal token. |
| pt_decimals | NUMBER(38,0) | Decimal precision of the principal token. |
| scalar_root | NUMBER(38,0) | AMM scalar root parameter set at market creation, controlling the interest rate range. |
| initial_anchor | NUMBER(38,0) | AMM initial anchor rate parameter set at market creation. |
| lnfee_rate_root | NUMBER(38,0) | Natural log of the market’s fee rate parameter set at market creation. |
| transaction_hash | VARCHAR(16777216) | Hash of the market-creation transaction. |
| transaction_index | NUMBER(38,0) | Zero-based position of the transaction within its block. |
| log_index | NUMBER(38,0) | Zero-based position of the market-creation event log within its transaction. |
| block_timestamp | TIMESTAMP_NTZ(9) | Timestamp (UTC) of the block that contains the market creation. |
| block_number | NUMBER(38,0) | Number of the block that contains the market creation. |
| block_hash | VARCHAR(16777216) | Hash of the block that contains the market creation. |
| is_pendle_verified | BOOLEAN | Whether the market is verified by Pendle. |
| _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. |
| _changed_since_full_refresh | BOOLEAN | Indicates if the record has changed since the last full data refresh. |
