Describe how you would design a database schema to track historical stock prices, ensuring quick retrieval for daily and monthly reports.
