📘
NOTE:
The data returned by the Tables API is unsorted by default. Data sorting must be done locally.

Filter Rows

It is possible to download only certain desired rows from a table, by specifying one or more columns to act as criteria to filter rows. If the value in a given column matches the filter argument, then the row containing that value is returned.

Only columns designated as filterable in the table's documentation page can be used as criteria to filter rows.

The filter examples below all involve the ETFG/FUND table. This particular table is filterable on columns date, ticker, shares_oustanding, nav and flow_daily. This means that users can narrow down their request to rows with specific values of date, ticker, shares_oustanding, nav and flow_daily.

Definition:
GET https://data.nasdaq.com/api/v3/datatables/{datatable_code}.{format}?<row_filter_criteria>

Example Request:

curl "https://data.nasdaq.com/api/v3/datatables/ETFG/FUND.json?ticker=SPY&api_key=YOURAPIKEY"

curl "https://data.nasdaq.com/api/v3/datatables/ETFG/FUND.xml?ticker=SPY&api_key=YOURAPIKEY"

curl "https://data.nasdaq.com/api/v3/datatables/ETFG/FUND.csv?ticker=SPY&api_key=YOURAPIKEY"

The above request returns those rows from the "ETFG/FUND" table whose "ticker" column has a value of "SPY".

Example Response:

