USAGE
Get time-series data
This call returns data from a specified time-series.
Definition:
GET https://data.nasdaq.com/api/v3/datasets/{database_code}/{dataset_code}/data.{return_format}
Example Request:
curl "https://data.nasdaq.com/api/v3/datasets/WIKI/FB/data.json?api_key=YOURAPIKEY"
curl "https://data.nasdaq.com/api/v3/datasets/WIKI/FB/data.xml?api_key=YOURAPIKEY"
curl "https://data.nasdaq.com/api/v3/datasets/WIKI/FB/data.csv?api_key=YOURAPIKEY"
Example Response:
{
"dataset_data":{
"limit":null,
"transform":null,
"column_index":null,
"column_names":[
"Date",
"Open",
"High",
"Low"
],
"start_date":"2015-05-24",
"end_date":"2015-05-28",
"frequency":"daily",
"data":[
[
"2015-05-28",
9.58,
10.17,
12.96
],
[
"2015-05-27",
9.53,
10.13,
12.97
],
[
"2015-05-26",
9.53,
10.11,
12.98
]
],
"collapse":null,
"order":"desc"
}
}
<?xml version="1.0" encoding="UTF-8"?>
<quandl-response>
<dataset-data>
<limit nil="true" />
<transform nil="true" />
<column-index nil="true" />
<column-names type="array">
<column-name>Date</column-name>
<column-name>Open</column-name>
<column-name>High</column-name>
<column-name>Low</column-name>
</column-names>
<start-date type="date">2015-05-24</start-date>
<end-date type="date">2015-05-28</end-date>
<frequency>daily</frequency>
<data type="array">
<datum type="array">
<datum type="date">2015-05-28</datum>
<datum type="float">9.58</datum>
<datum type="float">10.17</datum>
<datum type="float">12.97</datum>
</datum>
<datum type="array">
<datum type="date">2015-05-27</datum>
<datum type="float">9.53</datum>
<datum type="float">10.13</datum>
<datum type="float">12.97</datum>
</datum>
<datum type="array">
<datum type="date">2015-05-26</datum>
<datum type="float">9.53</datum>
<datum type="float">10.11</datum>
<datum type="float">12.98</datum>
</datum>
</data>
<collapse nil="true" />
<order>desc</order>
</dataset-data>
</quandl-response>
Date,Open,High,Low
2015-05-28,9.58,10.17,12.96
2015-05-27,9.53,10.13,12.97
2015-05-26,9.53,10.11,12.98
...
NOTE: For conciseness, only three data rows appear in the example response.
Get filtered time-series data
You can slice, transform and otherwise customize your time-series dataset prior to download by appending various optional parameters to your query.
Get monthly % changes in Facebook's closing price for the year 2014:
curl "https://data.nasdaq.com/api/v3/datasets/WIKI/FB.json?column_index=4&start_date=2014-01-01&end_date=2014-12-31&collapse=monthly&transform=rdiff&api_key=YOURAPIKEY"
curl "https://data.nasdaq.com/api/v3/datasets/WIKI/FB.xml?column_index=4&start_date=2014-01-01&end_date=2014-12-31&collapse=monthly&transform=rdiff&api_key=YOURAPIKEY"
curl "https://data.nasdaq.com/api/v3/datasets/WIKI/FB.csv?column_index=4&start_date=2014-01-01&end_date=2014-12-31&collapse=monthly&transform=rdiff&api_key=YOURAPIKEY
Get time-series metadata
The following metadata fields are available:
Metadata Field Name | Description | Example |
---|---|---|
dataset_code | The code for this time-series | FB |
database_code | The code for the database this time-series belongs to | EOD |
name | The name of this time-series | Facebook Inc (FB) stock price |
description | A brief description of this time-series | End-of-day stock price for Facebook Inc (FB) |
refreshed_at | The time at which the data and/or metadata of this time-series was most recently refreshed | 2015-07-31 17:46:36 UTC |
newest_available_date | The most recent date of all available data points in this time-series | 2015-07-31 |
oldest_available_date | The earliest date of all available data points in this time-series | 2012-04-16 |
column_names | The titles for each column in this time-series | [“Date”, “Open”,“High”,“Low”] |
frequency | The frequency of observations in the time-series | daily |
type | The type of data being returned | Time-series |
premium | Whether this time-series is premium | TRUE |
This call returns metadata for a specified time-series.
Definition:
GET https://data.nasdaq.com/api/v3/datasets/{database_code}/{dataset_code}/metadata.{return_format}
Example Request:
curl "https://data.nasdaq.com/api/v3/datasets/WIKI/FB/metadata.json?api_key=YOURAPIKEY"
curl "https://data.nasdaq.com/api/v3/datasets/WIKI/FB/metadata.xml?api_key=YOURAPIKEY"
curl "https://data.nasdaq.com/api/v3/datasets/WIKI/FB/metadata.csv?api_key=YOURAPIKEY"
Example Response:
id,dataset_code,database_code,name,description,refreshed_at, ...
9775409,FB,WIKI,Facebook Inc.(FB) Price,End of day price for Facebook ...
<?xml version="1.0" encoding="UTF-8"?>
<quandl-response>
<dataset>
<id type="integer">9775409</id>
<dataset-code>FB</dataset-code>
<database-code>WIKI</database-code>
<name>Facebook Inc. (FB) Price</name>
<description>End of day price for Facebook Inc.</description>
<refreshed-at type="dateTime">2015-07-31T17:46:36Z</refreshed-at>
<newest-available-date type="date">2015-08-01</newest-available-date>
<oldest-available-date type="date">2015-05-24</oldest-available-date>
<column-names type="array">
<column-name>Date</column-name>
<column-name>Open</column-name>
<column-name>High</column-name>
<column-name>Low</column-name>
</column-names>
<frequency>daily</frequency>
<type>Time Series</type>
<premium type="boolean">false</premium>
<database-id type="integer">4922</database-id>
</dataset>
</quandl-response>
`id,dataset_code,database_code,name,description,refreshed_at, ...
9775409,FB,WIKI,Facebook Inc.(FB) Price,End of day price for Facebook ...`
Get time-series data and metadata
This call returns data and metadata for a given time-series.
Definition:
GET https://data.nasdaq.com/api/v3/datasets/{database_code}/{dataset_code}.{return_format}
Example Request:
curl "https://data.nasdaq.com/api/v3/datasets/WIKI/FB.json?api_key=YOURAPIKEY"
curl "https://data.nasdaq.com/api/v3/datasets/WIKI/FB.xml?api_key=YOURAPIKEY"
This call is not available for CSV.
Example Response:
{
"dataset":{
"id":1,
"dataset_code":"FB",
"database_code":"WIKI",
"name":"Facebook Inc. (FB) stock price",
"description":"End of day open, high, low",
"refreshed_at":"2015-07-31T17:46:36.000Z",
"newest_available_date":"2015-08-01",
"oldest_available_date":"2015-05-24",
"column_names":[
"Date",
"Open",
"High",
"Low"
],
"frequency":"daily",
"type":"Time Series",
"premium":false,
"limit":null,
"transform":null,
"column_index":null,
"start_date":"2015-05-24",
"end_date":"2015-05-28",
"data":[
[
"2015-05-28",
9.58,
10.17,
12.96
],
[
"2015-05-27",
9.53,
10.13,
12.97
],
[
"2015-05-26",
9.526415957480097,
10.11017545854056,
12.982029225784581
]
],
"collapse":null,
"order":"desc",
"database_id":1
}
}
<?xml version="1.0" encoding="UTF-8"?>
<quandl-response>
<dataset>
<id type="integer">1</id>
<dataset-code>FB</dataset-code>
<database-code>WIKI</database-code>
<name>Facebook Inc. (FB)</name>
<description>End of day open, high, low</description>
<refreshed-at type="dateTime">2015-07-31T17:46:36Z</refreshed-at>
<newest-available-date type="date">2015-08-01</newest-available-date>
<oldest-available-date type="date">2015-05-24</oldest-available-date>
<column-names type="array">
<column-name>Date</column-name>
<column-name>Open</column-name>
<column-name>High</column-name>
<column-name>Low</column-name>
</column-names>
<frequency>daily</frequency>
<type>Time Series</type>
<premium type="boolean">false</premium>
<limit nil="true" />
<transform nil="true" />
<column-index nil="true" />
<start-date type="date">2015-05-24</start-date>
<end-date type="date">2015-05-28</end-date>
<data type="array">
<datum type="array">
<datum type="date">2015-05-28</datum>
<datum type="float">9.58</datum>
<datum type="float">10.17</datum>
<datum type="float">12.97</datum>
</datum>
<datum type="array">
<datum type="date">2015-05-27</datum>
<datum type="float">9.53</datum>
<datum type="float">10.13</datum>
<datum type="float">12.97</datum>
</datum>
<datum type="array">
<datum type="date">2015-05-26</datum>
<datum type="float">9.53</datum>
<datum type="float">10.11</datum>
<datum type="float">12.98</datum>
</datum>
</data>
<collapse nil="true" />
<order>desc</order>
<database-id type="integer">1</database-id>
</dataset>
</quandl-response>
This call is not available for CSV.
NOTE: For conciseness, only 3 data rows are shown in the example response.
Get metadata for a time-series database
You can retrieve metadata for a specified time-series database. This call will return the following metadata fields:
Metadata Fields
Field Name | Description | Example |
---|---|---|
id | Numerical identifier for the database | 4922 |
name | The name of the database | WIKI EOD Stock Prices |
database_code | A short code for the database | WIKI |
description | A description of the database | End of day stock prices, dividends, splits … |
datasets_count | The number of distinct time-series datasets in the database | 3179 |
downloads | The number of times a time-series from this database has been downloaded | 186,209,776 |
premium | Whether this time-series database is premium | false |
image | A link to the database logo | https://cdn.example.com/path/to/image/resource.jpeg |
Definition:
GET https://data.nasdaq.com/api/v3/databases/{database_code}.{return_format}
Example Request:
curl "https://data.nasdaq.com/api/v3/databases/WIKI.json?api_key=YOURAPIKEY"
curl "https://data.nasdaq.com/api/v3/databases/WIKI.xml?api_key=YOURAPIKEY"
curl "https://data.nasdaq.com/api/v3/databases/WIKI.csv?api_key=YOURAPIKEY"
Example Response:
{
"database":{
"id":4922,
"database_code":"WIKI",
"name":"Wiki EOD Stock Prices",
"description":"End of day stock prices, dividends and splits for 30000 US companies curated by our community and released into the public domain.",
"datasets_count":3179,
"downloads":186224033,
"premium":false,
"image":"https://cdn.example.com/path/to/image/resource.jpg"
}
}
<?xml version="1.0" encoding="UTF-8"?>
<quandl-response>
<database>
<id type="integer">4922</id>
<name>Wiki EOD Stock Prices</name>
<database-code>WIKI</database-code>
<description>End of day stock prices, dividends and splits for 30000 US companies curated by our community and released into the public domain.</description>
<datasets_count type="integer">3179</datasets_count>
<downloads type="integer">186224033</downloads>
<premium type="boolean">false</premium>
<image>https://cdn.example.com/path/to/image/resource.jpeg</image>
</database>
</quandl-response>
id,name,database_code,description, ...
4922,WIKI EOD Stock Prices,WIKI,End of day stock prices ...
Get an entire time-series dataset
Our time-series API provides users the functionality to download an entire time-series dataset in a single call.
This method has two restrictions:
- This method is not available for free datasets, only premium data products.
- This method is only available for subscribers of the premium data product they wish to download.
Irrespective of whether you call this method through the API, R or Python, the output format is always the same: a single zipped CSV file of the entire database. The first column of this CSV is the time-series code; the remaining columns replicate the columns of individual datasets.
Definition:
GET https://data.nasdaq.com/api/v3/databases/{database_code}/data?download_type=full
Example Request:
curl "https://data.nasdaq.com/api/v3/databases/SCF/data?download_type=full&api_key=YOURAPIKEY"
Example Response:
Code,Date,Open,High,Low,Settle,Volume,Prev. Day Open Interest
CME_BO2_ON,2017-03-08,34,34.26,33.67,33.81,29655,94232
CME_BO2_ON,2017-03-07,34.57,34.59,33.67,34,24918,94861
CME_BO2_ON,2017-03-06,34.72,34.87,34.31,34.54,14414,95369
CME_BO2_ON,2017-03-03,34.45,34.71,34.11,34.65,17931,94905
...
In addition to functionality to download the entire dataset, the Time-series API also provides functionality to download a partial file, which includes only the latest available observation for each time-series in the dataset.
This functionality has the same restrictions as outlined above in that it only works for premium data products.
Definition:
GET https://data.nasdaq.com/api/v3/databases/{database_code}/data?download_type=partial
Example Request:
curl "https://data.nasdaq.com/api/v3/databases/SCF/data?download_type=partial&api_key=YOURAPIKEY"
Example Response:
Code,Date,Open,High,Low,Settle,Volume,Prev. Day Open Interest
CBOE_VX1_EB,2017-03-07,12.68,12.83,12.3,12.625,109144,220290
CBOE_VX1_FB,2017-03-07,14.45,14.55,14.2,14.475,78084,211657
CBOE_VX1_OB,2017-03-07,12.68,12.83,12.3,12.625,109144,220290
CBOE_VX2_EF,2017-03-07,-69.03,-68.93,-69.28,-69.005,78084,211657
...
Updated 8 months ago