Altair® Panopticon


Creating Data Extract from OneTick

The OneTick connector allows connection to OneMarketData OneTick tick history databases on a polled basis. In general, it is used to retrieve conflated time series data sets. The connector supports either:

q  Execution of a specified OTQ

q  Execution of a specified parameterized OTQ

q  Execution of a custom SQL Query



1.     On the New Data Extract page, select OneTick in the Connector drop-down list.


2.     Enter the Context (for example, REMOTE).

3.     You can either check:

·         Show Local OTQs box to display the local OTQs in the Selected OTQ drop-down list.

·         Show Remote OTQs box to display the remote OTQs in the Selected OTQ drop-down list.

An OTQ can be specified for execution, or a custom SQL query can be executed, through selection of the appropriate radio button:

·         OTQs

·         Query

4.    Click Load    to populate the Selected OTQ drop-down list. Select an OTQ.

The list of input parameters that the OTQ expects is displayed. In addition, the basic SQL query is generated allowing the OTQ to be executed.

As well as the input parameters specific to the selected OTQ, the following are generic to all OTQs:

·         Symbol List


This property will accept comma-separated values either hardwired or parameterized.


·         From

·         To

These add additional filter criteria such as symbol, and time window onto the basic OTQ.

5.     Check the Separate DB Name box to generate a separate field for the database name.

6.     Check the Show per symbol errors as warnings box to proceed with warnings in the log if symbol errors are returned.

The result is a fully generated OneTick SQL query. This can be edited as required.

7.     Click    to save and display the details of the data extract.

8.     Click   then   to display the data preview.