i am looking for an project wherein u deal with stock market data
wherein u can capture data from yahoo finance website for each n every second for some specific time period by performing etl
where data is captured at the end of the day in csv format for various companies.

Another csv should be generated for capturing the tweets(good or bad) from the social networking site twitter against this stock data

Based on this two csv data -

will create trending reports to see the effects of centiments(good or bad tweets is distinguished using the words like Good and Bad in tweet) on the stock data products -

EG - What are the feedbacks for the apple product?
how the sale for apple varies weekly, monthly and yearly based on feedback(tweet)?


Thanks,
Sheetal