OVERVIEW
Final Project -607 Data Acquisition and Management
By Karim hammoud
For the final project, I will analyze SP 500 and pick one of the companies stock like Apple, with my 6 years in the finance industry I am inspired to find specific trends that move the market like corporate influence, news, and political status.
There are multiple variables to be analyzed in this like market capitals, trading volume and prices.
U.S. Stock Market Indexes
Sources:
I will use multiple sources like web scraping Wikipedia https://en.wikipedia.org/wiki/List_of_S%26P_500_companies
Quantmod for financial data.
NYT API for the news and sentiment analysis.
TOP US FINANCIAL INDEXES
Row
2020 Stock Pricing Analysis
TOP US FINANCIAL INDEXES2020 Trading days
235Market Cap in $Trillions
29.472020 SP 500 highest value
36992020 SP 500 lowest value
2192Highest Trading Volumne
9044690000Lowest Trading Volumne
2778450000Row
Dow Jones
The Top 4 Major Indexes
NASDAQ-100
Row
SP price 2020
S&P 500 Sectors percentages
Wilshire 5000
S&P 500 LIST
NYT ON APPLE
| Link | summary | paragraph | abstract | news | main | pub_date | document | news_desk | word_count | type |
|---|---|---|---|---|---|---|---|---|---|---|
| https://www.nytimes.com/2020/09/28/technology/apple-epic-app-court.html | The two companies argued in federal court over Apple’s power over apps, as their fight heads to trial next year. | SAN FRANCISCO — Apple and Epic Games, the maker of Fortnite, sparred in federal court on Monday over whether to reinstate the popular game in Apple’s App Store, raising antitrust arguments that may reshape a key part of the internet economy and the way people use smartphones. | The two companies argued in federal court over Apple’s power over apps, as their fight heads to trial next year. | The New York Times | Apple and Epic Games Spar Over Returning Fortnite to the App Store | 2020-09-28T22:03:03+0000 | article | Business | 947 | News |
| https://www.nytimes.com/2020/09/24/technology/apple-google-coalition-epic-match-spotify.html | Spotify, Match Group, Epic Games and others have created a nonprofit alliance that they hope will amplify a protest against the power of the giants. | SAN FRANCISCO — For months, complaints from tech companies against Apple’s and Google’s power have grown louder. | Spotify, Match Group, Epic Games and others have created a nonprofit alliance that they hope will amplify a protest against the power of the giants. | The New York Times | To Fight Apple and Google, Smaller App Rivals Organize a Coalition | 2020-09-24T11:00:09+0000 | article | Business | 919 | News |
| https://www.nytimes.com/2020/09/24/opinion/apple-google-mobile-apps.html | Apple and Google have a virtual monopoly on distributing mobile apps, and that’s bad for competition. | Like most app developers, John Botte wants his work to end up on some of the 1.5 billion active iPhones on the market. But when the software engineer did the math on a photo-sharing app he hoped to create for wedding-goers, he decided against it. | Apple and Google have a virtual monopoly on distributing mobile apps, and that’s bad for competition. | The New York Times | What Apple’s Fortnite Fee Battle Is Really About | 2020-09-25T00:20:57+0000 | article | Editorial | 1328 | Op-Ed |
| https://www.nytimes.com/2020/09/15/technology/apple-watch-is-a-private-road.html | With newer technologies, we risk losing the open highways that have defined our digital lives. | This article is part of the On Tech newsletter. You can sign up here to receive it weekdays. | With newer technologies, we risk losing the open highways that have defined our digital lives. | The New York Times | Apple Watch Is a Private Road | 2020-09-15T16:45:45+0000 | article | NewsDesk | 1198 | News |
| https://www.nytimes.com/2020/09/17/travel/fall-activities-coronavirus.html | Wandering through corn mazes, picking pumpkins and visits to wineries and haunted houses are still on the calendar, but social distancing and face masks are part of the plan. | Across much of the country, fall is the season of apple-picking, corn mazes, winery harvests and Halloween hauntings, luring day-trippers and weekenders to rural areas. But if summer is any guide, many fall festivities may require more planning this year to avoid the crowds. | Wandering through corn mazes, picking pumpkins and visits to wineries and haunted houses are still on the calendar, but social distancing and face masks are part of the plan. | The New York Times | Fall’s Here. Can We Still Go Apple Picking? | 2020-09-17T09:00:25+0000 | article | Travel | 2074 | News |
| https://www.nytimes.com/2020/09/17/us/apples-maggots-washington-inslee.html | Gov. Jay Inslee apologized for transporting the pest to maggot-free counties in Washington, which produces about 70 percent of the nation’s apples. After the discovery, the hunt was on. | During a visit last weekend to areas of eastern Washington that had been scorched by wildfires, Gov. Jay Inslee brought a personal gift: honeycrisp apples grown at the Governor’s Mansion in Olympia. | Gov. Jay Inslee apologized for transporting the pest to maggot-free counties in Washington, which produces about 70 percent of the nation’s apples. After the discovery, the hunt was on. | The New York Times | A Governor Bestowed Apples on Wildfire Victims. The Maggots Were Unintended. | 2020-09-18T03:40:59+0000 | article | National | 537 | News |
| https://www.nytimes.com/2020/09/17/technology/personaltech/new-apple-watch-blood-oxygen-level-review.html | Blood oxygen readings can be a useful indicator of wellness, but context is important — and so is medical advice from a doctor. | The new Apple Watch can be summed up in two words: blood oxygen. | Blood oxygen readings can be a useful indicator of wellness, but context is important — and so is medical advice from a doctor. | The New York Times | The New Apple Watch Measures Your Blood Oxygen. Now What? | 2020-09-17T13:00:13+0000 | article | Business | 971 | News |
| https://www.nytimes.com/2020/09/12/arts/music/simeon-coxe-dead.html | In the late 1960s, playing a homemade electronic instrument, he created “the mating call between a jackhammer and a Veg-O-Matic.” | Simeon Coxe, a songwriter, singer and inventor whose psychedelic-era band Silver Apples was one of the first to put a synthesizer at the center of its music, died on Tuesday at his home in Fairhope, Ala. He was 82. | In the late 1960s, playing a homemade electronic instrument, he created “the mating call between a jackhammer and a Veg-O-Matic.” | The New York Times | Simeon Coxe, Whose Silver Apples Presaged Synth-Pop, Dies at 82 | 2020-09-12T15:18:00+0000 | article | Obits | 1057 | News |
| https://www.nytimes.com/2020/09/28/technology/google-play-store-30-percent.html | Some companies like Netflix and Spotify had avoided making the payment when people paid for something inside their apps. | OAKLAND, Calif. — Google said it would no longer allow any apps to circumvent its payment system within the Google Play store that provides the company a cut of in-app purchases. | Some companies like Netflix and Spotify had avoided making the payment when people paid for something inside their apps. | The New York Times | Google Demands 30% Cut From App Developers in Its Play Store | 2020-09-28T17:03:44+0000 | article | Business | 648 | News |
| https://www.nytimes.com/2020/09/30/arts/television/new-streaming-hulu-amazon.html | Every month, subscription streaming services add a new batch of titles to their libraries. Here are our picks for October. | For more recommendations on what to stream, sign up for our twice-weekly Watching newsletter here. | Every month, subscription streaming services add a new batch of titles to their libraries. Here are our picks for October. | The New York Times | The Best Movies and TV Shows Coming to Hulu, Amazon and More in October | 2020-09-30T21:34:18+0000 | article | Culture | 1269 | News |
APPLE ANALYSIS
Row
2020 Stock Pricing Analysis
APPLE COMPANY ANALYSISMarket Cap in $Trillions
1.995T2020 Apple highest value
1342020 Apple lowest value
552020 Apple Highest Trading Volumne
4268848002020 Apple Lowest Trading Volumne
20197800Row
Volume from 2019 - 2020 AAPL
Price range from 2019 - 2020 - AAPL
Row
Sentiment for NYT on Apple from July to Sept
NYT Sentiment for July 31 Article
NYT Sentiment on Apple from July to Sept
CONCLUSION
Based on the analysis I did, it showed all of the stocks indexes had fall down in march and april 2020 when
On the dashboard tab: it showed the data for SP, DOW, Nasdaq, and Wilshire with with pie chart for the top also the market cap and trading volume for the last trading day.
On the SP 500 list it was collected from Wikipedia and it shows a searchable table for all of the tickers and companies at SP 500, in addition to searchable to the year it was added to the sp list.
On the NYT APPLE, the data was collected from new york times API and it showes the articles about the apple inc, and summary and paragraph.
On the apple analysis tab, it showes the apple company stock analysis with market cap and lowest stock price in 2020, and stock trending the volume as well. and I created a sentiment analysis, for positive and negative on the paragraph, and I chose july 31 article because there is a increase in the date, and checked the nrc sentiment analysis for the nyt article.
Chech this article https://www.nytimes.com/2020/07/30/technology/tech-company-earnings-amazon-apple-facebook-google.html
Created by: Karim Hammoud