Average Ratings 0 Ratings
Average Ratings 0 Ratings
Description
A parallel query engine designed for efficient access to time- and symbol-indexed data. It incorporates an extended SQL syntax that allows for sophisticated filtering and aggregation capabilities. Users can unify quotes, trades, snapshots, and reference data within a single environment. The platform supports strategy backtesting using high-frequency data for enhanced analysis. It facilitates quantitative research and insights into market microstructure. Additionally, it offers detailed transaction cost analysis and comprehensive rollup reporting features. Market surveillance mechanisms and anomaly detection capabilities are also integrated into the system. The decomposition of non-transparent ETF/ETN instruments is supported, along with the utilization of FAST, SBE, and proprietary communication protocols. A plain text protocol is available alongside consolidated and direct data feeds. The system includes built-in tools for monitoring latency and provides end-of-day archival options. It can perform ETL processes from both institutional and retail financial data sources. Designed with a parallel SQL engine that features syntax extensions, it allows advanced filtering by trading session, auction stage, and index composition for precise analysis. Optimizations for aggregates related to OHLCV and VWAP calculations enhance performance. An interactive SQL console with auto-completion improves user experience, while an API endpoint facilitates seamless programmatic integration. Scheduled SQL reporting options are available, allowing delivery via email, file, or web. JDBC and ODBC drivers ensure compatibility with various applications, making this system a versatile tool for financial data handling.
Description
OpenTSDB comprises a Time Series Daemon (TSD) along with a suite of command line tools. Users primarily engage with OpenTSDB by operating one or more independent TSDs, as there is no centralized master or shared state, allowing for the scalability to run multiple TSDs as necessary to meet varying loads. Each TSD utilizes HBase, an open-source database, or the hosted Google Bigtable service for the storage and retrieval of time-series data. The schema designed for the data is highly efficient, enabling rapid aggregations of similar time series while minimizing storage requirements. Users interact with the TSD without needing direct access to the underlying storage system. Communication with the TSD can be accomplished through a straightforward telnet-style protocol, an HTTP API, or a user-friendly built-in graphical interface. To begin utilizing OpenTSDB, the initial task is to send time series data to the TSDs, and there are various tools available to facilitate the import of data from different sources into OpenTSDB. Overall, OpenTSDB's design emphasizes flexibility and efficiency for time series data management.
API Access
Has API
No
API Access
Has API
No
Integrations
APERIO DataWise
No
Axibase Enterprise Reporter (AER)
Yes
Circonus IRONdb
No
Google Cloud Bigtable
No
InsightFinder
No
SQL
Yes
VictoriaMetrics
No
Integrations
APERIO DataWise
Yes
Axibase Enterprise Reporter (AER)
No
Circonus IRONdb
Yes
Google Cloud Bigtable
Yes
InsightFinder
Yes
SQL
No
VictoriaMetrics
Yes
Pricing Details
No price information available.
Free Trial
Yes
Free Version
Yes
Pricing Details
No price information available.
Free Trial
No
Free Version
No
Deployment
Web-Based
Yes
On-Premises
No
iPhone App
No
iPad App
No
Android App
No
Windows
No
Mac
Yes
Linux
No
Chromebook
No
Deployment
Web-Based
Yes
On-Premises
No
iPhone App
No
iPad App
No
Android App
No
Windows
No
Mac
No
Linux
No
Chromebook
No
Customer Support
Business Hours
Yes
Live Rep (24/7)
No
Online Support
Yes
Customer Support
Business Hours
No
Live Rep (24/7)
No
Online Support
Yes
Types of Training
Training Docs
Yes
Webinars
Yes
Live Training (Online)
No
In Person
No
Types of Training
Training Docs
Yes
Webinars
No
Live Training (Online)
No
In Person
No
Vendor Details
Company Name
Axibase
Founded
2004
Country
United States
Website
axibase.com
Vendor Details
Company Name
OpenTSDB
Website
opentsdb.net/overview.html