I run an investment consultancy. I want to build a software which will download market data from NSE and BSE website and save it in MYSQL Database.
I need a java spring project which will download NSE and BSE daily market data and will store in Mysql tables.
The links to download are as follows:
NOTE: the are link for only single day e.g. 07 OCT 2019.
NSE_EQ = [login to view URL]
NSE_DERIVATIVE = [login to view URL]
NSE_CURRENCY = [login to view URL]
NCDEX_COMMODITY = [login to view URL]
BSE_EQ = [login to view URL]
Task to be done:
1. Design the MySQL DB shcema
2. Write an optimized REST API code to download the above URLs. The code MUST take date range. The downloaded data MUST be persisted in a directory. The URL which provides ".zip" file needs to be UnZipped in another directory. This directory also must be persisted.
2. Write and optimized code to parse the downloaded/UnZipped CSV files and save it to MySQL DB.
3. Write optimized REST API code to fecth data from MySQL DB by providing
Market_Segment = NSE_EQ or NSE_DERIVATIVE or NSE_CURRENCY or NCDEX_COMMODITY or BSE_EQ
SCRIPT_NAME = RELIANCE or SBIN or USDINR or .....
DATE_RANGE = FROM = 01SEP2019 , TO = 05OCT2019
4. ALL REST API must have some username and password to access
5. ALL API must have cron/quartz scheduler for daily data download
6. The code MUST contain JUNIT Testcses
7. Stepwise delivery expected
8. Findal delivery should contain the following:
1. Software design block diagram
2. Database schema diagram
3. Complete working code with test cases in JAVA, Spring Boot
4. MySQL DB schema in ".sql" file format
5. POSTMAN project to test the REST APIs
NOTE: Stepwise payment may be released if working code is delivered. I am always avilable for a discussion and will guide if you are blocked on some point.
24 freelancers are bidding on average ₹25770 for this job
Hi, We are a team of professional software developers. We have expertise in Java and can readily work on your requirements. Kindly consider our proposal for the best results. Best Regards, Team Optiroute Solutions
Hello sir I am a 5 year experienced java developer expertise in java, spring boot, spring mvc, hibernate, junit, mockito, testng, javafx, angular 2,4,5,6,7,8, reactjs, react redux. I can do it. Please hire me.
I have rich experience for data crawling for at least two years. Besides, i also have a lot of successful project experience on Java and MySql. For this task, things can be done within several days.