Abstract: Aspects of the subject technology relate to systems, methods, and computer-readable media for dynamically filtering time series data using multiple conditions in a structured query environment. An example method can include receiving, in a structured query environment, a data request, which includes a plurality of conditions associated with a time period. The example method further includes accessing a database, which is configured to store time-series data corresponding to the time period and mapping a set of dates based on the plurality of conditions associated with the time period. The example method also includes applying a sequence of filters corresponding to the plurality of conditions, onto the set of dates, within a single query to the database and obtaining, from the database, data corresponding to filtered dates.