Ideal schema for a financial TS database

1

Hi all,
very new to InfluxDB.

I would like to set up a ts database with thousands of time series, e.g.

1 S&P 500 Price
2 S&P Total Return
3 S&P Volatility
4 Microsoft Price
5 Microsoft Volume
[…]

Shall I go for 1 measurement and thousands of fields with tags to determine the financial instrument?
Or thousands of measurements with one field?
Or 1 measurement per financial instrument (e.g. S&P) and all necessary fields (e.g. Price, Total Return, Volatility)?

Thank you!

Massimo

2

You can find some guidelines about schema design in our documentation.

Generally, you probably want one measurement, with tags for meta data such as instrument name, and fields for the data itself, such as price.