> ## 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.

# Trades Enriched

> Enhanced Kalshi prediction market trades with comprehensive market metadata and categorization.

The `common.predictions.kalshi_trades_enriched` table provides enhanced trade data with comprehensive market metadata, categorization, event information, and settlement outcomes. This table extends the basic trades data with rich context about markets, questions, and resolution outcomes.

Use this table for advanced analytics, market research, category analysis, and outcome tracking across Kalshi prediction markets.

### Table Columns

**Data Precision Notes:**

* Prices are stored as floats on a 0-1 scale (e.g., 0.65 = \$0.65)
* Each contract is worth \$1 at settlement
* Includes all columns from the trades table plus market metadata

Unique Key: `trade_id`

| Column Name                        | Data Type         | Description                                           |
| ---------------------------------- | ----------------- | ----------------------------------------------------- |
| project                            | VARCHAR           | Project identifier, always 'kalshi'.                  |
| protocol                           | VARCHAR           | Protocol identifier, always 'kalshi'.                 |
| trade\_date                        | DATE              | Date of the trade (used for partitioning).            |
| created\_time                      | TIMESTAMP\_NTZ(9) | Timestamp when the trade was created.                 |
| trade\_id                          | VARCHAR           | Unique identifier for the trade.                      |
| ticker                             | VARCHAR           | Market ticker identifier for this trade.              |
| num\_contracts                     | NUMBER            | Number of contracts traded in this trade.             |
| taker\_side                        | VARCHAR           | Side taken by the taker (yes or no).                  |
| maker\_side                        | VARCHAR           | Side taken by the maker (opposite of taker\_side).    |
| yes\_price                         | FLOAT             | Price for "yes" outcome as a float (0-1 scale).       |
| no\_price                          | FLOAT             | Price for "no" outcome as a float (0-1 scale).        |
| taker\_price                       | FLOAT             | Price paid by the taker based on taker\_side.         |
| market\_event\_id                  | VARCHAR           | Event identifier for the market.                      |
| market\_name                       | VARCHAR           | Market name.                                          |
| market\_question                   | VARCHAR           | Market question text.                                 |
| market\_description                | VARCHAR           | Market description.                                   |
| market\_category                   | VARCHAR           | Market category classification.                       |
| market\_status                     | VARCHAR           | Current status of the market.                         |
| market\_start\_date                | TIMESTAMP\_NTZ(9) | Timestamp when the market opened for trading.         |
| market\_end\_date                  | TIMESTAMP\_NTZ(9) | Timestamp when the market closes for trading.         |
| market\_expected\_expiration\_time | TIMESTAMP\_NTZ(9) | Expected timestamp for market expiration.             |
| market\_expiration\_time           | TIMESTAMP\_NTZ(9) | Actual expiration timestamp of the market.            |
| market\_outcome                    | VARCHAR           | Market outcome resolution.                            |
| market\_resolved\_at               | TIMESTAMP\_NTZ(9) | Timestamp when the market was resolved.               |
| \_created\_at                      | TIMESTAMP\_NTZ(9) | Timestamp of the entry creation on Allium's database. |
| \_updated\_at                      | TIMESTAMP\_NTZ(9) | Timestamp of the entry update on Allium's database.   |

***