{
"datatable": {
"data": [
[
"2014-01-02",
"SPY",
955782116,
182.935913,
1531700525.6
],
[
"2014-01-03",
"SPY",
952482116,
182.879181,
-603688512.9
],
[
"2014-01-06",
"SPY",
954182116,
182.422859,
310894607.7
],
[
"2014-01-07",
"SPY",
947882116,
183.533158,
-1149264011.7
],
[
"2014-01-08",
"SPY",
944682116,
183.548301,
-587306105.6
],
[
"2014-01-09",
"SPY",
943932116,
183.611559,
-137661225.75
],
[
"2014-01-10",
"SPY",
940882116,
184.034274,
-560015254.95
],
[
"2014-01-13",
"SPY",
943432116,
181.74065,
469287398.7
],
[
"2014-01-14",
"SPY",
936482116,
183.705563,
-1263097517.5
],
[
"2014-01-15",
"SPY",
936532116,
184.657834,
9185278.15
],
[
"2014-01-16",
"SPY",
933632116,
184.413998,
-535507718.6
],
[
"2014-01-17",
"SPY",
927732116,
183.697407,
-1088042588.2
]
],
"columns": [
{
"name": "date",
"type": "Date"
},
{
"name": "ticker",
"type": "String"
},
{
"name": "shares_outstanding",
"type": "BigDecimal(36,14)"
},
{
"name": "nav",
"type": "BigDecimal(36,14)"
},
{
"name": "flow_daily",
"type": "BigDecimal(36,14)"
}
]
},
"meta": {
"next_cursor_id": null

<quandl-response>
<datatable>
<data type="array">
<datum type="array">
<datum type="date">2014-01-02</datum>
<datum>SPY</datum>
<datum type="float">955782116.0</datum>
<datum type="float">182.935913</datum>
<datum type="float">1531700525.6</datum>
</datum>
<datum type="array">
<datum type="date">2014-01-03</datum>
<datum>SPY</datum>
<datum type="float">952482116.0</datum>
<datum type="float">182.879181</datum>
<datum type="float">-603688512.9</datum>
</datum>
<datum type="array">
<datum type="date">2014-01-06</datum>
<datum>SPY</datum>
<datum type="float">954182116.0</datum>
<datum type="float">182.422859</datum>
<datum type="float">310894607.7</datum>
</datum>
<datum type="array">
<datum type="date">2014-01-07</datum>
<datum>SPY</datum>
<datum type="float">947882116.0</datum>
<datum type="float">183.533158</datum>
<datum type="float">-1149264011.7</datum>
</datum>
<datum type="array">
<datum type="date">2014-01-08</datum>
<datum>SPY</datum>
<datum type="float">944682116.0</datum>
<datum type="float">183.548301</datum>
<datum type="float">-587306105.6</datum>
</datum>
<datum type="array">
<datum type="date">2014-01-09</datum>
<datum>SPY</datum>
<datum type="float">943932116.0</datum>
<datum type="float">183.611559</datum>
<datum type="float">-137661225.75</datum>
</datum>
<datum type="array">
<datum type="date">2014-01-10</datum>
<datum>SPY</datum>
<datum type="float">940882116.0</datum>
<datum type="float">184.034274</datum>
<datum type="float">-560015254.95</datum>
</datum>
<datum type="array">
<datum type="date">2014-01-13</datum>
<datum>SPY</datum>
<datum type="float">943432116.0</datum>
<datum type="float">181.74065</datum>
<datum type="float">469287398.7</datum>
</datum>
<datum type="array">
<datum type="date">2014-01-14</datum>
<datum>SPY</datum>
<datum type="float">936482116.0</datum>
<datum type="float">183.705563</datum>
<datum type="float">-1263097517.5</datum>
</datum>
<datum type="array">
<datum type="date">2014-01-15</datum>
<datum>SPY</datum>
<datum type="float">936532116.0</datum>
<datum type="float">184.657834</datum>
<datum type="float">9185278.15</datum>
</datum>
<datum type="array">
<datum type="date">2014-01-16</datum>
<datum>SPY</datum>
<datum type="float">933632116.0</datum>
<datum type="float">184.413998</datum>
<datum type="float">-535507718.6</datum>
</datum>
<datum type="array">
<datum type="date">2014-01-17</datum>
<datum>SPY</datum>
<datum type="float">927732116.0</datum>
<datum type="float">183.697407</datum>
<datum type="float">-1088042588.2</datum>
</datum>
</data>
<columns type="array">
<column>
<name>date</name>
<type>Date</type>
</column>
<column>
<name>ticker</name>
<type>String</type>
</column>
<column>
<name>shares_outstanding</name>
<type>BigDecimal(36,14)</type>
</column>
<column>
<name>nav</name>
<type>BigDecimal(36,14)</type>
</column>
<column>
<name>flow_daily</name>
<type>BigDecimal(36,14)</type>
</column>
</columns>
</datatable>
<meta>
<next-cursor-id nil="true"/>
</meta>
</quandl-response>

date,ticker,shares_outstanding,nav,flow_daily
2014-01-02,SPY,955782116.0,182.935913,1531700525.6
2014-01-03,SPY,952482116.0,182.879181,-603688512.9
2014-01-06,SPY,954182116.0,182.422859,310894607.7
2014-01-07,SPY,947882116.0,183.533158,-1149264011.7
2014-01-08,SPY,944682116.0,183.548301,-587306105.6
2014-01-09,SPY,943932116.0,183.611559,-137661225.75
2014-01-10,SPY,940882116.0,184.034274,-560015254.95
2014-01-13,SPY,943432116.0,181.74065,469287398.7
2014-01-14,SPY,936482116.0,183.705563,-1263097517.5
2014-01-15,SPY,936532116.0,184.657834,9185278.15
2014-01-16,SPY,933632116.0,184.413998,-535507718.6
2014-01-17,SPY,927732116.0,183.697407,-1088042588.2

Filter on Multiple Values

Example Request:

curl "https://data.nasdaq.com/api/v3/datatables/ETFG/FUND.json?ticker=SPY,IWM&api_key=YOURAPIKEY"

curl "https://data.nasdaq.com/api/v3/datatables/ETFG/FUND.xml?ticker=SPY,IWM&api_key=YOURAPIKEY"

curl "https://data.nasdaq.com/api/v3/datatables/ETFG/FUND.csv?ticker=SPY,IWM&api_key=YOURAPIKEY"

The above request returns rows where the "ticker" column has a value of either "SPY" or "IWM".

Example Response:

{
"datatable": {
"data": [
[
"2014-01-02",
"IWM",
244900000,
115.4367,
0
],
[
"2014-01-02",
"SPY",
955782116,
182.935913,
1531700525.6
],
[
"2014-01-03",
"IWM",
234550000,
114.1586,
-1194769845
],
[
"2014-01-03",
"SPY",
952482116,
182.879181,
-603688512.9
],
[
"2014-01-06",
"IWM",
233800000,
114.6915,
-85618950
],
[
"2014-01-06",
"SPY",
954182116,
182.422859,
310894607.7
],
[
"2014-01-07",
"IWM",
226550000,
113.8059,
-831513375
],
[
"2014-01-07",
"SPY",
947882116,
183.533158,
-1149264011.7
],
[
"2014-01-08",
"IWM",
228700000,
114.8463,
244682685
],
[
"2014-01-08",
"SPY",
944682116,
183.548301,
-587306105.6
],
[
"2014-01-09",
"IWM",
221500000,
114.8353,
-826893360
],
[
"2014-01-09",
"SPY",
943932116,
183.611559,
-137661225.75
],
[
"2014-01-10",
"IWM",
221600000,
114.927,
11483530
],
[
"2014-01-10",
"SPY",
940882116,
184.034274,
-560015254.95
],
[
"2014-01-13",
"IWM",
218600000,
115.5398,
-344781000
],
[
"2014-01-13",
"SPY",
943432116,
181.74065,
469287398.7
],
[
"2014-01-14",
"IWM",
216750000,
113.9159,
-213748630
],
[
"2014-01-14",
"SPY",
936482116,
183.705563,
-1263097517.5
],
[
"2014-01-15",
"IWM",
218250000,
115.4396,
170873850
],
[
"2014-01-15",
"SPY",
936532116,
184.657834,
9185278.15
],
[
"2014-01-16",
"IWM",
224050000,
116.2312,
669549680
],
[
"2014-01-16",
"SPY",
933632116,
184.413998,
-535507718.6
],
[
"2014-01-17",
"IWM",
222850000,
116.4089,
-139477440
],
[
"2014-01-17",
"SPY",
927732116,
183.697407,
-1088042588.2
]
],
"columns": [
{
"name": "date",
"type": "Date"
},
{
"name": "ticker",
"type": "String"
},
{
"name": "shares_outstanding",
"type": "BigDecimal(36,14)"
},
{
"name": "nav",
"type": "BigDecimal(36,14)"
},
{
"name": "flow_daily",
"type": "BigDecimal(36,14)"
}
]
},
"meta": {
"next_cursor_id": null

<quandl-response>
<datatable>
<data type="array">
<datum type="array">
<datum type="date">2014-01-02</datum>
<datum>IWM</datum>
<datum type="float">244900000.0</datum>
<datum type="float">115.4367</datum>
<datum type="float">0.0</datum>
</datum>
<datum type="array">
<datum type="date">2014-01-02</datum>
<datum>SPY</datum>
<datum type="float">955782116.0</datum>
<datum type="float">182.935913</datum>
<datum type="float">1531700525.6</datum>
</datum>
<datum type="array">
<datum type="date">2014-01-03</datum>
<datum>IWM</datum>
<datum type="float">234550000.0</datum>
<datum type="float">114.1586</datum>
<datum type="float">-1194769845.0</datum>
</datum>
<datum type="array">
<datum type="date">2014-01-03</datum>
<datum>SPY</datum>
<datum type="float">952482116.0</datum>
<datum type="float">182.879181</datum>
<datum type="float">-603688512.9</datum>
</datum>
<datum type="array">
<datum type="date">2014-01-06</datum>
<datum>IWM</datum>
<datum type="float">233800000.0</datum>
<datum type="float">114.6915</datum>
<datum type="float">-85618950.0</datum>
</datum>
<datum type="array">
<datum type="date">2014-01-06</datum>
<datum>SPY</datum>
<datum type="float">954182116.0</datum>
<datum type="float">182.422859</datum>
<datum type="float">310894607.7</datum>
</datum>
<datum type="array">
<datum type="date">2014-01-07</datum>
<datum>IWM</datum>
<datum type="float">226550000.0</datum>
<datum type="float">113.8059</datum>
<datum type="float">-831513375.0</datum>
</datum>
<datum type="array">
<datum type="date">2014-01-07</datum>
<datum>SPY</datum>
<datum type="float">947882116.0</datum>
<datum type="float">183.533158</datum>
<datum type="float">-1149264011.7</datum>
</datum>
<datum type="array">
<datum type="date">2014-01-08</datum>
<datum>IWM</datum>
<datum type="float">228700000.0</datum>
<datum type="float">114.8463</datum>
<datum type="float">244682685.0</datum>
</datum>
<datum type="array">
<datum type="date">2014-01-08</datum>
<datum>SPY</datum>
<datum type="float">944682116.0</datum>
<datum type="float">183.548301</datum>
<datum type="float">-587306105.6</datum>
</datum>
<datum type="array">
<datum type="date">2014-01-09</datum>
<datum>IWM</datum>
<datum type="float">221500000.0</datum>
<datum type="float">114.8353</datum>
<datum type="float">-826893360.0</datum>
</datum>
<datum type="array">
<datum type="date">2014-01-09</datum>
<datum>SPY</datum>
<datum type="float">943932116.0</datum>
<datum type="float">183.611559</datum>
<datum type="float">-137661225.75</datum>
</datum>
<datum type="array">
<datum type="date">2014-01-10</datum>
<datum>IWM</datum>
<datum type="float">221600000.0</datum>
<datum type="float">114.927</datum>
<datum type="float">11483530.0</datum>
</datum>
<datum type="array">
<datum type="date">2014-01-10</datum>
<datum>SPY</datum>
<datum type="float">940882116.0</datum>
<datum type="float">184.034274</datum>
<datum type="float">-560015254.95</datum>
</datum>
<datum type="array">
<datum type="date">2014-01-13</datum>
<datum>IWM</datum>
<datum type="float">218600000.0</datum>
<datum type="float">115.5398</datum>
<datum type="float">-344781000.0</datum>
</datum>
<datum type="array">
<datum type="date">2014-01-13</datum>
<datum>SPY</datum>
<datum type="float">943432116.0</datum>
<datum type="float">181.74065</datum>
<datum type="float">469287398.7</datum>
</datum>
<datum type="array">
<datum type="date">2014-01-14</datum>
<datum>IWM</datum>
<datum type="float">216750000.0</datum>
<datum type="float">113.9159</datum>
<datum type="float">-213748630.0</datum>
</datum>
<datum type="array">
<datum type="date">2014-01-14</datum>
<datum>SPY</datum>
<datum type="float">936482116.0</datum>
<datum type="float">183.705563</datum>
<datum type="float">-1263097517.5</datum>
</datum>
<datum type="array">
<datum type="date">2014-01-15</datum>
<datum>IWM</datum>
<datum type="float">218250000.0</datum>
<datum type="float">115.4396</datum>
<datum type="float">170873850.0</datum>
</datum>
<datum type="array">
<datum type="date">2014-01-15</datum>
<datum>SPY</datum>
<datum type="float">936532116.0</datum>
<datum type="float">184.657834</datum>
<datum type="float">9185278.15</datum>
</datum>
<datum type="array">
<datum type="date">2014-01-16</datum>
<datum>IWM</datum>
<datum type="float">224050000.0</datum>
<datum type="float">116.2312</datum>
<datum type="float">669549680.0</datum>
</datum>
<datum type="array">
<datum type="date">2014-01-16</datum>
<datum>SPY</datum>
<datum type="float">933632116.0</datum>
<datum type="float">184.413998</datum>
<datum type="float">-535507718.6</datum>
</datum>
<datum type="array">
<datum type="date">2014-01-17</datum>
<datum>IWM</datum>
<datum type="float">222850000.0</datum>
<datum type="float">116.4089</datum>
<datum type="float">-139477440.0</datum>
</datum>
<datum type="array">
<datum type="date">2014-01-17</datum>
<datum>SPY</datum>
<datum type="float">927732116.0</datum>
<datum type="float">183.697407</datum>
<datum type="float">-1088042588.2</datum>
</datum>
</data>
<columns type="array">
<column>
<name>date</name>
<type>Date</type>
</column>
<column>
<name>ticker</name>
<type>String</type>
</column>
<column>
<name>shares_outstanding</name>
<type>BigDecimal(36,14)</type>
</column>
<column>
<name>nav</name>
<type>BigDecimal(36,14)</type>
</column>
<column>
<name>flow_daily</name>
<type>BigDecimal(36,14)</type>
</column>
</columns>
</datatable>
<meta>
<next-cursor-id nil="true"/>
</meta>
</quandl-response>

date,ticker,shares_outstanding,nav,flow_daily
2014-01-02,IWM,244900000.0,115.4367,0.0
2014-01-02,SPY,955782116.0,182.935913,1531700525.6
2014-01-03,IWM,234550000.0,114.1586,-1194769845.0
2014-01-03,SPY,952482116.0,182.879181,-603688512.9
2014-01-06,IWM,233800000.0,114.6915,-85618950.0
2014-01-06,SPY,954182116.0,182.422859,310894607.7
2014-01-07,IWM,226550000.0,113.8059,-831513375.0
2014-01-07,SPY,947882116.0,183.533158,-1149264011.7
2014-01-08,IWM,228700000.0,114.8463,244682685.0
2014-01-08,SPY,944682116.0,183.548301,-587306105.6
2014-01-09,IWM,221500000.0,114.8353,-826893360.0
2014-01-09,SPY,943932116.0,183.611559,-137661225.75
2014-01-10,IWM,221600000.0,114.927,11483530.0
2014-01-10,SPY,940882116.0,184.034274,-560015254.95
2014-01-13,IWM,218600000.0,115.5398,-344781000.0
2014-01-13,SPY,943432116.0,181.74065,469287398.7
2014-01-14,IWM,216750000.0,113.9159,-213748630.0
2014-01-14,SPY,936482116.0,183.705563,-1263097517.5
2014-01-15,IWM,218250000.0,115.4396,170873850.0
2014-01-15,SPY,936532116.0,184.657834,9185278.15
2014-01-16,IWM,224050000.0,116.2312,669549680.0
2014-01-16,SPY,933632116.0,184.413998,-535507718.6
2014-01-17,IWM,222850000.0,116.4089,-139477440.0
2014-01-17,SPY,927732116.0,183.697407,-1088042588.2

Filter Columns

It is possible to select specific table columns to download, by identifying them with the qopts.columns parameter.

Definition:
GET https://data.nasdaq.com/api/v3/datatables/{datatable_code}.{format}?<column_filter_criteria>

Example Request:

curl "https://data.nasdaq.com/api/v3/datatables/ETFG/FUND.json?qopts.columns=ticker&api_key=YOURAPIKEY"

curl "https://data.nasdaq.com/api/v3/datatables/ETFG/FUND.xml?qopts.columns=ticker&api_key=YOURAPIKEY"

curl "https://data.nasdaq.com/api/v3/datatables/ETFG/FUND.csv?qopts.columns=ticker&api_key=YOURAPIKEY"

The above request returns the column "ticker" for the ETFG/FUND table.

Example Response:

{
"datatable": {
"data": [
[
"EEM"
],
[
"EFA"
],
[
"GLD"
],
[
"IWM"
],
[
"JNK"
],
[
"SPY"
],
[
"TLT"
],
[
"EEM"
],
[
"EFA"
],
[
"GLD"
],
[
"IWM"
],
[
"JNK"
],
[
"SPY"
],
[
"TLT"
],
[
"EEM"
],
[
"EFA"
],
[
"GLD"
],
[
"IWM"
],
[
"JNK"
],
[
"SPY"
],
[
"TLT"
],
[
"EEM"
],
[
"EFA"
],
[
"GLD"
],
[
"IWM"
],
[
"JNK"
],
[
"SPY"
],
[
"TLT"
],
[
"EEM"
],
[
"EFA"
],
[
"GLD"
],
[
"IWM"
],
[
"JNK"
],
[
"SPY"
],
[
"TLT"
],
[
"EEM"
],
[
"EFA"
],
[
"GLD"
],
[
"IWM"
],
[
"JNK"
],
[
"SPY"
],
[
"TLT"
],
[
"EEM"
],
[
"EFA"
],
[
"GLD"
],
[
"IWM"
],
[
"JNK"
],
[
"SPY"
],
[
"TLT"
],
[
"EEM"
],
[
"EFA"
],
[
"GLD"
],
[
"IWM"
],
[
"JNK"
],
[
"SPY"
],
[
"TLT"
],
[
"EEM"
],
[
"EFA"
],
[
"GLD"
],
[
"IWM"
],
[
"JNK"
],
[
"SPY"
],
[
"TLT"
],
[
"EEM"
],
[
"EFA"
],
[
"GLD"
],
[
"IWM"
],
[
"JNK"
],
[
"SPY"
],
[
"TLT"
],
[
"EEM"
],
[
"EFA"
],
[
"GLD"
],
[
"IWM"
],
[
"JNK"
],
[
"SPY"
],
[
"TLT"
],
[
"EEM"
],
[
"EFA"
],
[
"GLD"
],
[
"IWM"
],
[
"JNK"
],
[
"SPY"
],
[
"TLT"
]
],
"columns": [
{
"name": "ticker",
"type": "String"
}
]
},
"meta": {
"next_cursor_id": null
}
}

<quandl-response>
<datatable>
<data type="array">
<datum type="array">
<datum>EEM</datum>
</datum>
<datum type="array">
<datum>EFA</datum>
</datum>
<datum type="array">
<datum>GLD</datum>
</datum>
<datum type="array">
<datum>IWM</datum>
</datum>
<datum type="array">
<datum>JNK</datum>
</datum>
<datum type="array">
<datum>SPY</datum>
</datum>
<datum type="array">
<datum>TLT</datum>
</datum>
<datum type="array">
<datum>EEM</datum>
</datum>
<datum type="array">
<datum>EFA</datum>
</datum>
<datum type="array">
<datum>GLD</datum>
</datum>
<datum type="array">
<datum>IWM</datum>
</datum>
<datum type="array">
<datum>JNK</datum>
</datum>
<datum type="array">
<datum>SPY</datum>
</datum>
<datum type="array">
<datum>TLT</datum>
</datum>
<datum type="array">
<datum>EEM</datum>
</datum>
<datum type="array">
<datum>EFA</datum>
</datum>
<datum type="array">
<datum>GLD</datum>
</datum>
<datum type="array">
<datum>IWM</datum>
</datum>
<datum type="array">
<datum>JNK</datum>
</datum>
<datum type="array">
<datum>SPY</datum>
</datum>
<datum type="array">
<datum>TLT</datum>
</datum>
<datum type="array">
<datum>EEM</datum>
</datum>
<datum type="array">
<datum>EFA</datum>
</datum>
<datum type="array">
<datum>GLD</datum>
</datum>
<datum type="array">
<datum>IWM</datum>
</datum>
<datum type="array">
<datum>JNK</datum>
</datum>
<datum type="array">
<datum>SPY</datum>
</datum>
<datum type="array">
<datum>TLT</datum>
</datum>
<datum type="array">
<datum>EEM</datum>
</datum>
<datum type="array">
<datum>EFA</datum>
</datum>
<datum type="array">
<datum>GLD</datum>
</datum>
<datum type="array">
<datum>IWM</datum>
</datum>
<datum type="array">
<datum>JNK</datum>
</datum>
<datum type="array">
<datum>SPY</datum>
</datum>
<datum type="array">
<datum>TLT</datum>
</datum>
<datum type="array">
<datum>EEM</datum>
</datum>
<datum type="array">
<datum>EFA</datum>
</datum>
<datum type="array">
<datum>GLD</datum>
</datum>
<datum type="array">
<datum>IWM</datum>
</datum>
<datum type="array">
<datum>JNK</datum>
</datum>
<datum type="array">
<datum>SPY</datum>
</datum>
<datum type="array">
<datum>TLT</datum>
</datum>
<datum type="array">
<datum>EEM</datum>
</datum>
<datum type="array">
<datum>EFA</datum>
</datum>
<datum type="array">
<datum>GLD</datum>
</datum>
<datum type="array">
<datum>IWM</datum>
</datum>
<datum type="array">
<datum>JNK</datum>
</datum>
<datum type="array">
<datum>SPY</datum>
</datum>
<datum type="array">
<datum>TLT</datum>
</datum>
<datum type="array">
<datum>EEM</datum>
</datum>
<datum type="array">
<datum>EFA</datum>
</datum>
<datum type="array">
<datum>GLD</datum>
</datum>
<datum type="array">
<datum>IWM</datum>
</datum>
<datum type="array">
<datum>JNK</datum>
</datum>
<datum type="array">
<datum>SPY</datum>
</datum>
<datum type="array">
<datum>TLT</datum>
</datum>
<datum type="array">
<datum>EEM</datum>
</datum>
<datum type="array">
<datum>EFA</datum>
</datum>
<datum type="array">
<datum>GLD</datum>
</datum>
<datum type="array">
<datum>IWM</datum>
</datum>
<datum type="array">
<datum>JNK</datum>
</datum>
<datum type="array">
<datum>SPY</datum>
</datum>
<datum type="array">
<datum>TLT</datum>
</datum>
<datum type="array">
<datum>EEM</datum>
</datum>
<datum type="array">
<datum>EFA</datum>
</datum>
<datum type="array">
<datum>GLD</datum>
</datum>
<datum type="array">
<datum>IWM</datum>
</datum>
<datum type="array">
<datum>JNK</datum>
</datum>
<datum type="array">
<datum>SPY</datum>
</datum>
<datum type="array">
<datum>TLT</datum>
</datum>
<datum type="array">
<datum>EEM</datum>
</datum>
<datum type="array">
<datum>EFA</datum>
</datum>
<datum type="array">
<datum>GLD</datum>
</datum>
<datum type="array">
<datum>IWM</datum>
</datum>
<datum type="array">
<datum>JNK</datum>
</datum>
<datum type="array">
<datum>SPY</datum>
</datum>
<datum type="array">
<datum>TLT</datum>
</datum>
<datum type="array">
<datum>EEM</datum>
</datum>
<datum type="array">
<datum>EFA</datum>
</datum>
<datum type="array">
<datum>GLD</datum>
</datum>
<datum type="array">
<datum>IWM</datum>
</datum>
<datum type="array">
<datum>JNK</datum>
</datum>
<datum type="array">
<datum>SPY</datum>
</datum>
<datum type="array">
<datum>TLT</datum>
</datum>
</data>
<columns type="array">
<column>
<name>ticker</name>
<type>String</type>
</column>
</columns>
</datatable>
<meta>
<next-cursor-id nil="true"/>
</meta>
</quandl-response>

ticker
EEM
EFA
GLD
IWM
JNK
SPY
TLT
EEM
EFA
GLD
IWM
JNK
SPY
TLT
EEM
EFA
GLD
IWM
JNK
SPY
TLT
EEM
EFA
GLD
IWM
JNK
SPY
TLT
EEM
EFA
GLD
IWM
JNK
SPY
TLT
EEM
EFA
GLD
IWM
JNK
SPY
TLT
EEM
EFA
GLD
IWM
JNK
SPY
TLT
EEM
EFA
GLD
IWM
JNK
SPY
TLT
EEM
EFA
GLD
IWM
JNK
SPY
TLT
EEM
EFA
GLD
IWM
JNK
SPY
TLT
EEM
EFA
GLD
IWM
JNK
SPY
TLT
EEM
EFA
GLD
IWM
JNK
SPY
TLT

Request Multiple Columns

Example Request:

curl "https://data.nasdaq.com/api/v3/datatables/ETFG/FUND.json?qopts.columns=ticker,date,shares_outstanding&api_key=YOURAPIKEY"

curl "https://data.nasdaq.com/api/v3/datatables/ETFG/FUND.xml?qopts.columns=ticker,date,shares_outstanding&api_key=YOURAPIKEY"

curl "https://data.nasdaq.com/api/v3/datatables/ETFG/FUND.csv?qopts.columns=ticker,date,shares_outstanding&api_key=YOURAPIKEY"

The above request returns columns "ticker", "date" and "shares_oustanding" for the ETFG/FUND table.

Example Response

{
"datatable": {
"data": [
[
"EEM",
"2014-01-02",
971550000
],
[
"EFA",
"2014-01-02",
791400000
],
[
"GLD",
"2014-01-02",
264800000
],
[
"IWM",
"2014-01-02",
244900000
],
[
"JNK",
"2014-01-02",
246523812
],
[
"SPY",
"2014-01-02",
955782116
],
[
"TLT",
"2014-01-02",
21700000
],
[
"EEM",
"2014-01-03",
971550000
],
[
"EFA",
"2014-01-03",
791400000
],
[
"GLD",
"2014-01-03",
264800000
],
[
"IWM",
"2014-01-03",
234550000
],
[
"JNK",
"2014-01-03",
246523812
],
[
"SPY",
"2014-01-03",
952482116
],
[
"TLT",
"2014-01-03",
23400000
],
[
"EEM",
"2014-01-06",
969300000
],
[
"EFA",
"2014-01-06",
791400000
],
[
"GLD",
"2014-01-06",
264800000
],
[
"IWM",
"2014-01-06",
233800000
],
[
"JNK",
"2014-01-06",
246523812
],
[
"SPY",
"2014-01-06",
954182116
],
[
"TLT",
"2014-01-06",
24200000
],
[
"EEM",
"2014-01-07",
963000000
],
[
"EFA",
"2014-01-07",
791400000
],
[
"GLD",
"2014-01-07",
264800000
],
[
"IWM",
"2014-01-07",
226550000
],
[
"JNK",
"2014-01-07",
247023812
],
[
"SPY",
"2014-01-07",
947882116
],
[
"TLT",
"2014-01-07",
23800000
],
[
"EEM",
"2014-01-08",
955800000
],
[
"EFA",
"2014-01-08",
791400000
],
[
"GLD",
"2014-01-08",
264300000
],
[
"IWM",
"2014-01-08",
228700000
],
[
"JNK",
"2014-01-08",
247023812
],
[
"SPY",
"2014-01-08",
944682116
],
[
"TLT",
"2014-01-08",
24000000
],
[
"EEM",
"2014-01-09",
949500000
],
[
"EFA",
"2014-01-09",
791400000
],
[
"GLD",
"2014-01-09",
264300000
],
[
"IWM",
"2014-01-09",
221500000
],
[
"JNK",
"2014-01-09",
245773812
],
[
"SPY",
"2014-01-09",
943932116
],
[
"TLT",
"2014-01-09",
23500000
],
[
"EEM",
"2014-01-10",
943200000
],
[
"EFA",
"2014-01-10",
791400000
],
[
"GLD",
"2014-01-10",
264300000
],
[
"IWM",
"2014-01-10",
221600000
],
[
"JNK",
"2014-01-10",
244773812
],
[
"SPY",
"2014-01-10",
940882116
],
[
"TLT",
"2014-01-10",
23600000
],
[
"EEM",
"2014-01-13",
936900000
],
[
"EFA",
"2014-01-13",
791400000
],
[
"GLD",
"2014-01-13",
264300000
],
[
"IWM",
"2014-01-13",
218600000
],
[
"JNK",
"2014-01-13",
245273812
],
[
"SPY",
"2014-01-13",
943432116
],
[
"TLT",
"2014-01-13",
22000000
],
[
"EEM",
"2014-01-14",
936900000
],
[
"EFA",
"2014-01-14",
791400000
],
[
"GLD",
"2014-01-14",
263200000
],
[
"IWM",
"2014-01-14",
216750000
],
[
"JNK",
"2014-01-14",
245273812
],
[
"SPY",
"2014-01-14",
936482116
],
[
"TLT",
"2014-01-14",
21800000
],
[
"EEM",
"2014-01-15",
936900000
],
[
"EFA",
"2014-01-15",
791400000
],
[
"GLD",
"2014-01-15",
263200000
],
[
"IWM",
"2014-01-15",
218250000
],
[
"JNK",
"2014-01-15",
244773812
],
[
"SPY",
"2014-01-15",
936532116
],
[
"TLT",
"2014-01-15",
21300000
],
[
"EEM",
"2014-01-16",
936900000
],
[
"EFA",
"2014-01-16",
791400000
],
[
"GLD",
"2014-01-16",
263200000
],
[
"IWM",
"2014-01-16",
224050000
],
[
"JNK",
"2014-01-16",
245273812
],
[
"SPY",
"2014-01-16",
933632116
],
[
"TLT",
"2014-01-16",
21600000
],
[
"EEM",
"2014-01-17",
936900000
],
[
"EFA",
"2014-01-17",
791400000
],
[
"GLD",
"2014-01-17",
265700000
],
[
"IWM",
"2014-01-17",
222850000
],
[
"JNK",
"2014-01-17",
245273812
],
[
"SPY",
"2014-01-17",
927732116
],
[
"TLT",
"2014-01-17",
22200000
]
],
"columns": [
{
"name": "ticker",
"type": "String"
},
{
"name": "date",
"type": "Date"
},
{
"name": "shares_outstanding",
"type": "BigDecimal(36,14)"
}
]
},
"meta": {
"next_cursor_id": null
}
}

<quandl-response>
<datatable>
<data type="array">
<datum type="array">
<datum>EEM</datum>
<datum type="date">2014-01-02</datum>
<datum type="float">971550000.0</datum>
</datum>
<datum type="array">
<datum>EFA</datum>
<datum type="date">2014-01-02</datum>
<datum type="float">791400000.0</datum>
</datum>
<datum type="array">
<datum>GLD</datum>
<datum type="date">2014-01-02</datum>
<datum type="float">264800000.0</datum>
</datum>
<datum type="array">
<datum>IWM</datum>
<datum type="date">2014-01-02</datum>
<datum type="float">244900000.0</datum>
</datum>
<datum type="array">
<datum>JNK</datum>
<datum type="date">2014-01-02</datum>
<datum type="float">246523812.0</datum>
</datum>
<datum type="array">
<datum>SPY</datum>
<datum type="date">2014-01-02</datum>
<datum type="float">955782116.0</datum>
</datum>
<datum type="array">
<datum>TLT</datum>
<datum type="date">2014-01-02</datum>
<datum type="float">21700000.0</datum>
</datum>
<datum type="array">
<datum>EEM</datum>
<datum type="date">2014-01-03</datum>
<datum type="float">971550000.0</datum>
</datum>
<datum type="array">
<datum>EFA</datum>
<datum type="date">2014-01-03</datum>
<datum type="float">791400000.0</datum>
</datum>
<datum type="array">
<datum>GLD</datum>
<datum type="date">2014-01-03</datum>
<datum type="float">264800000.0</datum>
</datum>
<datum type="array">
<datum>IWM</datum>
<datum type="date">2014-01-03</datum>
<datum type="float">234550000.0</datum>
</datum>
<datum type="array">
<datum>JNK</datum>
<datum type="date">2014-01-03</datum>
<datum type="float">246523812.0</datum>
</datum>
<datum type="array">
<datum>SPY</datum>
<datum type="date">2014-01-03</datum>
<datum type="float">952482116.0</datum>
</datum>
<datum type="array">
<datum>TLT</datum>
<datum type="date">2014-01-03</datum>
<datum type="float">23400000.0</datum>
</datum>
<datum type="array">
<datum>EEM</datum>
<datum type="date">2014-01-06</datum>
<datum type="float">969300000.0</datum>
</datum>
<datum type="array">
<datum>EFA</datum>
<datum type="date">2014-01-06</datum>
<datum type="float">791400000.0</datum>
</datum>
<datum type="array">
<datum>GLD</datum>
<datum type="date">2014-01-06</datum>
<datum type="float">264800000.0</datum>
</datum>
<datum type="array">
<datum>IWM</datum>
<datum type="date">2014-01-06</datum>
<datum type="float">233800000.0</datum>
</datum>
<datum type="array">
<datum>JNK</datum>
<datum type="date">2014-01-06</datum>
<datum type="float">246523812.0</datum>
</datum>
<datum type="array">
<datum>SPY</datum>
<datum type="date">2014-01-06</datum>
<datum type="float">954182116.0</datum>
</datum>
<datum type="array">
<datum>TLT</datum>
<datum type="date">2014-01-06</datum>
<datum type="float">24200000.0</datum>
</datum>
<datum type="array">
<datum>EEM</datum>
<datum type="date">2014-01-07</datum>
<datum type="float">963000000.0</datum>
</datum>
<datum type="array">
<datum>EFA</datum>
<datum type="date">2014-01-07</datum>
<datum type="float">791400000.0</datum>
</datum>
<datum type="array">
<datum>GLD</datum>
<datum type="date">2014-01-07</datum>
<datum type="float">264800000.0</datum>
</datum>
<datum type="array">
<datum>IWM</datum>
<datum type="date">2014-01-07</datum>
<datum type="float">226550000.0</datum>
</datum>
<datum type="array">
<datum>JNK</datum>
<datum type="date">2014-01-07</datum>
<datum type="float">247023812.0</datum>
</datum>
<datum type="array">
<datum>SPY</datum>
<datum type="date">2014-01-07</datum>
<datum type="float">947882116.0</datum>
</datum>
<datum type="array">
<datum>TLT</datum>
<datum type="date">2014-01-07</datum>
<datum type="float">23800000.0</datum>
</datum>
<datum type="array">
<datum>EEM</datum>
<datum type="date">2014-01-08</datum>
<datum type="float">955800000.0</datum>
</datum>
<datum type="array">
<datum>EFA</datum>
<datum type="date">2014-01-08</datum>
<datum type="float">791400000.0</datum>
</datum>
<datum type="array">
<datum>GLD</datum>
<datum type="date">2014-01-08</datum>
<datum type="float">264300000.0</datum>
</datum>
<datum type="array">
<datum>IWM</datum>
<datum type="date">2014-01-08</datum>
<datum type="float">228700000.0</datum>
</datum>
<datum type="array">
<datum>JNK</datum>
<datum type="date">2014-01-08</datum>
<datum type="float">247023812.0</datum>
</datum>
<datum type="array">
<datum>SPY</datum>
<datum type="date">2014-01-08</datum>
<datum type="float">944682116.0</datum>
</datum>
<datum type="array">
<datum>TLT</datum>
<datum type="date">2014-01-08</datum>
<datum type="float">24000000.0</datum>
</datum>
<datum type="array">
<datum>EEM</datum>
<datum type="date">2014-01-09</datum>
<datum type="float">949500000.0</datum>
</datum>
<datum type="array">
<datum>EFA</datum>
<datum type="date">2014-01-09</datum>
<datum type="float">791400000.0</datum>
</datum>
<datum type="array">
<datum>GLD</datum>
<datum type="date">2014-01-09</datum>
<datum type="float">264300000.0</datum>
</datum>
<datum type="array">
<datum>IWM</datum>
<datum type="date">2014-01-09</datum>
<datum type="float">221500000.0</datum>
</datum>
<datum type="array">
<datum>JNK</datum>
<datum type="date">2014-01-09</datum>
<datum type="float">245773812.0</datum>
</datum>
<datum type="array">
<datum>SPY</datum>
<datum type="date">2014-01-09</datum>
<datum type="float">943932116.0</datum>
</datum>
<datum type="array">
<datum>TLT</datum>
<datum type="date">2014-01-09</datum>
<datum type="float">23500000.0</datum>
</datum>
<datum type="array">
<datum>EEM</datum>
<datum type="date">2014-01-10</datum>
<datum type="float">943200000.0</datum>
</datum>
<datum type="array">
<datum>EFA</datum>
<datum type="date">2014-01-10</datum>
<datum type="float">791400000.0</datum>
</datum>
<datum type="array">
<datum>GLD</datum>
<datum type="date">2014-01-10</datum>
<datum type="float">264300000.0</datum>
</datum>
<datum type="array">
<datum>IWM</datum>
<datum type="date">2014-01-10</datum>
<datum type="float">221600000.0</datum>
</datum>
<datum type="array">
<datum>JNK</datum>
<datum type="date">2014-01-10</datum>
<datum type="float">244773812.0</datum>
</datum>
<datum type="array">
<datum>SPY</datum>
<datum type="date">2014-01-10</datum>
<datum type="float">940882116.0</datum>
</datum>
<datum type="array">
<datum>TLT</datum>
<datum type="date">2014-01-10</datum>
<datum type="float">23600000.0</datum>
</datum>
<datum type="array">
<datum>EEM</datum>
<datum type="date">2014-01-13</datum>
<datum type="float">936900000.0</datum>
</datum>
<datum type="array">
<datum>EFA</datum>
<datum type="date">2014-01-13</datum>
<datum type="float">791400000.0</datum>
</datum>
<datum type="array">
<datum>GLD</datum>
<datum type="date">2014-01-13</datum>
<datum type="float">264300000.0</datum>
</datum>
<datum type="array">
<datum>IWM</datum>
<datum type="date">2014-01-13</datum>
<datum type="float">218600000.0</datum>
</datum>
<datum type="array">
<datum>JNK</datum>
<datum type="date">2014-01-13</datum>
<datum type="float">245273812.0</datum>
</datum>
<datum type="array">
<datum>SPY</datum>
<datum type="date">2014-01-13</datum>
<datum type="float">943432116.0</datum>
</datum>
<datum type="array">
<datum>TLT</datum>
<datum type="date">2014-01-13</datum>
<datum type="float">22000000.0</datum>
</datum>
<datum type="array">
<datum>EEM</datum>
<datum type="date">2014-01-14</datum>
<datum type="float">936900000.0</datum>
</datum>
<datum type="array">
<datum>EFA</datum>
<datum type="date">2014-01-14</datum>
<datum type="float">791400000.0</datum>
</datum>
<datum type="array">
<datum>GLD</datum>
<datum type="date">2014-01-14</datum>
<datum type="float">263200000.0</datum>
</datum>
<datum type="array">
<datum>IWM</datum>
<datum type="date">2014-01-14</datum>
<datum type="float">216750000.0</datum>
</datum>
<datum type="array">
<datum>JNK</datum>
<datum type="date">2014-01-14</datum>
<datum type="float">245273812.0</datum>
</datum>
<datum type="array">
<datum>SPY</datum>
<datum type="date">2014-01-14</datum>
<datum type="float">936482116.0</datum>
</datum>
<datum type="array">
<datum>TLT</datum>
<datum type="date">2014-01-14</datum>
<datum type="float">21800000.0</datum>
</datum>
<datum type="array">
<datum>EEM</datum>
<datum type="date">2014-01-15</datum>
<datum type="float">936900000.0</datum>
</datum>
<datum type="array">
<datum>EFA</datum>
<datum type="date">2014-01-15</datum>
<datum type="float">791400000.0</datum>
</datum>
<datum type="array">
<datum>GLD</datum>
<datum type="date">2014-01-15</datum>
<datum type="float">263200000.0</datum>
</datum>
<datum type="array">
<datum>IWM</datum>
<datum type="date">2014-01-15</datum>
<datum type="float">218250000.0</datum>
</datum>
<datum type="array">
<datum>JNK</datum>
<datum type="date">2014-01-15</datum>
<datum type="float">244773812.0</datum>
</datum>
<datum type="array">
<datum>SPY</datum>
<datum type="date">2014-01-15</datum>
<datum type="float">936532116.0</datum>
</datum>
<datum type="array">
<datum>TLT</datum>
<datum type="date">2014-01-15</datum>
<datum type="float">21300000.0</datum>
</datum>
<datum type="array">
<datum>EEM</datum>
<datum type="date">2014-01-16</datum>
<datum type="float">936900000.0</datum>
</datum>
<datum type="array">
<datum>EFA</datum>
<datum type="date">2014-01-16</datum>
<datum type="float">791400000.0</datum>
</datum>
<datum type="array">
<datum>GLD</datum>
<datum type="date">2014-01-16</datum>
<datum type="float">263200000.0</datum>
</datum>
<datum type="array">
<datum>IWM</datum>
<datum type="date">2014-01-16</datum>
<datum type="float">224050000.0</datum>
</datum>
<datum type="array">
<datum>JNK</datum>
<datum type="date">2014-01-16</datum>
<datum type="float">245273812.0</datum>
</datum>
<datum type="array">
<datum>SPY</datum>
<datum type="date">2014-01-16</datum>
<datum type="float">933632116.0</datum>
</datum>
<datum type="array">
<datum>TLT</datum>
<datum type="date">2014-01-16</datum>
<datum type="float">21600000.0</datum>
</datum>
<datum type="array">
<datum>EEM</datum>
<datum type="date">2014-01-17</datum>
<datum type="float">936900000.0</datum>
</datum>
<datum type="array">
<datum>EFA</datum>
<datum type="date">2014-01-17</datum>
<datum type="float">791400000.0</datum>
</datum>
<datum type="array">
<datum>GLD</datum>
<datum type="date">2014-01-17</datum>
<datum type="float">265700000.0</datum>
</datum>
<datum type="array">
<datum>IWM</datum>
<datum type="date">2014-01-17</datum>
<datum type="float">222850000.0</datum>
</datum>
<datum type="array">
<datum>JNK</datum>
<datum type="date">2014-01-17</datum>
<datum type="float">245273812.0</datum>
</datum>
<datum type="array">
<datum>SPY</datum>
<datum type="date">2014-01-17</datum>
<datum type="float">927732116.0</datum>
</datum>
<datum type="array">
<datum>TLT</datum>
<datum type="date">2014-01-17</datum>
<datum type="float">22200000.0</datum>
</datum>
</data>
<columns type="array">
<column>
<name>ticker</name>
<type>String</type>
</column>
<column>
<name>date</name>
<type>Date</type>
</column>
<column>
<name>shares_outstanding</name>
<type>BigDecimal(36,14)</type>
</column>
</columns>
</datatable>
<meta>
<next-cursor-id nil="true"/>
</meta>
</quandl-response>

ticker,date,shares_outstanding
EEM,2014-01-02,971550000.0
EFA,2014-01-02,791400000.0
GLD,2014-01-02,264800000.0
IWM,2014-01-02,244900000.0
JNK,2014-01-02,246523812.0
SPY,2014-01-02,955782116.0
TLT,2014-01-02,21700000.0
EEM,2014-01-03,971550000.0
EFA,2014-01-03,791400000.0
GLD,2014-01-03,264800000.0
IWM,2014-01-03,234550000.0
JNK,2014-01-03,246523812.0
SPY,2014-01-03,952482116.0
TLT,2014-01-03,23400000.0
EEM,2014-01-06,969300000.0
EFA,2014-01-06,791400000.0
GLD,2014-01-06,264800000.0
IWM,2014-01-06,233800000.0
JNK,2014-01-06,246523812.0
SPY,2014-01-06,954182116.0
TLT,2014-01-06,24200000.0
EEM,2014-01-07,963000000.0
EFA,2014-01-07,791400000.0
GLD,2014-01-07,264800000.0
IWM,2014-01-07,226550000.0
JNK,2014-01-07,247023812.0
SPY,2014-01-07,947882116.0
TLT,2014-01-07,23800000.0
EEM,2014-01-08,955800000.0
EFA,2014-01-08,791400000.0
GLD,2014-01-08,264300000.0
IWM,2014-01-08,228700000.0
JNK,2014-01-08,247023812.0
SPY,2014-01-08,944682116.0
TLT,2014-01-08,24000000.0
EEM,2014-01-09,949500000.0
EFA,2014-01-09,791400000.0
GLD,2014-01-09,264300000.0
IWM,2014-01-09,221500000.0
JNK,2014-01-09,245773812.0
SPY,2014-01-09,943932116.0
TLT,2014-01-09,23500000.0
EEM,2014-01-10,943200000.0
EFA,2014-01-10,791400000.0
GLD,2014-01-10,264300000.0
IWM,2014-01-10,221600000.0
JNK,2014-01-10,244773812.0
SPY,2014-01-10,940882116.0
TLT,2014-01-10,23600000.0
EEM,2014-01-13,936900000.0
EFA,2014-01-13,791400000.0
GLD,2014-01-13,264300000.0
IWM,2014-01-13,218600000.0
JNK,2014-01-13,245273812.0
SPY,2014-01-13,943432116.0
TLT,2014-01-13,22000000.0
EEM,2014-01-14,936900000.0
EFA,2014-01-14,791400000.0
GLD,2014-01-14,263200000.0
IWM,2014-01-14,216750000.0
JNK,2014-01-14,245273812.0
SPY,2014-01-14,936482116.0
TLT,2014-01-14,21800000.0
EEM,2014-01-15,936900000.0
EFA,2014-01-15,791400000.0
GLD,2014-01-15,263200000.0
IWM,2014-01-15,218250000.0
JNK,2014-01-15,244773812.0
SPY,2014-01-15,936532116.0
TLT,2014-01-15,21300000.0
EEM,2014-01-16,936900000.0
EFA,2014-01-16,791400000.0
GLD,2014-01-16,263200000.0
IWM,2014-01-16,224050000.0
JNK,2014-01-16,245273812.0
SPY,2014-01-16,933632116.0
TLT,2014-01-16,21600000.0
EEM,2014-01-17,936900000.0
EFA,2014-01-17,791400000.0
GLD,2014-01-17,265700000.0
IWM,2014-01-17,222850000.0
JNK,2014-01-17,245273812.0
SPY,2014-01-17,927732116.0
TLT,2014-01-17,22200000.0

Filter Rows and Columns

You can filter on both rows and columns by appending both filter types to your API request.

Definition:
GET https://data.nasdaq.com/api/v3/datatables/{datatable_code}.{format}?<column_filter_criteria>&<row_filter_criteria>

Example Request:

curl "https://data.nasdaq.com/api/v3/datatables/ETFG/FUND.json?ticker=SPY,IWM,GLD&qopts.columns=ticker,date,shares_outstanding&api_key=YOURAPIKEY"

curl "https://data.nasdaq.com/api/v3/datatables/ETFG/FUND.xml?ticker=SPY,IWM,GLD&qopts.columns=ticker,date,shares_outstanding&api_key=YOURAPIKEY"

curl "https://data.nasdaq.com/api/v3/datatables/ETFG/FUND.csv?ticker=SPY,IWM,GLD&qopts.columns=ticker,date,shares_outstanding&api_key=YOURAPIKEY"

The above request returns columns "ticker", "date" and "shares_oustanding" for all rows where the column "ticker" has the value "SPY", "IWM" or "GLD".

Example Response:

{
"datatable": {
"data": [
[
"GLD",
"2014-01-02",
264800000
],
[
"IWM",
"2014-01-02",
244900000
],
[
"SPY",
"2014-01-02",
955782116
],
[
"GLD",
"2014-01-03",
264800000
],
[
"IWM",
"2014-01-03",
234550000
],
[
"SPY",
"2014-01-03",
952482116
],
[
"GLD",
"2014-01-06",
264800000
],
[
"IWM",
"2014-01-06",
233800000
],
[
"SPY",
"2014-01-06",
954182116
],
[
"GLD",
"2014-01-07",
264800000
],
[
"IWM",
"2014-01-07",
226550000
],
[
"SPY",
"2014-01-07",
947882116
],
[
"GLD",
"2014-01-08",
264300000
],
[
"IWM",
"2014-01-08",
228700000
],
[
"SPY",
"2014-01-08",
944682116
],
[
"GLD",
"2014-01-09",
264300000
],
[
"IWM",
"2014-01-09",
221500000
],
[
"SPY",
"2014-01-09",
943932116
],
[
"GLD",
"2014-01-10",
264300000
],
[
"IWM",
"2014-01-10",
221600000
],
[
"SPY",
"2014-01-10",
940882116
],
[
"GLD",
"2014-01-13",
264300000
],
[
"IWM",
"2014-01-13",
218600000
],
[
"SPY",
"2014-01-13",
943432116
],
[
"GLD",
"2014-01-14",
263200000
],
[
"IWM",
"2014-01-14",
216750000
],
[
"SPY",
"2014-01-14",
936482116
],
[
"GLD",
"2014-01-15",
263200000
],
[
"IWM",
"2014-01-15",
218250000
],
[
"SPY",
"2014-01-15",
936532116
],
[
"GLD",
"2014-01-16",
263200000
],
[
"IWM",
"2014-01-16",
224050000
],
[
"SPY",
"2014-01-16",
933632116
],
[
"GLD",
"2014-01-17",
265700000
],
[
"IWM",
"2014-01-17",
222850000
],
[
"SPY",
"2014-01-17",
927732116
]
],
"columns": [
{
"name": "ticker",
"type": "String"
},
{
"name": "date",
"type": "Date"
},
{
"name": "shares_outstanding",
"type": "BigDecimal(36,14)"
}
]
},
"meta": {
"next_cursor_id": null
}
}

<quandl-response>
<datatable>
<data type="array">
<datum type="array">
<datum>GLD</datum>
<datum type="date">2014-01-02</datum>
<datum type="float">264800000.0</datum>
</datum>
<datum type="array">
<datum>IWM</datum>
<datum type="date">2014-01-02</datum>
<datum type="float">244900000.0</datum>
</datum>
<datum type="array">
<datum>SPY</datum>
<datum type="date">2014-01-02</datum>
<datum type="float">955782116.0</datum>
</datum>
<datum type="array">
<datum>GLD</datum>
<datum type="date">2014-01-03</datum>
<datum type="float">264800000.0</datum>
</datum>
<datum type="array">
<datum>IWM</datum>
<datum type="date">2014-01-03</datum>
<datum type="float">234550000.0</datum>
</datum>
<datum type="array">
<datum>SPY</datum>
<datum type="date">2014-01-03</datum>
<datum type="float">952482116.0</datum>
</datum>
<datum type="array">
<datum>GLD</datum>
<datum type="date">2014-01-06</datum>
<datum type="float">264800000.0</datum>
</datum>
<datum type="array">
<datum>IWM</datum>
<datum type="date">2014-01-06</datum>
<datum type="float">233800000.0</datum>
</datum>
<datum type="array">
<datum>SPY</datum>
<datum type="date">2014-01-06</datum>
<datum type="float">954182116.0</datum>
</datum>
<datum type="array">
<datum>GLD</datum>
<datum type="date">2014-01-07</datum>
<datum type="float">264800000.0</datum>
</datum>
<datum type="array">
<datum>IWM</datum>
<datum type="date">2014-01-07</datum>
<datum type="float">226550000.0</datum>
</datum>
<datum type="array">
<datum>SPY</datum>
<datum type="date">2014-01-07</datum>
<datum type="float">947882116.0</datum>
</datum>
<datum type="array">
<datum>GLD</datum>
<datum type="date">2014-01-08</datum>
<datum type="float">264300000.0</datum>
</datum>
<datum type="array">
<datum>IWM</datum>
<datum type="date">2014-01-08</datum>
<datum type="float">228700000.0</datum>
</datum>
<datum type="array">
<datum>SPY</datum>
<datum type="date">2014-01-08</datum>
<datum type="float">944682116.0</datum>
</datum>
<datum type="array">
<datum>GLD</datum>
<datum type="date">2014-01-09</datum>
<datum type="float">264300000.0</datum>
</datum>
<datum type="array">
<datum>IWM</datum>
<datum type="date">2014-01-09</datum>
<datum type="float">221500000.0</datum>
</datum>
<datum type="array">
<datum>SPY</datum>
<datum type="date">2014-01-09</datum>
<datum type="float">943932116.0</datum>
</datum>
<datum type="array">
<datum>GLD</datum>
<datum type="date">2014-01-10</datum>
<datum type="float">264300000.0</datum>
</datum>
<datum type="array">
<datum>IWM</datum>
<datum type="date">2014-01-10</datum>
<datum type="float">221600000.0</datum>
</datum>
<datum type="array">
<datum>SPY</datum>
<datum type="date">2014-01-10</datum>
<datum type="float">940882116.0</datum>
</datum>
<datum type="array">
<datum>GLD</datum>
<datum type="date">2014-01-13</datum>
<datum type="float">264300000.0</datum>
</datum>
<datum type="array">
<datum>IWM</datum>
<datum type="date">2014-01-13</datum>
<datum type="float">218600000.0</datum>
</datum>
<datum type="array">
<datum>SPY</datum>
<datum type="date">2014-01-13</datum>
<datum type="float">943432116.0</datum>
</datum>
<datum type="array">
<datum>GLD</datum>
<datum type="date">2014-01-14</datum>
<datum type="float">263200000.0</datum>
</datum>
<datum type="array">
<datum>IWM</datum>
<datum type="date">2014-01-14</datum>
<datum type="float">216750000.0</datum>
</datum>
<datum type="array">
<datum>SPY</datum>
<datum type="date">2014-01-14</datum>
<datum type="float">936482116.0</datum>
</datum>
<datum type="array">
<datum>GLD</datum>
<datum type="date">2014-01-15</datum>
<datum type="float">263200000.0</datum>
</datum>
<datum type="array">
<datum>IWM</datum>
<datum type="date">2014-01-15</datum>
<datum type="float">218250000.0</datum>
</datum>
<datum type="array">
<datum>SPY</datum>
<datum type="date">2014-01-15</datum>
<datum type="float">936532116.0</datum>
</datum>
<datum type="array">
<datum>GLD</datum>
<datum type="date">2014-01-16</datum>
<datum type="float">263200000.0</datum>
</datum>
<datum type="array">
<datum>IWM</datum>
<datum type="date">2014-01-16</datum>
<datum type="float">224050000.0</datum>
</datum>
<datum type="array">
<datum>SPY</datum>
<datum type="date">2014-01-16</datum>
<datum type="float">933632116.0</datum>
</datum>
<datum type="array">
<datum>GLD</datum>
<datum type="date">2014-01-17</datum>
<datum type="float">265700000.0</datum>
</datum>
<datum type="array">
<datum>IWM</datum>
<datum type="date">2014-01-17</datum>
<datum type="float">222850000.0</datum>
</datum>
<datum type="array">
<datum>SPY</datum>
<datum type="date">2014-01-17</datum>
<datum type="float">927732116.0</datum>
</datum>
</data>
<columns type="array">
<column>
<name>ticker</name>
<type>String</type>
</column>
<column>
<name>date</name>
<type>Date</type>
</column>
<column>
<name>shares_outstanding</name>
<type>BigDecimal(36,14)</type>
</column>
</columns>
</datatable>
<meta>
<next-cursor-id nil="true"/>
</meta>
</quandl-response>

ticker,date,shares_outstanding
GLD,2014-01-02,264800000.0
IWM,2014-01-02,244900000.0
SPY,2014-01-02,955782116.0
GLD,2014-01-03,264800000.0
IWM,2014-01-03,234550000.0
SPY,2014-01-03,952482116.0
GLD,2014-01-06,264800000.0
IWM,2014-01-06,233800000.0
SPY,2014-01-06,954182116.0
GLD,2014-01-07,264800000.0
IWM,2014-01-07,226550000.0
SPY,2014-01-07,947882116.0
GLD,2014-01-08,264300000.0
IWM,2014-01-08,228700000.0
SPY,2014-01-08,944682116.0
GLD,2014-01-09,264300000.0
IWM,2014-01-09,221500000.0
SPY,2014-01-09,943932116.0
GLD,2014-01-10,264300000.0
IWM,2014-01-10,221600000.0
SPY,2014-01-10,940882116.0
GLD,2014-01-13,264300000.0
IWM,2014-01-13,218600000.0
SPY,2014-01-13,943432116.0
GLD,2014-01-14,263200000.0
IWM,2014-01-14,216750000.0
SPY,2014-01-14,936482116.0
GLD,2014-01-15,263200000.0
IWM,2014-01-15,218250000.0
SPY,2014-01-15,936532116.0
GLD,2014-01-16,263200000.0
IWM,2014-01-16,224050000.0
SPY,2014-01-16,933632116.0
GLD,2014-01-17,265700000.0
IWM,2014-01-17,222850000.0
SPY,2014-01-17,927732116.0

Get Table Metadata

Definition: https://data.nasdaq.com/api/v3/datatables/{datatable_code}/metadata.{format}

Example Request:

curl "https://data.nasdaq.com/api/v3/datatables/AR/MWCS/metadata.json?api_key=YOURAPIKEY"

curl "https://data.nasdaq.com/api/v3/datatables/AR/MWCS/metadata.xml?api_key=YOURAPIKEY"

curl "https://data.nasdaq.com/api/v3/datatables/AR/MWCS/metadata.csv?api_key=YOURAPIKEY"

Example Response:

{
"datatable": {
"vendor_code": "AR",
"datatable_code": "MWCS",
"name": "MarketWorks Futures Settlement CME",
"description": null,
"columns": [
{
"name": "code",
"type": "String"
},
{
"name": "date",
"type": "Date"
},
{
"name": "settlement",
"type": "BigDecimal(16,7)"
}
],
"filters": [
"code",
"date"
],
"primary_key": [
"code",
"date"
],
"premium": true,
"status": {
"refreshed_at": "2017-03-02T14:35:25.000Z",
"status": null,
"expected_at": null,
"update_frequency": null
}
}
}

<quandl-response>
<datatable>
<vendor-code>AR</vendor-code>
<datatable-code>MWCS</datatable-code>
<name>MarketWorks Futures Settlement CME</name>
<description nil="true"/>
<columns type="array">
<column>
<name>code</name>
<type>String</type>
</column>
<column>
<name>date</name>
<type>Date</type>
</column>
<column>
<name>settlement</name>
<type>BigDecimal(16,7)</type>
</column>
</columns>
<filters type="array">
<filter>code</filter>
<filter>date</filter>
</filters>
<primary-key type="array">
<primary-key>code</primary-key>
<primary-key>date</primary-key>
</primary-key>
<premium type="boolean">true</premium>
<status>
<refreshed-at>2017-03-02T14:35:25.000Z</refreshed-at>
<status nil="true"/>
<expected-at nil="true"/>
<update-frequency nil="true"/>
</status>
</datatable>
</quandl-response>

vendor_code,datatable_code,name,description,columns,filters,primary_key,premium,status
AR,MWCS,MarketWorks Futures Settlement CME,"","[{:name=>""code"", :type=>""String""}, {:name=>""date"", :type=>""Date""}, {:name=>""settlement"", :type=>""BigDecimal(16,7)""}]","[""code"", ""date""]","[""code"", ""date""]",true,"{:refreshed_at=>""2017-03-02T14:35:25.000Z"", :status=>nil, :expected_at=>nil, :update_frequency=>nil}"

Bulk Download and Pagination

An API call that does not include any filter will, by default, attempt to download the entire table. However, as the API has a limit of 10,000 rows of data, this type of call will not actually download the entire table for most datasets. There are two options to overcome the 10,000 row return limit. See Table Exporter and Pagination solution below.

Table Exporter

We have created an exporter function that will download the entire table as a zipped CSV file. Simply append qopts.export=true to your API call. Using the bulk download feature will create a job which will asynchronously return a download link which contains a zipped csv file with the data.

📘
NOTE:
Table Exporter works through a browser interface and so the API call should be made from your browser to properly access the data.

Definition: https://data.nasdaq.com/api/v3/datatables/{datatable_code}?qopts.export=true

Example Request: https://data.nasdaq.com/api/v3/datatables/NDAQ/RTAT10?qopts.export=true&api_key=YOURAPIKEY

This call will take you to a similar dialog box as the one below, where you will be given the option to download the entire table in a zipped CSV file.

📘
NOTE:
If a more up-to-date CSV can be generated, you will have the option to either:

Download the most recently generated file immediately or

Wait for a new file to be generated. (This option may take several minutes but will provide the most up-to-date data.)

The above example will return the entire NDAQ/RTAT10 table. We also recommend using the Table Exporter by appending qopts.export=true to your API call in the following situations:

Example 1: When Requesting a Large Subset of Data

Use the table exporter like this:
https://data.nasdaq.com/api/v3/datatables/NDAQ/RTAT10?date.gte=2017-02-01&api_key=YOURAPIKEY&qopts.export=true

Do not use this:
https://data.nasdaq.com/api/v3/datatables/NDAQ/RTAT10?date.gte=2017-02-01&api_key=YOURAPIKEY

The above API calls are requesting data where date is greater than or equal to 2017-02-01 which will result in more than 10,000 rows of data. If you make a request without appending qopts.export=true to the API call, only a maximum of 10,000 rows of data will be returned. Appending qopts.export=true bypasses this limit and ensures that all rows of data will be returned.

Example 2: When Making an API Call With Many Filters

Use the table exporter like this:
https://data.nasdaq.com/api/v3/datatables/NDAQ/RTAT10?date.gte=2017-02-01&date.lte=2019-01-01&ticker=ticker=A,AA,AAL,AAMC,AAN,AAOI,AAON,AAP,AAPL,AAT,AAWW,ABAX&qopts.columns=date,ticker,open,high,low,close,volume&api_key=YOURAPIKEY&qopts.export=true

Do not use this:
https://data.nasdaq.com/api/v3/datatables/NDAQ/RTAT10?date.gte=2017-02-01&date.lte=2019-01-01&ticker=ticker=A,AA,AAL,AAMC,AAN,AAOI,AAON,AAP,AAPL,AAT,AAWW,ABAX&qopts.columns=date,ticker,open,high,low,close,volume&api_key=YOURAPIKEY

The above API calls contain many filters and may result in more than 10,000 rows of data. If you make a request without appending qopts.export=true to the API call, only a maximum of 10,000 rows of data will be returned, and the many filters could cause the API call to time out. Appending qopts.export=true will minimize the chances that the API will time out and it bypasses the 10,000 row limit, ensuring that all rows of data will be returned.

Also, if you make an API call with very many filters, this can result in too many characters in your API call. This will return an error: “Your request query parameters are too long.” If you see this error, we recommend bulk downloading the entire table, without filters, and filtering locally for the data you need. For example, instead of using:

https://data.nasdaq.com/api/v3/datatables/NDAQ/RTAT10?date.gte=2017-02-01&date.lte=2019-01-01&ticker=ticker=A,AA,AAL,AAMC,AAN,AAOI,AAON,AAP,AAPL,AAT,AAWW,ABAX&qopts.columns=date,ticker,open,high,low,close,volume&api_key=YOURAPIKEY&qopts.export=true

You could also choose to use this API call without filters and filter locally for the data you need:
https://data.nasdaq.com/api/v3/datatables/NDAQ/RTAT10?api_key=YOURAPIKEY&qopts.export=true

Example 3: When Experiencing Any Other Issues With Our API

If you make an API call and receive a 500 error or an error message which says “Your query will return too many results. Please apply some filters and try again.", we recommend appending qopts.export=true to your API call. This can minimize the chances of encountering such errors.

Example 4: When Retrieving From Data Sets With Big Data Backends

You should use the exporter function to retrieve data from products hosted on our big data backend regardless of the anticipated return row count. You will need to use the exporter function by appending qopts.export=true to your API call. This will return a zipped CSV file with the data enclosed.

You can find a list of these data sets here:

OSMV
ETFC
ETFCCA
PHOTO
PHTOEOD
NOTOI
NOTOEOD
ISEI
ISEEOD
GEMXI
GEMXEOD
GFH
GFHAF

Pagination

The Tables API is limited to 10,000 rows per call. However, you can choose to paginate in the browser. After making an API call without a return format https://data.nasdaq.com/api/v3/datatables/NDAQ/RTAT10?api_key=YOURAPIKEY, the API call will automatically return in JSON format, and you will find a field at the end of the response called "next_cursor_id".

You can append the cursor ID to the same API call to paginate through the requests until the value is null.

Example Request: https://data.nasdaq.com/api/v3/datatables/NDAQ/RTAT10?api_key=YOURAPIKEY&qopts.cursor_id=XXXXXXXXXXXXXXXXXX

This data will also be returned in JSON format.

Using the Bulk Download Programatically

To use our bulk download exporter function programmatically, you will need to append the parameter qopts.export=true to your API call with a return format (i.e. .csv, .json, .xml). When this parameter is present, rather than returning data synchronously in pages, Nasdaq Data Link will generate a single file containing all of the requested data and return metadata containing the location link and status of this file.

DEFINITION: GET https://data.nasdaq.com/api/v3/datatables/{datatable_code}.{format}/?qopts.export=true

https://data.nasdaq.com/api/v3/datatables/zacks/ee.json?api_key=YOURKEY&qopts.export=true&api_key=YOURAPIKEY

https://data.nasdaq.com/api/v3/datatables/zacks/ee.xml?api_key=YOURKEY&qopts.export=true&api_key=YOURAPIKEY

https://data.nasdaq.com/api/v3/datatables/zacks/ee.csv?api_key=YOURKEY&qopts.export=true&api_key=YOURAPIKEY

EXAMPLE RESPONSE:

{
  "datatable_bulk_download": {
      "file": {
        "link": "https://duf9k3nptkna3.cloudfront.net/ZACKS/EE/ZACKS_EE_99456f7bd6584ef9c0d21f3804f27f44.zip?api_key=...",
        "status": "regenerating",
        "data_snapshot_time": "2017-04-26 14:33:02 UTC"
      },
      "datatable": {
        "last_refreshed_time": "2017-10-12 09:03:36 UTC"
      }
    }
}

<quandl-response>
	<datatable-bulk-download>
		<file>
			<link> https://duf9k3nptkna3.cloudfront.net/ZACKS/EE/ZACKS_EE_99456f7bd6584ef9c0d21f3804f27f44.zip?api_key=...
			</link>
			<status>fresh</status>
			<data-snapshot-time type="dateTime">2017-10-12T21:13:54Z</data-snapshot-time>
		</file>
		<datatable>
			<last-refreshed-time type="dateTime">2017-10-12T09:03:36Z</last-refreshed-time>
		</datatable>
	</datatable-bulk-download>
</quandl-response>

file.link,file.status,file.data_snapshot_time,datatable.last_refreshed_time
https://duf9k3nptkna3.cloudfront.net/ZACKS/EE/ZACKS_EE_99456f7bd6584ef9c0d21f3804f27f44.zip?api_key=...

For example, when you append the parameter qopts.export=true to an API call with a return .json format, the API call will return a json object with the following attributes: link, status, data_snapshot_time, last_refreshed_time.

The first call will queue up a job to create the zip file for you. A subsequent call will either place the job in a 'Creating' or 'Fresh' state. You can implement a wait and then re-execute the API call until the file status is 'Fresh'. Once the status is 'Fresh', a URL will populate in the 'link' field which can be executed programmatically to download the zip file.

For more information about bulk download and attributes, please see below:

Attribute Definitions

file

link The string URL where the file can be downloaded, or null, if it is not
present
status The string status of the requested file; the possible values are:
- Fresh the file is available and up to date
- Creating the file is not available but it is being created
- Regenerating the file is available but it is out of date and a new one is
  being created
data_snapshot_time the DateTime when the file creation process was initiated

datatable

last_refreshed_time The DateTime when the table was last updated

The generated link is only valid for 30 minutes. If your link expires, repeat your
API call to generate a new download link.

Limits

This feature is only available to subscribers.
Subscribers must be logged in to access the bulk download API.
Subscribers are limited to requesting 60 bulk download files every hour.

USAGE

📘
NOTE:

Filter Rows

Filter on Multiple Values

Filter Columns

Request Multiple Columns

Filter Rows and Columns

Get Table Metadata

Bulk Download and Pagination

Table Exporter

📘
NOTE:

📘
NOTE:

Pagination

Using the Bulk Download Programatically

Attribute Definitions

file

datatable

Limits

📘NOTE:

Filter Rows

Filter on Multiple Values

Filter Columns

Request Multiple Columns

Filter Rows and Columns

Get Table Metadata

Bulk Download and Pagination

Table Exporter

📘NOTE:

📘NOTE:

Pagination

Using the Bulk Download Programatically

Attribute Definitions

file

datatable

Limits

📘
NOTE:

📘
NOTE:

📘
NOTE: