> ## Documentation Index
> Fetch the complete documentation index at: https://docs.pinkfish.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# nasdaq

> Financial Data API

**Server path:** `/nasdaq` | **Type:** Application | **PCID required:** Yes

## Tools

| Tool                                                              | Description                              |
| ----------------------------------------------------------------- | ---------------------------------------- |
| [`nasdaq_get_database`](#nasdaq_get_database)                     | Get database metadata                    |
| [`nasdaq_get_dataset`](#nasdaq_get_dataset)                       | Get time-series dataset with data        |
| [`nasdaq_get_dataset_metadata`](#nasdaq_get_dataset_metadata)     | Get dataset metadata without data        |
| [`nasdaq_get_datatable`](#nasdaq_get_datatable)                   | Get datatable data                       |
| [`nasdaq_get_datatable_metadata`](#nasdaq_get_datatable_metadata) | Get datatable metadata                   |
| [`nasdaq_list_databases`](#nasdaq_list_databases)                 | List available databases                 |
| [`nasdaq_search_datasets`](#nasdaq_search_datasets)               | Search for datasets across all databases |

***

## nasdaq\_get\_database

Get database metadata

**Parameters:**

| Parameter       | Type   | Required | Default | Description                                                                     |
| --------------- | ------ | -------- | ------- | ------------------------------------------------------------------------------- |
| `database_code` | string | Yes      | —       | The unique code identifying the database (e.g. 'WIKI', 'FRED', 'EOD', 'ZILLOW') |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for the authenticated connection"
      },
      "database_code": {
        "type": "string",
        "description": "The unique code identifying the database (e.g. 'WIKI', 'FRED', 'EOD', 'ZILLOW')"
      }
    },
    "required": [
      "PCID",
      "database_code"
    ]
  }
  ```
</Expandable>

***

## nasdaq\_get\_dataset

Get time-series dataset with data

**Parameters:**

| Parameter       | Type    | Required | Default | Description                                                                                                                                                                                                                                       |
| --------------- | ------- | -------- | ------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `database_code` | string  | Yes      | —       | The database code (e.g. 'WIKI', 'FRED', 'EOD')                                                                                                                                                                                                    |
| `dataset_code`  | string  | Yes      | —       | The dataset code within the database (e.g. 'AAPL', 'GDP', 'MSFT')                                                                                                                                                                                 |
| `limit`         | integer | No       | —       | Number of rows to return (use with order to get first N or last N rows)                                                                                                                                                                           |
| `column_index`  | integer | No       | —       | Index of a single column to return (0-based, where 0 is always Date). Selects one column only.                                                                                                                                                    |
| `start_date`    | string  | No       | —       | Start date for filtering data (format: YYYY-MM-DD). Only rows on or after this date are returned.                                                                                                                                                 |
| `end_date`      | string  | No       | —       | End date for filtering data (format: YYYY-MM-DD). Only rows on or before this date are returned.                                                                                                                                                  |
| `order`         | string  | No       | —       | Sort order for returned data rows                                                                                                                                                                                                                 |
| `collapse`      | string  | No       | —       | Collapse data to a lower frequency. Returns the last observation for each period.                                                                                                                                                                 |
| `transform`     | string  | No       | —       | Apply a calculation to each data point before returning. 'diff' = row-on-row change, 'rdiff' = row-on-row percentage change, 'rdiff\_from' = latest value as percentage increment, 'cumul' = cumulative sum, 'normalize' = scale to start at 100. |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for the authenticated connection"
      },
      "database_code": {
        "type": "string",
        "description": "The database code (e.g. 'WIKI', 'FRED', 'EOD')"
      },
      "dataset_code": {
        "type": "string",
        "description": "The dataset code within the database (e.g. 'AAPL', 'GDP', 'MSFT')"
      },
      "limit": {
        "type": "integer",
        "description": "Number of rows to return (use with order to get first N or last N rows)"
      },
      "column_index": {
        "type": "integer",
        "description": "Index of a single column to return (0-based, where 0 is always Date). Selects one column only."
      },
      "start_date": {
        "type": "string",
        "description": "Start date for filtering data (format: YYYY-MM-DD). Only rows on or after this date are returned."
      },
      "end_date": {
        "type": "string",
        "description": "End date for filtering data (format: YYYY-MM-DD). Only rows on or before this date are returned."
      },
      "order": {
        "type": "string",
        "description": "Sort order for returned data rows",
        "enum": [
          "asc",
          "desc"
        ]
      },
      "collapse": {
        "type": "string",
        "description": "Collapse data to a lower frequency. Returns the last observation for each period.",
        "enum": [
          "daily",
          "weekly",
          "monthly",
          "quarterly",
          "annual"
        ]
      },
      "transform": {
        "type": "string",
        "description": "Apply a calculation to each data point before returning. 'diff' = row-on-row change, 'rdiff' = row-on-row percentage change, 'rdiff_from' = latest value as percentage increment, 'cumul' = cumulative sum, 'normalize' = scale to start at 100.",
        "enum": [
          "diff",
          "rdiff",
          "rdiff_from",
          "cumul",
          "normalize"
        ]
      }
    },
    "required": [
      "PCID",
      "database_code",
      "dataset_code"
    ]
  }
  ```
</Expandable>

***

## nasdaq\_get\_dataset\_metadata

Get dataset metadata without data

**Parameters:**

| Parameter       | Type   | Required | Default | Description                                                       |
| --------------- | ------ | -------- | ------- | ----------------------------------------------------------------- |
| `database_code` | string | Yes      | —       | The database code (e.g. 'WIKI', 'FRED', 'EOD')                    |
| `dataset_code`  | string | Yes      | —       | The dataset code within the database (e.g. 'AAPL', 'GDP', 'MSFT') |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for the authenticated connection"
      },
      "database_code": {
        "type": "string",
        "description": "The database code (e.g. 'WIKI', 'FRED', 'EOD')"
      },
      "dataset_code": {
        "type": "string",
        "description": "The dataset code within the database (e.g. 'AAPL', 'GDP', 'MSFT')"
      }
    },
    "required": [
      "PCID",
      "database_code",
      "dataset_code"
    ]
  }
  ```
</Expandable>

***

## nasdaq\_get\_datatable

Get datatable data

**Parameters:**

| Parameter         | Type    | Required | Default | Description                                                                                               |
| ----------------- | ------- | -------- | ------- | --------------------------------------------------------------------------------------------------------- |
| `publisher`       | string  | Yes      | —       | The publisher/vendor code (e.g. 'ZACKS', 'SHARADAR', 'MER', 'NDAQ')                                       |
| `table`           | string  | Yes      | —       | The table code within the publisher (e.g. 'FC', 'SF1', 'F1', 'RTAT')                                      |
| `qopts.columns`   | string  | No       | —       | Comma-separated list of column names to return (e.g. 'ticker,date,close'). Omit to return all columns.    |
| `qopts.per_page`  | integer | No       | —       | Number of rows per page (max 10000)                                                                       |
| `qopts.cursor_id` | string  | No       | —       | Cursor for pagination. Use the next\_cursor\_id from a previous response to get the next page of results. |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for the authenticated connection"
      },
      "publisher": {
        "type": "string",
        "description": "The publisher/vendor code (e.g. 'ZACKS', 'SHARADAR', 'MER', 'NDAQ')"
      },
      "table": {
        "type": "string",
        "description": "The table code within the publisher (e.g. 'FC', 'SF1', 'F1', 'RTAT')"
      },
      "qopts.columns": {
        "type": "string",
        "description": "Comma-separated list of column names to return (e.g. 'ticker,date,close'). Omit to return all columns."
      },
      "qopts.per_page": {
        "type": "integer",
        "description": "Number of rows per page (max 10000)"
      },
      "qopts.cursor_id": {
        "type": "string",
        "description": "Cursor for pagination. Use the next_cursor_id from a previous response to get the next page of results."
      }
    },
    "required": [
      "PCID",
      "publisher",
      "table"
    ]
  }
  ```
</Expandable>

***

## nasdaq\_get\_datatable\_metadata

Get datatable metadata

**Parameters:**

| Parameter   | Type   | Required | Default | Description                                                          |
| ----------- | ------ | -------- | ------- | -------------------------------------------------------------------- |
| `publisher` | string | Yes      | —       | The publisher/vendor code (e.g. 'ZACKS', 'SHARADAR', 'MER', 'NDAQ')  |
| `table`     | string | Yes      | —       | The table code within the publisher (e.g. 'FC', 'SF1', 'F1', 'RTAT') |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for the authenticated connection"
      },
      "publisher": {
        "type": "string",
        "description": "The publisher/vendor code (e.g. 'ZACKS', 'SHARADAR', 'MER', 'NDAQ')"
      },
      "table": {
        "type": "string",
        "description": "The table code within the publisher (e.g. 'FC', 'SF1', 'F1', 'RTAT')"
      }
    },
    "required": [
      "PCID",
      "publisher",
      "table"
    ]
  }
  ```
</Expandable>

***

## nasdaq\_list\_databases

List available databases

**Parameters:**

| Parameter  | Type    | Required | Default | Description                                                                                    |
| ---------- | ------- | -------- | ------- | ---------------------------------------------------------------------------------------------- |
| `query`    | string  | No       | —       | Search query to filter databases by name or description (e.g. 'oil', 'housing', 'commodities') |
| `per_page` | integer | No       | —       | Number of results per page (default 100, max 100)                                              |
| `page`     | integer | No       | —       | Page number for pagination (starts at 1)                                                       |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for the authenticated connection"
      },
      "query": {
        "type": "string",
        "description": "Search query to filter databases by name or description (e.g. 'oil', 'housing', 'commodities')"
      },
      "per_page": {
        "type": "integer",
        "description": "Number of results per page (default 100, max 100)"
      },
      "page": {
        "type": "integer",
        "description": "Page number for pagination (starts at 1)"
      }
    },
    "required": [
      "PCID"
    ]
  }
  ```
