Barchart Market Data Solutions » Web Services » Historical Data

End of Day Date Range Queries

End of Day date range queries return the date range available in the end of day database for a comma delimited list of symbols.

Historical Data

Instrument Definitions

Overview

End of Day date range queries return the date range available in the end of day database for a comma delimited list of symbols. Only three parameters are supported, and all three are required: username, password, and symbols.

The results consist of three-field records (i.e. SYMBOL,DATE_OLDEST_RECORD, DATE_MOSTRECENT_RECORD). Symbols that do not exist in the system are simply ignored and no corresponding record is returned. The request handler for end of day date range queries is queryeoddaterange.ashx

End of Day Date Range Query Parameters

The following parameters are either required or supported in end of day date range queries (required parameters are marked with an asterisk):

username*: this parameter should be set to the user name provided by ddfplus to the user account.

password*: this parameter should be set to the password provided by ddfplus for the user name passed in parameter username.

symbols*: this parameter should be set to a comma delimited list of symbols for which the query should return data.

End of Day Date Range Query Results Format

Results are returned by end of day date range queries in comma delimited text format, one symbol date range record per line, as follows (first date is the oldest record available in the system, and second date is the most recent record available in the system):

SYMBOL,YYYY-MM-DD,YYYY-MM-DD

Example:

AAPL,1987-10-06,2011-06-29

IBM,1987-10-01,2011-06-29

End of Day Date Range Query Examples

In order to query date ranges available in the system for both IBM and AAPL, execute:

http://ds01.ddfplus.com/historical/queryeoddaterange.ashx?username=username&password=password&symbols=IBM,AAPL