| market | VARCHAR(16777216) | Contract address of the pendle market/liquidity pool token. |
| market_name | VARCHAR(16777216) | Name of the market. |
| timestamp | TIMESTAMP_NTZ(9) | Block timestamp when the price was recorded. |
| lp_to_asset_rate | FLOAT | Conversion rate between LP tokens and underlying assets. |
| pt_to_asset_rate | FLOAT | Conversion rate between principal tokens and underlying assets. |
| yt_to_asset_rate | FLOAT | Conversion rate between yield tokens and underlying assets. |
| pt_to_sy_rate | FLOAT | Conversion rate between principal tokens and standardized yield tokens. |
| lp_price_usd | FLOAT | USD price of LP tokens. |
| pt_price_usd | FLOAT | USD price of principal tokens. |
| yt_price_usd | FLOAT | USD price of yield tokens. |
| sy_price_usd | FLOAT | USD price of standardized yield tokens. |
| asset | VARCHAR(16777216) | Address of the underlying asset. |
| asset_decimals | NUMBER(38,0) | Decimal precision of the underlying asset. |
| asset_name | VARCHAR(16777216) | Name of the underlying asset. |
| asset_price_usd | FLOAT | USD price of the underlying asset. |
| asset_yield_token | VARCHAR(16777216) | Address of the yield token for the underlying asset. |
| asset_yield_token_name | VARCHAR(16777216) | Name of the yield token for the underlying asset. |
| asset_yield_token_decimals | NUMBER(38,0) | Decimal precision of the yield token. |
| sy | VARCHAR(16777216) | Address of the standardized yield token. |
| sy_name | VARCHAR(16777216) | Name of the standardized yield token. |
| sy_decimals | NUMBER(38,0) | Decimal precision of the standardized yield token. |
| yt | VARCHAR(16777216) | Address of the yield token. |
| yt_name | VARCHAR(16777216) | Name of the yield token. |
| yt_decimals | NUMBER(38,0) | Decimal precision of the yield token. |
| pt | VARCHAR(16777216) | Address of the principal token. |
| pt_name | VARCHAR(16777216) | Name of the principal token. |
| pt_decimals | NUMBER(38,0) | Decimal precision of the principal token. |
| block_number | NUMBER(38,0) | Block number when the oracle data was fetched. |
| _prices_ingested_at | TIMESTAMP_NTZ(9) | Timestamp of price ingestion. |
| _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. |