</Expandable>

***

## nasdaq\_search\_datasets

Search for datasets across all databases

**Parameters:**

| Parameter       | Type    | Required | Default | Description                                                                          |
| --------------- | ------- | -------- | ------- | ------------------------------------------------------------------------------------ |
| `query`         | string  | Yes      | —       | Search query to find datasets (e.g. 'crude oil', 'apple stock', 'unemployment rate') |
| `database_code` | string  | No       | —       | Filter results to datasets within a specific database (e.g. 'WIKI', 'FRED')          |
| `per_page`      | integer | No       | —       | Number of results per page (default 100, max 100)                                    |
| `page`          | integer | No       | —       | Page number for pagination (starts at 1)                                             |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID for the authenticated connection"
      },
      "query": {
        "type": "string",
        "description": "Search query to find datasets (e.g. 'crude oil', 'apple stock', 'unemployment rate')"
      },
      "database_code": {
        "type": "string",
        "description": "Filter results to datasets within a specific database (e.g. 'WIKI', 'FRED')"
      },
      "per_page": {
        "type": "integer",
        "description": "Number of results per page (default 100, max 100)"
      },
      "page": {
        "type": "integer",
        "description": "Page number for pagination (starts at 1)"
      }
    },
    "required": [
      "PCID",
      "query"
    ]
  }
  ```
</Expandable>