Storing weather data

Have you tried MongoDB Charts?

If you use MongoDB Atlas, the Charts are also available for use in it. Also available for free/shared clusters.

By the way, you do not have to reduce your data size since your document size is relatively small enough. and if you use Charts after, you will be able to filter as you like later.