ONETICK

From Hanlon Financial Systems Lab Web Encyclopedia
Jump to: navigation, search

Onetick

Onetick is the flagship product of OneMarketData (OMD), a company focused on providing market data management and analytical solutions that enable financial institutions to outmaneuver their competition by allowing them to develop and execute new trading strategies faster than previously possible.
Through Onetick, client solutions are created combining complex event processing (CEP) with historical tick data analysis. OneTick provides both historical and real-time services, and with it quantitative analysts and traders can enhance alpha, increasing trading performance through superior data management.
Onetick is powered by its database server, a proprietary, non-relational engine, which includes an in-memory database and a file-based archive store. Unlike in a typical relational storage engine, there is no need to wrestle with a vast amount of decision points for the design of tables, schemas, relationships, indexing strategies, and so forth. Thus, modeling work can be efficiently and effectively reduced to a few items.
With its intuitive, performance-driven design, OneTick users benefit from an enterprise system designed and built by Wall Street experts to address the sophisticated data analysis needs of the most demanding financial institutions.

Client APIs and programming languages

OneTick provides a client library with bindings across standard compiled languages, Java, C++ and C# and the ubiquitous scripting languages of PERL and Python. The API across all the languages provides a means to execute queries (stored in OTQ files), access data directly, and execute SQL statements using OneTick’s own dialect. As with all the query tools and mechanisms, the API operates on all the database storage subsystems (archives, in-memory, real-time) providing transparent access across them. The API is callback based, and result sets are self-describing and so it is possible to use exact same client code for historical queries as for continuous / CEP queries. In addition to query execution, the OneTick API can be used to extend the OneTick analytical language and to design custom versions of real-time data collectors, historical or in memory database loaders or CEP adapters.

Types of data that Onetick handles

OneTick is optimized for the capture, storage, retrieval and analysis of extremely high-frequency (tick) data. It is built to specifically handle data in the financial markets domain, such as instrument prices, trades, quotes, order book information, etc. Additionally, it can be used to store other types of data, such as closing prices, orders & executions, fundamental data and news feeds; OneTick has pre-defined constructs to support these financial market-specific concepts. The OneTick database server (also referred to as the Tick Server) is a proprietary, non-relational engine, which includes an in-memory database and a file-based archive store.

How is it different?

OneTick is a time series tick database, a software system that is optimized for the handling of data organized by time. Time series are finite or infinite sequences of data items, where each item has an associated timestamp and the sequence of timestamps is non-decreasing. OneTick is such a database management system specifically for storing financial tick data such as trades and quotes. It also incorporates the ability to apply trade cancels, corrections and corporate actions such as splits and dividends. These are unique features to OneTick specifically designed for the financial industry.

Time Series

Time series are finite or infinite sequences of data items, where each item has an associated timestamp. The time resolution of some systems such as financial data sources can be quite low (milliseconds, microseconds or even nanoseconds). Elements of a time series are called ticks. Time series are also called (data) streams. The term 'stream' is often associated with infinite sequences (as in 'stream-oriented computation', i.e. computation that does not assume that the end of the data is accessible and occurs as the data arrives) but is used interchangeably with 'time series'.

Core Technologies

OneTick is a specialized time-series tick database optimized for capture, storage, retrieval and analysis of extremely high-frequency (tick) data. It is built to specifically handle data in the financial markets domain, such as instrument prices, trades, quotes, order book information, etc.
OneTick is also a complex event processing (CEP) for the analysis of real-time market data. These are the foundational technologies within OneTick which are folded together into a single solution. This allows users to efficiently incorporate history and real-time data analysis. OneTick does not distinguish or require differing programming models in the use of real-time vs. historic data. They are viewed as a single time continuum, what happened yesterday, last week or last month is simply as extension of what is occurring today and what may occur in the future.