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

> Polymarket US executed trades.

The `common.predictions.polymarket_us_trades` table contains executed trades on Polymarket US. Each row is one trade.

### Table Columns

Unique Key: `unique_key`

| Column Name       | Data Type      | Description                                        |
| ----------------- | -------------- | -------------------------------------------------- |
| project           | VARCHAR        | Project name.                                      |
| protocol          | VARCHAR        | Protocol name.                                     |
| trade\_date       | DATE           | UTC calendar date of the trade.                    |
| session\_date     | DATE           | Exchange session date for the trade.               |
| trade\_timestamp  | TIMESTAMP\_NTZ | UTC timestamp of the trade.                        |
| transaction\_time | VARCHAR        | Trade timestamp in US Eastern time with offset.    |
| unique\_key       | VARCHAR        | Unique trade identifier.                           |
| slug              | VARCHAR        | Market slug identifier.                            |
| outcome\_1\_price | FLOAT          | Implied probability for outcome\_1 (0 to 1 scale). |
| outcome\_2\_price | FLOAT          | Implied probability for outcome\_2 (0 to 1 scale). |
| last\_quantity    | FLOAT          | Trade quantity in contracts.                       |
| fee\_usd          | FLOAT          | Trading fee in USD.                                |
| \_created\_at     | TIMESTAMP\_NTZ | Record creation timestamp.                         |
| \_updated\_at     | TIMESTAMP\_NTZ | Record update timestamp.                           |

***

### Sample Query

```sql theme={null}
SELECT
    trade_date,
    COUNT(*) AS num_trades,
    SUM(last_quantity) AS total_volume
FROM common.predictions.polymarket_us_trades
WHERE trade_date >= DATEADD(day, -7, CURRENT_DATE())
GROUP BY trade_date
ORDER BY trade_date DESC
```