Onetick Cloud
SQL Querying Examples
Real Time & Historical Market Data on Demand
ABOUT THE SERVICE
Query the Market Data assets available in OneTick Cloud via SQL.
Example queries are provided as a starting point covering both the types of data to retrieve and some of the available time series analytics. Modify these examples or write your own SQL to retrieve relevant data.
SQL access to data assets is supported through this dashboard, the REST API, Python API, ODBC & JDBC Drivers, and the OneTick desktop tools.
WATCH THE DEMO
ALL SERVICES
- Data Assets
- Symbol Universe
- Symbol Cross Reference Mapping
- REST API End Point Documentation
- Reference Data & Enumerations
- System Availability
- US - Market Share
- Canada - Market Share
- European - Market Share
- SQL Querying Examples
- Python Queries Using Directed Graph Style API
- Python Queries Using Pandas Style API
- Futures Continuous Contracts
- Point in Time with Offsets
- Latest Prices
- L1 Tick Data
- Trade and Quote Bars
- Book Depth
- US ETF Universe
- EBBO Calculation
- Data Explorer
- Corporate Actions History
- Market Replay
- Period Quote & Trade Statistics