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

> Individual Kalshi perpetual futures trades including price, size, and taker side.

The `common.perpetuals.kalshi_trades` table provides individual trade data from Kalshi perpetual markets. Each row represents a single trade with its market ticker, contract count, price, and taker side.

Use this table to analyze trading volume, price discovery, and order flow across Kalshi perps.

### Table Columns

**Data Notes:**

* `price` is per-contract in US dollars. A contract represents `contract_size` units of the underlying asset.
* `underlying_price` is the per-underlying-asset price (`price / contract_size`), e.g. a BTC perp `price` of 6.45 with `contract_size` 0.0001 is an `underlying_price` of \$64,500.
* `partition_date` is the event date of the trade (date of `created_time`).

Unique Key: `trade_id`

| Column Name       | Data Type         | Description                                                           |
| ----------------- | ----------------- | --------------------------------------------------------------------- |
| project           | VARCHAR           | Project identifier, always 'kalshi'.                                  |
| protocol          | VARCHAR           | Protocol identifier, always 'kalshi'.                                 |
| unique\_key       | VARCHAR           | Unique identifier for the trade (equal to trade\_id).                 |
| trade\_id         | VARCHAR           | Unique identifier for the trade.                                      |
| ticker            | VARCHAR           | Perp market ticker for this trade.                                    |
| created\_time     | TIMESTAMP\_NTZ(9) | Timestamp when the trade occurred.                                    |
| num\_contracts    | NUMBER(38,2)      | Number of contracts traded.                                           |
| price             | FLOAT             | Trade price in US dollars, per contract.                              |
| contract\_size    | FLOAT             | Units of the underlying asset represented by one contract.            |
| underlying\_price | FLOAT             | Price of the underlying asset in US dollars (price / contract\_size). |
| taker\_side       | VARCHAR           | Side taken by the taker.                                              |
| partition\_date   | DATE              | Event date of the trade (used for partitioning).                      |
| ingested\_at      | TIMESTAMP\_NTZ(9) | Timestamp the record was ingested into Allium's database.             |

***

### Sample Query

```sql theme={null}
select
  trade_id,
  ticker,
  created_time,
  num_contracts,
  price,
  contract_size,
  underlying_price,
  taker_side
from common.perpetuals.kalshi_trades
where partition_date >= current_date - interval '7 days'
order by created_time desc
limit 100
```