I am building a trading system.
I have 40,000 different symbols, and 32 candles each symbol per day.
I would like to store a month of data. and the read actions to be fast (I’m querying symbol by symbol)
How do you suggest to design the DB? (collection for each symbol? collection for each day?)