Small web app from google api

For this project, my purpose is to create a stock information database for all the stock in s&p 500. Through SQL language to retrieve information from the database, I can apply some basic stock price data visualisation methods: pricing plot through a certain time window, and correlation table for chosen stocks. And I also developed a web running on the local server. User can select the stock they are interested in and get more information from the stock open high low close price for most recent 3 month.

More detail about this project please refer to: