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.

Documentation    

Search results for "{{ search.query }}"

No results found for "{{search.query}}". 
View All Results

USAGE

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 two minutes. If your link expires, repeat your
API call to generate a new ​download link.

Limits

  • If you do not have a subscription to the data, your file will include only preview data.
  • Subscribers must be logged in to access the bulk download API.
  • Subscribers are limited to requesting 10 bulk download files every hour.

USAGE