Lots o' Ticks: Real-time high performance time series queries on billions of trades and quotes

Arthur Whitney, Dennis Shasha

Research output: Chapter in Book/Report/Conference proceedingConference contribution

Abstract

Financial mathematicians think they can predict the future by looking at time series of trades and quotes (called ticks) from the past. The main evidence for this hypothesis is that prices fluctuate only by a small amount in a given day and more or less obey the mathematics of a random walk. The hypothesis allows traders to price options and to speculate on stocks. This demonstration presents a query language and a parallel database (50-way parallelism) to support traders who want to analyze every tick, not just end-of-day ticks, using temporal statistical queries such as time-delayed correlations and tick trends. This is the first attempt that we know of to store and analyze hundreds of gigabytes of time series data and to query that data using a declarative time series extension to SQL (available at www.kx.com).

Original languageEnglish (US)
Title of host publicationProceedings of the ACM SIGMOD International Conference on Management of Data
EditorsT. Sellis, S. Mehrotra
Pages617
Number of pages1
StatePublished - 2001
Event2001 ACM SIGMOD International Conference on Management of Data - Santa Barbara, CA, United States
Duration: May 21 2001May 24 2001

Other

Other2001 ACM SIGMOD International Conference on Management of Data
CountryUnited States
CitySanta Barbara, CA
Period5/21/015/24/01

Fingerprint

Time series
Query languages
Demonstrations

ASJC Scopus subject areas

  • Computer Science(all)

Cite this

Whitney, A., & Shasha, D. (2001). Lots o' Ticks: Real-time high performance time series queries on billions of trades and quotes. In T. Sellis, & S. Mehrotra (Eds.), Proceedings of the ACM SIGMOD International Conference on Management of Data (pp. 617)

Lots o' Ticks : Real-time high performance time series queries on billions of trades and quotes. / Whitney, Arthur; Shasha, Dennis.

Proceedings of the ACM SIGMOD International Conference on Management of Data. ed. / T. Sellis; S. Mehrotra. 2001. p. 617.

Research output: Chapter in Book/Report/Conference proceedingConference contribution

Whitney, A & Shasha, D 2001, Lots o' Ticks: Real-time high performance time series queries on billions of trades and quotes. in T Sellis & S Mehrotra (eds), Proceedings of the ACM SIGMOD International Conference on Management of Data. pp. 617, 2001 ACM SIGMOD International Conference on Management of Data, Santa Barbara, CA, United States, 5/21/01.
Whitney A, Shasha D. Lots o' Ticks: Real-time high performance time series queries on billions of trades and quotes. In Sellis T, Mehrotra S, editors, Proceedings of the ACM SIGMOD International Conference on Management of Data. 2001. p. 617
Whitney, Arthur ; Shasha, Dennis. / Lots o' Ticks : Real-time high performance time series queries on billions of trades and quotes. Proceedings of the ACM SIGMOD International Conference on Management of Data. editor / T. Sellis ; S. Mehrotra. 2001. pp. 617
@inproceedings{f24968bfe097431599f4207281f498e2,
title = "Lots o' Ticks: Real-time high performance time series queries on billions of trades and quotes",
abstract = "Financial mathematicians think they can predict the future by looking at time series of trades and quotes (called ticks) from the past. The main evidence for this hypothesis is that prices fluctuate only by a small amount in a given day and more or less obey the mathematics of a random walk. The hypothesis allows traders to price options and to speculate on stocks. This demonstration presents a query language and a parallel database (50-way parallelism) to support traders who want to analyze every tick, not just end-of-day ticks, using temporal statistical queries such as time-delayed correlations and tick trends. This is the first attempt that we know of to store and analyze hundreds of gigabytes of time series data and to query that data using a declarative time series extension to SQL (available at www.kx.com).",
author = "Arthur Whitney and Dennis Shasha",
year = "2001",
language = "English (US)",
pages = "617",
editor = "T. Sellis and S. Mehrotra",
booktitle = "Proceedings of the ACM SIGMOD International Conference on Management of Data",

}

TY - GEN

T1 - Lots o' Ticks

T2 - Real-time high performance time series queries on billions of trades and quotes

AU - Whitney, Arthur

AU - Shasha, Dennis

PY - 2001

Y1 - 2001

N2 - Financial mathematicians think they can predict the future by looking at time series of trades and quotes (called ticks) from the past. The main evidence for this hypothesis is that prices fluctuate only by a small amount in a given day and more or less obey the mathematics of a random walk. The hypothesis allows traders to price options and to speculate on stocks. This demonstration presents a query language and a parallel database (50-way parallelism) to support traders who want to analyze every tick, not just end-of-day ticks, using temporal statistical queries such as time-delayed correlations and tick trends. This is the first attempt that we know of to store and analyze hundreds of gigabytes of time series data and to query that data using a declarative time series extension to SQL (available at www.kx.com).

AB - Financial mathematicians think they can predict the future by looking at time series of trades and quotes (called ticks) from the past. The main evidence for this hypothesis is that prices fluctuate only by a small amount in a given day and more or less obey the mathematics of a random walk. The hypothesis allows traders to price options and to speculate on stocks. This demonstration presents a query language and a parallel database (50-way parallelism) to support traders who want to analyze every tick, not just end-of-day ticks, using temporal statistical queries such as time-delayed correlations and tick trends. This is the first attempt that we know of to store and analyze hundreds of gigabytes of time series data and to query that data using a declarative time series extension to SQL (available at www.kx.com).

UR - http://www.scopus.com/inward/record.url?scp=0034818753&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=0034818753&partnerID=8YFLogxK

M3 - Conference contribution

SP - 617

BT - Proceedings of the ACM SIGMOD International Conference on Management of Data

A2 - Sellis, T.

A2 - Mehrotra, S.

ER -