Excel Plug-In: Understanding Queries
Queries with CloudQuant Data Liberator allow you to retrieve two distinct types of data: point-in-time data or time series data.
Point-In-Time Data
Most users requesting point-in-time data query information for the current moment. However, you can specify any particular point in time to examine how data appeared at that previous moment — known as the “as of” date in CloudQuant Data Liberator terminology.
When reading a dataset with point-in-time queries, the system returns data for your specified time, enabling retrieval of historical snapshots showing what information was known at earlier dates.
Think of point-in-time data structurally: one row for each given trading symbol.
Time Series Data
Time series data returns multiple rows for each trading symbol from your specified dataset. For instance, requesting Minute Bar stock prices over a ten-minute period generates 10 data rows per symbol.
