Can I use the API to download a single column from a data feed?
Note that each data feed on Nasdaq Data Link is delivered through one of the following Nasdaq Data Link APIs:
- Streaming API for real-time data
- REST API for real-time or delayed data
- REST API for time-series
- REST API for tables
You can learn more about these APIs and data formats here.
If you’re using the Streaming API for real-time data, you can use the filterstream operation to filter by symbols and/or msg types. If you are using the Java SDK, see example 10 here. If you are using the Python SDK, see example 10 here.
If you're using the REST API for time-series or tables, please see below:
Time-series
To download a single column from a time-series, use the column_index=n parameter, like this:
https://data.nasdaq.com/api/v3/datasets/XNAS/ACIW.csv?column_index=4&api_key=YOURAPIKEY
The above API call will return the close column (column 4) from the XNAS/ACIW time-series because column=4. Note that column 0 is the date column and is always returned. Data begins at column 1.
To see other parameters for individual time-series, please see the documentation here. To see other examples of API calls for time-series data, please see here.
Tables
To download a specific column from a table, use the qopts.columns= parameter, like this:
https://data.nasdaq.com/api/v3/datatables/SHARADAR/SEP.csv?qopts.columns=ticker&api_key=YOURAPIKEY
The above API call will return the ticker column from SHARADAR/SEP table because qopts.columns=ticker.
To see other parameters for tables, please see the documentation here. To see other examples of API calls for tables data, please see here.