I have time series data from several weather stations located in a specific area. The readings include a timestamp, the humidity and the temperature. The resolution of the data is quite high, about 6 measurements every second. The recorded data are provided as CSV files (one CSV for each day for each weather station).
My question is how is it possible to perform a query like this: Find a station (or let's say an area) where the temperature is higher than 20°C for more than 6 hours during the last 3 months.
I would appreciate any hints or examples.