Write python code to download daily stock prices from National Stock Exchange website.

1. Open this website. https://www.nseindia.com/products/content/equities/equities/archieve_eq.htm

2. Select Report as "Bhavcopy"

3. Download all the files for last 10 years

Understand bhavcopy data structure and create a database structure in MySQL

1. Create master table for Company names along with symbol, stock split, bonus issue etc

2. Create a separate table for data

3. Connect all these tables using primary and foreign keys

4. Create routines for showing a time series for any company

5. Create indexes to speed up query execution. Ideally, any query should execute in less than 100 ms

Create a public web page for displaying stock price chart

1. Design a web page using Pencil or other wireframing tools. This should be done simultaneously with Point 2.4 above

2. Create a web server and an HTML page using Django library in Python

3. Use D3.js charts or Google charts to show census data in chart and table format

Create an android mobile app for displaying census data

1. Design screens for the app using Pencil or other wireframing tools. This should be done simultaneously with Point 2.4 above

2. Use the same web server, charts and routines created above to fetch and visualize data