Guides
Guides

USAGE

Suggest Edits

📘

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://www.quandl.com/api/v3/datatables/{datatable_code}.{format}?<row_filter_criteria>

Example Request:

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

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

curl "https://www.quandl.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://www.quandl.com/api/v3/datatables/ETFG/FUND.json?ticker=SPY,IWM&api_key=YOURAPIKEY"

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

curl "https://www.quandl.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://www.quandl.com/api/v3/datatables/{datatable_code}.{format}?<column_filter_criteria>

Example Request:

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

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

curl "https://www.quandl.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://www.quandl.com/api/v3/datatables/ETFG/FUND.json?qopts.columns=ticker,date,shares_outstanding&api_key=YOURAPIKEY"

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

curl "https://www.quandl.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://www.quandl.com/api/v3/datatables/{datatable_code}.{format}?<column_filter_criteria>&<row_filter_criteria>

Example Request:

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

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

curl "https://www.quandl.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://www.quandl.com/api/v3/datatables/{datatable_code}/metadata.{format}

Example Request:

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

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

curl "https://www.quandl.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}"

Download an entire table

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. For this purpose, we have created Table Exporter.

Table Exporter

Alternatively, 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.

📘

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://www.quandl.com/api/v3/datatables/{datatable_code}?qopts.export=true

Example Request: https://www.quandl.com/api/v3/datatables/WIKI/PRICES?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.

592

📘

NOTE:

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

  1. Download the most recently generated file immediately or
  2. 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 WIKI/PRICES 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://www.quandl.com/api/v3/datatables/WIKI/PRICES?date.gte=1997-02-01&api_key=YOURAPIKEY&qopts.export=true

Do not use this:
https://www.quandl.com/api/v3/datatables/WIKI/PRICES?date.gte=1997-02-01&api_key=YOURAPIKEY

The above API calls are requesting data where date is greater than or equal to 1997-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://www.quandl.com/api/v3/datatables/WIKI/PRICES?date.gte=1997-02-01&date.lte=2017-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://www.quandl.com/api/v3/datatables/WIKI/PRICES?date.gte=1997-02-01&date.lte=2017-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://www.quandl.com/api/v3/datatables/WIKI/PRICES?date.gte=1997-02-01&date.lte=2017-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://www.quandl.com/api/v3/datatables/WIKI/PRICES?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.

Get an entire table 

 
Our Table API provides users the functionality to download an entire table. The file is created on demand, based on the provided API parameters and delivered asynchronously. That is, the request will return a link to the contents of the table.

To download an entire table, simply append the query parameter qopts.export=true​ to your table request. When this parameter is present, rather than returning data synchronously in pages, Quandl 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://www.quandl.com/api/v3/datatables/{datatable_code}.{format}/?qopts.export=true

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

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

https://www.quandl.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=...

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 10 bulk download files every hour.

Updated almost 4 years ago