fine-tuned db schema and replaced manual stock_price table partitioning with MySQL's built-in table partitioning options