Quandl API Documentation

Welcome to Quandl. You'll find comprehensive guides and documentation to help you start working with Quandl as quickly as possible, as well as support if you get stuck. Let's get started.

Guides    

USAGE

ūüďė

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.

ūüďė

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.)

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.¬† ¬†

DEFNITION: 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 2 months ago

USAGE


Suggested Edits are limited on API Reference Pages

You can only suggest edits to Markdown body content, but not to the API spec.