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

# Markets

> Lighter market metadata

The `lighter.raw.markets` table contains market metadata for Lighter.

### Table Details

| Property          | Value  |
| ----------------- | ------ |
| Clustering Key(s) | (none) |

## Table Columns

| Column Name                        | Description                                             |
| ---------------------------------- | ------------------------------------------------------- |
| market\_id                         | Unique market identifier                                |
| symbol                             | Market symbol (e.g., BTC for perps, ETH/USDC for spots) |
| market\_type                       | 'perp' or 'spot'                                        |
| base\_asset\_id                    | Base asset ID                                           |
| base\_l1\_address                  | L1 contract address of base asset. NULL for perpetuals  |
| quote\_asset\_id                   | Quote asset ID                                          |
| base\_symbol                       | Base asset symbol                                       |
| quote\_symbol                      | Quote asset symbol                                      |
| collateral\_asset\_id              | Collateral asset ID for perpetuals                      |
| collateral\_symbol                 | Collateral asset symbol (e.g., USDC). NULL for spots    |
| status                             | Market status (e.g., 'active')                          |
| liquidation\_fee                   | Liquidation fee parameter                               |
| default\_initial\_margin\_fraction | Default initial margin fraction for perpetuals          |
| maintenance\_margin\_fraction      | Maintenance margin fraction for perpetuals              |
| closeout\_margin\_fraction         | Closeout margin fraction for perpetuals                 |

## Sample Query

```sql theme={null}
SELECT
    market_id,
    symbol,
    market_type,
    base_symbol,
    quote_symbol,
    collateral_symbol
FROM lighter.raw.markets
ORDER BY market_id
```