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

> Market metadata and trading parameters.

The `lighter_robinhood.raw.markets` table contains market metadata and trading parameters.

## Table Columns

**Unique key:** `market_id`

| Column Name                       | Data Type          | Description                                                                      |
| --------------------------------- | ------------------ | -------------------------------------------------------------------------------- |
| `market_id`                       | `NUMBER(38,0)`     | Unique market identifier.                                                        |
| `symbol`                          | `VARCHAR`          | Market symbol (e.g., BTC for perps, ETH/USDG for spots).                         |
| `market_type`                     | `VARCHAR`          | 'perp' or 'spot'.                                                                |
| `base_asset_id`                   | `NUMBER(38,0)`     | Base asset ID.                                                                   |
| `base_l1_address`                 | `VARCHAR`          | L1 contract address of the base asset, when applicable.                          |
| `quote_asset_id`                  | `NUMBER(38,0)`     | Quote asset ID.                                                                  |
| `base_symbol`                     | `VARCHAR`          | Base asset symbol.                                                               |
| `quote_symbol`                    | `VARCHAR`          | Quote asset symbol.                                                              |
| `collateral_asset_id`             | `NUMBER(38,0)`     | Collateral asset ID for perpetuals.                                              |
| `collateral_symbol`               | `VARCHAR`          | Collateral asset symbol (for example, USDG). NULL for spots.                     |
| `status`                          | `VARCHAR`          | Market status, such as `active`.                                                 |
| `taker_fee`                       | `VARCHAR`          | Default taker fee setting for the market.                                        |
| `maker_fee`                       | `VARCHAR`          | Default maker fee setting for the market.                                        |
| `liquidation_fee`                 | `VARCHAR`          | Liquidation fee setting for the market.                                          |
| `min_base_amount`                 | `VARCHAR`          | Minimum order size in base asset units for this market.                          |
| `min_quote_amount`                | `VARCHAR`          | Minimum order size in quote asset units for this market.                         |
| `order_quote_limit`               | `VARCHAR`          | Maximum total quote value allowed per order for this market.                     |
| `supported_size_decimals`         | `NUMBER(38,0)`     | Supported decimal precision for order sizes in this market.                      |
| `supported_price_decimals`        | `NUMBER(38,0)`     | Supported decimal precision for prices in this market.                           |
| `supported_quote_decimals`        | `NUMBER(38,0)`     | Supported decimal precision for quote amounts in this market.                    |
| `size_decimals`                   | `NUMBER(38,0)`     | Number of decimal places used for size (quantity) representation in this market. |
| `price_decimals`                  | `NUMBER(38,0)`     | Number of decimal places used for price representation in this market.           |
| `quote_multiplier`                | `NUMBER(38,0)`     | Multiplier applied to quote asset amounts for this market's pricing.             |
| `default_initial_margin_fraction` | `NUMBER(38,0)`     | Default initial margin fraction for perpetuals.                                  |
| `min_initial_margin_fraction`     | `NUMBER(38,0)`     | Minimum initial margin fraction allowed for positions in this market.            |
| `maintenance_margin_fraction`     | `NUMBER(38,0)`     | Maintenance margin fraction for perpetuals.                                      |
| `closeout_margin_fraction`        | `NUMBER(38,0)`     | Closeout margin fraction for perpetuals.                                         |
| `_created_at`                     | `TIMESTAMP_NTZ(9)` | Timestamp when the row was first recorded.                                       |
| `_updated_at`                     | `TIMESTAMP_NTZ(9)` | Timestamp when the row was last updated.                                         |

### Sample Query

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