Loscalzo,
Indeed the workload you describe might be problematic for MySQL.
Actually for what you describe - historical data of stock prices and run analytics over it, I saw multiple successful deployments of ClickHouse. You may want to take a look - [URL]Fast Open-Source OLAP DBMS - ClickHouse