Get Historical IEX Cloud Core Financial Data#
Important
We are in the process of migrating legacy IEX Cloud Core Data to IEX Cloud Core Datasets in Apperate. IEX Cloud’s API reference is currently split between Apperate’s API Reference and the Legacy API Reference. If the API Reference doesn’t list the data you want, please check the Legacy API Reference.
Apperate’s Core Financial Datasets provide historical time series financial data. Let’s call an endpoint to get this financial data.
Prerequisites:
IEX Cloud Apperate account - Create one here.
Apperate workspace - See Creating a Workspace.
Steps#
Here are steps for getting this core financial data.
Browse the Core Financial Datasets in the console at Data → Datasets → Core. The Core Datasets list appears.
Hint
If there are grayed-out datasets you want to use, upgrade your plan. To upgrade, click one of the grayed-out datasets and click the Upgrade button that appears. Otherwise, upgrade your plan at Account → Manage Plan.
Click on the dataset you want data from. For example, if you want to get cash flow records, click the CASH_FLOW dataset. The dataset overview appears.
Note
From a dataset’s Database page, you can query its data, export the query results to a CSV, and share your query in a URL.
Examine the the Example Request URL.
https://WORKSPACE.iex.cloud/v1/data/CORE/CASH_FLOW?last=1&token=TOKEN
Here’s a breakdown of the URL.
URL Component
Description
https://WORKSPACE.iex.cloud/v1
Base URL consisting of the domain (your workspace is the subdomain) and the API version.
/data/CORE/CASH_FLOW
The Data API’s
GET /data/
method followed by path parameter valuesCORE
for the dataset namespace andCASH_FLOW
for the dataset ID.?last=1&token=TOKEN
Method parameters
last=1
to return the last record andtoken=TOKEN
to authorize access. Please see theGET /data/
method reference for additional parameters. See Security and Access to create public access tokens.Get the latest record by clicking the Example Request URL. Apperate opens the request in a new browser tab and the A JSON array appears in the response like this:
[ { "capitalExpenditures": -153981933.26019996, "cashChange": 52921982765.789, "cashFlow": -7635540477.244902, "cashFlowFinancing": 804800407.0185003, "changesInInventories": 0, "changesInReceivables": 0, "currency": "USD", "depreciation": 300821632.50179994, "dividendsPaid": null, "exchangeRateEffect": null, "filingType": "6-K", "fiscalDate": "2022-07-31", "fiscalQuarter": 3, "fiscalYear": 2022, "investingActivityOther": null, "investments": null, "netBorrowings": -786885758368.2644, "netIncome": 1956976221.5984, "otherFinancingCashFlows": null, "reportDate": "2022-08-23", "symbol": "BNS", "totalInvestingCashFlows": 5990703186.795099, "id": "CASH_FLOW", "key": "BNS", "subkey": "quarterly", "date": 1659225600000, "updated": 1661439879000 } ]
Note
The response will be different for you because records are continuously being added.
Update the URL to get Apple’s latest cash flow record: add the
AAPL
symbol as a path parameter (thekey
path parameter) afterCASH_FLOW
and replaceWORKSPACE
andTOKEN
with your values.https://WORKSPACE.iex.cloud/v1/data/CORE/CASH_FLOW/AAPL?last=1&token=TOKEN
A JSON array appears in the response like this:
[ { "capitalExpenditures": -2102000000, "cashChange": 48231000000, "cashFlow": 22892000000, "cashFlowFinancing": -27445000000, "changesInInventories": 5433000000, "changesInReceivables": 42242000000, "currency": "USD", "depreciation": 2805000000, "dividendsPaid": null, "exchangeRateEffect": null, "filingType": "10-Q", "fiscalDate": "2022-06-25", "fiscalQuarter": 3, "fiscalYear": 2022, "investingActivityOther": null, "investments": null, "netBorrowings": 55074000000, "netIncome": 19442000000, "otherFinancingCashFlows": null, "reportDate": "2022-07-29", "symbol": "AAPL", "totalInvestingCashFlows": 4234000000, "id": "CASH_FLOW", "key": "AAPL", "subkey": "quarterly", "date": 1656115200000, "updated": 1661439802000 } ]
Important
key and subkey path parameters are restricted to primary and secondary indexes, respectively. For more information on the Unique Index components, see Understanding Datasets.
Congratulations on getting core financial time series data.
What’s Next#
If you want to get real-time IEX Cloud financial data, see Get Real-Time IEX Cloud Core Financial Data.
To dive into more Core Financial Dataset queries using the Data API, see Querying Datasets.
To learn more about Apperate’s APIs, visit the API Reference.
If want to combine Core Financial Dataset data with data from other datasets, check out Create Views.
If you need to store application data, learn how at Write and Read Data.