Barchart Market Data Solutions » Web Services » Historical Data

Minute Date Range Queries

Minute date range queries return the date range available in the minute database for a comma delimited list of symbols.

Historical Data

Instrument Definitions

Overview

Minute date range queries return the date range available in the minute 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,TIMESTAMP_OLDEST_RECORD, TIMESTAMP_MOSTRECENT_RECORD). Symbols that do not exist in the system are simply ignored and no corresponding record is returned. The request handler for minute date range queries is queryminutedaterange.ashx

Minute Date Range Query Parameters

The following parameters are either required or supported in minute 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.

Minute Date Range Query Results Format

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

SYMBOL,YYYY-MM-DD HH:MM,YYYY-MM-DD HH:MM

Example:

AAPL,2008-05-05 09:30,2011-06-29 19:57

IBM,2008-05-05 09:30,2011-06-29 18:51

Minute Date Range Query Examples

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

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