Methods, systems, and computer-readable storage media for receiving a query that is coded into a computer-executed application that queries a database system, the query including a first portion that defines a number of groups that data is to be divided into, and a second portion that removes redundant values from a group, if any, processing, within the database system, the query to perform a plurality of computations within the database system, and produce a result set including a plurality of data groups, each data group having a minimum value and associated timestamp, and a maximum value and associated timestamp, and transmitting the result set to the application to provide one or more time series visualizations for display in a user interface.