{"cells":[{"cell_type":"markdown","metadata":{},"source":["# Overview\n","\n","This project focuses on applying machine learning techniques to stock market analysis and trading. The goal is to leverage natural language processing (NLP) of financial news combined with quantitative trading algorithms to generate actionable insights for making profitable trades. Specifically, the project aims to analyze sentiment in news headlines about 30 companies in the Dow Jones Industrial Average (DJIA) index, and correlate this sentiment with actual stock price movements over corresponding time periods. Sentiment refers to the tone of the text - whether it is positive, negative or neutral about a company. By quantifying and correlating sentiment signals in headlines with price changes, the system can identify predictive indicators.\n"," \n","These sentiment-based indicators can then be combined with traditional technical analysis strategies, like detecting trends and momentum in price charts, to generate more robust trading recommendations. The project implements a technical trading algorithm called MACD (Moving Average Convergence Divergence) which detects crossover buy and sell signals in price charts. By merging sentiment analysis predictions with the MACD technical signals, the system can produce 1-5 recommendations for each stock ranging from \"Strong Buy\" to \"Strong Sell\". The recommendations are projected 1 week into the future based on current market conditions.\n"]},{"cell_type":"markdown","metadata":{"cell_id":"f9fc9ff7b2514fb9a157d2283845327f","deepnote_app_block_visible":true,"deepnote_app_coordinates":{"h":5,"w":12,"x":0,"y":0},"deepnote_cell_type":"markdown"},"source":["# Part 1: Sentiment Analysis"]},{"cell_type":"code","execution_count":null,"metadata":{"cell_id":"3aca2b7dfde74413b0f6da5ed97ade48","deepnote_app_block_visible":true,"deepnote_app_coordinates":{"h":5,"w":12,"x":0,"y":0},"deepnote_cell_type":"code","deepnote_to_be_reexecuted":false,"execution_millis":53587,"execution_start":1696524744745,"source_hash":null},"outputs":[{"name":"stderr","output_type":"stream","text":["/shared-libs/python3.9/py/lib/python3.9/site-packages/tqdm/auto.py:22: TqdmWarning: IProgress not found. Please update jupyter and ipywidgets. See https://ipywidgets.readthedocs.io/en/stable/user_install.html\n","  from .autonotebook import tqdm as notebook_tqdm\n","Downloading (…)okenizer_config.json: 100%|██████████| 252/252 [00:00<00:00, 53.2kB/s]\n","Downloading (…)lve/main/config.json: 100%|██████████| 758/758 [00:00<00:00, 153kB/s]\n","Downloading (…)solve/main/vocab.txt: 100%|██████████| 232k/232k [00:00<00:00, 737kB/s]\n","Downloading (…)cial_tokens_map.json: 100%|██████████| 112/112 [00:00<00:00, 108kB/s]\n","Downloading pytorch_model.bin: 100%|██████████| 438M/438M [00:01<00:00, 366MB/s]\n","100%|██████████| 474/474 [00:38<00:00, 12.37it/s]Data for 2023-09-01 has been fetched and inserted into the dataframe.\n","\n"]}],"source":["# Importing necessary libraries\n","import requests\n","import pandas as pd\n","import numpy as np\n","import seaborn as sns\n","import matplotlib.pyplot as plt\n","from transformers import AutoModelForSequenceClassification, AutoTokenizer\n","import torch\n","import finnhub\n","import sqlite3\n","from datetime import datetime, timedelta, timezone\n","from tqdm import tqdm\n","tqdm.pandas()\n","\n","\n","### DATE SETTINGS ###\n","\n","# Function to convert date string to Unix timestamp\n","def unix_timestamp_from_date(date_str, date_format=\"%Y-%m-%d\"):\n","    dt = datetime.strptime(date_str, date_format)\n","    unix_timestamp = dt.replace(tzinfo=timezone.utc).timestamp()\n","    return int(unix_timestamp)\n","\n","# Get the current date and time\n","current_datetime = datetime.now()\n","\n","# Format the current date\n","# current_date = current_datetime.strftime(\"%Y-%m-%d\")\n","\n","# Set the current date to predefined date\n","# current_date = datetime.now().strftime(\"%Y-%m-%d\")\n","current_date = '2023-09-01'\n","\n","# Calculate the date 30 days ago from the current date\n","from_datetime = current_datetime - timedelta(days=30)\n","from_datetime\n","# Format the from_date\n","from_date_str = from_datetime.strftime(\"%Y-%m-%d\")\n","\n","# Convert to Unix timestamps\n","from_date = unix_timestamp_from_date(from_date_str)\n","to_date = unix_timestamp_from_date(current_date)\n","\n","\n","### FINNHUB API SETTINGS ###\n","\n","# API key setup (replace 'YOUR_API_KEY' with the actual API key)\n","api_key = 'API_KEY'\n","\n","# DJIA Tickers and Companies\n","symbols = ['AAPL', 'MSFT', 'JNJ', 'PG', 'V', 'RTX', 'UNH', 'VZ', 'CSCO', 'KO', \n","        'DOW', 'TRV', 'JPM', 'INTC', 'WBA', 'CVX', 'CAT', 'MMM', 'GS', \n","        'NKE', 'HD', 'MRK', 'DIS', 'IBM', 'MCD', 'BA', 'AMGN', 'CRM', 'XOM', 'PFE']\n","\n","companies = ['Apple', 'Microsoft', 'Johnson & Johnson', 'Procter & Gamble', \n","            'Visa', 'Raytheon', 'UnitedHealth', 'Verizon', 'Cisco', 'Coca-Cola',\n","            'Dow Chemical', 'Travelers', 'JPMorgan Chase', 'Intel', 'Walgreens',\n","            'Chevron', 'Caterpillar', '3M', 'Goldman Sachs', 'Nike', 'Home Depot',\n","            'Merck', 'Disney', 'IBM', 'McDonalds', 'Boeing', 'Amgen', 'Salesforce',\n","            'Exxon Mobil', 'Pfizer']\n","\n","# Initialize an empty list to store news headlines as DataFrames\n","df_list = []\n","\n","# Loop through each DJIA company\n","for symbol, company in zip(symbols, companies):\n","    # API request to get news headlines\n","    url = f'https://finnhub.io/api/v1/company-news?symbol={symbol}&from={current_date}&to={current_date}&token={api_key}'\n","    response = requests.get(url)\n","    \n","    # Error checking for API response\n","    if response.status_code != 200:\n","        print(f\"Failed to get data for {symbol}\")\n","        continue\n","    \n","    # Extract news headlines\n","    news_data = response.json()\n","    news_df = pd.DataFrame(news_data)\n","\n","    # Convert Unix timestamps to human-readable datetime\n","    news_df['datetime'] = pd.to_datetime(news_df['datetime'], unit='s')\n","\n","    # Add 'company' and 'symbol' columns\n","    news_df['company'] = company\n","    news_df['symbol'] = symbol\n","    \n","    # Keep only the columns we need\n","    # news_df = news_df[['company', 'symbol', 'datetime', 'headline']]\n","    \n","    # Add to list of DataFrames\n","    df_list.append(news_df)\n","\n","# Concatenate all the collected DataFrames\n","df_headlines = pd.concat(df_list, ignore_index=True)\n","\n","# Create new column 'analysis' by concatenating 'headline' and 'summary'\n","df_headlines['analysis'] = df_headlines['headline'] + ' ' + df_headlines['summary']\n","\n","\n","\n","### SENTIMENT ANALYSIS SETTINGS ###\n","\n","# Initialize finBERT model and tokenizer\n","# For finBERT, we used the model identifier from Hugging Face\n","model_name = 'ProsusAI/finbert'\n","tokenizer = AutoTokenizer.from_pretrained(model_name)\n","model = AutoModelForSequenceClassification.from_pretrained(model_name)\n","\n","# Function to compute sentiment\n","def compute_sentiment(headline):\n","    inputs = tokenizer(headline, return_tensors=\"pt\", max_length=512, truncation=True)\n","    with torch.no_grad():\n","        outputs = model(**inputs)\n","    logits = outputs.logits\n","    sentiment = torch.softmax(logits, dim=1).numpy()\n","    # Assuming 0: negative, 1: neutral, 2: positive\n","    return ['negative', 'neutral', 'positive'][sentiment.argmax()]\n","\n","# Reminder: df_headlines is our DataFrame with news headlines\n","# Add a new column for sentiment\n","df_headlines['sentiment'] = df_headlines['analysis'].progress_apply(compute_sentiment)\n","\n","\n","print(f\"Data for {current_date} has been fetched and inserted into the dataframe.\")"]},{"cell_type":"code","execution_count":null,"metadata":{"cell_id":"ba63e591353d4a34a8f087a67b3707e8","deepnote_app_block_visible":true,"deepnote_app_coordinates":{"h":5,"w":12,"x":0,"y":0},"deepnote_cell_type":"code","deepnote_table_invalid":false,"deepnote_table_loading":false,"deepnote_table_state":{"filters":[],"pageIndex":0,"pageSize":100,"sortBy":[]},"deepnote_to_be_reexecuted":false,"execution_millis":296,"execution_start":1696524811944,"source_hash":null},"outputs":[{"data":{"application/vnd.deepnote.dataframe.v3+json":{"column_count":13,"columns":[{"dtype":"object","name":"category","stats":{"categories":[{"count":474,"name":"company"}],"nan_count":0,"unique_count":1}},{"dtype":"datetime64[ns]","name":"datetime","stats":{"histogram":[{"bin_end":1693535688000000000,"bin_start":1693527300000000000,"count":30},{"bin_end":1693544076000000000,"bin_start":1693535688000000000,"count":50},{"bin_end":1693552464000000000,"bin_start":1693544076000000000,"count":52},{"bin_end":1693560852000000000,"bin_start":1693552464000000000,"count":67},{"bin_end":1693569240000000000,"bin_start":1693560852000000000,"count":65},{"bin_end":1693577628000000000,"bin_start":1693569240000000000,"count":63},{"bin_end":1693586016000000000,"bin_start":1693577628000000000,"count":49},{"bin_end":1693594404000000000,"bin_start":1693586016000000000,"count":53},{"bin_end":1693602792000000000,"bin_start":1693594404000000000,"count":21},{"bin_end":1693611180000000000,"bin_start":1693602792000000000,"count":24}],"max":"2023-09-01 23:33:00","min":"2023-09-01 00:15:00","nan_count":0,"unique_count":339}},{"dtype":"object","name":"headline","stats":{"categories":[{"count":5,"name":"CDC: Dividend ETF With Unconventional Market Timing"},{"count":5,"name":"Dow Jones Today: Index Moves Up on Jobs Report"},{"count":464,"name":"403 others"}],"nan_count":0,"unique_count":405}},{"dtype":"int64","name":"id","stats":{"histogram":[{"bin_end":122365253.8,"bin_start":122352268,"count":130},{"bin_end":122378239.6,"bin_start":122365253.8,"count":191},{"bin_end":122391225.4,"bin_start":122378239.6,"count":106},{"bin_end":122404211.2,"bin_start":122391225.4,"count":32},{"bin_end":122417197,"bin_start":122404211.2,"count":7},{"bin_end":122430182.8,"bin_start":122417197,"count":0},{"bin_end":122443168.6,"bin_start":122430182.8,"count":0},{"bin_end":122456154.4,"bin_start":122443168.6,"count":0},{"bin_end":122469140.2,"bin_start":122456154.4,"count":5},{"bin_end":122482126,"bin_start":122469140.2,"count":3}],"max":"122482126","min":"122352268","nan_count":0,"unique_count":408}},{"dtype":"object","name":"image","stats":{"categories":[{"count":234,"name":""},{"count":26,"name":"https://images.mktw.net/im-220105/social"},{"count":214,"name":"153 others"}],"nan_count":0,"unique_count":155}},{"dtype":"object","name":"related","stats":{"categories":[{"count":53,"name":"DIS"},{"count":49,"name":"WBA"},{"count":372,"name":"28 others"}],"nan_count":0,"unique_count":30}},{"dtype":"object","name":"source","stats":{"categories":[{"count":190,"name":"Yahoo"},{"count":58,"name":"MarketWatch"},{"count":226,"name":"19 others"}],"nan_count":0,"unique_count":21}},{"dtype":"object","name":"summary","stats":{"categories":[{"count":166,"name":"Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results."},{"count":24,"name":""},{"count":284,"name":"244 others"}],"nan_count":0,"unique_count":246}},{"dtype":"object","name":"url","stats":{"categories":[{"count":5,"name":"https://finnhub.io/api/news?id=5f8f7e89d18cf8dd0844f89909ac1c494d8d86dc04b8f6113d3cf0fad1e9f456"},{"count":5,"name":"https://finnhub.io/api/news?id=b54f112c5c161509c2e389ae1cd13628545b33437b6c60ec3531ddc51b96a36b"},{"count":464,"name":"406 others"}],"nan_count":0,"unique_count":408}},{"dtype":"object","name":"company","stats":{"categories":[{"count":53,"name":"Disney"},{"count":49,"name":"Walgreens"},{"count":372,"name":"28 others"}],"nan_count":0,"unique_count":30}},{"dtype":"object","name":"symbol","stats":{"categories":[{"count":53,"name":"DIS"},{"count":49,"name":"WBA"},{"count":372,"name":"28 others"}],"nan_count":0,"unique_count":30}},{"dtype":"object","name":"analysis","stats":{"categories":[{"count":5,"name":"CDC: Dividend ETF With Unconventional Market Timing VictoryShares US EQ Income Enhanced Volatility Wtd is a defensive ETF with unconventional market timing and lower risk in drawdowns. Learn more about CDC here."},{"count":5,"name":"Dow Jones Today: Index Moves Up on Jobs Report The Dow Jones finished higher by about 115 points, or 0.3%, on investors optimism that the latest employment report will help prompt the Fed to end its interest rate hikes."},{"count":464,"name":"406 others"}],"nan_count":0,"unique_count":408}},{"dtype":"object","name":"sentiment","stats":{"categories":[{"count":284,"name":"positive"},{"count":95,"name":"negative"},{"count":95,"name":"neutral"}],"nan_count":0,"unique_count":3}},{"dtype":"int64","name":"_deepnote_index_column"}],"row_count":474,"rows":[{"_deepnote_index_column":0,"analysis":"Exclusive-Arm signs up big tech firms for IPO at $50 billion-$55 billion valuation -sources NEW YORK (Reuters) -Customers of Arm Holdings Ltd including Apple Inc, Nvidia Corp, Alphabet Inc and Advanced Micro Devices Inc have agreed to invest in the chip designer's initial public offering, according to people familiar with the matter.  Intel Corp, Samsung Electronics Co Ltd, Cadence Design Systems Inc and Synopsys Inc have also agreed to participate as investors in the offering, the sources added.","category":"company","company":"Apple","datetime":"2023-09-01 23:13:08","headline":"Exclusive-Arm signs up big tech firms for IPO at $50 billion-$55 billion valuation -sources","id":122382404,"image":"https://media.zenfs.com/en/reuters-finance.com/df3f57bfdc3a2f80109f2c43dc92636b","related":"AAPL","sentiment":"negative","source":"Yahoo","summary":"NEW YORK (Reuters) -Customers of Arm Holdings Ltd including Apple Inc, Nvidia Corp, Alphabet Inc and Advanced Micro Devices Inc have agreed to invest in the chip designer's initial public offering, according to people familiar with the matter.  Intel Corp, Samsung Electronics Co Ltd, Cadence Design Systems Inc and Synopsys Inc have also agreed to participate as investors in the offering, the sources added.","symbol":"AAPL","url":"https://finnhub.io/api/news?id=4cd8bf8f9821bfe0b21fa54bc9d696211523882ea5142c0514eb7ff117b51002"},{"_deepnote_index_column":1,"analysis":"SoftBank Lines Up Apple, Nvidia as Strategic Arm IPO Backers (Bloomberg) -- SoftBank Group Corp. has lined up some of Arm Ltd.’s biggest customers as strategic investors for the chip company’s initial public offering, including Apple Inc., Nvidia Corp., Intel Corp. and Samsung Electronics Co., according to people familiar with the situation.Most Read from BloombergTesla’s $41,000 Model X Discount Unlocks Subsidies Musk Wanted GoneSaola Departs Hong Kong After Bringing Destructive WindsTesla Refreshes Model 3 and Slashes Prices of Top-End CarsSingapore Pic","category":"company","company":"Apple","datetime":"2023-09-01 23:08:56","headline":"SoftBank Lines Up Apple, Nvidia as Strategic Arm IPO Backers","id":122382018,"image":"https://s.yimg.com/ny/api/res/1.2/HorrfiXzXAyVdJzcLu.Kjg--/YXBwaWQ9aGlnaGxhbmRlcjt3PTEyMDA7aD04MDA-/https://media.zenfs.com/en/bloomberg_technology_68/bacbc800522af4b4f5702dbaf6abf158","related":"AAPL","sentiment":"positive","source":"Yahoo","summary":"(Bloomberg) -- SoftBank Group Corp. has lined up some of Arm Ltd.’s biggest customers as strategic investors for the chip company’s initial public offering, including Apple Inc., Nvidia Corp., Intel Corp. and Samsung Electronics Co., according to people familiar with the situation.Most Read from BloombergTesla’s $41,000 Model X Discount Unlocks Subsidies Musk Wanted GoneSaola Departs Hong Kong After Bringing Destructive WindsTesla Refreshes Model 3 and Slashes Prices of Top-End CarsSingapore Pic","symbol":"AAPL","url":"https://finnhub.io/api/news?id=376135bb5ff5d10006bd2fea52e76c2af9f1462709f10618dccfe234dae1ebbb"},{"_deepnote_index_column":2,"analysis":"Tech suppliers in China skip seasonal hiring rush amid weak demand The Amazon supplier has not had to make any special recruitment efforts, and its hourly wage for temporary workers remains at Rmb16 ($2.19), the minimum basic rate for the area in 2023.  “There is no need to hire any additional workers for the traditional peak season,” said the manager, who asked not to use his name.  China’s massive tech manufacturing industry usually ramps up hiring in summer, recruiting hundreds of thousands of temporary workers to help handle the rush of orders from Apple, Amazon, HP, Dell and others ahead of the year-end holiday shopping season.","category":"company","company":"Apple","datetime":"2023-09-01 22:00:37","headline":"Tech suppliers in China skip seasonal hiring rush amid weak demand","id":122385415,"image":"https://s.yimg.com/cv/apiv2/social/images/yahoo_default_logo-1200x1200.png","related":"AAPL","sentiment":"neutral","source":"Yahoo","summary":"The Amazon supplier has not had to make any special recruitment efforts, and its hourly wage for temporary workers remains at Rmb16 ($2.19), the minimum basic rate for the area in 2023.  “There is no need to hire any additional workers for the traditional peak season,” said the manager, who asked not to use his name.  China’s massive tech manufacturing industry usually ramps up hiring in summer, recruiting hundreds of thousands of temporary workers to help handle the rush of orders from Apple, Amazon, HP, Dell and others ahead of the year-end holiday shopping season.","symbol":"AAPL","url":"https://finnhub.io/api/news?id=ef6e62f55088bc386f35400e2a112833595b3bd30efe4a0c4592df801f2446c4"},{"_deepnote_index_column":3,"analysis":"Apple (AAPL) Outpaces Stock Market Gains: What You Should Know Apple (AAPL) closed at $189.46 in the latest trading session, marking a +0.85% move from the prior day.","category":"company","company":"Apple","datetime":"2023-09-01 21:45:17","headline":"Apple (AAPL) Outpaces Stock Market Gains: What You Should Know","id":122385416,"image":"https://media.zenfs.com/en/zacks.com/3496571a811465d910e99bd171c71a94","related":"AAPL","sentiment":"negative","source":"Yahoo","summary":"Apple (AAPL) closed at $189.46 in the latest trading session, marking a +0.85% move from the prior day.","symbol":"AAPL","url":"https://finnhub.io/api/news?id=ea85159d6abc0817ead6e14695bba159e760da04ed55516e0d34049d7f8f7be9"},{"_deepnote_index_column":4,"analysis":"Globalstar Satellites Could Score for Small Devices, IoT, Says New Boss Moves in the satellite company's share price point to hope among investors that it could be poised for better times after years of struggling to turn a profit.","category":"company","company":"Apple","datetime":"2023-09-01 21:36:00","headline":"Globalstar Satellites Could Score for Small Devices, IoT, Says New Boss","id":122378763,"image":"https://s.yimg.com/ny/api/res/1.2/fcqof7cpXY5HKMaHQoCdRw--/YXBwaWQ9aGlnaGxhbmRlcjt3PTEyMDA7aD02MDA-/https://media.zenfs.com/en/Barrons.com/bef984ce7efcc20e7dc2d5cb3548a9da","related":"AAPL","sentiment":"negative","source":"Yahoo","summary":"Moves in the satellite company's share price point to hope among investors that it could be poised for better times after years of struggling to turn a profit.","symbol":"AAPL","url":"https://finnhub.io/api/news?id=780b55e2afd6e4455955fa0020817433e09b7fea9cb9548cf64ac7d0e741c519"},{"_deepnote_index_column":5,"analysis":"These Stocks Moved the Most Today: Dell, Elastic, Nutanix, Warner Bros. Discovery, Samsara, Broadcom, and More Adjusted second-quarter earnings from Dell Technologies soundly topped analysts' estimates, Elastic's fiscal first-quarter profit and revenue beat forecasts, and Nutanix issued strong guidance.","category":"company","company":"Apple","datetime":"2023-09-01 20:26:00","headline":"These Stocks Moved the Most Today: Dell, Elastic, Nutanix, Warner Bros. Discovery, Samsara, Broadcom, and More","id":122384392,"image":"https://s.yimg.com/ny/api/res/1.2/AIFMAUDVxEGUkvTWPq6twQ--/YXBwaWQ9aGlnaGxhbmRlcjt3PTEyMDA7aD02MDA-/https://media.zenfs.com/en/Barrons.com/2592f19756b3846bcb05e4d81d11f080","related":"AAPL","sentiment":"negative","source":"Yahoo","summary":"Adjusted second-quarter earnings from Dell Technologies soundly topped analysts' estimates, Elastic's fiscal first-quarter profit and revenue beat forecasts, and Nutanix issued strong guidance.","symbol":"AAPL","url":"https://finnhub.io/api/news?id=d533364a4e1b89d8ecf5fe959dbb98ae8f0b6ea0394ef2c947a6055cafacbc49"},{"_deepnote_index_column":6,"analysis":"Want to know what's 'NEXT'? Tune in to Yahoo Finance's new series If this year has taught us anything, it's that the technological revolution is moving faster than investors can keep pace with. Yahoo Finance wants to put you ahead of the curve with our new series, NEXT, premiering on September 8 at 10 a.m. ET. At a time when AI is creating billion-dollar companies out of thin air, automation is upending the future workforce, and semiconductors are becoming as important as oil — it's hard to know where to look. Our original series puts YOU in front of the trend and up close and personal with the people who matter — the leaders, inventors, and investors at the forefront of the most exciting period in the history of tech. Who's developing the next ChatGPT? Can anyone take on Netflix? Where is the big capital flowing? From venture capitalists to the nascent enterprises they're betting on ... we want YOU to know where innovation takes us next. Episode one zeroes in on the global smartphone…","category":"company","company":"Apple","datetime":"2023-09-01 19:11:21","headline":"Want to know what's 'NEXT'? Tune in to Yahoo Finance's new series","id":122383648,"image":"https://s.yimg.com/ny/api/res/1.2/Dyz8TyGBxTMnKXzcxIlMbQ--/YXBwaWQ9aGlnaGxhbmRlcjt3PTEyMDA7aD02NzU-/https://s.yimg.com/os/creatr-uploaded-images/2023-09/8e6a35e0-48e5-11ee-b4bd-9ea43f9c8a0c","related":"AAPL","sentiment":"positive","source":"Yahoo","summary":"If this year has taught us anything, it's that the technological revolution is moving faster than investors can keep pace with. Yahoo Finance wants to put you ahead of the curve with our new series, NEXT, premiering on September 8 at 10 a.m. ET. At a time when AI is creating billion-dollar companies out of thin air, automation is upending the future workforce, and semiconductors are becoming as important as oil — it's hard to know where to look. Our original series puts YOU in front of the trend and up close and personal with the people who matter — the leaders, inventors, and investors at the forefront of the most exciting period in the history of tech. Who's developing the next ChatGPT? Can anyone take on Netflix? Where is the big capital flowing? From venture capitalists to the nascent enterprises they're betting on ... we want YOU to know where innovation takes us next. Episode one zeroes in on the global smartphone battle. Samsung (005930.KS) and Apple (AAPL) are vying for domina…","symbol":"AAPL","url":"https://finnhub.io/api/news?id=937b210148a39045d5410c9ab8151420964edf69badb4f2a038ba02d9d6d5cdb"},{"_deepnote_index_column":7,"analysis":"Stocks Stink in September—But This Year Could Be Different This could be a balmy month for markets as corporate earnings look poised for liftoff and profit margins expand.","category":"company","company":"Apple","datetime":"2023-09-01 18:34:00","headline":"Stocks Stink in September—But This Year Could Be Different","id":122386332,"image":"https://images.barrons.com/im-64727429/social","related":"AAPL","sentiment":"negative","source":"MarketWatch","summary":"This could be a balmy month for markets as corporate earnings look poised for liftoff and profit margins expand.","symbol":"AAPL","url":"https://finnhub.io/api/news?id=8fa7cc4679de688fa0a1a56c9c856a0901f7fd3ad18380f7e3fff9c9e02b8abd"},{"_deepnote_index_column":8,"analysis":"Apple's Big Moves: Trademark Settlement, iPhone 15 Reveal, and 3D Printing Trials Today's top stories for Apple Inc. (NASDAQ: AAPL) include a legal settlement over a trademark dispute, the much-awaited announcement of the iPhone 15, and innovative supply chain developments for the Apple Watch 9. Here's a closer look at these key updates. Trademark Settlement with USPTO: Apple has reached a settlement with the U.S. Patent and Trademark Office (PTO) over its \"Smart Keyboard\" trademark application. The conflict began in 2018 when the PTO rejected Apple's application, a decision","category":"company","company":"Apple","datetime":"2023-09-01 17:48:56","headline":"Apple's Big Moves: Trademark Settlement, iPhone 15 Reveal, and 3D Printing Trials","id":122385420,"image":"https://media.zenfs.com/en/Benzinga/9affb7a0d1f72cf9019e21453ab78c2a","related":"AAPL","sentiment":"positive","source":"Yahoo","summary":"Today's top stories for Apple Inc. (NASDAQ: AAPL) include a legal settlement over a trademark dispute, the much-awaited announcement of the iPhone 15, and innovative supply chain developments for the Apple Watch 9. Here's a closer look at these key updates. Trademark Settlement with USPTO: Apple has reached a settlement with the U.S. Patent and Trademark Office (PTO) over its \"Smart Keyboard\" trademark application. The conflict began in 2018 when the PTO rejected Apple's application, a decision","symbol":"AAPL","url":"https://finnhub.io/api/news?id=65f438e487163aa734921cde879d1190e38d74b88eaeb8d3011c1467981cffad"},{"_deepnote_index_column":9,"analysis":"Folding phones are here. So where is Apple? Apple is sitting on the sidelines of the foldable phone trend, but its declining iPhone sales suggest it might be time for the company to think different.","category":"company","company":"Apple","datetime":"2023-09-01 17:02:01","headline":"Folding phones are here. So where is Apple?","id":122385421,"image":"https://s.yimg.com/ny/api/res/1.2/zLXBYcy65QY37ge0MoYzJw--/YXBwaWQ9aGlnaGxhbmRlcjt3PTEyMDA7aD04MDA-/https://media.zenfs.com/en/fortune_175/9aecec7a1ea7cedc4191f7cf6169ed77","related":"AAPL","sentiment":"neutral","source":"Yahoo","summary":"Apple is sitting on the sidelines of the foldable phone trend, but its declining iPhone sales suggest it might be time for the company to think different.","symbol":"AAPL","url":"https://finnhub.io/api/news?id=7b7b89ce2f7204d46763a953e0ebee07cf78737a84fc6dfc1cf66c3ed5143a47"},{"_deepnote_index_column":10,"analysis":"Apple Inc. stock outperforms competitors on strong trading day Shares of Apple Inc. inched 0.85% higher to $189.46 Friday, on what proved to be an all-around mixed trading session for the stock market, with the Dow Jones...","category":"company","company":"Apple","datetime":"2023-09-01 16:32:00","headline":"Apple Inc. stock outperforms competitors on strong trading day","id":122389660,"image":"https://images.mktw.net/im-213861/social","related":"AAPL","sentiment":"negative","source":"MarketWatch","summary":"Shares of Apple Inc. inched 0.85% higher to $189.46 Friday, on what proved to be an all-around mixed trading session for the stock market, with the Dow Jones...","symbol":"AAPL","url":"https://finnhub.io/api/news?id=8562709018e4d3aa97cf20d21ec361fe40ecda277a7a7c01c87e9464fe368411"},{"_deepnote_index_column":11,"analysis":"Hollywood strikes: ‘Focus on the consumer,’ MNTN CEO says There are several issues writers and Hollywood studios are battling over in their contract talks including streaming, AI, and writers’ rooms. Recently, media mogul Barry Diller warned of consequences for studios if they continue partnering with streaming companies like Netflix (NFLX). MNTN CEO Mark Douglas joins Yahoo Finance Live to discuss the comments. “If you look at the economics on it, I’m not sure how that quite works,” Douglas says. Douglas notes that Disney (DIS) “did about $10 billion in studio revenue last year,” whereas Netflix (NFLX) did “three times that, just by themselves. So they’re the size of like a couple of major studios combined, so I don’t know how you take an industry that seems to be largely striking over streaming and try to separate it out.” “Whenever these studios are in trouble, it’s like the finance team takes over and it just doesn’t make sense,” Douglas says. “These studios have to meet consumers…","category":"company","company":"Apple","datetime":"2023-09-01 15:59:10","headline":"Hollywood strikes: ‘Focus on the consumer,’ MNTN CEO says","id":122368277,"image":"https://s.yimg.com/ny/api/res/1.2/I6FRpZEqDMSnL5JOlX_Llg--/YXBwaWQ9aGlnaGxhbmRlcjt3PTEyMDA7aD02NzY-/https://s.yimg.com/os/creatr-uploaded-images/2023-09/95c18a60-48df-11ee-96cf-8ee83768feeb","related":"AAPL","sentiment":"positive","source":"Yahoo","summary":"There are several issues writers and Hollywood studios are battling over in their contract talks including streaming, AI, and writers’ rooms. Recently, media mogul Barry Diller warned of consequences for studios if they continue partnering with streaming companies like Netflix (NFLX). MNTN CEO Mark Douglas joins Yahoo Finance Live to discuss the comments. “If you look at the economics on it, I’m not sure how that quite works,” Douglas says. Douglas notes that Disney (DIS) “did about $10 billion in studio revenue last year,” whereas Netflix (NFLX) did “three times that, just by themselves. So they’re the size of like a couple of major studios combined, so I don’t know how you take an industry that seems to be largely striking over streaming and try to separate it out.” “Whenever these studios are in trouble, it’s like the finance team takes over and it just doesn’t make sense,” Douglas says. “These studios have to meet consumers where they are. The consumer sees no difference,” Douglas…","symbol":"AAPL","url":"https://finnhub.io/api/news?id=08b1d20aa4d2af36a658fc2535253912dc2c463d5aaf3b1b52a68df121e1b6a3"},{"_deepnote_index_column":12,"analysis":"iPhone 15 release date: When Apple’s new phone will actually arrive? Apple’s latest iPhone is coming.  While it did not explicitly say that it will see the launch of the iPhone 15, it almost certainly will.  At the event, on 12 September, it will show off four new variants of the iPhone 15: the base model as well as the iPhone 15 Plus, Pro and Pro Max. It is also expected to launch a new Apple Watch and Watch Ultra, and some new AirPods.","category":"company","company":"Apple","datetime":"2023-09-01 15:55:55","headline":"iPhone 15 release date: When Apple’s new phone will actually arrive?","id":122368278,"image":"https://static.independent.co.uk/2022/10/12/16/GettyImages-1421648761.jpg?quality=75&width=1200&auto=webp","related":"AAPL","sentiment":"positive","source":"Yahoo","summary":"Apple’s latest iPhone is coming.  While it did not explicitly say that it will see the launch of the iPhone 15, it almost certainly will.  At the event, on 12 September, it will show off four new variants of the iPhone 15: the base model as well as the iPhone 15 Plus, Pro and Pro Max. It is also expected to launch a new Apple Watch and Watch Ultra, and some new AirPods.","symbol":"AAPL","url":"https://finnhub.io/api/news?id=bb5d00d16af4f5b905bc534c24a294c5e31b8bd1ddc51b4a2ec36ee958b507f0"},{"_deepnote_index_column":13,"analysis":"15 Countries That Produce the Most E-waste in the World In this article, we will be analyzing e-waste, its hidden value, and the companies efficiently managing this kind of waste. If you wish to skip our detailed analysis, you can go directly to the 5 Countries That Produce the Most E-waste in the World. What is E-Waste? E-waste, also known as electronic or electric waste, […]","category":"company","company":"Apple","datetime":"2023-09-01 15:49:58","headline":"15 Countries That Produce the Most E-waste in the World","id":122368280,"image":"https://media.zenfs.com/en/insidermonkey.com/4e1548673a7f70f81f721aff266f346d","related":"AAPL","sentiment":"positive","source":"Yahoo","summary":"In this article, we will be analyzing e-waste, its hidden value, and the companies efficiently managing this kind of waste. If you wish to skip our detailed analysis, you can go directly to the 5 Countries That Produce the Most E-waste in the World. What is E-Waste? E-waste, also known as electronic or electric waste, […]","symbol":"AAPL","url":"https://finnhub.io/api/news?id=0285093278952a3a795530d75e4288b6dc5e5478c2c6b4d85a9483583874b1e2"},{"_deepnote_index_column":14,"analysis":"Apple Stock Rises for Sixth Straight Session It’s another good day for Apple stock. Shares of the tech giant (ticker: AAPL) were rising for the sixth day in a row on Friday, putting them on pace for their longest winning streak since March 29, 2022, when they rose for 11 consecutive trading days, according to Dow Jones Market Data.","category":"company","company":"Apple","datetime":"2023-09-01 14:54:08","headline":"Apple Stock Rises for Sixth Straight Session","id":122368282,"image":"https://media.zenfs.com/en/Barrons.com/12ea0f43d8f8307249a68d1cb2e0587e","related":"AAPL","sentiment":"negative","source":"Yahoo","summary":"It’s another good day for Apple stock. Shares of the tech giant (ticker: AAPL) were rising for the sixth day in a row on Friday, putting them on pace for their longest winning streak since March 29, 2022, when they rose for 11 consecutive trading days, according to Dow Jones Market Data.","symbol":"AAPL","url":"https://finnhub.io/api/news?id=86435c3c2507bb11a075befaec09a363c17f1cb65e97a2358101d7909085ed2d"},{"_deepnote_index_column":15,"analysis":"Lululemon: Consumers 'picking their spots' to spend, strategist says Lululemon Athletica (LULU) reported second quarter results that beat analyst estimates. When it comes to retailers that cater to wealthier consumers, \"it's all about branding, it's all about pricing power, it's all about sort of aspiration,\" says eToro Global Markets Strategist Ben Laidler. Laidler tells Yahoo Finance Live that some high-end consumers are trading down and that \"consumers are absolutely picking their spots\" when it comes to spending their cash.","category":"company","company":"Apple","datetime":"2023-09-01 14:33:24","headline":"Lululemon: Consumers 'picking their spots' to spend, strategist says","id":122368284,"image":"https://s.yimg.com/ny/api/res/1.2/62a6oeIsu1.FwACMlhZb9Q--/YXBwaWQ9aGlnaGxhbmRlcjt3PTEyMDA7aD02NzY-/https://s.yimg.com/os/creatr-uploaded-images/2023-09/7fb8e2b0-48ce-11ee-8df7-a94fd3bb4faa","related":"AAPL","sentiment":"positive","source":"Yahoo","summary":"Lululemon Athletica (LULU) reported second quarter results that beat analyst estimates. When it comes to retailers that cater to wealthier consumers, \"it's all about branding, it's all about pricing power, it's all about sort of aspiration,\" says eToro Global Markets Strategist Ben Laidler. Laidler tells Yahoo Finance Live that some high-end consumers are trading down and that \"consumers are absolutely picking their spots\" when it comes to spending their cash.","symbol":"AAPL","url":"https://finnhub.io/api/news?id=f9816d54e32f0e716ef6b1322bc4f5e16e1cd77e3c1ea63e3f106469e7faebe2"},{"_deepnote_index_column":16,"analysis":"Apple’s stock advances toward longest winning streak in 17 months Apple Inc. shares are rising again Friday and on track to log their sixth consecutive session of gains. The stock is up 0.6% in Friday’s session and ahead...","category":"company","company":"Apple","datetime":"2023-09-01 13:59:00","headline":"Apple’s stock advances toward longest winning streak in 17 months","id":122389662,"image":"https://s.wsj.net/public/resources/MWimages/MW-GP644_MicroS_ZG_20180906154215.jpg","related":"AAPL","sentiment":"negative","source":"MarketWatch","summary":"Apple Inc. shares are rising again Friday and on track to log their sixth consecutive session of gains. The stock is up 0.6% in Friday’s session and ahead...","symbol":"AAPL","url":"https://finnhub.io/api/news?id=146e887e7538f415adbd5831419db17bbd77c951ce6d2936965f8de23c776da0"},{"_deepnote_index_column":17,"analysis":"DGRW: Dividend Growth I Wouldn't Buy Into DGRW lags behind its peers in terms of dividend growth. Future dividend performance relies on a few companies in the fund's portfolio. Click here to read more.","category":"company","company":"Apple","datetime":"2023-09-01 13:47:33","headline":"DGRW: Dividend Growth I Wouldn't Buy Into","id":122369196,"image":"https://static.seekingalpha.com/cdn/s3/uploads/getty_images/1326978045/image_1326978045.jpg?io=getty-c-w1536","related":"AAPL","sentiment":"positive","source":"SeekingAlpha","summary":"DGRW lags behind its peers in terms of dividend growth. Future dividend performance relies on a few companies in the fund's portfolio. Click here to read more.","symbol":"AAPL","url":"https://finnhub.io/api/news?id=757795cc4c570722e8f999057e563f36ed3ad77a4126e7e63216de8b259e77f0"},{"_deepnote_index_column":18,"analysis":"Is Trending Stock Apple Inc. (AAPL) a Buy Now? Apple (AAPL) has received quite a bit of attention from Zacks.com users lately. Therefore, it is wise to be aware of the facts that can impact the stock's prospects.","category":"company","company":"Apple","datetime":"2023-09-01 13:00:11","headline":"Is Trending Stock Apple Inc. (AAPL) a Buy Now?","id":122368286,"image":"https://media.zenfs.com/en/zacks.com/17a4db66bb13bdabcbf848550a6ea15a","related":"AAPL","sentiment":"positive","source":"Yahoo","summary":"Apple (AAPL) has received quite a bit of attention from Zacks.com users lately. Therefore, it is wise to be aware of the facts that can impact the stock's prospects.","symbol":"AAPL","url":"https://finnhub.io/api/news?id=0cc2d7debac77536f1b9c50d9261336e2969de0c4c04ede3fc007f75038ede51"},{"_deepnote_index_column":19,"analysis":"Apple: Incredible Recovery Lifting Sentiments Ahead Of iPhone 15 Launch Apple buyers rush in as iPhone 15 shipments may reach 86M units, hinting at a strong holiday season. Click here to read an analysis on AAPL stock now.","category":"company","company":"Apple","datetime":"2023-09-01 12:42:33","headline":"Apple: Incredible Recovery Lifting Sentiments Ahead Of iPhone 15 Launch","id":122367157,"image":"https://static.seekingalpha.com/cdn/s3/uploads/getty_images/1445281649/image_1445281649.jpg?io=getty-c-w1536","related":"AAPL","sentiment":"negative","source":"SeekingAlpha","summary":"Apple buyers rush in as iPhone 15 shipments may reach 86M units, hinting at a strong holiday season. Click here to read an analysis on AAPL stock now.","symbol":"AAPL","url":"https://finnhub.io/api/news?id=6276fea7a54b934322fb0dadab1cf1e6ac6a5b53e45dafcb3ab30122e2d97e43"},{"_deepnote_index_column":20,"analysis":"The Ultimate Explosive ‘Sleeper’ Tech of 2024 Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","category":"company","company":"Apple","datetime":"2023-09-01 12:42:00","headline":"The Ultimate Explosive ‘Sleeper’ Tech of 2024","id":122370131,"image":"","related":"AAPL","sentiment":"positive","source":"InvestorPlace","summary":"Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","symbol":"AAPL","url":"https://finnhub.io/api/news?id=2db92abb6b58c629ea67fac5b37e1fbf0451a1e84704c0cf0097ef739b6ede1f"},{"_deepnote_index_column":21,"analysis":"10 Information Technology Stocks With Whale Alerts In Today's Session Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","category":"company","company":"Apple","datetime":"2023-09-01 12:41:00","headline":"10 Information Technology Stocks With Whale Alerts In Today's Session","id":122370132,"image":"","related":"AAPL","sentiment":"positive","source":"Benzinga","summary":"Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","symbol":"AAPL","url":"https://finnhub.io/api/news?id=a793c6982b1e901630f1f652d2d9e97e9b9a5835e2b7b9ad9841d2c58606836d"},{"_deepnote_index_column":22,"analysis":"These Stocks Are Moving the Most Today: Dell, Broadcom, Tesla, Apple, Nutanix, MongoDB, and More Adjusted second-quarter earnings from Dell Technologies soundly top analysts' estimates, Broadcom's revenue guidance for its fiscal fourth quarter is in line with Wall Street forecasts, Tesla unveils a revamped Model 3 with a longer range, and Nutanix issues strong fiscal first-quarter sales guidance.","category":"company","company":"Apple","datetime":"2023-09-01 09:33:00","headline":"These Stocks Are Moving the Most Today: Dell, Broadcom, Tesla, Apple, Nutanix, MongoDB, and More","id":122359158,"image":"https://s.yimg.com/ny/api/res/1.2/AIFMAUDVxEGUkvTWPq6twQ--/YXBwaWQ9aGlnaGxhbmRlcjt3PTEyMDA7aD02MDA-/https://media.zenfs.com/en/Barrons.com/2592f19756b3846bcb05e4d81d11f080","related":"AAPL","sentiment":"negative","source":"Yahoo","summary":"Adjusted second-quarter earnings from Dell Technologies soundly top analysts' estimates, Broadcom's revenue guidance for its fiscal fourth quarter is in line with Wall Street forecasts, Tesla unveils a revamped Model 3 with a longer range, and Nutanix issues strong fiscal first-quarter sales guidance.","symbol":"AAPL","url":"https://finnhub.io/api/news?id=a53686e9c83c591dbcfed3625641bedb6be4078bdfd21a3bea42ebde17970bbd"},{"_deepnote_index_column":23,"analysis":"With interest rates so high, should you be invested in cash? Also: The housing market adjusts, a potential bitcoin pop and some difficult family money problems to solve.","category":"company","company":"Apple","datetime":"2023-09-01 12:08:00","headline":"With interest rates so high, should you be invested in cash?","id":122385768,"image":"https://images.mktw.net/im-845712/social","related":"AAPL","sentiment":"neutral","source":"MarketWatch","summary":"Also: The housing market adjusts, a potential bitcoin pop and some difficult family money problems to solve.","symbol":"AAPL","url":"https://finnhub.io/api/news?id=4cd39628edb0a6387b042314a0f38c871d629d6cea46452fd58b40123acdbf58"},{"_deepnote_index_column":24,"analysis":"Nvidia's market cap climbs amid tech turbulence in August Nvidia's shares surged last month, boosted by its quarterly revenue forecast, which exceeded analyst expectations as the artificial intelligence boom fuels demand for its chips.  The market capitalization of Apple and Microsoft Corp's shares declined 4.4% and 2.4%, respectively, while Meta Platforms Inc's shares fell 7.1%.  Meanwhile, Berkshire Hathaway's market cap rose over 2% last month, as its shares touched a record high after the company's quarterly operating profit topped $10 billion for the first time.","category":"company","company":"Apple","datetime":"2023-09-01 12:03:09","headline":"Nvidia's market cap climbs amid tech turbulence in August","id":122361572,"image":"https://media.zenfs.com/en/reuters-finance.com/d11ef3fef283fc1156aa254d6de1271f","related":"AAPL","sentiment":"neutral","source":"Yahoo","summary":"Nvidia's shares surged last month, boosted by its quarterly revenue forecast, which exceeded analyst expectations as the artificial intelligence boom fuels demand for its chips.  The market capitalization of Apple and Microsoft Corp's shares declined 4.4% and 2.4%, respectively, while Meta Platforms Inc's shares fell 7.1%.  Meanwhile, Berkshire Hathaway's market cap rose over 2% last month, as its shares touched a record high after the company's quarterly operating profit topped $10 billion for the first time.","symbol":"AAPL","url":"https://finnhub.io/api/news?id=0815a25e80b3f52f34406a93b260acef5032e9bc2cc04d62a61166f5e374e302"},{"_deepnote_index_column":25,"analysis":"Google Is A Money-Making Machine: Still The Best Buy In Tech Due to better-than-expected business performance, Google stock is up 53% this year and still trades at a lower P/E than peers like Microsoft and Apple. Read more here.","category":"company","company":"Apple","datetime":"2023-09-01 11:41:14","headline":"Google Is A Money-Making Machine: Still The Best Buy In Tech","id":122365005,"image":"https://static.seekingalpha.com/cdn/s3/uploads/getty_images/1425481847/image_1425481847.jpg?io=getty-c-w1536","related":"AAPL","sentiment":"positive","source":"SeekingAlpha","summary":"Due to better-than-expected business performance, Google stock is up 53% this year and still trades at a lower P/E than peers like Microsoft and Apple. Read more here.","symbol":"AAPL","url":"https://finnhub.io/api/news?id=2747f95df82bcc486f6fd1da5f921ec114aa10b9a95b472985ed54fe526a1cda"},{"_deepnote_index_column":26,"analysis":"Do Instagram Users Favor Android Or iPhones? Adam Mosseri Weighs In Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","category":"company","company":"Apple","datetime":"2023-09-01 10:33:00","headline":"Do Instagram Users Favor Android Or iPhones? Adam Mosseri Weighs In","id":122392125,"image":"","related":"AAPL","sentiment":"positive","source":"Benzinga","summary":"Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","symbol":"AAPL","url":"https://finnhub.io/api/news?id=556f4b8ca714daad699ec2aeb5e70ced804aec6fdeff4db5b200347e4828359b"},{"_deepnote_index_column":27,"analysis":"Market Clubhouse Morning Memo - September 1st, 2023 (Trade Strategy For SPY, QQQ, AAPL, AMZN, GOOGL, MSFT, And NVDA) Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","category":"company","company":"Apple","datetime":"2023-09-01 10:05:00","headline":"Market Clubhouse Morning Memo - September 1st, 2023 (Trade Strategy For SPY, QQQ, AAPL, AMZN, GOOGL, MSFT, And NVDA)","id":122365242,"image":"","related":"AAPL","sentiment":"positive","source":"Benzinga","summary":"Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","symbol":"AAPL","url":"https://finnhub.io/api/news?id=b41cab9848de22568bef530b820d7ed8c880a9b48fa58a553c557b1437f2311d"},{"_deepnote_index_column":28,"analysis":"How Elon Musk Wants To Make Sure Creators Aren't 'Trapped' On X Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","category":"company","company":"Apple","datetime":"2023-09-01 09:58:00","headline":"How Elon Musk Wants To Make Sure Creators Aren't 'Trapped' On X","id":122392129,"image":"","related":"AAPL","sentiment":"positive","source":"Benzinga","summary":"Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","symbol":"AAPL","url":"https://finnhub.io/api/news?id=ef5e991dc2bc3e9542d0c4f7812ab047b5e81a10096c9fe68039aa449aced89c"},{"_deepnote_index_column":29,"analysis":"Unveiling Apple And Microsoft's Salary Secrets — Is iPhone Money Better Than AI Paychecks? Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","category":"company","company":"Apple","datetime":"2023-09-01 09:07:00","headline":"Unveiling Apple And Microsoft's Salary Secrets — Is iPhone Money Better Than AI Paychecks?","id":122365247,"image":"","related":"AAPL","sentiment":"positive","source":"Benzinga","summary":"Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","symbol":"AAPL","url":"https://finnhub.io/api/news?id=8e105487866f5be38fb582bda37c2372f776944502be25c850ee8445b133abf4"},{"_deepnote_index_column":30,"analysis":"2 Warren Buffett Stocks That Are Screaming Buys in September, and 1 to Avoid Like the Plague Two amazing deals are hiding in plain sight within Berkshire Hathaway's $352 billion investment portfolio, while another market-leading business has seen its growth engine completely stall.","category":"company","company":"Apple","datetime":"2023-09-01 09:06:00","headline":"2 Warren Buffett Stocks That Are Screaming Buys in September, and 1 to Avoid Like the Plague","id":122359582,"image":"https://s.yimg.com/ny/api/res/1.2/x8dow7phc8AgpvHABJrPIg--/YXBwaWQ9aGlnaGxhbmRlcjt3PTEyMDA7aD04MDA-/https://media.zenfs.com/en/motleyfool.com/df2cb63d1b3321c66ed9d4847223d29f","related":"AAPL","sentiment":"neutral","source":"Yahoo","summary":"Two amazing deals are hiding in plain sight within Berkshire Hathaway's $352 billion investment portfolio, while another market-leading business has seen its growth engine completely stall.","symbol":"AAPL","url":"https://finnhub.io/api/news?id=e29aa03c6da19bd4edb5a27e67addbde995de58e9c3f70660d9c2813ed8968f7"},{"_deepnote_index_column":31,"analysis":"Google DeepMind co-founder says US should enforce AI standards for ethical use Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","category":"company","company":"Apple","datetime":"2023-09-01 08:34:00","headline":"Google DeepMind co-founder says US should enforce AI standards for ethical use","id":122365249,"image":"","related":"AAPL","sentiment":"positive","source":"Seeking Alpha","summary":"Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","symbol":"AAPL","url":"https://finnhub.io/api/news?id=6ab33fe9f88f8140dcc75503bd34ca4183c812a81c6b6d948b3479d7170ad037"},{"_deepnote_index_column":32,"analysis":"Notable open interest changes for September 1st Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","category":"company","company":"Apple","datetime":"2023-09-01 07:55:00","headline":"Notable open interest changes for September 1st","id":122370141,"image":"","related":"AAPL","sentiment":"positive","source":"Thefly.com","summary":"Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","symbol":"AAPL","url":"https://finnhub.io/api/news?id=3fb98d23c2dd8aaacce07da1d71b9d4b83833ae8f3b6d51c213f4f2f600035a7"},{"_deepnote_index_column":33,"analysis":"New Stock Signals Say Long-Term Opportunity For Investors Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","category":"company","company":"Apple","datetime":"2023-09-01 07:17:00","headline":"New Stock Signals Say Long-Term Opportunity For Investors","id":122390669,"image":"","related":"AAPL","sentiment":"positive","source":"TalkMarkets","summary":"Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","symbol":"AAPL","url":"https://finnhub.io/api/news?id=fb408820da0b3580cdcc453b2e7ff8beed6fe3b8162da2eaf78055a6184cf82b"},{"_deepnote_index_column":34,"analysis":"Why Amazon Stock Can Beat the Market and Notch Its Best Monthly Streak in 20 Years Amazon just clinched its longest monthly winning streak since 2011. With September a historically good month for the stock, a new milestone is in sight.","category":"company","company":"Apple","datetime":"2023-09-01 06:55:00","headline":"Why Amazon Stock Can Beat the Market and Notch Its Best Monthly Streak in 20 Years","id":122389664,"image":"https://images.barrons.com/im-803063/social","related":"AAPL","sentiment":"negative","source":"MarketWatch","summary":"Amazon just clinched its longest monthly winning streak since 2011. With September a historically good month for the stock, a new milestone is in sight.","symbol":"AAPL","url":"https://finnhub.io/api/news?id=e66687ac7584785fa36abb589737854be27fe041013ab292dc8d261aae20790b"},{"_deepnote_index_column":35,"analysis":"Why pricey French bags are better than U.S. tech, according to this analyst Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","category":"company","company":"Apple","datetime":"2023-09-01 06:44:00","headline":"Why pricey French bags are better than U.S. tech, according to this analyst","id":122365531,"image":"","related":"AAPL","sentiment":"positive","source":"MarketWatch","summary":"Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","symbol":"AAPL","url":"https://finnhub.io/api/news?id=b685e3ca313371da63e2546c7ed968750a413b7b73430e91e384319584d76035"},{"_deepnote_index_column":36,"analysis":"Even If the Fed’s Rate Hikes Are Over, Uncertainty Is Only Getting Worse Tesla revamps its Model 3 in China, Taylor Swift movie gives hope to theaters, and other news to start your day.","category":"company","company":"Apple","datetime":"2023-09-01 06:43:00","headline":"Even If the Fed’s Rate Hikes Are Over, Uncertainty Is Only Getting Worse","id":122385046,"image":"https://images.barrons.com/im-827573/social","related":"AAPL","sentiment":"positive","source":"MarketWatch","summary":"Tesla revamps its Model 3 in China, Taylor Swift movie gives hope to theaters, and other news to start your day.","symbol":"AAPL","url":"https://finnhub.io/api/news?id=7a0fb58715110e564e4b042d8a741e78adc2b71706c047ff42b6a030941a1d45"},{"_deepnote_index_column":37,"analysis":"Should studios cut streamers out of Hollywood strike negotiations? Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","category":"company","company":"Apple","datetime":"2023-09-01 06:35:00","headline":"Should studios cut streamers out of Hollywood strike negotiations?","id":122365955,"image":"","related":"AAPL","sentiment":"positive","source":"Seeking Alpha","summary":"Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","symbol":"AAPL","url":"https://finnhub.io/api/news?id=1624d9ffc54093cdb81693c920601e9f17e5b6b8a246424d101a568fc9627108"},{"_deepnote_index_column":38,"analysis":"Apple Is Cooking Up A Secret Recipe To Make The iPhone 16 Display Brighter And More Efficient Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","category":"company","company":"Apple","datetime":"2023-09-01 06:32:00","headline":"Apple Is Cooking Up A Secret Recipe To Make The iPhone 16 Display Brighter And More Efficient","id":122370145,"image":"","related":"AAPL","sentiment":"positive","source":"Benzinga","summary":"Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","symbol":"AAPL","url":"https://finnhub.io/api/news?id=f87a9dd68921d82b37bd3f0cacc1abb75b2b618bcf775cccfd53f80f7a3ce74e"},{"_deepnote_index_column":39,"analysis":"This MacBook Pro Model Is Now A 'Vintage Product' That Will No Longer Get OS Updates Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","category":"company","company":"Apple","datetime":"2023-09-01 05:28:00","headline":"This MacBook Pro Model Is Now A 'Vintage Product' That Will No Longer Get OS Updates","id":122370146,"image":"","related":"AAPL","sentiment":"positive","source":"Benzinga","summary":"Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","symbol":"AAPL","url":"https://finnhub.io/api/news?id=be112cfd1d197b5dbd3f83b9900ce245f8e076d92701411f8e84e292c447c5d2"},{"_deepnote_index_column":40,"analysis":"Morgan Stanley ups Dell target, names top hardware pick over Apple Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","category":"company","company":"Apple","datetime":"2023-09-01 04:24:00","headline":"Morgan Stanley ups Dell target, names top hardware pick over Apple","id":122367294,"image":"","related":"AAPL","sentiment":"positive","source":"Thefly.com","summary":"Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","symbol":"AAPL","url":"https://finnhub.io/api/news?id=f890f93447264e9493c925a266de7037a4aa699061fa067a1c31d34e4b010af6"},{"_deepnote_index_column":41,"analysis":"Apple Reveals Why It Ditched Plans To Scan iPhones For Child Sexual Abuse Material: 'Slippery Slope Of Unintended Consequences' Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","category":"company","company":"Apple","datetime":"2023-09-01 04:11:00","headline":"Apple Reveals Why It Ditched Plans To Scan iPhones For Child Sexual Abuse Material: 'Slippery Slope Of Unintended Consequences'","id":122370148,"image":"","related":"AAPL","sentiment":"positive","source":"Benzinga","summary":"Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","symbol":"AAPL","url":"https://finnhub.io/api/news?id=f93fd0e7c4d605ffa48289e1e04ba0ff51f9502354af4c67a688e5fa9835f15f"},{"_deepnote_index_column":42,"analysis":"Long-Term Returns of David Einhorn’s Activist Targets In this article, we discuss long-term returns of David Einhorn’s 10 activist targets. You can skip our detailed analysis of Einhorn’s activist targets and their historical performance and go directly to read Long-Term Returns of David Einhorn’s 5 Activist Targets. David Einhorn is one of the most successful hedge fund managers. As the co-founder and president of […]","category":"company","company":"Apple","datetime":"2023-09-01 03:20:02","headline":"Long-Term Returns of David Einhorn’s Activist Targets","id":122355256,"image":"https://media.zenfs.com/en/insidermonkey.com/5bd59b35452dcee5cc6910b5d56b756a","related":"AAPL","sentiment":"positive","source":"Yahoo","summary":"In this article, we discuss long-term returns of David Einhorn’s 10 activist targets. You can skip our detailed analysis of Einhorn’s activist targets and their historical performance and go directly to read Long-Term Returns of David Einhorn’s 5 Activist Targets. David Einhorn is one of the most successful hedge fund managers. As the co-founder and president of […]","symbol":"AAPL","url":"https://finnhub.io/api/news?id=cdf75e2b02925cace51b29189ce6b689ab902ee3968fa300133100c06e80daa3"},{"_deepnote_index_column":43,"analysis":"Goldman Sachs Growth Stocks: Top 12 Stocks In this piece, we will take a look at Goldman Sachs’ top 12 growth stock picks. If you want to skip the latest about one of America’s most well known banks, then head on over to Goldman Sachs Growth Stocks: Top 5 Stocks. Investment bank The Goldman Sachs Group, Inc. (NYSE:GS) is making a lot […]","category":"company","company":"Apple","datetime":"2023-09-01 03:03:36","headline":"Goldman Sachs Growth Stocks: Top 12 Stocks","id":122353586,"image":"https://media.zenfs.com/en/insidermonkey.com/49b505a51ba0218597ee8894f7e57449","related":"AAPL","sentiment":"positive","source":"Yahoo","summary":"In this piece, we will take a look at Goldman Sachs’ top 12 growth stock picks. If you want to skip the latest about one of America’s most well known banks, then head on over to Goldman Sachs Growth Stocks: Top 5 Stocks. Investment bank The Goldman Sachs Group, Inc. (NYSE:GS) is making a lot […]","symbol":"AAPL","url":"https://finnhub.io/api/news?id=21946644c1cc0be3a2bf3a2825685af77e4aa3ca3e062ac64d1d6a5b63d6f632"},{"_deepnote_index_column":44,"analysis":"Globalstar signs deal worth up to $64M with SpaceX, filing shows Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","category":"company","company":"Apple","datetime":"2023-09-01 02:35:00","headline":"Globalstar signs deal worth up to $64M with SpaceX, filing shows","id":122390959,"image":"","related":"AAPL","sentiment":"positive","source":"Seeking Alpha","summary":"Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","symbol":"AAPL","url":"https://finnhub.io/api/news?id=e20abc4409a2e174b21ef1d8b8aae796b9a4334e8695b80e0cbd0b3e661cc4c1"},{"_deepnote_index_column":45,"analysis":"Can the Stock Market’s Rally Keep Going? Strategists on What’s Ahead. Inflation will fall further, interest rates could slip, and the recession has been postponed. How to invest in a \"moderating\" market.","category":"company","company":"Apple","datetime":"2023-09-01 01:00:00","headline":"Can the Stock Market’s Rally Keep Going? Strategists on What’s Ahead.","id":122389663,"image":"https://images.barrons.com/im-91947241/social","related":"AAPL","sentiment":"positive","source":"MarketWatch","summary":"Inflation will fall further, interest rates could slip, and the recession has been postponed. How to invest in a \"moderating\" market.","symbol":"AAPL","url":"https://finnhub.io/api/news?id=59e05b8429044ab1ff9a139546e8b353c5919f1d3524ff77cd40c36c2559b396"},{"_deepnote_index_column":46,"analysis":"Ally partners with Microsoft to leverage generative artificial intelligence Here's how Ally Financial is fully embracing generative AI after the launch of ChatGPT late last year.","category":"company","company":"Microsoft","datetime":"2023-09-01 18:50:05","headline":"Ally partners with Microsoft to leverage generative artificial intelligence","id":122374569,"image":"","related":"MSFT","sentiment":"positive","source":"Yahoo","summary":"Here's how Ally Financial is fully embracing generative AI after the launch of ChatGPT late last year.","symbol":"MSFT","url":"https://finnhub.io/api/news?id=1db7544ed88772320a504623685ea6d5e6118c1dcb623cf720ac6f051a44ac30"},{"_deepnote_index_column":47,"analysis":"Microsoft-Backed Rubrik Aims for IPO as Soon as This Year (Bloomberg) -- Rubrik Inc., a cloud and data security startup backed by Microsoft Corp., is on track to hold its initial public offering this year and its investor roadshow could start as early as October, according to people familiar with the matter. Most Read from BloombergTesla’s $41,000 Model X Discount Unlocks Subsidies Musk Wanted GoneSaola Weakens After Bringing ‘Destructive’ Winds to Hong KongSingapore Picks Tharman as President in Ruling Party BoostTesla Refreshes Model 3 and Slashes Pr","category":"company","company":"Microsoft","datetime":"2023-09-01 18:40:20","headline":"Microsoft-Backed Rubrik Aims for IPO as Soon as This Year","id":122374570,"image":"https://s.yimg.com/ny/api/res/1.2/4T4QFtT9R1wQNcOYdW4H1Q--/YXBwaWQ9aGlnaGxhbmRlcjt3PTEyMDA7aD04MDA-/https://media.zenfs.com/en/bloomberg_markets_842/e6a5d6cba1a218b0108246e72379bffa","related":"MSFT","sentiment":"positive","source":"Yahoo","summary":"(Bloomberg) -- Rubrik Inc., a cloud and data security startup backed by Microsoft Corp., is on track to hold its initial public offering this year and its investor roadshow could start as early as October, according to people familiar with the matter. Most Read from BloombergTesla’s $41,000 Model X Discount Unlocks Subsidies Musk Wanted GoneSaola Weakens After Bringing ‘Destructive’ Winds to Hong KongSingapore Picks Tharman as President in Ruling Party BoostTesla Refreshes Model 3 and Slashes Pr","symbol":"MSFT","url":"https://finnhub.io/api/news?id=21837973ae0c70abcb6f02d630266d818c572354d83a6e5c0a6529eabec4ddf7"},{"_deepnote_index_column":48,"analysis":"Microsoft Corp. stock outperforms market on strong trading day Shares of Microsoft Corp. inched 0.27% higher to $328.66 Friday, on what proved to be an all-around great trading session for the stock market, with the S&P...","category":"company","company":"Microsoft","datetime":"2023-09-01 16:33:00","headline":"Microsoft Corp. stock outperforms market on strong trading day","id":122397630,"image":"https://images.mktw.net/im-220105/social","related":"MSFT","sentiment":"negative","source":"MarketWatch","summary":"Shares of Microsoft Corp. inched 0.27% higher to $328.66 Friday, on what proved to be an all-around great trading session for the stock market, with the S&P...","symbol":"MSFT","url":"https://finnhub.io/api/news?id=208c53090fb4761e6caf2a35a9fdb444a20836a10467785afbaf1539b02f24ef"},{"_deepnote_index_column":49,"analysis":"SentinelOne, Inc. (NYSE:S) Q2 2024 Earnings Call Transcript SentinelOne, Inc. (NYSE:S) Q2 2024 Earnings Call Transcript August 31, 2023 SentinelOne, Inc. beats earnings expectations. Reported EPS is $0.08, expectations were $-0.15. Operator: Good afternoon, and thank you for attending todays SentinelOne Q2 Fiscal Year ‘24 Earnings Conference Call. My name is Cole, and I will be your moderator for today’s call. [Operator Instructions] […]","category":"company","company":"Microsoft","datetime":"2023-09-01 14:31:48","headline":"SentinelOne, Inc. (NYSE:S) Q2 2024 Earnings Call Transcript","id":122368412,"image":"https://media.zenfs.com/en/insidermonkey.com/ea35b0e6ecbd2fd7acf5d2a3e06b5ef6","related":"MSFT","sentiment":"positive","source":"Yahoo","summary":"SentinelOne, Inc. (NYSE:S) Q2 2024 Earnings Call Transcript August 31, 2023 SentinelOne, Inc. beats earnings expectations. Reported EPS is $0.08, expectations were $-0.15. Operator: Good afternoon, and thank you for attending todays SentinelOne Q2 Fiscal Year ‘24 Earnings Conference Call. My name is Cole, and I will be your moderator for today’s call. [Operator Instructions] […]","symbol":"MSFT","url":"https://finnhub.io/api/news?id=29878f30b53c77b92983a1bb90e552669ea5a88b0bd12456321891a616f74d18"},{"_deepnote_index_column":50,"analysis":"DGRW: Dividend Growth I Wouldn't Buy Into DGRW lags behind its peers in terms of dividend growth. Future dividend performance relies on a few companies in the fund's portfolio. Click here to read more.","category":"company","company":"Microsoft","datetime":"2023-09-01 13:47:33","headline":"DGRW: Dividend Growth I Wouldn't Buy Into","id":122369196,"image":"https://static.seekingalpha.com/cdn/s3/uploads/getty_images/1326978045/image_1326978045.jpg?io=getty-c-w1536","related":"MSFT","sentiment":"positive","source":"SeekingAlpha","summary":"DGRW lags behind its peers in terms of dividend growth. Future dividend performance relies on a few companies in the fund's portfolio. Click here to read more.","symbol":"MSFT","url":"https://finnhub.io/api/news?id=757795cc4c570722e8f999057e563f36ed3ad77a4126e7e63216de8b259e77f0"},{"_deepnote_index_column":51,"analysis":"Why This 1 Computer and Technology Stock Could Be a Great Addition to Your Portfolio The Zacks Focus List offers investors a way to easily find top-rated stocks and build a winning investment portfolio. Here's why you should take advantage.","category":"company","company":"Microsoft","datetime":"2023-09-01 13:30:06","headline":"Why This 1 Computer and Technology Stock Could Be a Great Addition to Your Portfolio","id":122374572,"image":"https://media.zenfs.com/en/zacks.com/e8e4b0344809eaac6d73c9fd25fd180a","related":"MSFT","sentiment":"positive","source":"Yahoo","summary":"The Zacks Focus List offers investors a way to easily find top-rated stocks and build a winning investment portfolio. Here's why you should take advantage.","symbol":"MSFT","url":"https://finnhub.io/api/news?id=66257ee3a950f2f492a1da61a0dc82b34b067b5985498423ed678e79b2dfb644"},{"_deepnote_index_column":52,"analysis":"Investors Heavily Search Microsoft Corporation (MSFT): Here is What You Need to Know Zacks.com users have recently been watching Microsoft (MSFT) quite a bit. Thus, it is worth knowing the facts that could determine the stock's prospects.","category":"company","company":"Microsoft","datetime":"2023-09-01 13:00:10","headline":"Investors Heavily Search Microsoft Corporation (MSFT): Here is What You Need to Know","id":122374573,"image":"https://media.zenfs.com/en/zacks.com/0c6f98f4bf655bec3b199bc1a71b8b85","related":"MSFT","sentiment":"positive","source":"Yahoo","summary":"Zacks.com users have recently been watching Microsoft (MSFT) quite a bit. Thus, it is worth knowing the facts that could determine the stock's prospects.","symbol":"MSFT","url":"https://finnhub.io/api/news?id=3d7a047e7acd82aa6080f834fd58eff27718fb017decca0a12668067d41af59c"},{"_deepnote_index_column":53,"analysis":"2 Cheap AI Stocks That Are Not Microsoft to Buy Hand Over Fist Before They Take Off Investors looking for value plays in the AI space may want to buy these stocks before they surge higher.","category":"company","company":"Microsoft","datetime":"2023-09-01 13:00:00","headline":"2 Cheap AI Stocks That Are Not Microsoft to Buy Hand Over Fist Before They Take Off","id":122362050,"image":"https://s.yimg.com/ny/api/res/1.2/bPL9MZ0x45N9ZOfUC2B3Hg--/YXBwaWQ9aGlnaGxhbmRlcjt3PTEyMDA7aD04MDA-/https://media.zenfs.com/en/motleyfool.com/f4b21b3b6f77c68b622a56736fd69182","related":"MSFT","sentiment":"positive","source":"Yahoo","summary":"Investors looking for value plays in the AI space may want to buy these stocks before they surge higher.","symbol":"MSFT","url":"https://finnhub.io/api/news?id=7c9f800ebed77303ddf583a865be9b1a6ee66144008c69d4255703e7f30672a1"},{"_deepnote_index_column":54,"analysis":"The Ultimate Explosive ‘Sleeper’ Tech of 2024 Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","category":"company","company":"Microsoft","datetime":"2023-09-01 12:42:00","headline":"The Ultimate Explosive ‘Sleeper’ Tech of 2024","id":122370131,"image":"","related":"MSFT","sentiment":"positive","source":"InvestorPlace","summary":"Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","symbol":"MSFT","url":"https://finnhub.io/api/news?id=2db92abb6b58c629ea67fac5b37e1fbf0451a1e84704c0cf0097ef739b6ede1f"},{"_deepnote_index_column":55,"analysis":"10 Information Technology Stocks With Whale Alerts In Today's Session Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","category":"company","company":"Microsoft","datetime":"2023-09-01 12:41:00","headline":"10 Information Technology Stocks With Whale Alerts In Today's Session","id":122370132,"image":"","related":"MSFT","sentiment":"positive","source":"Benzinga","summary":"Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","symbol":"MSFT","url":"https://finnhub.io/api/news?id=a793c6982b1e901630f1f652d2d9e97e9b9a5835e2b7b9ad9841d2c58606836d"},{"_deepnote_index_column":56,"analysis":"Microsoft (MSFT) to Unbundle Teams From Office 365 in Europe Microsoft (MSFT) is set to unbundle Teams from its Microsoft 365 and Office 365 productivity suites in EU markets in October to avoid further antitrust scrutiny.","category":"company","company":"Microsoft","datetime":"2023-09-01 12:38:00","headline":"Microsoft (MSFT) to Unbundle Teams From Office 365 in Europe","id":122374575,"image":"https://media.zenfs.com/en/zacks.com/d325e443265f81b37d14d0c390b4cefa","related":"MSFT","sentiment":"positive","source":"Yahoo","summary":"Microsoft (MSFT) is set to unbundle Teams from its Microsoft 365 and Office 365 productivity suites in EU markets in October to avoid further antitrust scrutiny.","symbol":"MSFT","url":"https://finnhub.io/api/news?id=d8c714489e234e214282991c4533695c8b7c97fdf659dfe4f6edfa71368e700f"},{"_deepnote_index_column":57,"analysis":"Google Is A Money-Making Machine: Still The Best Buy In Tech Due to better-than-expected business performance, Google stock is up 53% this year and still trades at a lower P/E than peers like Microsoft and Apple. Read more here.","category":"company","company":"Microsoft","datetime":"2023-09-01 11:41:14","headline":"Google Is A Money-Making Machine: Still The Best Buy In Tech","id":122365005,"image":"https://static.seekingalpha.com/cdn/s3/uploads/getty_images/1425481847/image_1425481847.jpg?io=getty-c-w1536","related":"MSFT","sentiment":"positive","source":"SeekingAlpha","summary":"Due to better-than-expected business performance, Google stock is up 53% this year and still trades at a lower P/E than peers like Microsoft and Apple. Read more here.","symbol":"MSFT","url":"https://finnhub.io/api/news?id=2747f95df82bcc486f6fd1da5f921ec114aa10b9a95b472985ed54fe526a1cda"},{"_deepnote_index_column":58,"analysis":"Q2 2024 SentinelOne Inc Earnings Call Q2 2024 SentinelOne Inc Earnings Call","category":"company","company":"Microsoft","datetime":"2023-09-01 11:30:50","headline":"Q2 2024 SentinelOne Inc Earnings Call","id":122368415,"image":"https://s.yimg.com/cv/apiv2/social/images/yahoo_default_logo-1200x1200.png","related":"MSFT","sentiment":"positive","source":"Yahoo","summary":"Q2 2024 SentinelOne Inc Earnings Call","symbol":"MSFT","url":"https://finnhub.io/api/news?id=0c4b71c95c42f057969aa62f77329d4625e0ff7fc020ccc39b1daf416a8c8efc"},{"_deepnote_index_column":59,"analysis":"SAP brings in Walter Sun from Microsoft as new AI chief Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","category":"company","company":"Microsoft","datetime":"2023-09-01 11:21:00","headline":"SAP brings in Walter Sun from Microsoft as new AI chief","id":122365237,"image":"","related":"MSFT","sentiment":"positive","source":"Alliance News","summary":"Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","symbol":"MSFT","url":"https://finnhub.io/api/news?id=f9c19b8277c5926f32e4146f1c8eaa5da2e108a348694963977a8f8a2bcc861d"},{"_deepnote_index_column":60,"analysis":"Tesla Taps Into X For Hiring, And So Do These Companies: Elon Musk Finds It 'Cool' Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","category":"company","company":"Microsoft","datetime":"2023-09-01 11:04:00","headline":"Tesla Taps Into X For Hiring, And So Do These Companies: Elon Musk Finds It 'Cool'","id":122392123,"image":"","related":"MSFT","sentiment":"positive","source":"Benzinga","summary":"Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","symbol":"MSFT","url":"https://finnhub.io/api/news?id=5bb481ccdca9770c9ccd08b1dbd4b7500ff1e0b12b5450eb3c213a054365a7f6"},{"_deepnote_index_column":61,"analysis":"Microsoft Could Be Launching AI-Powered Smart Backpacks: Here Are Some Use Cases Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","category":"company","company":"Microsoft","datetime":"2023-09-01 10:39:00","headline":"Microsoft Could Be Launching AI-Powered Smart Backpacks: Here Are Some Use Cases","id":122365240,"image":"","related":"MSFT","sentiment":"positive","source":"Benzinga","summary":"Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","symbol":"MSFT","url":"https://finnhub.io/api/news?id=e4ae884bfc4500507801585d3d2ba0aae5839594280487a1f37ef69a2c175358"},{"_deepnote_index_column":62,"analysis":"Market Clubhouse Morning Memo - September 1st, 2023 (Trade Strategy For SPY, QQQ, AAPL, AMZN, GOOGL, MSFT, And NVDA) Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","category":"company","company":"Microsoft","datetime":"2023-09-01 10:05:00","headline":"Market Clubhouse Morning Memo - September 1st, 2023 (Trade Strategy For SPY, QQQ, AAPL, AMZN, GOOGL, MSFT, And NVDA)","id":122365242,"image":"","related":"MSFT","sentiment":"positive","source":"Benzinga","summary":"Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","symbol":"MSFT","url":"https://finnhub.io/api/news?id=b41cab9848de22568bef530b820d7ed8c880a9b48fa58a553c557b1437f2311d"},{"_deepnote_index_column":63,"analysis":"SentinelOne (S) Q2 2024 Earnings Call Transcript Thank you for attending today's SentinelOne Q2 fiscal year '24 earnings conference call.  Good afternoon, everyone, and welcome to SentinelOne's earnings call for the second quarter of fiscal year '24 ended July 31st.  With us today are Tomer Weingarten, CEO; and Dave Bernhardt, CFO.","category":"company","company":"Microsoft","datetime":"2023-09-01 09:30:25","headline":"SentinelOne (S) Q2 2024 Earnings Call Transcript","id":122368416,"image":"","related":"MSFT","sentiment":"positive","source":"Yahoo","summary":"Thank you for attending today's SentinelOne Q2 fiscal year '24 earnings conference call.  Good afternoon, everyone, and welcome to SentinelOne's earnings call for the second quarter of fiscal year '24 ended July 31st.  With us today are Tomer Weingarten, CEO; and Dave Bernhardt, CFO.","symbol":"MSFT","url":"https://finnhub.io/api/news?id=620aece2286f584c0e97660d822cfc181fcc32ef5e9116316af76e65ff18473b"},{"_deepnote_index_column":64,"analysis":"3 Bulletproof Stocks to Protect Your Portfolio From Tech Turmoil Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","category":"company","company":"Microsoft","datetime":"2023-09-01 09:12:00","headline":"3 Bulletproof Stocks to Protect Your Portfolio From Tech Turmoil","id":122365244,"image":"","related":"MSFT","sentiment":"positive","source":"InvestorPlace","summary":"Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","symbol":"MSFT","url":"https://finnhub.io/api/news?id=39e5e3068274d7d78cd47f8faf7aec82b80c5d3cb344092e9fb165f01111e6d2"},{"_deepnote_index_column":65,"analysis":"Unveiling Apple And Microsoft's Salary Secrets — Is iPhone Money Better Than AI Paychecks? Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","category":"company","company":"Microsoft","datetime":"2023-09-01 09:07:00","headline":"Unveiling Apple And Microsoft's Salary Secrets — Is iPhone Money Better Than AI Paychecks?","id":122365247,"image":"","related":"MSFT","sentiment":"positive","source":"Benzinga","summary":"Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","symbol":"MSFT","url":"https://finnhub.io/api/news?id=8e105487866f5be38fb582bda37c2372f776944502be25c850ee8445b133abf4"},{"_deepnote_index_column":66,"analysis":"Like Amazon And Google, Salesforce Is Optimistic About The Remaining Half Of The Year Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","category":"company","company":"Microsoft","datetime":"2023-09-01 09:07:00","headline":"Like Amazon And Google, Salesforce Is Optimistic About The Remaining Half Of The Year","id":122365245,"image":"","related":"MSFT","sentiment":"positive","source":"Benzinga","summary":"Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","symbol":"MSFT","url":"https://finnhub.io/api/news?id=7db5239f8eced42a39d9ffe336e5f0e2de162dcaf3db9fa4f52e93a6d6f8408e"},{"_deepnote_index_column":67,"analysis":"SAP Names Microsoft's Walter Sun as Head of Artificial Intelligence -- Update By Mauro Orru SAP appointed Microsoft's Walter Sun as global head of artificial intelligence, a move that underscores the business-software company's efforts to secure a larger share in this...","category":"company","company":"Microsoft","datetime":"2023-09-01 09:01:03","headline":"SAP Names Microsoft's Walter Sun as Head of Artificial Intelligence -- Update","id":122361922,"image":"","related":"MSFT","sentiment":"negative","source":"Finnhub","summary":"By Mauro Orru SAP appointed Microsoft's Walter Sun as global head of artificial intelligence, a move that underscores the business-software company's efforts to secure a larger share in this...","symbol":"MSFT","url":"https://finnhub.io/api/news?id=751fd0b7e96da48944a1e3eb2fc0ce4db14bc66e996e8588ab2292847c96b158"},{"_deepnote_index_column":68,"analysis":"SAP Names Microsoft's Walter Sun as Head of Artificial Intelligence By Mauro Orru SAP appointed Microsoft's Walter Sun as global head of artificial intelligence, a move that underscores the business-software company's efforts to secure a larger share in this...","category":"company","company":"Microsoft","datetime":"2023-09-01 08:38:02","headline":"SAP Names Microsoft's Walter Sun as Head of Artificial Intelligence","id":122361215,"image":"","related":"MSFT","sentiment":"negative","source":"Finnhub","summary":"By Mauro Orru SAP appointed Microsoft's Walter Sun as global head of artificial intelligence, a move that underscores the business-software company's efforts to secure a larger share in this...","symbol":"MSFT","url":"https://finnhub.io/api/news?id=af4131daa7252d6d8e13a20f6354c5fdac00b3427b5fbeaa8fe680ea001fa914"},{"_deepnote_index_column":69,"analysis":"Google DeepMind co-founder says US should enforce AI standards for ethical use Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","category":"company","company":"Microsoft","datetime":"2023-09-01 08:34:00","headline":"Google DeepMind co-founder says US should enforce AI standards for ethical use","id":122365249,"image":"","related":"MSFT","sentiment":"positive","source":"Seeking Alpha","summary":"Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","symbol":"MSFT","url":"https://finnhub.io/api/news?id=6ab33fe9f88f8140dcc75503bd34ca4183c812a81c6b6d948b3479d7170ad037"},{"_deepnote_index_column":70,"analysis":"Inflection AI's CEO Wants Restrictions on Nvidia Chip Sales: The Ethical Debate Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","category":"company","company":"Microsoft","datetime":"2023-09-01 07:39:00","headline":"Inflection AI's CEO Wants Restrictions on Nvidia Chip Sales: The Ethical Debate","id":122365250,"image":"","related":"MSFT","sentiment":"positive","source":"Benzinga","summary":"Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","symbol":"MSFT","url":"https://finnhub.io/api/news?id=edd37866c554f091c08a7cfd062a581a7a4007138ca2dbcb52aea6abd5f41ea5"},{"_deepnote_index_column":71,"analysis":"How To Turn Google And Meta Into 4.2% Yielding Rich Retirement Dream Stocks Growth stocks like Google and Meta Platforms, Inc. offer long-term income potential with high returns and income growth. Check out our GOOG and META strategy.","category":"company","company":"Microsoft","datetime":"2023-09-01 07:15:00","headline":"How To Turn Google And Meta Into 4.2% Yielding Rich Retirement Dream Stocks","id":122359984,"image":"https://static.seekingalpha.com/cdn/s3/uploads/getty_images/626205158/image_626205158.jpg?io=getty-c-w1536","related":"MSFT","sentiment":"positive","source":"SeekingAlpha","summary":"Growth stocks like Google and Meta Platforms, Inc. offer long-term income potential with high returns and income growth. Check out our GOOG and META strategy.","symbol":"MSFT","url":"https://finnhub.io/api/news?id=ff3fb025e0ff3a39fd5e2ec6e63cc3855e4a7693ebb999dfbe9bc13e2ece3701"},{"_deepnote_index_column":72,"analysis":"SAP names Walter Sun as new Global Head of Artificial Intelligence Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","category":"company","company":"Microsoft","datetime":"2023-09-01 07:03:00","headline":"SAP names Walter Sun as new Global Head of Artificial Intelligence","id":122365253,"image":"","related":"MSFT","sentiment":"positive","source":"Thefly.com","summary":"Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","symbol":"MSFT","url":"https://finnhub.io/api/news?id=c372ce733a888a4b170a99b3a3521df62e23ec84027f5765497f108cc2e7e68a"},{"_deepnote_index_column":73,"analysis":"Samsung stock rises on chip supply deal with Nvidia for use in AI - report Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","category":"company","company":"Microsoft","datetime":"2023-09-01 04:37:00","headline":"Samsung stock rises on chip supply deal with Nvidia for use in AI - report","id":122365256,"image":"","related":"MSFT","sentiment":"positive","source":"Seeking Alpha","summary":"Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","symbol":"MSFT","url":"https://finnhub.io/api/news?id=7cf128c22377c2d148d67650eeabf4ff9a9d6d7c829722f5e707fd045d71eb42"},{"_deepnote_index_column":74,"analysis":"The paper trail revealing hidden Adani investors When short seller Hindenburg Researchaccused Gautam Adani — then Asia’s richest man — of “pulling the largest con in corporate history” earlier this year, a key component of the New York firm’s allegations concerned the role of Gautam’s older brother Vinod Adani.  The elder Adani had used a web of offshore entities domiciled in Mauritius and other offshore havens to move billions of dollars into public and private Adani Group companies in India, Hindenburg alleged, flouting disclosure rules in the process.  Now, new documents shared with the FT by the Organized Crime and Corruption Reporting Project reveal new insight into some of Hindenburg’s claims, which Adani Group has strenuously denied.","category":"company","company":"Microsoft","datetime":"2023-09-01 04:01:47","headline":"The paper trail revealing hidden Adani investors","id":122360708,"image":"https://s.yimg.com/cv/apiv2/social/images/yahoo_default_logo-1200x1200.png","related":"MSFT","sentiment":"positive","source":"Yahoo","summary":"When short seller Hindenburg Researchaccused Gautam Adani — then Asia’s richest man — of “pulling the largest con in corporate history” earlier this year, a key component of the New York firm’s allegations concerned the role of Gautam’s older brother Vinod Adani.  The elder Adani had used a web of offshore entities domiciled in Mauritius and other offshore havens to move billions of dollars into public and private Adani Group companies in India, Hindenburg alleged, flouting disclosure rules in the process.  Now, new documents shared with the FT by the Organized Crime and Corruption Reporting Project reveal new insight into some of Hindenburg’s claims, which Adani Group has strenuously denied.","symbol":"MSFT","url":"https://finnhub.io/api/news?id=c220f26308d8c6a2e2e9e5fb37e47a7fb96087a99c6806cea4951d9415ae24db"},{"_deepnote_index_column":75,"analysis":"Long-Term Returns of David Einhorn’s Activist Targets In this article, we discuss long-term returns of David Einhorn’s 10 activist targets. You can skip our detailed analysis of Einhorn’s activist targets and their historical performance and go directly to read Long-Term Returns of David Einhorn’s 5 Activist Targets. David Einhorn is one of the most successful hedge fund managers. As the co-founder and president of […]","category":"company","company":"Microsoft","datetime":"2023-09-01 03:20:02","headline":"Long-Term Returns of David Einhorn’s Activist Targets","id":122355256,"image":"https://media.zenfs.com/en/insidermonkey.com/5bd59b35452dcee5cc6910b5d56b756a","related":"MSFT","sentiment":"positive","source":"Yahoo","summary":"In this article, we discuss long-term returns of David Einhorn’s 10 activist targets. You can skip our detailed analysis of Einhorn’s activist targets and their historical performance and go directly to read Long-Term Returns of David Einhorn’s 5 Activist Targets. David Einhorn is one of the most successful hedge fund managers. As the co-founder and president of […]","symbol":"MSFT","url":"https://finnhub.io/api/news?id=cdf75e2b02925cace51b29189ce6b689ab902ee3968fa300133100c06e80daa3"},{"_deepnote_index_column":76,"analysis":"What You Missed On Wall Street On Friday Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","category":"company","company":"Microsoft","datetime":"2023-09-01 03:15:00","headline":"What You Missed On Wall Street On Friday","id":122376469,"image":"","related":"MSFT","sentiment":"positive","source":"Thefly.com","summary":"Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","symbol":"MSFT","url":"https://finnhub.io/api/news?id=70c94e133452a2671b3ddc7211db66c2ca58193039456a5abec0520dd01923ef"},{"_deepnote_index_column":77,"analysis":"List of 55 Artificial Intelligence Companies in USA In this article, we will cover a list of 55 Artificial Intelligence Companies in USA. If you want to skip our detailed analysis, head straight to the top 10 Artificial Intelligence Companies in USA. On 21st July 2023, seven major tech giants, including Alphabet Inc (NASDAQ:GOOG), Microsoft Corp (NASDAQ:MSFT), Meta Platforms Inc (NASDAQ:META), and Amazon.com, Inc […]","category":"company","company":"Microsoft","datetime":"2023-09-01 02:58:29","headline":"List of 55 Artificial Intelligence Companies in USA","id":122353487,"image":"https://media.zenfs.com/en/insidermonkey.com/ef9347813a3ad58dfce55d51a0d7d3ca","related":"MSFT","sentiment":"positive","source":"Yahoo","summary":"In this article, we will cover a list of 55 Artificial Intelligence Companies in USA. If you want to skip our detailed analysis, head straight to the top 10 Artificial Intelligence Companies in USA. On 21st July 2023, seven major tech giants, including Alphabet Inc (NASDAQ:GOOG), Microsoft Corp (NASDAQ:MSFT), Meta Platforms Inc (NASDAQ:META), and Amazon.com, Inc […]","symbol":"MSFT","url":"https://finnhub.io/api/news?id=d01f792811d6c37569a573e523f4f0014ed6acd16b90da5576f72b3c92df8bed"},{"_deepnote_index_column":78,"analysis":"Starfield's Bumpy Ride: Accessibility Concerns, Steam Deck's Performance Stumbles Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","category":"company","company":"Microsoft","datetime":"2023-09-01 02:43:00","headline":"Starfield's Bumpy Ride: Accessibility Concerns, Steam Deck's Performance Stumbles","id":122407600,"image":"","related":"MSFT","sentiment":"positive","source":"Benzinga","summary":"Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","symbol":"MSFT","url":"https://finnhub.io/api/news?id=5e5216d475a2521931deea9e297fa99adc7256dc72aa1f772eea8f369fe9b2e9"},{"_deepnote_index_column":79,"analysis":"Want to Get Rich? 3 Game-Changing AI Stocks to Buy Right Now Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","category":"company","company":"Microsoft","datetime":"2023-09-01 02:39:00","headline":"Want to Get Rich? 3 Game-Changing AI Stocks to Buy Right Now","id":122375556,"image":"","related":"MSFT","sentiment":"positive","source":"InvestorPlace","summary":"Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","symbol":"MSFT","url":"https://finnhub.io/api/news?id=2f9deb565ef7571684ebebff11b6b773adab4ab5c4e3b8ad2252375d2ec22949"},{"_deepnote_index_column":80,"analysis":"Cybersecurity firm Rubrik aims for IPO this year - report Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","category":"company","company":"Microsoft","datetime":"2023-09-01 02:29:00","headline":"Cybersecurity firm Rubrik aims for IPO this year - report","id":122407602,"image":"","related":"MSFT","sentiment":"positive","source":"Seeking Alpha","summary":"Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","symbol":"MSFT","url":"https://finnhub.io/api/news?id=6e38e38828fb112281d2f50521e55285789167adc127e0a4ae7ad7b25e8523e8"},{"_deepnote_index_column":81,"analysis":"16 Best High Volume Stocks To Buy Today In this piece, we will take a look at the 16 best high volume stocks to buy today. If you want to skip our introduction to different metrics of stock trading, then head on over to 5 Best High Volume Stocks To Buy Today. One way in which technology has impacted the financial world is […]","category":"company","company":"Microsoft","datetime":"2023-09-01 02:23:53","headline":"16 Best High Volume Stocks To Buy Today","id":122353547,"image":"https://media.zenfs.com/en/insidermonkey.com/047739e527396bfecb37fa6e2d412bdb","related":"MSFT","sentiment":"positive","source":"Yahoo","summary":"In this piece, we will take a look at the 16 best high volume stocks to buy today. If you want to skip our introduction to different metrics of stock trading, then head on over to 5 Best High Volume Stocks To Buy Today. One way in which technology has impacted the financial world is […]","symbol":"MSFT","url":"https://finnhub.io/api/news?id=265f4ade65257168f2a1e37df2fee2ca3b9faa90ea7ddabc52fe1ecaa8cdd8e0"},{"_deepnote_index_column":82,"analysis":"Perspectives On Innovation: 'Responsible AI' As A Barometer For Risk Mitigation And Growth Potential Artificial intelligence (AI) will create many exciting opportunities for companies but also risks—understanding both is key to identifying companies with above-average growth prospects.","category":"company","company":"Microsoft","datetime":"2023-09-01 02:15:00","headline":"Perspectives On Innovation: 'Responsible AI' As A Barometer For Risk Mitigation And Growth Potential","id":122356015,"image":"https://static.seekingalpha.com/cdn/s3/uploads/getty_images/1464561797/image_1464561797.jpg?io=getty-c-w1536","related":"MSFT","sentiment":"negative","source":"SeekingAlpha","summary":"Artificial intelligence (AI) will create many exciting opportunities for companies but also risks—understanding both is key to identifying companies with above-average growth prospects.","symbol":"MSFT","url":"https://finnhub.io/api/news?id=3bfc7c81c972ff3d10a2c16cfa31dad61fe6c525ddbebd0a69d919661e25d6f6"},{"_deepnote_index_column":83,"analysis":"Microsoft-backed Rubrik on track for IPO as soon as this year, Bloomberg says Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","category":"company","company":"Microsoft","datetime":"2023-09-01 01:58:00","headline":"Microsoft-backed Rubrik on track for IPO as soon as this year, Bloomberg says","id":122407604,"image":"","related":"MSFT","sentiment":"positive","source":"Thefly.com","summary":"Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","symbol":"MSFT","url":"https://finnhub.io/api/news?id=8a61cc5911e8c1c4bea31d4d7bd944c738e9bbe88fff0335cf90a44d41b728ce"},{"_deepnote_index_column":84,"analysis":"What Critics Are Saying About Starfield: Bethesda Game Studio's Space Adventure Under The Microscope Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","category":"company","company":"Microsoft","datetime":"2023-09-01 01:40:00","headline":"What Critics Are Saying About Starfield: Bethesda Game Studio's Space Adventure Under The Microscope","id":122407605,"image":"","related":"MSFT","sentiment":"positive","source":"Benzinga","summary":"Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","symbol":"MSFT","url":"https://finnhub.io/api/news?id=33a000ecf62871a23415005f4ece945e0e16b2f5b7c3809a84de652113923a8e"},{"_deepnote_index_column":85,"analysis":"Goldman Sachs AI Stocks: Top 10 Stock Picks In this article, we will be taking a look at Goldman Sachs AI stocks: top 10 stock picks. To skip our detailed analysis of the artificial intelligence market, you can go directly to see the Goldman Sachs AI Stocks: Top 5 Stock Picks. Artificial intelligence has been all the hype so far in 2023. Every […]","category":"company","company":"Microsoft","datetime":"2023-09-01 00:39:40","headline":"Goldman Sachs AI Stocks: Top 10 Stock Picks","id":122352268,"image":"https://s.yimg.com/ny/api/res/1.2/FGgd9teXqnLeynnZGLyj_g--/YXBwaWQ9aGlnaGxhbmRlcjt3PTEyMDA7aD02MDA-/https://media.zenfs.com/en/insidermonkey.com/d26d2c55cd027e2b4f44ded4c6ac02d0","related":"MSFT","sentiment":"positive","source":"Yahoo","summary":"In this article, we will be taking a look at Goldman Sachs AI stocks: top 10 stock picks. To skip our detailed analysis of the artificial intelligence market, you can go directly to see the Goldman Sachs AI Stocks: Top 5 Stock Picks. Artificial intelligence has been all the hype so far in 2023. Every […]","symbol":"MSFT","url":"https://finnhub.io/api/news?id=09c9410dd80cd28e20ac8442b6693498ec304cf29ec2ac5053ddb1eab8a0abb2"},{"_deepnote_index_column":86,"analysis":"J&J Dividend Decision Shows Power of Free Cash Flow J&J plans to maintain its quarterly dividend even after separating its Kenvue business. It didn't have to do that to keep its status as a Dividend Aristocrat.","category":"company","company":"Johnson & Johnson","datetime":"2023-09-01 23:33:00","headline":"J&J Dividend Decision Shows Power of Free Cash Flow","id":122386013,"image":"","related":"JNJ","sentiment":"positive","source":"Yahoo","summary":"J&J plans to maintain its quarterly dividend even after separating its Kenvue business. It didn't have to do that to keep its status as a Dividend Aristocrat.","symbol":"JNJ","url":"https://finnhub.io/api/news?id=b4acf705cabaca34bd43dbc17fb6d19691d7e5f3e1db072a4a1a9bd8668b7938"},{"_deepnote_index_column":87,"analysis":"Johnson & Johnson (JNJ) Stock Sinks As Market Gains: What You Should Know In the latest trading session, Johnson & Johnson (JNJ) closed at $160.48, marking a -0.74% move from the previous day.","category":"company","company":"Johnson & Johnson","datetime":"2023-09-01 21:45:15","headline":"Johnson & Johnson (JNJ) Stock Sinks As Market Gains: What You Should Know","id":122386014,"image":"https://media.zenfs.com/en/zacks.com/3cb5117fc22f5e37890d1860dcd61f9f","related":"JNJ","sentiment":"neutral","source":"Yahoo","summary":"In the latest trading session, Johnson & Johnson (JNJ) closed at $160.48, marking a -0.74% move from the previous day.","symbol":"JNJ","url":"https://finnhub.io/api/news?id=eb63598bedc4ebf6035ce56a047a6f38ddf4a2a2e0b022438382ed18e97646b8"},{"_deepnote_index_column":88,"analysis":"Novartis sues US government over Medicare drug price regulation Swiss drugmaker Novartis on Friday said it had sued the U.S. government in an attempt to halt the Medicare drug-price negotiation program, which includes its top-selling heart-failure medicine Entresto.  The lawsuit, filed in federal court in New Jersey, is the first since the Biden administration on Tuesday released its list of 10 prescription medicines that will be subject to price negotiations by the Medicare health program, which covers 66 million people.  Other drugs selected were Bristol Myers Squibb and Pfizer’s blood thinner Eliquis, Merck's diabetes drug Januvia, and Eliquis rival Xarelto from Johnson & Johnson .","category":"company","company":"Johnson & Johnson","datetime":"2023-09-01 20:13:30","headline":"Novartis sues US government over Medicare drug price regulation","id":122375928,"image":"https://s.yimg.com/cv/apiv2/social/images/yahoo_default_logo-1200x1200.png","related":"JNJ","sentiment":"neutral","source":"Yahoo","summary":"Swiss drugmaker Novartis on Friday said it had sued the U.S. government in an attempt to halt the Medicare drug-price negotiation program, which includes its top-selling heart-failure medicine Entresto.  The lawsuit, filed in federal court in New Jersey, is the first since the Biden administration on Tuesday released its list of 10 prescription medicines that will be subject to price negotiations by the Medicare health program, which covers 66 million people.  Other drugs selected were Bristol Myers Squibb and Pfizer’s blood thinner Eliquis, Merck's diabetes drug Januvia, and Eliquis rival Xarelto from Johnson & Johnson .","symbol":"JNJ","url":"https://finnhub.io/api/news?id=1277c5fd6018f5713eb340ec75f1d22dc33b2dedfa5bb9f09248ba0b0fc72fd0"},{"_deepnote_index_column":89,"analysis":"CDC: Dividend ETF With Unconventional Market Timing VictoryShares US EQ Income Enhanced Volatility Wtd is a defensive ETF with unconventional market timing and lower risk in drawdowns. Learn more about CDC here.","category":"company","company":"Johnson & Johnson","datetime":"2023-09-01 14:48:52","headline":"CDC: Dividend ETF With Unconventional Market Timing","id":122372218,"image":"https://static.seekingalpha.com/cdn/s3/uploads/getty_images/1427671653/image_1427671653.jpg?io=getty-c-w1536","related":"JNJ","sentiment":"positive","source":"SeekingAlpha","summary":"VictoryShares US EQ Income Enhanced Volatility Wtd is a defensive ETF with unconventional market timing and lower risk in drawdowns. Learn more about CDC here.","symbol":"JNJ","url":"https://finnhub.io/api/news?id=5f8f7e89d18cf8dd0844f89909ac1c494d8d86dc04b8f6113d3cf0fad1e9f456"},{"_deepnote_index_column":90,"analysis":"7 Cash Cow Stocks for Recession-Resilient Dividends Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","category":"company","company":"Johnson & Johnson","datetime":"2023-09-01 11:55:00","headline":"7 Cash Cow Stocks for Recession-Resilient Dividends","id":122369575,"image":"","related":"JNJ","sentiment":"positive","source":"InvestorPlace","summary":"Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","symbol":"JNJ","url":"https://finnhub.io/api/news?id=710d269d11539fda439f20244a33f820335abb9dcc8859082e4d5f6857de8abd"},{"_deepnote_index_column":91,"analysis":"As Medicare drug-price negotiations inch forward, some states are flexing new powers to cut costs for a broader swath of drugs  States like Colorado are looking to set upper payment limits on certain drugs as soon as next year.","category":"company","company":"Johnson & Johnson","datetime":"2023-09-01 11:30:00","headline":"As Medicare drug-price negotiations inch forward, some states are flexing new powers to cut costs for a broader swath of drugs ","id":122397222,"image":"https://images.mktw.net/im-837664/social","related":"JNJ","sentiment":"negative","source":"MarketWatch","summary":"States like Colorado are looking to set upper payment limits on certain drugs as soon as next year.","symbol":"JNJ","url":"https://finnhub.io/api/news?id=feceb1f3bf932674cd1f735bf1e4a9f53e33611146a2829583a11dcdad567f4b"},{"_deepnote_index_column":92,"analysis":"As Medicare drug-price negotiations inch forward, some states are flexing new powers to cut costs for a broader swath of drugs Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","category":"company","company":"Johnson & Johnson","datetime":"2023-09-01 10:33:00","headline":"As Medicare drug-price negotiations inch forward, some states are flexing new powers to cut costs for a broader swath of drugs","id":122373668,"image":"","related":"JNJ","sentiment":"positive","source":"MarketWatch","summary":"Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","symbol":"JNJ","url":"https://finnhub.io/api/news?id=327a1fe720bdda25ee08dc8f66c784a9f022d2556b5bde8061e441b5cff96468"},{"_deepnote_index_column":93,"analysis":"EU regulators warn pregnant women not to use topiramate Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","category":"company","company":"Johnson & Johnson","datetime":"2023-09-01 09:51:00","headline":"EU regulators warn pregnant women not to use topiramate","id":122376729,"image":"","related":"JNJ","sentiment":"positive","source":"Seeking Alpha","summary":"Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","symbol":"JNJ","url":"https://finnhub.io/api/news?id=a7df6a00d844421bc1b45aa69d4f9b5d2445561ac76cec95cd337a8c0f8cb178"},{"_deepnote_index_column":94,"analysis":"GLOBAL BROKER RATINGS: UBS cuts Volkswagen and Renault to 'sell' Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","category":"company","company":"Johnson & Johnson","datetime":"2023-09-01 07:08:00","headline":"GLOBAL BROKER RATINGS: UBS cuts Volkswagen and Renault to 'sell'","id":122365530,"image":"","related":"JNJ","sentiment":"positive","source":"Alliance News","summary":"Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","symbol":"JNJ","url":"https://finnhub.io/api/news?id=d9b02927682ba1c608634c6387545f6bb5f1315e8ba5dd28f95313722ac81b67"},{"_deepnote_index_column":95,"analysis":"Johnson & Johnson stock falls Friday, underperforms market Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","category":"company","company":"Johnson & Johnson","datetime":"2023-09-01 03:33:00","headline":"Johnson & Johnson stock falls Friday, underperforms market","id":122381199,"image":"","related":"JNJ","sentiment":"neutral","source":"MarketWatch","summary":"Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","symbol":"JNJ","url":"https://finnhub.io/api/news?id=c05a40d37e87b0348e5ca2507b29506f3d0d7d76fbaac602a29e692943ac5997"},{"_deepnote_index_column":96,"analysis":"10 Best September Dividend Stocks To Buy In this article, we discuss 10 best September dividend stocks to buy. You can skip our detailed analysis of dividend stocks and dividend capture strategy, and go directly to read 5 Best September Dividend Stocks To Buy. Dividend investing is a popular way to increase your earnings and generate income through investments. While it might […]","category":"company","company":"Johnson & Johnson","datetime":"2023-09-01 03:10:10","headline":"10 Best September Dividend Stocks To Buy","id":122353700,"image":"https://media.zenfs.com/en/insidermonkey.com/3245b2d901e1e3872d975604e16b2820","related":"JNJ","sentiment":"positive","source":"Yahoo","summary":"In this article, we discuss 10 best September dividend stocks to buy. You can skip our detailed analysis of dividend stocks and dividend capture strategy, and go directly to read 5 Best September Dividend Stocks To Buy. Dividend investing is a popular way to increase your earnings and generate income through investments. While it might […]","symbol":"JNJ","url":"https://finnhub.io/api/news?id=b693bf211fe810b7632c0b6dbd5791c84e3c105aa8e4200abd64f53dd0b61e41"},{"_deepnote_index_column":97,"analysis":"Pete Davidson Reveals He's Tried Ketamine To Cope With Depression Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","category":"company","company":"Johnson & Johnson","datetime":"2023-09-01 02:59:00","headline":"Pete Davidson Reveals He's Tried Ketamine To Cope With Depression","id":122381200,"image":"","related":"JNJ","sentiment":"positive","source":"Benzinga","summary":"Looking for stock market analysis and research with proves results? Zacks.com offers in-depth financial research with over 30years of proven results.","symbol":"JNJ","url":"https://finnhub.io/api/news?id=e945061956bb8933aba99dc14458e662a54cd9aaa3f8f5bebca49b4a4cbc0f2d"},{"_deepnote_index_column":98,"analysis":"Kroger Queen City Championship Presented by P&G Returns to Cincinnati Uplifting Women in Sports, Business and Education The Kroger Co. (NYSE: KR) and The Procter and Gamble Company (NYSE:PG) today shared new details on their continued efforts to uplift women in sports, business and education through their innovative Game Changers program established in conjunction the LPGA Kroger Queen City Championship presented by P&G.","category":"company","company":"Procter & Gamble","datetime":"2023-09-01 17:30:00","headline":"Kroger Queen City Championship Presented by P&G Returns to Cincinnati Uplifting Women in Sports, Business and Education","id":122374342,"image":"https://media.zenfs.com/en/prnewswire.com/12bfd504092dd753de291bac4b5ef505","related":"PG","sentiment":"negative","source":"Yahoo","summary":"The Kroger Co. (NYSE: KR) and The Procter and Gamble Company (NYSE:PG) today shared new details on their continued efforts to uplift women in sports, business and education through their innovative Game Changers program established in conjunction the LPGA Kroger Queen City Championship presented by P&G.","symbol":"PG","url":"https://finnhub.io/api/news?id=e1f6a06d892ad2c19942aa94a103e7579aae5192a475b4301247d2efcd2f1de5"},{"_deepnote_index_column":99,"analysis":"Procter & Gamble Co. stock rises Friday, still underperforms market Shares of Procter & Gamble Co. inched 0.11% higher to $154.51 Friday, on what proved to be an all-around favorable trading session for the stock market, with...","category":"company","company":"Procter & Gamble","datetime":"2023-09-01 16:34:00","headline":"Procter & Gamble Co. stock rises Friday, still underperforms market","id":122398171,"image":"https://images.mktw.net/im-220105/social","related":"PG","sentiment":"negative","source":"MarketWatch","summary":"Shares of Procter & Gamble Co. inched 0.11% higher to $154.51 Friday, on what proved to be an all-around favorable trading session for the stock market, with...","symbol":"PG","url":"https://finnhub.io/api/news?id=df1e338ef23479ae645580c35180f277c2e381673a5c7236db29e04622cdb8d3"}]},"text/html":["<div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>category</th>\n","      <th>datetime</th>\n","      <th>headline</th>\n","      <th>id</th>\n","      <th>image</th>\n","      <th>related</th>\n","      <th>source</th>\n","      <th>summary</th>\n","      <th>url</th>\n","      <th>company</th>\n","      <th>symbol</th>\n","      <th>analysis</th>\n","      <th>sentiment</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>company</td>\n","      <td>2023-09-01 23:13:08</td>\n","      <td>Exclusive-Arm signs up big tech firms for IPO ...</td>\n","      <td>122382404</td>\n","      <td>https://media.zenfs.com/en/reuters-finance.com...</td>\n","      <td>AAPL</td>\n","      <td>Yahoo</td>\n","      <td>NEW YORK (Reuters) -Customers of Arm Holdings ...</td>\n","      <td>https://finnhub.io/api/news?id=4cd8bf8f9821bfe...</td>\n","      <td>Apple</td>\n","      <td>AAPL</td>\n","      <td>Exclusive-Arm signs up big tech firms for IPO ...</td>\n","      <td>negative</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>company</td>\n","      <td>2023-09-01 23:08:56</td>\n","      <td>SoftBank Lines Up Apple, Nvidia as Strategic A...</td>\n","      <td>122382018</td>\n","      <td>https://s.yimg.com/ny/api/res/1.2/HorrfiXzXAyV...</td>\n","      <td>AAPL</td>\n","      <td>Yahoo</td>\n","      <td>(Bloomberg) -- SoftBank Group Corp. has lined ...</td>\n","      <td>https://finnhub.io/api/news?id=376135bb5ff5d10...</td>\n","      <td>Apple</td>\n","      <td>AAPL</td>\n","      <td>SoftBank Lines Up Apple, Nvidia as Strategic A...</td>\n","      <td>positive</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>company</td>\n","      <td>2023-09-01 22:00:37</td>\n","      <td>Tech suppliers in China skip seasonal hiring r...</td>\n","      <td>122385415</td>\n","      <td>https://s.yimg.com/cv/apiv2/social/images/yaho...</td>\n","      <td>AAPL</td>\n","      <td>Yahoo</td>\n","      <td>The Amazon supplier has not had to make any sp...</td>\n","      <td>https://finnhub.io/api/news?id=ef6e62f55088bc3...</td>\n","      <td>Apple</td>\n","      <td>AAPL</td>\n","      <td>Tech suppliers in China skip seasonal hiring r...</td>\n","      <td>neutral</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>company</td>\n","      <td>2023-09-01 21:45:17</td>\n","      <td>Apple (AAPL) Outpaces Stock Market Gains: What...</td>\n","      <td>122385416</td>\n","      <td>https://media.zenfs.com/en/zacks.com/3496571a8...</td>\n","      <td>AAPL</td>\n","      <td>Yahoo</td>\n","      <td>Apple (AAPL) closed at $189.46 in the latest t...</td>\n","      <td>https://finnhub.io/api/news?id=ea85159d6abc081...</td>\n","      <td>Apple</td>\n","      <td>AAPL</td>\n","      <td>Apple (AAPL) Outpaces Stock Market Gains: What...</td>\n","      <td>negative</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>company</td>\n","      <td>2023-09-01 21:36:00</td>\n","      <td>Globalstar Satellites Could Score for Small De...</td>\n","      <td>122378763</td>\n","      <td>https://s.yimg.com/ny/api/res/1.2/fcqof7cpXY5H...</td>\n","      <td>AAPL</td>\n","      <td>Yahoo</td>\n","      <td>Moves in the satellite company's share price p...</td>\n","      <td>https://finnhub.io/api/news?id=780b55e2afd6e44...</td>\n","      <td>Apple</td>\n","      <td>AAPL</td>\n","      <td>Globalstar Satellites Could Score for Small De...</td>\n","      <td>negative</td>\n","    </tr>\n","    <tr>\n","      <th>...</th>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","    </tr>\n","    <tr>\n","      <th>469</th>\n","      <td>company</td>\n","      <td>2023-09-01 08:22:00</td>\n","      <td>Horizon Therapeutics gains after FTC settles w...</td>\n","      <td>122368387</td>\n","      <td></td>\n","      <td>PFE</td>\n","      <td>Seeking Alpha</td>\n","      <td>Looking for stock market analysis and research...</td>\n","      <td>https://finnhub.io/api/news?id=e45fd97f6120653...</td>\n","      <td>Pfizer</td>\n","      <td>PFE</td>\n","      <td>Horizon Therapeutics gains after FTC settles w...</td>\n","      <td>positive</td>\n","    </tr>\n","    <tr>\n","      <th>470</th>\n","      <td>company</td>\n","      <td>2023-09-01 07:59:00</td>\n","      <td>Horizon Therapeutics gains amid reports FTC se...</td>\n","      <td>122368388</td>\n","      <td></td>\n","      <td>PFE</td>\n","      <td>Seeking Alpha</td>\n","      <td>Looking for stock market analysis and research...</td>\n","      <td>https://finnhub.io/api/news?id=eb8ebe3b7547b3c...</td>\n","      <td>Pfizer</td>\n","      <td>PFE</td>\n","      <td>Horizon Therapeutics gains amid reports FTC se...</td>\n","      <td>negative</td>\n","    </tr>\n","    <tr>\n","      <th>471</th>\n","      <td>company</td>\n","      <td>2023-09-01 07:46:02</td>\n","      <td>EU authorises use of adapted Pfizer/BioNtech v...</td>\n","      <td>122357955</td>\n","      <td>https://s.yimg.com/cv/apiv2/social/images/yaho...</td>\n","      <td>PFE</td>\n","      <td>Yahoo</td>\n","      <td>The European Commission has authorised an upda...</td>\n","      <td>https://finnhub.io/api/news?id=88a5a0a9076c24e...</td>\n","      <td>Pfizer</td>\n","      <td>PFE</td>\n","      <td>EU authorises use of adapted Pfizer/BioNtech v...</td>\n","      <td>positive</td>\n","    </tr>\n","    <tr>\n","      <th>472</th>\n","      <td>company</td>\n","      <td>2023-09-01 05:59:00</td>\n","      <td>Pfizer, BioNTech granted EU nod for new Omicro...</td>\n","      <td>122377748</td>\n","      <td></td>\n","      <td>PFE</td>\n","      <td>Seeking Alpha</td>\n","      <td>Looking for stock market analysis and research...</td>\n","      <td>https://finnhub.io/api/news?id=700f854610d9880...</td>\n","      <td>Pfizer</td>\n","      <td>PFE</td>\n","      <td>Pfizer, BioNTech granted EU nod for new Omicro...</td>\n","      <td>positive</td>\n","    </tr>\n","    <tr>\n","      <th>473</th>\n","      <td>company</td>\n","      <td>2023-09-01 01:00:00</td>\n","      <td>Noteworthy Friday Option Activity: PFE, C, GOOG</td>\n","      <td>122380060</td>\n","      <td></td>\n","      <td>PFE</td>\n","      <td>Stock Options Channel</td>\n","      <td>Looking for stock market analysis and research...</td>\n","      <td>https://finnhub.io/api/news?id=57d1995f05d1154...</td>\n","      <td>Pfizer</td>\n","      <td>PFE</td>\n","      <td>Noteworthy Friday Option Activity: PFE, C, GOO...</td>\n","      <td>positive</td>\n","    </tr>\n","  </tbody>\n","</table>\n","<p>474 rows × 13 columns</p>\n","</div>"],"text/plain":["    category            datetime  \\\n","0    company 2023-09-01 23:13:08   \n","1    company 2023-09-01 23:08:56   \n","2    company 2023-09-01 22:00:37   \n","3    company 2023-09-01 21:45:17   \n","4    company 2023-09-01 21:36:00   \n","..       ...                 ...   \n","469  company 2023-09-01 08:22:00   \n","470  company 2023-09-01 07:59:00   \n","471  company 2023-09-01 07:46:02   \n","472  company 2023-09-01 05:59:00   \n","473  company 2023-09-01 01:00:00   \n","\n","                                              headline         id  \\\n","0    Exclusive-Arm signs up big tech firms for IPO ...  122382404   \n","1    SoftBank Lines Up Apple, Nvidia as Strategic A...  122382018   \n","2    Tech suppliers in China skip seasonal hiring r...  122385415   \n","3    Apple (AAPL) Outpaces Stock Market Gains: What...  122385416   \n","4    Globalstar Satellites Could Score for Small De...  122378763   \n","..                                                 ...        ...   \n","469  Horizon Therapeutics gains after FTC settles w...  122368387   \n","470  Horizon Therapeutics gains amid reports FTC se...  122368388   \n","471  EU authorises use of adapted Pfizer/BioNtech v...  122357955   \n","472  Pfizer, BioNTech granted EU nod for new Omicro...  122377748   \n","473    Noteworthy Friday Option Activity: PFE, C, GOOG  122380060   \n","\n","                                                 image related  \\\n","0    https://media.zenfs.com/en/reuters-finance.com...    AAPL   \n","1    https://s.yimg.com/ny/api/res/1.2/HorrfiXzXAyV...    AAPL   \n","2    https://s.yimg.com/cv/apiv2/social/images/yaho...    AAPL   \n","3    https://media.zenfs.com/en/zacks.com/3496571a8...    AAPL   \n","4    https://s.yimg.com/ny/api/res/1.2/fcqof7cpXY5H...    AAPL   \n","..                                                 ...     ...   \n","469                                                        PFE   \n","470                                                        PFE   \n","471  https://s.yimg.com/cv/apiv2/social/images/yaho...     PFE   \n","472                                                        PFE   \n","473                                                        PFE   \n","\n","                    source                                            summary  \\\n","0                    Yahoo  NEW YORK (Reuters) -Customers of Arm Holdings ...   \n","1                    Yahoo  (Bloomberg) -- SoftBank Group Corp. has lined ...   \n","2                    Yahoo  The Amazon supplier has not had to make any sp...   \n","3                    Yahoo  Apple (AAPL) closed at $189.46 in the latest t...   \n","4                    Yahoo  Moves in the satellite company's share price p...   \n","..                     ...                                                ...   \n","469          Seeking Alpha  Looking for stock market analysis and research...   \n","470          Seeking Alpha  Looking for stock market analysis and research...   \n","471                  Yahoo  The European Commission has authorised an upda...   \n","472          Seeking Alpha  Looking for stock market analysis and research...   \n","473  Stock Options Channel  Looking for stock market analysis and research...   \n","\n","                                                   url company symbol  \\\n","0    https://finnhub.io/api/news?id=4cd8bf8f9821bfe...   Apple   AAPL   \n","1    https://finnhub.io/api/news?id=376135bb5ff5d10...   Apple   AAPL   \n","2    https://finnhub.io/api/news?id=ef6e62f55088bc3...   Apple   AAPL   \n","3    https://finnhub.io/api/news?id=ea85159d6abc081...   Apple   AAPL   \n","4    https://finnhub.io/api/news?id=780b55e2afd6e44...   Apple   AAPL   \n","..                                                 ...     ...    ...   \n","469  https://finnhub.io/api/news?id=e45fd97f6120653...  Pfizer    PFE   \n","470  https://finnhub.io/api/news?id=eb8ebe3b7547b3c...  Pfizer    PFE   \n","471  https://finnhub.io/api/news?id=88a5a0a9076c24e...  Pfizer    PFE   \n","472  https://finnhub.io/api/news?id=700f854610d9880...  Pfizer    PFE   \n","473  https://finnhub.io/api/news?id=57d1995f05d1154...  Pfizer    PFE   \n","\n","                                              analysis sentiment  \n","0    Exclusive-Arm signs up big tech firms for IPO ...  negative  \n","1    SoftBank Lines Up Apple, Nvidia as Strategic A...  positive  \n","2    Tech suppliers in China skip seasonal hiring r...   neutral  \n","3    Apple (AAPL) Outpaces Stock Market Gains: What...  negative  \n","4    Globalstar Satellites Could Score for Small De...  negative  \n","..                                                 ...       ...  \n","469  Horizon Therapeutics gains after FTC settles w...  positive  \n","470  Horizon Therapeutics gains amid reports FTC se...  negative  \n","471  EU authorises use of adapted Pfizer/BioNtech v...  positive  \n","472  Pfizer, BioNTech granted EU nod for new Omicro...  positive  \n","473  Noteworthy Friday Option Activity: PFE, C, GOO...  positive  \n","\n","[474 rows x 13 columns]"]},"metadata":{},"output_type":"display_data"}],"source":["display(df_headlines)"]},{"cell_type":"code","execution_count":null,"metadata":{"cell_id":"c24a34468832480ea20b8dbb81d94391","deepnote_app_block_visible":true,"deepnote_app_coordinates":{"h":5,"w":12,"x":0,"y":0},"deepnote_cell_type":"code","deepnote_to_be_reexecuted":false,"execution_millis":19,"execution_start":1696524828460,"source_hash":null},"outputs":[],"source":["# Convert 'datetime' to date\n","df_headlines['date'] = pd.to_datetime(df_headlines['datetime'], unit='s').dt.date\n","\n","# Group by 'company' and 'date', then count sentiment occurrences\n","grouped_df = df_headlines.groupby(['company', 'date', 'sentiment']).size().reset_index(name='count')\n","\n","# Initialize an empty DataFrame to store final results\n","result_df = pd.DataFrame()\n","\n","# Loop through unique companies and dates\n","for name, group in grouped_df.groupby(['company', 'date']):\n","    company, date = name\n","    total_count = group['count'].sum()\n","    \n","    # Calculate sentiment score\n","    sentiment_score = \"\"\n","    for idx, row in group.iterrows():\n","        if row['count'] / total_count > 0.5:\n","            sentiment_score = row['sentiment']\n","            break\n","    if not sentiment_score:\n","        sentiment_score = \"neutral\"\n","    \n","    # Append to result DataFrame\n","    result_df = result_df.append({'company': company, 'date': date, 'sentiment_score': sentiment_score}, ignore_index=True)"]},{"cell_type":"code","execution_count":null,"metadata":{"cell_id":"dfe10ac2b2ce403db109516d9024ebca","deepnote_app_block_visible":true,"deepnote_app_coordinates":{"h":5,"w":12,"x":0,"y":0},"deepnote_cell_type":"code","deepnote_to_be_reexecuted":false,"execution_millis":252,"execution_start":1696522216478,"source_hash":null},"outputs":[{"data":{"application/vnd.deepnote.dataframe.v3+json":{"column_count":3,"columns":[{"dtype":"object","name":"company","stats":{"categories":[{"count":1,"name":"3M"},{"count":1,"name":"Amgen"},{"count":28,"name":"28 others"}],"nan_count":0,"unique_count":30}},{"dtype":"object","name":"date","stats":{"categories":[{"count":30,"name":"2023-09-01"}],"nan_count":0,"unique_count":1}},{"dtype":"object","name":"sentiment_score","stats":{"categories":[{"count":16,"name":"positive"},{"count":11,"name":"neutral"},{"count":3,"name":"negative"}],"nan_count":0,"unique_count":3}},{"dtype":"int64","name":"_deepnote_index_column"}],"row_count":30,"rows":[{"_deepnote_index_column":0,"company":"3M","date":"2023-09-01","sentiment_score":"positive"},{"_deepnote_index_column":1,"company":"Amgen","date":"2023-09-01","sentiment_score":"positive"},{"_deepnote_index_column":2,"company":"Apple","date":"2023-09-01","sentiment_score":"positive"},{"_deepnote_index_column":3,"company":"Boeing","date":"2023-09-01","sentiment_score":"neutral"},{"_deepnote_index_column":4,"company":"Caterpillar","date":"2023-09-01","sentiment_score":"negative"},{"_deepnote_index_column":5,"company":"Chevron","date":"2023-09-01","sentiment_score":"neutral"},{"_deepnote_index_column":6,"company":"Cisco","date":"2023-09-01","sentiment_score":"positive"},{"_deepnote_index_column":7,"company":"Coca-Cola","date":"2023-09-01","sentiment_score":"positive"},{"_deepnote_index_column":8,"company":"Disney","date":"2023-09-01","sentiment_score":"neutral"},{"_deepnote_index_column":9,"company":"Dow Chemical","date":"2023-09-01","sentiment_score":"neutral"}]},"text/html":["<div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>company</th>\n","      <th>date</th>\n","      <th>sentiment_score</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>3M</td>\n","      <td>2023-09-01</td>\n","      <td>positive</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>Amgen</td>\n","      <td>2023-09-01</td>\n","      <td>positive</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>Apple</td>\n","      <td>2023-09-01</td>\n","      <td>positive</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>Boeing</td>\n","      <td>2023-09-01</td>\n","      <td>neutral</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>Caterpillar</td>\n","      <td>2023-09-01</td>\n","      <td>negative</td>\n","    </tr>\n","    <tr>\n","      <th>5</th>\n","      <td>Chevron</td>\n","      <td>2023-09-01</td>\n","      <td>neutral</td>\n","    </tr>\n","    <tr>\n","      <th>6</th>\n","      <td>Cisco</td>\n","      <td>2023-09-01</td>\n","      <td>positive</td>\n","    </tr>\n","    <tr>\n","      <th>7</th>\n","      <td>Coca-Cola</td>\n","      <td>2023-09-01</td>\n","      <td>positive</td>\n","    </tr>\n","    <tr>\n","      <th>8</th>\n","      <td>Disney</td>\n","      <td>2023-09-01</td>\n","      <td>neutral</td>\n","    </tr>\n","    <tr>\n","      <th>9</th>\n","      <td>Dow Chemical</td>\n","      <td>2023-09-01</td>\n","      <td>neutral</td>\n","    </tr>\n","    <tr>\n","      <th>10</th>\n","      <td>Exxon Mobil</td>\n","      <td>2023-09-01</td>\n","      <td>neutral</td>\n","    </tr>\n","    <tr>\n","      <th>11</th>\n","      <td>Goldman Sachs</td>\n","      <td>2023-09-01</td>\n","      <td>positive</td>\n","    </tr>\n","    <tr>\n","      <th>12</th>\n","      <td>Home Depot</td>\n","      <td>2023-09-01</td>\n","      <td>neutral</td>\n","    </tr>\n","    <tr>\n","      <th>13</th>\n","      <td>IBM</td>\n","      <td>2023-09-01</td>\n","      <td>positive</td>\n","    </tr>\n","    <tr>\n","      <th>14</th>\n","      <td>Intel</td>\n","      <td>2023-09-01</td>\n","      <td>positive</td>\n","    </tr>\n","    <tr>\n","      <th>15</th>\n","      <td>JPMorgan Chase</td>\n","      <td>2023-09-01</td>\n","      <td>positive</td>\n","    </tr>\n","    <tr>\n","      <th>16</th>\n","      <td>Johnson &amp; Johnson</td>\n","      <td>2023-09-01</td>\n","      <td>positive</td>\n","    </tr>\n","    <tr>\n","      <th>17</th>\n","      <td>McDonalds</td>\n","      <td>2023-09-01</td>\n","      <td>positive</td>\n","    </tr>\n","    <tr>\n","      <th>18</th>\n","      <td>Merck</td>\n","      <td>2023-09-01</td>\n","      <td>neutral</td>\n","    </tr>\n","    <tr>\n","      <th>19</th>\n","      <td>Microsoft</td>\n","      <td>2023-09-01</td>\n","      <td>positive</td>\n","    </tr>\n","    <tr>\n","      <th>20</th>\n","      <td>Nike</td>\n","      <td>2023-09-01</td>\n","      <td>positive</td>\n","    </tr>\n","    <tr>\n","      <th>21</th>\n","      <td>Pfizer</td>\n","      <td>2023-09-01</td>\n","      <td>positive</td>\n","    </tr>\n","    <tr>\n","      <th>22</th>\n","      <td>Procter &amp; Gamble</td>\n","      <td>2023-09-01</td>\n","      <td>negative</td>\n","    </tr>\n","    <tr>\n","      <th>23</th>\n","      <td>Raytheon</td>\n","      <td>2023-09-01</td>\n","      <td>neutral</td>\n","    </tr>\n","    <tr>\n","      <th>24</th>\n","      <td>Salesforce</td>\n","      <td>2023-09-01</td>\n","      <td>positive</td>\n","    </tr>\n","    <tr>\n","      <th>25</th>\n","      <td>Travelers</td>\n","      <td>2023-09-01</td>\n","      <td>negative</td>\n","    </tr>\n","    <tr>\n","      <th>26</th>\n","      <td>UnitedHealth</td>\n","      <td>2023-09-01</td>\n","      <td>neutral</td>\n","    </tr>\n","    <tr>\n","      <th>27</th>\n","      <td>Verizon</td>\n","      <td>2023-09-01</td>\n","      <td>positive</td>\n","    </tr>\n","    <tr>\n","      <th>28</th>\n","      <td>Visa</td>\n","      <td>2023-09-01</td>\n","      <td>neutral</td>\n","    </tr>\n","    <tr>\n","      <th>29</th>\n","      <td>Walgreens</td>\n","      <td>2023-09-01</td>\n","      <td>neutral</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["              company        date sentiment_score\n","0                  3M  2023-09-01        positive\n","1               Amgen  2023-09-01        positive\n","2               Apple  2023-09-01        positive\n","3              Boeing  2023-09-01         neutral\n","4         Caterpillar  2023-09-01        negative\n","5             Chevron  2023-09-01         neutral\n","6               Cisco  2023-09-01        positive\n","7           Coca-Cola  2023-09-01        positive\n","8              Disney  2023-09-01         neutral\n","9        Dow Chemical  2023-09-01         neutral\n","10        Exxon Mobil  2023-09-01         neutral\n","11      Goldman Sachs  2023-09-01        positive\n","12         Home Depot  2023-09-01         neutral\n","13                IBM  2023-09-01        positive\n","14              Intel  2023-09-01        positive\n","15     JPMorgan Chase  2023-09-01        positive\n","16  Johnson & Johnson  2023-09-01        positive\n","17          McDonalds  2023-09-01        positive\n","18              Merck  2023-09-01         neutral\n","19          Microsoft  2023-09-01        positive\n","20               Nike  2023-09-01        positive\n","21             Pfizer  2023-09-01        positive\n","22   Procter & Gamble  2023-09-01        negative\n","23           Raytheon  2023-09-01         neutral\n","24         Salesforce  2023-09-01        positive\n","25          Travelers  2023-09-01        negative\n","26       UnitedHealth  2023-09-01         neutral\n","27            Verizon  2023-09-01        positive\n","28               Visa  2023-09-01         neutral\n","29          Walgreens  2023-09-01         neutral"]},"metadata":{},"output_type":"display_data"}],"source":["display(result_df)"]},{"cell_type":"markdown","metadata":{"cell_id":"3bec9e439fbc41f39f54d6e7a00d988f","deepnote_app_block_visible":true,"deepnote_app_coordinates":{"h":5,"w":12,"x":0,"y":0},"deepnote_cell_type":"markdown"},"source":["# Part 2: MACD Scoring"]},{"cell_type":"code","execution_count":null,"metadata":{"cell_id":"39d463997b0947e98e861aef67cfceb4","deepnote_app_block_visible":true,"deepnote_app_coordinates":{"h":5,"w":12,"x":0,"y":0},"deepnote_cell_type":"code","deepnote_to_be_reexecuted":false,"execution_millis":2360,"execution_start":1696524842263,"source_hash":null},"outputs":[{"data":{"application/vnd.deepnote.dataframe.v3+json":{"column_count":4,"columns":[{"dtype":"object","name":"company","stats":{"categories":[{"count":24,"name":"Apple"},{"count":24,"name":"Microsoft"},{"count":672,"name":"28 others"}],"nan_count":0,"unique_count":30}},{"dtype":"object","name":"symbol","stats":{"categories":[{"count":24,"name":"AAPL"},{"count":24,"name":"MSFT"},{"count":672,"name":"28 others"}],"nan_count":0,"unique_count":30}},{"dtype":"datetime64[ns]","name":"dates","stats":{"histogram":[{"bin_end":1691115840000000000,"bin_start":1690848000000000000,"count":120},{"bin_end":1691383680000000000,"bin_start":1691115840000000000,"count":30},{"bin_end":1691651520000000000,"bin_start":1691383680000000000,"count":90},{"bin_end":1691919360000000000,"bin_start":1691651520000000000,"count":30},{"bin_end":1692187200000000000,"bin_start":1691919360000000000,"count":90},{"bin_end":1692455040000000000,"bin_start":1692187200000000000,"count":60},{"bin_end":1692722880000000000,"bin_start":1692455040000000000,"count":60},{"bin_end":1692990720000000000,"bin_start":1692722880000000000,"count":90},{"bin_end":1693258560000000000,"bin_start":1692990720000000000,"count":30},{"bin_end":1693526400000000000,"bin_start":1693258560000000000,"count":120}],"max":"2023-09-01 00:00:00","min":"2023-08-01 00:00:00","nan_count":0,"unique_count":24}},{"dtype":"float64","name":"prices","stats":{"histogram":[{"bin_end":72.18,"bin_start":23.43,"count":168},{"bin_end":120.93,"bin_start":72.18,"count":144},{"bin_end":169.68,"bin_start":120.93,"count":129},{"bin_end":218.43,"bin_start":169.68,"count":60},{"bin_end":267.18,"bin_start":218.43,"count":75},{"bin_end":315.93,"bin_start":267.18,"count":48},{"bin_end":364.68,"bin_start":315.93,"count":72},{"bin_end":413.43,"bin_start":364.68,"count":0},{"bin_end":462.18,"bin_start":413.43,"count":0},{"bin_end":510.93,"bin_start":462.18,"count":24}],"max":"510.93","min":"23.43","nan_count":0,"unique_count":695}},{"dtype":"int64","name":"_deepnote_index_column"}],"row_count":720,"rows":[{"_deepnote_index_column":0,"company":"Apple","dates":"2023-08-01 00:00:00","prices":195.605,"symbol":"AAPL"},{"_deepnote_index_column":1,"company":"Apple","dates":"2023-08-02 00:00:00","prices":192.58,"symbol":"AAPL"},{"_deepnote_index_column":2,"company":"Apple","dates":"2023-08-03 00:00:00","prices":191.17,"symbol":"AAPL"},{"_deepnote_index_column":3,"company":"Apple","dates":"2023-08-04 00:00:00","prices":181.99,"symbol":"AAPL"},{"_deepnote_index_column":4,"company":"Apple","dates":"2023-08-07 00:00:00","prices":178.85,"symbol":"AAPL"},{"_deepnote_index_column":5,"company":"Apple","dates":"2023-08-08 00:00:00","prices":179.8,"symbol":"AAPL"},{"_deepnote_index_column":6,"company":"Apple","dates":"2023-08-09 00:00:00","prices":178.19,"symbol":"AAPL"},{"_deepnote_index_column":7,"company":"Apple","dates":"2023-08-10 00:00:00","prices":177.97,"symbol":"AAPL"},{"_deepnote_index_column":8,"company":"Apple","dates":"2023-08-11 00:00:00","prices":177.79,"symbol":"AAPL"},{"_deepnote_index_column":9,"company":"Apple","dates":"2023-08-14 00:00:00","prices":179.46,"symbol":"AAPL"}]},"text/html":["<div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>company</th>\n","      <th>symbol</th>\n","      <th>dates</th>\n","      <th>prices</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>Apple</td>\n","      <td>AAPL</td>\n","      <td>2023-08-01</td>\n","      <td>195.605</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>Apple</td>\n","      <td>AAPL</td>\n","      <td>2023-08-02</td>\n","      <td>192.580</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>Apple</td>\n","      <td>AAPL</td>\n","      <td>2023-08-03</td>\n","      <td>191.170</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>Apple</td>\n","      <td>AAPL</td>\n","      <td>2023-08-04</td>\n","      <td>181.990</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>Apple</td>\n","      <td>AAPL</td>\n","      <td>2023-08-07</td>\n","      <td>178.850</td>\n","    </tr>\n","    <tr>\n","      <th>...</th>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","    </tr>\n","    <tr>\n","      <th>715</th>\n","      <td>Pfizer</td>\n","      <td>PFE</td>\n","      <td>2023-08-28</td>\n","      <td>36.210</td>\n","    </tr>\n","    <tr>\n","      <th>716</th>\n","      <td>Pfizer</td>\n","      <td>PFE</td>\n","      <td>2023-08-29</td>\n","      <td>36.150</td>\n","    </tr>\n","    <tr>\n","      <th>717</th>\n","      <td>Pfizer</td>\n","      <td>PFE</td>\n","      <td>2023-08-30</td>\n","      <td>35.900</td>\n","    </tr>\n","    <tr>\n","      <th>718</th>\n","      <td>Pfizer</td>\n","      <td>PFE</td>\n","      <td>2023-08-31</td>\n","      <td>35.380</td>\n","    </tr>\n","    <tr>\n","      <th>719</th>\n","      <td>Pfizer</td>\n","      <td>PFE</td>\n","      <td>2023-09-01</td>\n","      <td>35.780</td>\n","    </tr>\n","  </tbody>\n","</table>\n","<p>720 rows × 4 columns</p>\n","</div>"],"text/plain":["    company symbol      dates   prices\n","0     Apple   AAPL 2023-08-01  195.605\n","1     Apple   AAPL 2023-08-02  192.580\n","2     Apple   AAPL 2023-08-03  191.170\n","3     Apple   AAPL 2023-08-04  181.990\n","4     Apple   AAPL 2023-08-07  178.850\n","..      ...    ...        ...      ...\n","715  Pfizer    PFE 2023-08-28   36.210\n","716  Pfizer    PFE 2023-08-29   36.150\n","717  Pfizer    PFE 2023-08-30   35.900\n","718  Pfizer    PFE 2023-08-31   35.380\n","719  Pfizer    PFE 2023-09-01   35.780\n","\n","[720 rows x 4 columns]"]},"metadata":{},"output_type":"display_data"}],"source":["import finnhub\n","import os\n","import time\n","from datetime import datetime, timezone\n","from datetime import date\n","from zoneinfo import ZoneInfo\n","import pandas as pd\n","import numpy as np\n","import seaborn as sns\n","import matplotlib.pyplot as plt\n","import sqlite3\n","\n","# Function to convert date string to Unix timestamp\n","def unix_timestamp_from_date(date_str, date_format=\"%Y-%m-%d\"):\n","    dt = datetime.strptime(date_str, date_format)\n","    unix_timestamp = dt.replace(tzinfo=timezone.utc).timestamp()\n","    return int(unix_timestamp)\n","\n","start_date = '2023-08-01'\n","#current_date =  '2023-09-01'\n","\n","# Convert to Unix timestamps\n","from_date = unix_timestamp_from_date(start_date)\n","to_date = unix_timestamp_from_date(current_date)\n","\n","\n","# DJIA Tickers and Companies\n","symbols = ['AAPL', 'MSFT', 'JNJ', 'PG', 'V', 'RTX', 'UNH', 'VZ', 'CSCO', 'KO', \n","        'DOW', 'TRV', 'JPM', 'INTC', 'WBA', 'CVX', 'CAT', 'MMM', 'GS', \n","        'NKE', 'HD', 'MRK', 'DIS', 'IBM', 'MCD', 'BA', 'AMGN', 'CRM', 'XOM', 'PFE']\n","\n","companies = ['Apple', 'Microsoft', 'Johnson & Johnson', 'Procter & Gamble', \n","            'Visa', 'Raytheon', 'UnitedHealth', 'Verizon', 'Cisco', 'Coca-Cola',\n","            'Dow Chemical', 'Travelers', 'JPMorgan Chase', 'Intel', 'Walgreens',\n","            'Chevron', 'Caterpillar', '3M', 'Goldman Sachs', 'Nike', 'Home Depot',\n","            'Merck', 'Disney', 'IBM', 'McDonalds', 'Boeing', 'Amgen', 'Salesforce',\n","            'Exxon Mobil', 'Pfizer']\n","\n","\n","# Set up client\n","finnhub_client = finnhub.Client(api_key='API_KEY')\n","df_list = []\n","resolution = 'D'\n","\n","# make request and print\n","for symbol, company in zip(symbols, companies):\n","    res = finnhub_client.stock_candles(\n","        symbol,\n","        resolution,\n","        from_date,\n","        to_date\n","      )\n","\n","# Ditch the status code\n","    try:\n","        res.pop('s')\n","    except KeyError as e:\n","        print(\"Already ditched status code\")\n","\n","    stock_data = res\n","    stock_df = pd.DataFrame(stock_data)\n","\n","    # Convert Unix timestamps to human-readable datetime\n","    stock_df['t'] = pd.to_datetime(stock_df['t'], unit='s')\n","\n","    # Add 'company' and 'symbol' columns\n","    stock_df['company'] = company\n","    stock_df['symbol'] = symbol\n","    stock_df['prices'] = stock_df.pop('c')\n","    stock_df['dates'] = stock_df.pop('t')\n","    \n","    # Keep only the columns we need\n","    stock_df = stock_df[['company', 'symbol', 'dates', 'prices']]\n","    \n","    # Add to list of DataFrames\n","    df_list.append(stock_df)\n","\n","    df_stock_data = pd.concat(df_list, ignore_index=True)\n","\n","display(df_stock_data)"]},{"cell_type":"code","execution_count":null,"metadata":{"cell_id":"c39133c2e82247eb999df8899a1afecd","deepnote_app_block_visible":true,"deepnote_app_coordinates":{"h":5,"w":12,"x":0,"y":0},"deepnote_cell_type":"code","deepnote_to_be_reexecuted":false,"execution_millis":246,"execution_start":1696524862837,"source_hash":null},"outputs":[{"data":{"application/vnd.deepnote.dataframe.v3+json":{"column_count":12,"columns":[{"dtype":"object","name":"company","stats":{"categories":[{"count":1,"name":"Apple"},{"count":1,"name":"Amgen"},{"count":28,"name":"28 others"}],"nan_count":0,"unique_count":30}},{"dtype":"object","name":"symbol","stats":{"categories":[{"count":1,"name":"AAPL"},{"count":1,"name":"AMGN"},{"count":28,"name":"28 others"}],"nan_count":0,"unique_count":30}},{"dtype":"datetime64[ns]","name":"dates","stats":{"histogram":null,"max":"2023-09-01 00:00:00","min":"2023-09-01 00:00:00","nan_count":0,"unique_count":1}},{"dtype":"float64","name":"prices","stats":{"histogram":[{"bin_end":68.711,"bin_start":23.43,"count":7},{"bin_end":113.99199999999999,"bin_start":68.711,"count":6},{"bin_end":159.273,"bin_start":113.99199999999999,"count":3},{"bin_end":204.554,"bin_start":159.273,"count":4},{"bin_end":249.835,"bin_start":204.554,"count":3},{"bin_end":295.116,"bin_start":249.835,"count":3},{"bin_end":340.397,"bin_start":295.116,"count":3},{"bin_end":385.678,"bin_start":340.397,"count":0},{"bin_end":430.959,"bin_start":385.678,"count":0},{"bin_end":476.24,"bin_start":430.959,"count":1}],"max":"476.24","min":"23.43","nan_count":0,"unique_count":30}},{"dtype":"float64","name":"Daily Return","stats":{"histogram":[{"bin_end":-0.06266778008471839,"bin_start":-0.07427894112998812,"count":1},{"bin_end":-0.05105661903944867,"bin_start":-0.06266778008471839,"count":0},{"bin_end":-0.03944545799417895,"bin_start":-0.05105661903944867,"count":0},{"bin_end":-0.027834296948909223,"bin_start":-0.03944545799417895,"count":0},{"bin_end":-0.016223135903639496,"bin_start":-0.027834296948909223,"count":1},{"bin_end":-0.004611974858369783,"bin_start":-0.016223135903639496,"count":2},{"bin_end":0.006999186186899944,"bin_start":-0.004611974858369783,"count":14},{"bin_end":0.01861034723216967,"bin_start":0.006999186186899944,"count":9},{"bin_end":0.0302215082774394,"bin_start":0.01861034723216967,"count":2},{"bin_end":0.041832669322709126,"bin_start":0.0302215082774394,"count":1}],"max":"0.041832669322709126","min":"-0.07427894112998812","nan_count":0,"unique_count":30}},{"dtype":"float64","name":"ShortEMA","stats":{"histogram":[{"bin_end":-0.014163989278808723,"bin_start":-0.017043605714969302,"count":1},{"bin_end":-0.011284372842648143,"bin_start":-0.014163989278808723,"count":0},{"bin_end":-0.008404756406487565,"bin_start":-0.011284372842648143,"count":0},{"bin_end":-0.0055251399703269855,"bin_start":-0.008404756406487565,"count":1},{"bin_end":-0.002645523534166406,"bin_start":-0.0055251399703269855,"count":3},{"bin_end":0.00023409290199417204,"bin_start":-0.002645523534166406,"count":7},{"bin_end":0.0031137093381547534,"bin_start":0.00023409290199417204,"count":7},{"bin_end":0.005993325774315331,"bin_start":0.0031137093381547534,"count":6},{"bin_end":0.00887294221047591,"bin_start":0.005993325774315331,"count":4},{"bin_end":0.011752558646636492,"bin_start":0.00887294221047591,"count":1}],"max":"0.011752558646636492","min":"-0.017043605714969302","nan_count":0,"unique_count":30}},{"dtype":"float64","name":"LongEMA","stats":{"histogram":[{"bin_end":-0.011302177375734447,"bin_start":-0.01322967359778482,"count":1},{"bin_end":-0.009374681153684075,"bin_start":-0.011302177375734447,"count":0},{"bin_end":-0.0074471849316337015,"bin_start":-0.009374681153684075,"count":0},{"bin_end":-0.005519688709583328,"bin_start":-0.0074471849316337015,"count":0},{"bin_end":-0.0035921924875329542,"bin_start":-0.005519688709583328,"count":3},{"bin_end":-0.0016646962654825823,"bin_start":-0.0035921924875329542,"count":4},{"bin_end":0.0002627999565677913,"bin_start":-0.0016646962654825823,"count":6},{"bin_end":0.002190296178618165,"bin_start":0.0002627999565677913,"count":6},{"bin_end":0.004117792400668537,"bin_start":0.002190296178618165,"count":8},{"bin_end":0.006045288622718911,"bin_start":0.004117792400668537,"count":2}],"max":"0.006045288622718911","min":"-0.01322967359778482","nan_count":0,"unique_count":30}},{"dtype":"float64","name":"MACD","stats":{"histogram":[{"bin_end":-0.002861811903074275,"bin_start":-0.0038139321171844816,"count":1},{"bin_end":-0.001909691688964069,"bin_start":-0.002861811903074275,"count":0},{"bin_end":-0.0009575714748538628,"bin_start":-0.001909691688964069,"count":4},{"bin_end":-0.000005451260743656334,"bin_start":-0.0009575714748538628,"count":5},{"bin_end":0.0009466689533665501,"bin_start":-0.000005451260743656334,"count":4},{"bin_end":0.001898789167476756,"bin_start":0.0009466689533665501,"count":8},{"bin_end":0.002850909381586963,"bin_start":0.001898789167476756,"count":4},{"bin_end":0.003803029595697169,"bin_start":0.002850909381586963,"count":3},{"bin_end":0.004755149809807376,"bin_start":0.003803029595697169,"count":0},{"bin_end":0.005707270023917581,"bin_start":0.004755149809807376,"count":1}],"max":"0.005707270023917581","min":"-0.0038139321171844816","nan_count":0,"unique_count":30}},{"dtype":"float64","name":"SignalLine","stats":{"histogram":[{"bin_end":-0.0016351869503808492,"bin_start":-0.0021541225828762708,"count":1},{"bin_end":-0.0011162513178854276,"bin_start":-0.0016351869503808492,"count":1},{"bin_end":-0.000597315685390006,"bin_start":-0.0011162513178854276,"count":3},{"bin_end":-0.0000783800528945844,"bin_start":-0.000597315685390006,"count":2},{"bin_end":0.00044055557960083697,"bin_start":-0.0000783800528945844,"count":4},{"bin_end":0.0009594912120962588,"bin_start":0.00044055557960083697,"count":11},{"bin_end":0.0014784268445916806,"bin_start":0.0009594912120962588,"count":2},{"bin_end":0.001997362477087102,"bin_start":0.0014784268445916806,"count":2},{"bin_end":0.0025162981095825233,"bin_start":0.001997362477087102,"count":0},{"bin_end":0.003035233742077945,"bin_start":0.0025162981095825233,"count":4}],"max":"0.003035233742077945","min":"-0.0021541225828762708","nan_count":0,"unique_count":30}},{"dtype":"float64","name":"MACD_Histogram","stats":{"histogram":[{"bin_end":-0.0022512216604307343,"bin_start":-0.0028378667176918873,"count":1},{"bin_end":-0.001664576603169581,"bin_start":-0.0022512216604307343,"count":0},{"bin_end":-0.0010779315459084277,"bin_start":-0.001664576603169581,"count":0},{"bin_end":-0.0004912864886472746,"bin_start":-0.0010779315459084277,"count":3},{"bin_end":0.00009535856861387845,"bin_start":-0.0004912864886472746,"count":8},{"bin_end":0.000682003625875032,"bin_start":0.00009535856861387845,"count":12},{"bin_end":0.0012686486831361846,"bin_start":0.000682003625875032,"count":3},{"bin_end":0.001855293740397338,"bin_start":0.0012686486831361846,"count":2},{"bin_end":0.0024419387976584916,"bin_start":0.001855293740397338,"count":0},{"bin_end":0.003028583854919644,"bin_start":0.0024419387976584916,"count":1}],"max":"0.003028583854919644","min":"-0.0028378667176918873","nan_count":0,"unique_count":30}},{"dtype":"float64","name":"Delta Histogram","stats":{"histogram":[{"bin_end":-7.672621076133213,"bin_start":-8.793524368664471,"count":2},{"bin_end":-6.551717783601954,"bin_start":-7.672621076133213,"count":0},{"bin_end":-5.430814491070695,"bin_start":-6.551717783601954,"count":0},{"bin_end":-4.309911198539437,"bin_start":-5.430814491070695,"count":1},{"bin_end":-3.189007906008179,"bin_start":-4.309911198539437,"count":2},{"bin_end":-2.06810461347692,"bin_start":-3.189007906008179,"count":0},{"bin_end":-0.9472013209456609,"bin_start":-2.06810461347692,"count":4},{"bin_end":0.1737019715855972,"bin_start":-0.9472013209456609,"count":11},{"bin_end":1.2946052641168553,"bin_start":0.1737019715855972,"count":8},{"bin_end":2.4155085566481143,"bin_start":1.2946052641168553,"count":2}],"max":"2.4155085566481143","min":"-8.793524368664471","nan_count":0,"unique_count":30}},{"dtype":"object","name":"stock_rec","stats":{"categories":[{"count":18,"name":"Sell"},{"count":12,"name":"Buy"}],"nan_count":0,"unique_count":2}},{"dtype":"int64","name":"_deepnote_index_column"}],"row_count":30,"rows":[{"Daily Return":0.00846329908979615,"Delta Histogram":-0.41467579055858506,"LongEMA":0.0030949209511439107,"MACD":0.0033723344973178716,"MACD_Histogram":0.0003371007552399265,"ShortEMA":0.006467255448461782,"SignalLine":0.003035233742077945,"_deepnote_index_column":23,"company":"Apple","dates":"2023-09-01 00:00:00","prices":189.46,"stock_rec":"Sell","symbol":"AAPL"},{"Daily Return":0.0014433954903643187,"Delta Histogram":2.4155085566481143,"LongEMA":0.0014662140957449176,"MACD":-0.001805121499230014,"MACD_Histogram":0.00034900108364625685,"ShortEMA":-0.0003389074034850963,"SignalLine":-0.0021541225828762708,"_deepnote_index_column":647,"company":"Amgen","dates":"2023-09-01 00:00:00","prices":256.71,"stock_rec":"Buy","symbol":"AMGN"},{"Daily Return":-0.0028121233763335196,"Delta Histogram":-0.15808104888530727,"LongEMA":-0.0025015999994145673,"MACD":-0.00003688125238262381,"MACD_Histogram":-0.00032148270782235677,"ShortEMA":-0.002538481251797191,"SignalLine":0.00028460145543973296,"_deepnote_index_column":623,"company":"Boeing","dates":"2023-09-01 00:00:00","prices":223.4,"stock_rec":"Sell","symbol":"BA"},{"Daily Return":0.01821221498950676,"Delta Histogram":1.1225459575342849,"LongEMA":0.002225003761327704,"MACD":0.0027415939234958675,"MACD_Histogram":0.0011574598728013232,"ShortEMA":0.004966597684823572,"SignalLine":0.0015841340506945443,"_deepnote_index_column":407,"company":"Caterpillar","dates":"2023-09-01 00:00:00","prices":286.25,"stock_rec":"Buy","symbol":"CAT"},{"Daily Return":0.0003160841686986604,"Delta Histogram":-0.5928807093773247,"LongEMA":0.0035054103036642344,"MACD":0.0034081695094032266,"MACD_Histogram":0.0007622571880554281,"ShortEMA":0.006913579813067461,"SignalLine":0.0026459123213477985,"_deepnote_index_column":671,"company":"Salesforce","dates":"2023-09-01 00:00:00","prices":221.53,"stock_rec":"Sell","symbol":"CRM"},{"Daily Return":0.008544027898866657,"Delta Histogram":0.24915229901181424,"LongEMA":0.005032280081352706,"MACD":0.0008488724662545624,"MACD_Histogram":0.00033786820692257116,"ShortEMA":0.005881152547607268,"SignalLine":0.0005110042593319912,"_deepnote_index_column":215,"company":"Cisco","dates":"2023-09-01 00:00:00","prices":57.84,"stock_rec":"Buy","symbol":"CSCO"},{"Daily Return":0.019863438857852467,"Delta Histogram":1.9894566389186035,"LongEMA":0.0021595262270144317,"MACD":0.001979404727678891,"MACD_Histogram":0.001305712603058996,"ShortEMA":0.0041389309546933225,"SignalLine":0.0006736921246198947,"_deepnote_index_column":383,"company":"Chevron","dates":"2023-09-01 00:00:00","prices":164.3,"stock_rec":"Buy","symbol":"CVX"},{"Daily Return":-0.02437858508604218,"Delta Histogram":-8.14286472761177,"LongEMA":-0.00460644472519052,"MACD":-0.0014137012262317008,"MACD_Histogram":-0.0010679189036935444,"ShortEMA":-0.006020145951422221,"SignalLine":-0.0003457823225381563,"_deepnote_index_column":551,"company":"Disney","dates":"2023-09-01 00:00:00","prices":81.64,"stock_rec":"Sell","symbol":"DIS"},{"Daily Return":0.013379765395894472,"Delta Histogram":-4.757585826440538,"LongEMA":0.0010658730375521159,"MACD":0.0014291283882231908,"MACD_Histogram":0.0005423987674564398,"ShortEMA":0.0024950014257753067,"SignalLine":0.000886729620766751,"_deepnote_index_column":263,"company":"Dow Chemical","dates":"2023-09-01 00:00:00","prices":55.29,"stock_rec":"Sell","symbol":"DOW"},{"Daily Return":-0.0009459583168045516,"Delta Histogram":-0.7519030954765538,"LongEMA":-0.0019749909244070906,"MACD":0.0016009877601382621,"MACD_Histogram":0.00007469856121804447,"ShortEMA":-0.0003740031642688285,"SignalLine":0.0015262891989202177,"_deepnote_index_column":455,"company":"Goldman Sachs","dates":"2023-09-01 00:00:00","prices":327.4,"stock_rec":"Sell","symbol":"GS"}]},"text/html":["<div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>company</th>\n","      <th>symbol</th>\n","      <th>dates</th>\n","      <th>prices</th>\n","      <th>Daily Return</th>\n","      <th>ShortEMA</th>\n","      <th>LongEMA</th>\n","      <th>MACD</th>\n","      <th>SignalLine</th>\n","      <th>MACD_Histogram</th>\n","      <th>Delta Histogram</th>\n","      <th>stock_rec</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>23</th>\n","      <td>Apple</td>\n","      <td>AAPL</td>\n","      <td>2023-09-01</td>\n","      <td>189.46</td>\n","      <td>0.008463</td>\n","      <td>0.006467</td>\n","      <td>0.003095</td>\n","      <td>0.003372</td>\n","      <td>0.003035</td>\n","      <td>0.000337</td>\n","      <td>-0.414676</td>\n","      <td>Sell</td>\n","    </tr>\n","    <tr>\n","      <th>647</th>\n","      <td>Amgen</td>\n","      <td>AMGN</td>\n","      <td>2023-09-01</td>\n","      <td>256.71</td>\n","      <td>0.001443</td>\n","      <td>-0.000339</td>\n","      <td>0.001466</td>\n","      <td>-0.001805</td>\n","      <td>-0.002154</td>\n","      <td>0.000349</td>\n","      <td>2.415509</td>\n","      <td>Buy</td>\n","    </tr>\n","    <tr>\n","      <th>623</th>\n","      <td>Boeing</td>\n","      <td>BA</td>\n","      <td>2023-09-01</td>\n","      <td>223.40</td>\n","      <td>-0.002812</td>\n","      <td>-0.002538</td>\n","      <td>-0.002502</td>\n","      <td>-0.000037</td>\n","      <td>0.000285</td>\n","      <td>-0.000321</td>\n","      <td>-0.158081</td>\n","      <td>Sell</td>\n","    </tr>\n","    <tr>\n","      <th>407</th>\n","      <td>Caterpillar</td>\n","      <td>CAT</td>\n","      <td>2023-09-01</td>\n","      <td>286.25</td>\n","      <td>0.018212</td>\n","      <td>0.004967</td>\n","      <td>0.002225</td>\n","      <td>0.002742</td>\n","      <td>0.001584</td>\n","      <td>0.001157</td>\n","      <td>1.122546</td>\n","      <td>Buy</td>\n","    </tr>\n","    <tr>\n","      <th>671</th>\n","      <td>Salesforce</td>\n","      <td>CRM</td>\n","      <td>2023-09-01</td>\n","      <td>221.53</td>\n","      <td>0.000316</td>\n","      <td>0.006914</td>\n","      <td>0.003505</td>\n","      <td>0.003408</td>\n","      <td>0.002646</td>\n","      <td>0.000762</td>\n","      <td>-0.592881</td>\n","      <td>Sell</td>\n","    </tr>\n","    <tr>\n","      <th>215</th>\n","      <td>Cisco</td>\n","      <td>CSCO</td>\n","      <td>2023-09-01</td>\n","      <td>57.84</td>\n","      <td>0.008544</td>\n","      <td>0.005881</td>\n","      <td>0.005032</td>\n","      <td>0.000849</td>\n","      <td>0.000511</td>\n","      <td>0.000338</td>\n","      <td>0.249152</td>\n","      <td>Buy</td>\n","    </tr>\n","    <tr>\n","      <th>383</th>\n","      <td>Chevron</td>\n","      <td>CVX</td>\n","      <td>2023-09-01</td>\n","      <td>164.30</td>\n","      <td>0.019863</td>\n","      <td>0.004139</td>\n","      <td>0.002160</td>\n","      <td>0.001979</td>\n","      <td>0.000674</td>\n","      <td>0.001306</td>\n","      <td>1.989457</td>\n","      <td>Buy</td>\n","    </tr>\n","    <tr>\n","      <th>551</th>\n","      <td>Disney</td>\n","      <td>DIS</td>\n","      <td>2023-09-01</td>\n","      <td>81.64</td>\n","      <td>-0.024379</td>\n","      <td>-0.006020</td>\n","      <td>-0.004606</td>\n","      <td>-0.001414</td>\n","      <td>-0.000346</td>\n","      <td>-0.001068</td>\n","      <td>-8.142865</td>\n","      <td>Sell</td>\n","    </tr>\n","    <tr>\n","      <th>263</th>\n","      <td>Dow Chemical</td>\n","      <td>DOW</td>\n","      <td>2023-09-01</td>\n","      <td>55.29</td>\n","      <td>0.013380</td>\n","      <td>0.002495</td>\n","      <td>0.001066</td>\n","      <td>0.001429</td>\n","      <td>0.000887</td>\n","      <td>0.000542</td>\n","      <td>-4.757586</td>\n","      <td>Sell</td>\n","    </tr>\n","    <tr>\n","      <th>455</th>\n","      <td>Goldman Sachs</td>\n","      <td>GS</td>\n","      <td>2023-09-01</td>\n","      <td>327.40</td>\n","      <td>-0.000946</td>\n","      <td>-0.000374</td>\n","      <td>-0.001975</td>\n","      <td>0.001601</td>\n","      <td>0.001526</td>\n","      <td>0.000075</td>\n","      <td>-0.751903</td>\n","      <td>Sell</td>\n","    </tr>\n","    <tr>\n","      <th>503</th>\n","      <td>Home Depot</td>\n","      <td>HD</td>\n","      <td>2023-09-01</td>\n","      <td>333.08</td>\n","      <td>0.008417</td>\n","      <td>0.002531</td>\n","      <td>0.001256</td>\n","      <td>0.001275</td>\n","      <td>0.000638</td>\n","      <td>0.000636</td>\n","      <td>0.588479</td>\n","      <td>Buy</td>\n","    </tr>\n","    <tr>\n","      <th>575</th>\n","      <td>IBM</td>\n","      <td>IBM</td>\n","      <td>2023-09-01</td>\n","      <td>147.94</td>\n","      <td>0.007560</td>\n","      <td>0.003462</td>\n","      <td>0.002454</td>\n","      <td>0.001008</td>\n","      <td>0.000840</td>\n","      <td>0.000168</td>\n","      <td>-4.152970</td>\n","      <td>Sell</td>\n","    </tr>\n","    <tr>\n","      <th>335</th>\n","      <td>Intel</td>\n","      <td>INTC</td>\n","      <td>2023-09-01</td>\n","      <td>36.61</td>\n","      <td>0.041833</td>\n","      <td>0.011753</td>\n","      <td>0.006045</td>\n","      <td>0.005707</td>\n","      <td>0.002679</td>\n","      <td>0.003029</td>\n","      <td>0.793822</td>\n","      <td>Buy</td>\n","    </tr>\n","    <tr>\n","      <th>71</th>\n","      <td>Johnson &amp; Johnson</td>\n","      <td>JNJ</td>\n","      <td>2023-09-01</td>\n","      <td>160.48</td>\n","      <td>-0.007422</td>\n","      <td>-0.005262</td>\n","      <td>-0.003950</td>\n","      <td>-0.001313</td>\n","      <td>-0.001131</td>\n","      <td>-0.000181</td>\n","      <td>0.102452</td>\n","      <td>Buy</td>\n","    </tr>\n","    <tr>\n","      <th>311</th>\n","      <td>JPMorgan Chase</td>\n","      <td>JPM</td>\n","      <td>2023-09-01</td>\n","      <td>146.82</td>\n","      <td>0.003349</td>\n","      <td>-0.001874</td>\n","      <td>-0.002421</td>\n","      <td>0.000546</td>\n","      <td>0.000431</td>\n","      <td>0.000115</td>\n","      <td>-1.434142</td>\n","      <td>Sell</td>\n","    </tr>\n","    <tr>\n","      <th>239</th>\n","      <td>Coca-Cola</td>\n","      <td>KO</td>\n","      <td>2023-09-01</td>\n","      <td>59.31</td>\n","      <td>-0.008691</td>\n","      <td>-0.002913</td>\n","      <td>-0.002134</td>\n","      <td>-0.000779</td>\n","      <td>-0.000026</td>\n","      <td>-0.000753</td>\n","      <td>0.484531</td>\n","      <td>Buy</td>\n","    </tr>\n","    <tr>\n","      <th>599</th>\n","      <td>McDonalds</td>\n","      <td>MCD</td>\n","      <td>2023-09-01</td>\n","      <td>280.94</td>\n","      <td>-0.000747</td>\n","      <td>-0.001454</td>\n","      <td>-0.001417</td>\n","      <td>-0.000036</td>\n","      <td>0.000223</td>\n","      <td>-0.000260</td>\n","      <td>-0.336243</td>\n","      <td>Sell</td>\n","    </tr>\n","    <tr>\n","      <th>431</th>\n","      <td>3M</td>\n","      <td>MMM</td>\n","      <td>2023-09-01</td>\n","      <td>106.95</td>\n","      <td>0.002625</td>\n","      <td>0.006066</td>\n","      <td>0.002624</td>\n","      <td>0.003442</td>\n","      <td>0.002888</td>\n","      <td>0.000554</td>\n","      <td>-0.585099</td>\n","      <td>Sell</td>\n","    </tr>\n","    <tr>\n","      <th>527</th>\n","      <td>Merck</td>\n","      <td>MRK</td>\n","      <td>2023-09-01</td>\n","      <td>109.84</td>\n","      <td>0.007891</td>\n","      <td>0.001089</td>\n","      <td>0.001501</td>\n","      <td>-0.000413</td>\n","      <td>-0.000377</td>\n","      <td>-0.000036</td>\n","      <td>-0.948195</td>\n","      <td>Sell</td>\n","    </tr>\n","    <tr>\n","      <th>47</th>\n","      <td>Microsoft</td>\n","      <td>MSFT</td>\n","      <td>2023-09-01</td>\n","      <td>328.66</td>\n","      <td>0.002746</td>\n","      <td>0.001777</td>\n","      <td>0.000697</td>\n","      <td>0.001081</td>\n","      <td>0.001193</td>\n","      <td>-0.000113</td>\n","      <td>-0.067368</td>\n","      <td>Sell</td>\n","    </tr>\n","    <tr>\n","      <th>479</th>\n","      <td>Nike</td>\n","      <td>NKE</td>\n","      <td>2023-09-01</td>\n","      <td>102.36</td>\n","      <td>0.006391</td>\n","      <td>0.000420</td>\n","      <td>-0.001615</td>\n","      <td>0.002036</td>\n","      <td>0.000776</td>\n","      <td>0.001260</td>\n","      <td>0.009254</td>\n","      <td>Buy</td>\n","    </tr>\n","    <tr>\n","      <th>719</th>\n","      <td>Pfizer</td>\n","      <td>PFE</td>\n","      <td>2023-09-01</td>\n","      <td>35.78</td>\n","      <td>0.011306</td>\n","      <td>-0.001179</td>\n","      <td>-0.000430</td>\n","      <td>-0.000749</td>\n","      <td>-0.000736</td>\n","      <td>-0.000013</td>\n","      <td>-0.988759</td>\n","      <td>Sell</td>\n","    </tr>\n","    <tr>\n","      <th>95</th>\n","      <td>Procter &amp; Gamble</td>\n","      <td>PG</td>\n","      <td>2023-09-01</td>\n","      <td>154.51</td>\n","      <td>0.001101</td>\n","      <td>0.000716</td>\n","      <td>0.000057</td>\n","      <td>0.000659</td>\n","      <td>0.000442</td>\n","      <td>0.000217</td>\n","      <td>-0.281676</td>\n","      <td>Sell</td>\n","    </tr>\n","    <tr>\n","      <th>143</th>\n","      <td>Raytheon</td>\n","      <td>RTX</td>\n","      <td>2023-09-01</td>\n","      <td>86.28</td>\n","      <td>0.002789</td>\n","      <td>0.000973</td>\n","      <td>0.000213</td>\n","      <td>0.000760</td>\n","      <td>0.000604</td>\n","      <td>0.000156</td>\n","      <td>0.429147</td>\n","      <td>Buy</td>\n","    </tr>\n","    <tr>\n","      <th>287</th>\n","      <td>Travelers</td>\n","      <td>TRV</td>\n","      <td>2023-09-01</td>\n","      <td>162.30</td>\n","      <td>0.006636</td>\n","      <td>0.000011</td>\n","      <td>-0.001317</td>\n","      <td>0.001328</td>\n","      <td>0.000760</td>\n","      <td>0.000568</td>\n","      <td>1.231905</td>\n","      <td>Buy</td>\n","    </tr>\n","    <tr>\n","      <th>167</th>\n","      <td>UnitedHealth</td>\n","      <td>UNH</td>\n","      <td>2023-09-01</td>\n","      <td>476.24</td>\n","      <td>-0.000713</td>\n","      <td>-0.004915</td>\n","      <td>-0.003673</td>\n","      <td>-0.001242</td>\n","      <td>-0.000627</td>\n","      <td>-0.000615</td>\n","      <td>-0.513259</td>\n","      <td>Sell</td>\n","    </tr>\n","    <tr>\n","      <th>119</th>\n","      <td>Visa</td>\n","      <td>V</td>\n","      <td>2023-09-01</td>\n","      <td>248.11</td>\n","      <td>0.009891</td>\n","      <td>0.003441</td>\n","      <td>0.002471</td>\n","      <td>0.000970</td>\n","      <td>0.000625</td>\n","      <td>0.000345</td>\n","      <td>-8.793524</td>\n","      <td>Sell</td>\n","    </tr>\n","    <tr>\n","      <th>191</th>\n","      <td>Verizon</td>\n","      <td>VZ</td>\n","      <td>2023-09-01</td>\n","      <td>34.86</td>\n","      <td>-0.003431</td>\n","      <td>0.004667</td>\n","      <td>0.003470</td>\n","      <td>0.001198</td>\n","      <td>0.001270</td>\n","      <td>-0.000072</td>\n","      <td>-1.096585</td>\n","      <td>Sell</td>\n","    </tr>\n","    <tr>\n","      <th>359</th>\n","      <td>Walgreens</td>\n","      <td>WBA</td>\n","      <td>2023-09-01</td>\n","      <td>23.43</td>\n","      <td>-0.074279</td>\n","      <td>-0.017044</td>\n","      <td>-0.013230</td>\n","      <td>-0.003814</td>\n","      <td>-0.000976</td>\n","      <td>-0.002838</td>\n","      <td>-3.490151</td>\n","      <td>Sell</td>\n","    </tr>\n","    <tr>\n","      <th>695</th>\n","      <td>Exxon Mobil</td>\n","      <td>XOM</td>\n","      <td>2023-09-01</td>\n","      <td>113.52</td>\n","      <td>0.020955</td>\n","      <td>0.006182</td>\n","      <td>0.004116</td>\n","      <td>0.002065</td>\n","      <td>0.000593</td>\n","      <td>0.001472</td>\n","      <td>0.995660</td>\n","      <td>Buy</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["               company symbol      dates  prices  Daily Return  ShortEMA  \\\n","23               Apple   AAPL 2023-09-01  189.46      0.008463  0.006467   \n","647              Amgen   AMGN 2023-09-01  256.71      0.001443 -0.000339   \n","623             Boeing     BA 2023-09-01  223.40     -0.002812 -0.002538   \n","407        Caterpillar    CAT 2023-09-01  286.25      0.018212  0.004967   \n","671         Salesforce    CRM 2023-09-01  221.53      0.000316  0.006914   \n","215              Cisco   CSCO 2023-09-01   57.84      0.008544  0.005881   \n","383            Chevron    CVX 2023-09-01  164.30      0.019863  0.004139   \n","551             Disney    DIS 2023-09-01   81.64     -0.024379 -0.006020   \n","263       Dow Chemical    DOW 2023-09-01   55.29      0.013380  0.002495   \n","455      Goldman Sachs     GS 2023-09-01  327.40     -0.000946 -0.000374   \n","503         Home Depot     HD 2023-09-01  333.08      0.008417  0.002531   \n","575                IBM    IBM 2023-09-01  147.94      0.007560  0.003462   \n","335              Intel   INTC 2023-09-01   36.61      0.041833  0.011753   \n","71   Johnson & Johnson    JNJ 2023-09-01  160.48     -0.007422 -0.005262   \n","311     JPMorgan Chase    JPM 2023-09-01  146.82      0.003349 -0.001874   \n","239          Coca-Cola     KO 2023-09-01   59.31     -0.008691 -0.002913   \n","599          McDonalds    MCD 2023-09-01  280.94     -0.000747 -0.001454   \n","431                 3M    MMM 2023-09-01  106.95      0.002625  0.006066   \n","527              Merck    MRK 2023-09-01  109.84      0.007891  0.001089   \n","47           Microsoft   MSFT 2023-09-01  328.66      0.002746  0.001777   \n","479               Nike    NKE 2023-09-01  102.36      0.006391  0.000420   \n","719             Pfizer    PFE 2023-09-01   35.78      0.011306 -0.001179   \n","95    Procter & Gamble     PG 2023-09-01  154.51      0.001101  0.000716   \n","143           Raytheon    RTX 2023-09-01   86.28      0.002789  0.000973   \n","287          Travelers    TRV 2023-09-01  162.30      0.006636  0.000011   \n","167       UnitedHealth    UNH 2023-09-01  476.24     -0.000713 -0.004915   \n","119               Visa      V 2023-09-01  248.11      0.009891  0.003441   \n","191            Verizon     VZ 2023-09-01   34.86     -0.003431  0.004667   \n","359          Walgreens    WBA 2023-09-01   23.43     -0.074279 -0.017044   \n","695        Exxon Mobil    XOM 2023-09-01  113.52      0.020955  0.006182   \n","\n","      LongEMA      MACD  SignalLine  MACD_Histogram  Delta Histogram stock_rec  \n","23   0.003095  0.003372    0.003035        0.000337        -0.414676      Sell  \n","647  0.001466 -0.001805   -0.002154        0.000349         2.415509       Buy  \n","623 -0.002502 -0.000037    0.000285       -0.000321        -0.158081      Sell  \n","407  0.002225  0.002742    0.001584        0.001157         1.122546       Buy  \n","671  0.003505  0.003408    0.002646        0.000762        -0.592881      Sell  \n","215  0.005032  0.000849    0.000511        0.000338         0.249152       Buy  \n","383  0.002160  0.001979    0.000674        0.001306         1.989457       Buy  \n","551 -0.004606 -0.001414   -0.000346       -0.001068        -8.142865      Sell  \n","263  0.001066  0.001429    0.000887        0.000542        -4.757586      Sell  \n","455 -0.001975  0.001601    0.001526        0.000075        -0.751903      Sell  \n","503  0.001256  0.001275    0.000638        0.000636         0.588479       Buy  \n","575  0.002454  0.001008    0.000840        0.000168        -4.152970      Sell  \n","335  0.006045  0.005707    0.002679        0.003029         0.793822       Buy  \n","71  -0.003950 -0.001313   -0.001131       -0.000181         0.102452       Buy  \n","311 -0.002421  0.000546    0.000431        0.000115        -1.434142      Sell  \n","239 -0.002134 -0.000779   -0.000026       -0.000753         0.484531       Buy  \n","599 -0.001417 -0.000036    0.000223       -0.000260        -0.336243      Sell  \n","431  0.002624  0.003442    0.002888        0.000554        -0.585099      Sell  \n","527  0.001501 -0.000413   -0.000377       -0.000036        -0.948195      Sell  \n","47   0.000697  0.001081    0.001193       -0.000113        -0.067368      Sell  \n","479 -0.001615  0.002036    0.000776        0.001260         0.009254       Buy  \n","719 -0.000430 -0.000749   -0.000736       -0.000013        -0.988759      Sell  \n","95   0.000057  0.000659    0.000442        0.000217        -0.281676      Sell  \n","143  0.000213  0.000760    0.000604        0.000156         0.429147       Buy  \n","287 -0.001317  0.001328    0.000760        0.000568         1.231905       Buy  \n","167 -0.003673 -0.001242   -0.000627       -0.000615        -0.513259      Sell  \n","119  0.002471  0.000970    0.000625        0.000345        -8.793524      Sell  \n","191  0.003470  0.001198    0.001270       -0.000072        -1.096585      Sell  \n","359 -0.013230 -0.003814   -0.000976       -0.002838        -3.490151      Sell  \n","695  0.004116  0.002065    0.000593        0.001472         0.995660       Buy  "]},"metadata":{},"output_type":"display_data"}],"source":["df_stock_data['Daily Return'] = df_stock_data.groupby('symbol')['prices'].pct_change()\n","df_stock_data.sort_values(['symbol', 'dates'], inplace=True)\n","\n","# Define the short-term and long-term periods for EMA\n","short_term = 12\n","long_term = 26\n","\n","# Calculate the short-term and long-term exponential moving averages (EMAs)\n","df_stock_data['ShortEMA'] = df_stock_data.groupby('symbol')['Daily Return'].transform(lambda x: x.ewm(span=short_term).mean())\n","df_stock_data['LongEMA'] = df_stock_data.groupby('symbol')['Daily Return'].transform(lambda x: x.ewm(span=long_term).mean())\n","\n","# Calculate the MACD line (the difference between short-term and long-term EMAs)\n","df_stock_data['MACD'] = df_stock_data['ShortEMA'] - df_stock_data['LongEMA']\n","\n","# Define the signal line period\n","signal_period = 9\n","\n","# Calculate the signal line (9-day EMA of the MACD)\n","df_stock_data['SignalLine'] = df_stock_data.groupby('symbol')['MACD'].transform(lambda x: x.ewm(span=signal_period).mean())\n","\n","# Calculate the MACD histogram (the difference between MACD and Signal Line)\n","df_stock_data['MACD_Histogram'] = df_stock_data['MACD'] - df_stock_data['SignalLine']\n","\n","df_stock_data['Delta Histogram'] = df_stock_data.groupby('symbol')['MACD_Histogram'].pct_change()\n","\n","def get_stock_recommendation(row):\n","    if row['Delta Histogram'] > 0.00:\n","        return \"Buy\"\n","    else:\n","        return \"Sell\" \n","\n","df_stock_data['stock_rec'] = df_stock_data.apply(get_stock_recommendation, axis=1)  \n","\n","# Sort by date and ticker\n","#df_stock_data = df_stock_data.sort_values(by=['symbol', 'dates']) \n","\n","# Drop duplicates keeping last occurrence \n","df_stock_data = df_stock_data.drop_duplicates(subset='company', keep='last')\n","\n","display(df_stock_data)"]},{"cell_type":"code","execution_count":null,"metadata":{"cell_id":"9a35ef640ec14ca490b9742d02084bf3","deepnote_app_block_visible":true,"deepnote_app_coordinates":{"h":5,"w":12,"x":0,"y":0},"deepnote_cell_type":"code","deepnote_to_be_reexecuted":false,"execution_millis":7,"execution_start":1696524877124,"source_hash":null},"outputs":[],"source":["# Convert 'dates' to date\n","df_stock_data['dates'] = pd.to_datetime(df_stock_data['dates'], unit='s').dt.date"]},{"cell_type":"code","execution_count":null,"metadata":{"cell_id":"acbb5c16eb8848bc953ce152545797ed","deepnote_app_block_visible":true,"deepnote_app_coordinates":{"h":5,"w":12,"x":0,"y":0},"deepnote_cell_type":"code","deepnote_to_be_reexecuted":false,"execution_millis":249,"execution_start":1696524882164,"source_hash":null},"outputs":[{"data":{"application/vnd.deepnote.dataframe.v3+json":{"column_count":12,"columns":[{"dtype":"object","name":"company","stats":{"categories":[{"count":1,"name":"Apple"},{"count":1,"name":"Amgen"},{"count":28,"name":"28 others"}],"nan_count":0,"unique_count":30}},{"dtype":"object","name":"symbol","stats":{"categories":[{"count":1,"name":"AAPL"},{"count":1,"name":"AMGN"},{"count":28,"name":"28 others"}],"nan_count":0,"unique_count":30}},{"dtype":"object","name":"dates","stats":{"categories":[{"count":30,"name":"2023-09-01"}],"nan_count":0,"unique_count":1}},{"dtype":"float64","name":"prices","stats":{"histogram":[{"bin_end":68.711,"bin_start":23.43,"count":7},{"bin_end":113.99199999999999,"bin_start":68.711,"count":6},{"bin_end":159.273,"bin_start":113.99199999999999,"count":3},{"bin_end":204.554,"bin_start":159.273,"count":4},{"bin_end":249.835,"bin_start":204.554,"count":3},{"bin_end":295.116,"bin_start":249.835,"count":3},{"bin_end":340.397,"bin_start":295.116,"count":3},{"bin_end":385.678,"bin_start":340.397,"count":0},{"bin_end":430.959,"bin_start":385.678,"count":0},{"bin_end":476.24,"bin_start":430.959,"count":1}],"max":"476.24","min":"23.43","nan_count":0,"unique_count":30}},{"dtype":"float64","name":"Daily Return","stats":{"histogram":[{"bin_end":-0.06266778008471839,"bin_start":-0.07427894112998812,"count":1},{"bin_end":-0.05105661903944867,"bin_start":-0.06266778008471839,"count":0},{"bin_end":-0.03944545799417895,"bin_start":-0.05105661903944867,"count":0},{"bin_end":-0.027834296948909223,"bin_start":-0.03944545799417895,"count":0},{"bin_end":-0.016223135903639496,"bin_start":-0.027834296948909223,"count":1},{"bin_end":-0.004611974858369783,"bin_start":-0.016223135903639496,"count":2},{"bin_end":0.006999186186899944,"bin_start":-0.004611974858369783,"count":14},{"bin_end":0.01861034723216967,"bin_start":0.006999186186899944,"count":9},{"bin_end":0.0302215082774394,"bin_start":0.01861034723216967,"count":2},{"bin_end":0.041832669322709126,"bin_start":0.0302215082774394,"count":1}],"max":"0.041832669322709126","min":"-0.07427894112998812","nan_count":0,"unique_count":30}},{"dtype":"float64","name":"ShortEMA","stats":{"histogram":[{"bin_end":-0.014163989278808723,"bin_start":-0.017043605714969302,"count":1},{"bin_end":-0.011284372842648143,"bin_start":-0.014163989278808723,"count":0},{"bin_end":-0.008404756406487565,"bin_start":-0.011284372842648143,"count":0},{"bin_end":-0.0055251399703269855,"bin_start":-0.008404756406487565,"count":1},{"bin_end":-0.002645523534166406,"bin_start":-0.0055251399703269855,"count":3},{"bin_end":0.00023409290199417204,"bin_start":-0.002645523534166406,"count":7},{"bin_end":0.0031137093381547534,"bin_start":0.00023409290199417204,"count":7},{"bin_end":0.005993325774315331,"bin_start":0.0031137093381547534,"count":6},{"bin_end":0.00887294221047591,"bin_start":0.005993325774315331,"count":4},{"bin_end":0.011752558646636492,"bin_start":0.00887294221047591,"count":1}],"max":"0.011752558646636492","min":"-0.017043605714969302","nan_count":0,"unique_count":30}},{"dtype":"float64","name":"LongEMA","stats":{"histogram":[{"bin_end":-0.011302177375734447,"bin_start":-0.01322967359778482,"count":1},{"bin_end":-0.009374681153684075,"bin_start":-0.011302177375734447,"count":0},{"bin_end":-0.0074471849316337015,"bin_start":-0.009374681153684075,"count":0},{"bin_end":-0.005519688709583328,"bin_start":-0.0074471849316337015,"count":0},{"bin_end":-0.0035921924875329542,"bin_start":-0.005519688709583328,"count":3},{"bin_end":-0.0016646962654825823,"bin_start":-0.0035921924875329542,"count":4},{"bin_end":0.0002627999565677913,"bin_start":-0.0016646962654825823,"count":6},{"bin_end":0.002190296178618165,"bin_start":0.0002627999565677913,"count":6},{"bin_end":0.004117792400668537,"bin_start":0.002190296178618165,"count":8},{"bin_end":0.006045288622718911,"bin_start":0.004117792400668537,"count":2}],"max":"0.006045288622718911","min":"-0.01322967359778482","nan_count":0,"unique_count":30}},{"dtype":"float64","name":"MACD","stats":{"histogram":[{"bin_end":-0.002861811903074275,"bin_start":-0.0038139321171844816,"count":1},{"bin_end":-0.001909691688964069,"bin_start":-0.002861811903074275,"count":0},{"bin_end":-0.0009575714748538628,"bin_start":-0.001909691688964069,"count":4},{"bin_end":-0.000005451260743656334,"bin_start":-0.0009575714748538628,"count":5},{"bin_end":0.0009466689533665501,"bin_start":-0.000005451260743656334,"count":4},{"bin_end":0.001898789167476756,"bin_start":0.0009466689533665501,"count":8},{"bin_end":0.002850909381586963,"bin_start":0.001898789167476756,"count":4},{"bin_end":0.003803029595697169,"bin_start":0.002850909381586963,"count":3},{"bin_end":0.004755149809807376,"bin_start":0.003803029595697169,"count":0},{"bin_end":0.005707270023917581,"bin_start":0.004755149809807376,"count":1}],"max":"0.005707270023917581","min":"-0.0038139321171844816","nan_count":0,"unique_count":30}},{"dtype":"float64","name":"SignalLine","stats":{"histogram":[{"bin_end":-0.0016351869503808492,"bin_start":-0.0021541225828762708,"count":1},{"bin_end":-0.0011162513178854276,"bin_start":-0.0016351869503808492,"count":1},{"bin_end":-0.000597315685390006,"bin_start":-0.0011162513178854276,"count":3},{"bin_end":-0.0000783800528945844,"bin_start":-0.000597315685390006,"count":2},{"bin_end":0.00044055557960083697,"bin_start":-0.0000783800528945844,"count":4},{"bin_end":0.0009594912120962588,"bin_start":0.00044055557960083697,"count":11},{"bin_end":0.0014784268445916806,"bin_start":0.0009594912120962588,"count":2},{"bin_end":0.001997362477087102,"bin_start":0.0014784268445916806,"count":2},{"bin_end":0.0025162981095825233,"bin_start":0.001997362477087102,"count":0},{"bin_end":0.003035233742077945,"bin_start":0.0025162981095825233,"count":4}],"max":"0.003035233742077945","min":"-0.0021541225828762708","nan_count":0,"unique_count":30}},{"dtype":"float64","name":"MACD_Histogram","stats":{"histogram":[{"bin_end":-0.0022512216604307343,"bin_start":-0.0028378667176918873,"count":1},{"bin_end":-0.001664576603169581,"bin_start":-0.0022512216604307343,"count":0},{"bin_end":-0.0010779315459084277,"bin_start":-0.001664576603169581,"count":0},{"bin_end":-0.0004912864886472746,"bin_start":-0.0010779315459084277,"count":3},{"bin_end":0.00009535856861387845,"bin_start":-0.0004912864886472746,"count":8},{"bin_end":0.000682003625875032,"bin_start":0.00009535856861387845,"count":12},{"bin_end":0.0012686486831361846,"bin_start":0.000682003625875032,"count":3},{"bin_end":0.001855293740397338,"bin_start":0.0012686486831361846,"count":2},{"bin_end":0.0024419387976584916,"bin_start":0.001855293740397338,"count":0},{"bin_end":0.003028583854919644,"bin_start":0.0024419387976584916,"count":1}],"max":"0.003028583854919644","min":"-0.0028378667176918873","nan_count":0,"unique_count":30}},{"dtype":"float64","name":"Delta Histogram","stats":{"histogram":[{"bin_end":-7.672621076133213,"bin_start":-8.793524368664471,"count":2},{"bin_end":-6.551717783601954,"bin_start":-7.672621076133213,"count":0},{"bin_end":-5.430814491070695,"bin_start":-6.551717783601954,"count":0},{"bin_end":-4.309911198539437,"bin_start":-5.430814491070695,"count":1},{"bin_end":-3.189007906008179,"bin_start":-4.309911198539437,"count":2},{"bin_end":-2.06810461347692,"bin_start":-3.189007906008179,"count":0},{"bin_end":-0.9472013209456609,"bin_start":-2.06810461347692,"count":4},{"bin_end":0.1737019715855972,"bin_start":-0.9472013209456609,"count":11},{"bin_end":1.2946052641168553,"bin_start":0.1737019715855972,"count":8},{"bin_end":2.4155085566481143,"bin_start":1.2946052641168553,"count":2}],"max":"2.4155085566481143","min":"-8.793524368664471","nan_count":0,"unique_count":30}},{"dtype":"object","name":"stock_rec","stats":{"categories":[{"count":18,"name":"Sell"},{"count":12,"name":"Buy"}],"nan_count":0,"unique_count":2}},{"dtype":"int64","name":"_deepnote_index_column"}],"row_count":30,"rows":[{"Daily Return":0.00846329908979615,"Delta Histogram":-0.41467579055858506,"LongEMA":0.0030949209511439107,"MACD":0.0033723344973178716,"MACD_Histogram":0.0003371007552399265,"ShortEMA":0.006467255448461782,"SignalLine":0.003035233742077945,"_deepnote_index_column":23,"company":"Apple","dates":"2023-09-01","prices":189.46,"stock_rec":"Sell","symbol":"AAPL"},{"Daily Return":0.0014433954903643187,"Delta Histogram":2.4155085566481143,"LongEMA":0.0014662140957449176,"MACD":-0.001805121499230014,"MACD_Histogram":0.00034900108364625685,"ShortEMA":-0.0003389074034850963,"SignalLine":-0.0021541225828762708,"_deepnote_index_column":647,"company":"Amgen","dates":"2023-09-01","prices":256.71,"stock_rec":"Buy","symbol":"AMGN"},{"Daily Return":-0.0028121233763335196,"Delta Histogram":-0.15808104888530727,"LongEMA":-0.0025015999994145673,"MACD":-0.00003688125238262381,"MACD_Histogram":-0.00032148270782235677,"ShortEMA":-0.002538481251797191,"SignalLine":0.00028460145543973296,"_deepnote_index_column":623,"company":"Boeing","dates":"2023-09-01","prices":223.4,"stock_rec":"Sell","symbol":"BA"},{"Daily Return":0.01821221498950676,"Delta Histogram":1.1225459575342849,"LongEMA":0.002225003761327704,"MACD":0.0027415939234958675,"MACD_Histogram":0.0011574598728013232,"ShortEMA":0.004966597684823572,"SignalLine":0.0015841340506945443,"_deepnote_index_column":407,"company":"Caterpillar","dates":"2023-09-01","prices":286.25,"stock_rec":"Buy","symbol":"CAT"},{"Daily Return":0.0003160841686986604,"Delta Histogram":-0.5928807093773247,"LongEMA":0.0035054103036642344,"MACD":0.0034081695094032266,"MACD_Histogram":0.0007622571880554281,"ShortEMA":0.006913579813067461,"SignalLine":0.0026459123213477985,"_deepnote_index_column":671,"company":"Salesforce","dates":"2023-09-01","prices":221.53,"stock_rec":"Sell","symbol":"CRM"},{"Daily Return":0.008544027898866657,"Delta Histogram":0.24915229901181424,"LongEMA":0.005032280081352706,"MACD":0.0008488724662545624,"MACD_Histogram":0.00033786820692257116,"ShortEMA":0.005881152547607268,"SignalLine":0.0005110042593319912,"_deepnote_index_column":215,"company":"Cisco","dates":"2023-09-01","prices":57.84,"stock_rec":"Buy","symbol":"CSCO"},{"Daily Return":0.019863438857852467,"Delta Histogram":1.9894566389186035,"LongEMA":0.0021595262270144317,"MACD":0.001979404727678891,"MACD_Histogram":0.001305712603058996,"ShortEMA":0.0041389309546933225,"SignalLine":0.0006736921246198947,"_deepnote_index_column":383,"company":"Chevron","dates":"2023-09-01","prices":164.3,"stock_rec":"Buy","symbol":"CVX"},{"Daily Return":-0.02437858508604218,"Delta Histogram":-8.14286472761177,"LongEMA":-0.00460644472519052,"MACD":-0.0014137012262317008,"MACD_Histogram":-0.0010679189036935444,"ShortEMA":-0.006020145951422221,"SignalLine":-0.0003457823225381563,"_deepnote_index_column":551,"company":"Disney","dates":"2023-09-01","prices":81.64,"stock_rec":"Sell","symbol":"DIS"},{"Daily Return":0.013379765395894472,"Delta Histogram":-4.757585826440538,"LongEMA":0.0010658730375521159,"MACD":0.0014291283882231908,"MACD_Histogram":0.0005423987674564398,"ShortEMA":0.0024950014257753067,"SignalLine":0.000886729620766751,"_deepnote_index_column":263,"company":"Dow Chemical","dates":"2023-09-01","prices":55.29,"stock_rec":"Sell","symbol":"DOW"},{"Daily Return":-0.0009459583168045516,"Delta Histogram":-0.7519030954765538,"LongEMA":-0.0019749909244070906,"MACD":0.0016009877601382621,"MACD_Histogram":0.00007469856121804447,"ShortEMA":-0.0003740031642688285,"SignalLine":0.0015262891989202177,"_deepnote_index_column":455,"company":"Goldman Sachs","dates":"2023-09-01","prices":327.4,"stock_rec":"Sell","symbol":"GS"}]},"text/html":["<div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>company</th>\n","      <th>symbol</th>\n","      <th>dates</th>\n","      <th>prices</th>\n","      <th>Daily Return</th>\n","      <th>ShortEMA</th>\n","      <th>LongEMA</th>\n","      <th>MACD</th>\n","      <th>SignalLine</th>\n","      <th>MACD_Histogram</th>\n","      <th>Delta Histogram</th>\n","      <th>stock_rec</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>23</th>\n","      <td>Apple</td>\n","      <td>AAPL</td>\n","      <td>2023-09-01</td>\n","      <td>189.46</td>\n","      <td>0.008463</td>\n","      <td>0.006467</td>\n","      <td>0.003095</td>\n","      <td>0.003372</td>\n","      <td>0.003035</td>\n","      <td>0.000337</td>\n","      <td>-0.414676</td>\n","      <td>Sell</td>\n","    </tr>\n","    <tr>\n","      <th>647</th>\n","      <td>Amgen</td>\n","      <td>AMGN</td>\n","      <td>2023-09-01</td>\n","      <td>256.71</td>\n","      <td>0.001443</td>\n","      <td>-0.000339</td>\n","      <td>0.001466</td>\n","      <td>-0.001805</td>\n","      <td>-0.002154</td>\n","      <td>0.000349</td>\n","      <td>2.415509</td>\n","      <td>Buy</td>\n","    </tr>\n","    <tr>\n","      <th>623</th>\n","      <td>Boeing</td>\n","      <td>BA</td>\n","      <td>2023-09-01</td>\n","      <td>223.40</td>\n","      <td>-0.002812</td>\n","      <td>-0.002538</td>\n","      <td>-0.002502</td>\n","      <td>-0.000037</td>\n","      <td>0.000285</td>\n","      <td>-0.000321</td>\n","      <td>-0.158081</td>\n","      <td>Sell</td>\n","    </tr>\n","    <tr>\n","      <th>407</th>\n","      <td>Caterpillar</td>\n","      <td>CAT</td>\n","      <td>2023-09-01</td>\n","      <td>286.25</td>\n","      <td>0.018212</td>\n","      <td>0.004967</td>\n","      <td>0.002225</td>\n","      <td>0.002742</td>\n","      <td>0.001584</td>\n","      <td>0.001157</td>\n","      <td>1.122546</td>\n","      <td>Buy</td>\n","    </tr>\n","    <tr>\n","      <th>671</th>\n","      <td>Salesforce</td>\n","      <td>CRM</td>\n","      <td>2023-09-01</td>\n","      <td>221.53</td>\n","      <td>0.000316</td>\n","      <td>0.006914</td>\n","      <td>0.003505</td>\n","      <td>0.003408</td>\n","      <td>0.002646</td>\n","      <td>0.000762</td>\n","      <td>-0.592881</td>\n","      <td>Sell</td>\n","    </tr>\n","    <tr>\n","      <th>215</th>\n","      <td>Cisco</td>\n","      <td>CSCO</td>\n","      <td>2023-09-01</td>\n","      <td>57.84</td>\n","      <td>0.008544</td>\n","      <td>0.005881</td>\n","      <td>0.005032</td>\n","      <td>0.000849</td>\n","      <td>0.000511</td>\n","      <td>0.000338</td>\n","      <td>0.249152</td>\n","      <td>Buy</td>\n","    </tr>\n","    <tr>\n","      <th>383</th>\n","      <td>Chevron</td>\n","      <td>CVX</td>\n","      <td>2023-09-01</td>\n","      <td>164.30</td>\n","      <td>0.019863</td>\n","      <td>0.004139</td>\n","      <td>0.002160</td>\n","      <td>0.001979</td>\n","      <td>0.000674</td>\n","      <td>0.001306</td>\n","      <td>1.989457</td>\n","      <td>Buy</td>\n","    </tr>\n","    <tr>\n","      <th>551</th>\n","      <td>Disney</td>\n","      <td>DIS</td>\n","      <td>2023-09-01</td>\n","      <td>81.64</td>\n","      <td>-0.024379</td>\n","      <td>-0.006020</td>\n","      <td>-0.004606</td>\n","      <td>-0.001414</td>\n","      <td>-0.000346</td>\n","      <td>-0.001068</td>\n","      <td>-8.142865</td>\n","      <td>Sell</td>\n","    </tr>\n","    <tr>\n","      <th>263</th>\n","      <td>Dow Chemical</td>\n","      <td>DOW</td>\n","      <td>2023-09-01</td>\n","      <td>55.29</td>\n","      <td>0.013380</td>\n","      <td>0.002495</td>\n","      <td>0.001066</td>\n","      <td>0.001429</td>\n","      <td>0.000887</td>\n","      <td>0.000542</td>\n","      <td>-4.757586</td>\n","      <td>Sell</td>\n","    </tr>\n","    <tr>\n","      <th>455</th>\n","      <td>Goldman Sachs</td>\n","      <td>GS</td>\n","      <td>2023-09-01</td>\n","      <td>327.40</td>\n","      <td>-0.000946</td>\n","      <td>-0.000374</td>\n","      <td>-0.001975</td>\n","      <td>0.001601</td>\n","      <td>0.001526</td>\n","      <td>0.000075</td>\n","      <td>-0.751903</td>\n","      <td>Sell</td>\n","    </tr>\n","    <tr>\n","      <th>503</th>\n","      <td>Home Depot</td>\n","      <td>HD</td>\n","      <td>2023-09-01</td>\n","      <td>333.08</td>\n","      <td>0.008417</td>\n","      <td>0.002531</td>\n","      <td>0.001256</td>\n","      <td>0.001275</td>\n","      <td>0.000638</td>\n","      <td>0.000636</td>\n","      <td>0.588479</td>\n","      <td>Buy</td>\n","    </tr>\n","    <tr>\n","      <th>575</th>\n","      <td>IBM</td>\n","      <td>IBM</td>\n","      <td>2023-09-01</td>\n","      <td>147.94</td>\n","      <td>0.007560</td>\n","      <td>0.003462</td>\n","      <td>0.002454</td>\n","      <td>0.001008</td>\n","      <td>0.000840</td>\n","      <td>0.000168</td>\n","      <td>-4.152970</td>\n","      <td>Sell</td>\n","    </tr>\n","    <tr>\n","      <th>335</th>\n","      <td>Intel</td>\n","      <td>INTC</td>\n","      <td>2023-09-01</td>\n","      <td>36.61</td>\n","      <td>0.041833</td>\n","      <td>0.011753</td>\n","      <td>0.006045</td>\n","      <td>0.005707</td>\n","      <td>0.002679</td>\n","      <td>0.003029</td>\n","      <td>0.793822</td>\n","      <td>Buy</td>\n","    </tr>\n","    <tr>\n","      <th>71</th>\n","      <td>Johnson &amp; Johnson</td>\n","      <td>JNJ</td>\n","      <td>2023-09-01</td>\n","      <td>160.48</td>\n","      <td>-0.007422</td>\n","      <td>-0.005262</td>\n","      <td>-0.003950</td>\n","      <td>-0.001313</td>\n","      <td>-0.001131</td>\n","      <td>-0.000181</td>\n","      <td>0.102452</td>\n","      <td>Buy</td>\n","    </tr>\n","    <tr>\n","      <th>311</th>\n","      <td>JPMorgan Chase</td>\n","      <td>JPM</td>\n","      <td>2023-09-01</td>\n","      <td>146.82</td>\n","      <td>0.003349</td>\n","      <td>-0.001874</td>\n","      <td>-0.002421</td>\n","      <td>0.000546</td>\n","      <td>0.000431</td>\n","      <td>0.000115</td>\n","      <td>-1.434142</td>\n","      <td>Sell</td>\n","    </tr>\n","    <tr>\n","      <th>239</th>\n","      <td>Coca-Cola</td>\n","      <td>KO</td>\n","      <td>2023-09-01</td>\n","      <td>59.31</td>\n","      <td>-0.008691</td>\n","      <td>-0.002913</td>\n","      <td>-0.002134</td>\n","      <td>-0.000779</td>\n","      <td>-0.000026</td>\n","      <td>-0.000753</td>\n","      <td>0.484531</td>\n","      <td>Buy</td>\n","    </tr>\n","    <tr>\n","      <th>599</th>\n","      <td>McDonalds</td>\n","      <td>MCD</td>\n","      <td>2023-09-01</td>\n","      <td>280.94</td>\n","      <td>-0.000747</td>\n","      <td>-0.001454</td>\n","      <td>-0.001417</td>\n","      <td>-0.000036</td>\n","      <td>0.000223</td>\n","      <td>-0.000260</td>\n","      <td>-0.336243</td>\n","      <td>Sell</td>\n","    </tr>\n","    <tr>\n","      <th>431</th>\n","      <td>3M</td>\n","      <td>MMM</td>\n","      <td>2023-09-01</td>\n","      <td>106.95</td>\n","      <td>0.002625</td>\n","      <td>0.006066</td>\n","      <td>0.002624</td>\n","      <td>0.003442</td>\n","      <td>0.002888</td>\n","      <td>0.000554</td>\n","      <td>-0.585099</td>\n","      <td>Sell</td>\n","    </tr>\n","    <tr>\n","      <th>527</th>\n","      <td>Merck</td>\n","      <td>MRK</td>\n","      <td>2023-09-01</td>\n","      <td>109.84</td>\n","      <td>0.007891</td>\n","      <td>0.001089</td>\n","      <td>0.001501</td>\n","      <td>-0.000413</td>\n","      <td>-0.000377</td>\n","      <td>-0.000036</td>\n","      <td>-0.948195</td>\n","      <td>Sell</td>\n","    </tr>\n","    <tr>\n","      <th>47</th>\n","      <td>Microsoft</td>\n","      <td>MSFT</td>\n","      <td>2023-09-01</td>\n","      <td>328.66</td>\n","      <td>0.002746</td>\n","      <td>0.001777</td>\n","      <td>0.000697</td>\n","      <td>0.001081</td>\n","      <td>0.001193</td>\n","      <td>-0.000113</td>\n","      <td>-0.067368</td>\n","      <td>Sell</td>\n","    </tr>\n","    <tr>\n","      <th>479</th>\n","      <td>Nike</td>\n","      <td>NKE</td>\n","      <td>2023-09-01</td>\n","      <td>102.36</td>\n","      <td>0.006391</td>\n","      <td>0.000420</td>\n","      <td>-0.001615</td>\n","      <td>0.002036</td>\n","      <td>0.000776</td>\n","      <td>0.001260</td>\n","      <td>0.009254</td>\n","      <td>Buy</td>\n","    </tr>\n","    <tr>\n","      <th>719</th>\n","      <td>Pfizer</td>\n","      <td>PFE</td>\n","      <td>2023-09-01</td>\n","      <td>35.78</td>\n","      <td>0.011306</td>\n","      <td>-0.001179</td>\n","      <td>-0.000430</td>\n","      <td>-0.000749</td>\n","      <td>-0.000736</td>\n","      <td>-0.000013</td>\n","      <td>-0.988759</td>\n","      <td>Sell</td>\n","    </tr>\n","    <tr>\n","      <th>95</th>\n","      <td>Procter &amp; Gamble</td>\n","      <td>PG</td>\n","      <td>2023-09-01</td>\n","      <td>154.51</td>\n","      <td>0.001101</td>\n","      <td>0.000716</td>\n","      <td>0.000057</td>\n","      <td>0.000659</td>\n","      <td>0.000442</td>\n","      <td>0.000217</td>\n","      <td>-0.281676</td>\n","      <td>Sell</td>\n","    </tr>\n","    <tr>\n","      <th>143</th>\n","      <td>Raytheon</td>\n","      <td>RTX</td>\n","      <td>2023-09-01</td>\n","      <td>86.28</td>\n","      <td>0.002789</td>\n","      <td>0.000973</td>\n","      <td>0.000213</td>\n","      <td>0.000760</td>\n","      <td>0.000604</td>\n","      <td>0.000156</td>\n","      <td>0.429147</td>\n","      <td>Buy</td>\n","    </tr>\n","    <tr>\n","      <th>287</th>\n","      <td>Travelers</td>\n","      <td>TRV</td>\n","      <td>2023-09-01</td>\n","      <td>162.30</td>\n","      <td>0.006636</td>\n","      <td>0.000011</td>\n","      <td>-0.001317</td>\n","      <td>0.001328</td>\n","      <td>0.000760</td>\n","      <td>0.000568</td>\n","      <td>1.231905</td>\n","      <td>Buy</td>\n","    </tr>\n","    <tr>\n","      <th>167</th>\n","      <td>UnitedHealth</td>\n","      <td>UNH</td>\n","      <td>2023-09-01</td>\n","      <td>476.24</td>\n","      <td>-0.000713</td>\n","      <td>-0.004915</td>\n","      <td>-0.003673</td>\n","      <td>-0.001242</td>\n","      <td>-0.000627</td>\n","      <td>-0.000615</td>\n","      <td>-0.513259</td>\n","      <td>Sell</td>\n","    </tr>\n","    <tr>\n","      <th>119</th>\n","      <td>Visa</td>\n","      <td>V</td>\n","      <td>2023-09-01</td>\n","      <td>248.11</td>\n","      <td>0.009891</td>\n","      <td>0.003441</td>\n","      <td>0.002471</td>\n","      <td>0.000970</td>\n","      <td>0.000625</td>\n","      <td>0.000345</td>\n","      <td>-8.793524</td>\n","      <td>Sell</td>\n","    </tr>\n","    <tr>\n","      <th>191</th>\n","      <td>Verizon</td>\n","      <td>VZ</td>\n","      <td>2023-09-01</td>\n","      <td>34.86</td>\n","      <td>-0.003431</td>\n","      <td>0.004667</td>\n","      <td>0.003470</td>\n","      <td>0.001198</td>\n","      <td>0.001270</td>\n","      <td>-0.000072</td>\n","      <td>-1.096585</td>\n","      <td>Sell</td>\n","    </tr>\n","    <tr>\n","      <th>359</th>\n","      <td>Walgreens</td>\n","      <td>WBA</td>\n","      <td>2023-09-01</td>\n","      <td>23.43</td>\n","      <td>-0.074279</td>\n","      <td>-0.017044</td>\n","      <td>-0.013230</td>\n","      <td>-0.003814</td>\n","      <td>-0.000976</td>\n","      <td>-0.002838</td>\n","      <td>-3.490151</td>\n","      <td>Sell</td>\n","    </tr>\n","    <tr>\n","      <th>695</th>\n","      <td>Exxon Mobil</td>\n","      <td>XOM</td>\n","      <td>2023-09-01</td>\n","      <td>113.52</td>\n","      <td>0.020955</td>\n","      <td>0.006182</td>\n","      <td>0.004116</td>\n","      <td>0.002065</td>\n","      <td>0.000593</td>\n","      <td>0.001472</td>\n","      <td>0.995660</td>\n","      <td>Buy</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["               company symbol       dates  prices  Daily Return  ShortEMA  \\\n","23               Apple   AAPL  2023-09-01  189.46      0.008463  0.006467   \n","647              Amgen   AMGN  2023-09-01  256.71      0.001443 -0.000339   \n","623             Boeing     BA  2023-09-01  223.40     -0.002812 -0.002538   \n","407        Caterpillar    CAT  2023-09-01  286.25      0.018212  0.004967   \n","671         Salesforce    CRM  2023-09-01  221.53      0.000316  0.006914   \n","215              Cisco   CSCO  2023-09-01   57.84      0.008544  0.005881   \n","383            Chevron    CVX  2023-09-01  164.30      0.019863  0.004139   \n","551             Disney    DIS  2023-09-01   81.64     -0.024379 -0.006020   \n","263       Dow Chemical    DOW  2023-09-01   55.29      0.013380  0.002495   \n","455      Goldman Sachs     GS  2023-09-01  327.40     -0.000946 -0.000374   \n","503         Home Depot     HD  2023-09-01  333.08      0.008417  0.002531   \n","575                IBM    IBM  2023-09-01  147.94      0.007560  0.003462   \n","335              Intel   INTC  2023-09-01   36.61      0.041833  0.011753   \n","71   Johnson & Johnson    JNJ  2023-09-01  160.48     -0.007422 -0.005262   \n","311     JPMorgan Chase    JPM  2023-09-01  146.82      0.003349 -0.001874   \n","239          Coca-Cola     KO  2023-09-01   59.31     -0.008691 -0.002913   \n","599          McDonalds    MCD  2023-09-01  280.94     -0.000747 -0.001454   \n","431                 3M    MMM  2023-09-01  106.95      0.002625  0.006066   \n","527              Merck    MRK  2023-09-01  109.84      0.007891  0.001089   \n","47           Microsoft   MSFT  2023-09-01  328.66      0.002746  0.001777   \n","479               Nike    NKE  2023-09-01  102.36      0.006391  0.000420   \n","719             Pfizer    PFE  2023-09-01   35.78      0.011306 -0.001179   \n","95    Procter & Gamble     PG  2023-09-01  154.51      0.001101  0.000716   \n","143           Raytheon    RTX  2023-09-01   86.28      0.002789  0.000973   \n","287          Travelers    TRV  2023-09-01  162.30      0.006636  0.000011   \n","167       UnitedHealth    UNH  2023-09-01  476.24     -0.000713 -0.004915   \n","119               Visa      V  2023-09-01  248.11      0.009891  0.003441   \n","191            Verizon     VZ  2023-09-01   34.86     -0.003431  0.004667   \n","359          Walgreens    WBA  2023-09-01   23.43     -0.074279 -0.017044   \n","695        Exxon Mobil    XOM  2023-09-01  113.52      0.020955  0.006182   \n","\n","      LongEMA      MACD  SignalLine  MACD_Histogram  Delta Histogram stock_rec  \n","23   0.003095  0.003372    0.003035        0.000337        -0.414676      Sell  \n","647  0.001466 -0.001805   -0.002154        0.000349         2.415509       Buy  \n","623 -0.002502 -0.000037    0.000285       -0.000321        -0.158081      Sell  \n","407  0.002225  0.002742    0.001584        0.001157         1.122546       Buy  \n","671  0.003505  0.003408    0.002646        0.000762        -0.592881      Sell  \n","215  0.005032  0.000849    0.000511        0.000338         0.249152       Buy  \n","383  0.002160  0.001979    0.000674        0.001306         1.989457       Buy  \n","551 -0.004606 -0.001414   -0.000346       -0.001068        -8.142865      Sell  \n","263  0.001066  0.001429    0.000887        0.000542        -4.757586      Sell  \n","455 -0.001975  0.001601    0.001526        0.000075        -0.751903      Sell  \n","503  0.001256  0.001275    0.000638        0.000636         0.588479       Buy  \n","575  0.002454  0.001008    0.000840        0.000168        -4.152970      Sell  \n","335  0.006045  0.005707    0.002679        0.003029         0.793822       Buy  \n","71  -0.003950 -0.001313   -0.001131       -0.000181         0.102452       Buy  \n","311 -0.002421  0.000546    0.000431        0.000115        -1.434142      Sell  \n","239 -0.002134 -0.000779   -0.000026       -0.000753         0.484531       Buy  \n","599 -0.001417 -0.000036    0.000223       -0.000260        -0.336243      Sell  \n","431  0.002624  0.003442    0.002888        0.000554        -0.585099      Sell  \n","527  0.001501 -0.000413   -0.000377       -0.000036        -0.948195      Sell  \n","47   0.000697  0.001081    0.001193       -0.000113        -0.067368      Sell  \n","479 -0.001615  0.002036    0.000776        0.001260         0.009254       Buy  \n","719 -0.000430 -0.000749   -0.000736       -0.000013        -0.988759      Sell  \n","95   0.000057  0.000659    0.000442        0.000217        -0.281676      Sell  \n","143  0.000213  0.000760    0.000604        0.000156         0.429147       Buy  \n","287 -0.001317  0.001328    0.000760        0.000568         1.231905       Buy  \n","167 -0.003673 -0.001242   -0.000627       -0.000615        -0.513259      Sell  \n","119  0.002471  0.000970    0.000625        0.000345        -8.793524      Sell  \n","191  0.003470  0.001198    0.001270       -0.000072        -1.096585      Sell  \n","359 -0.013230 -0.003814   -0.000976       -0.002838        -3.490151      Sell  \n","695  0.004116  0.002065    0.000593        0.001472         0.995660       Buy  "]},"metadata":{},"output_type":"display_data"}],"source":["display(df_stock_data)"]},{"cell_type":"markdown","metadata":{"cell_id":"901a32201f624854a5557f94b2479afe","deepnote_app_block_visible":true,"deepnote_app_coordinates":{"h":5,"w":12,"x":0,"y":0},"deepnote_cell_type":"markdown"},"source":["# Part 3: Recommendation"]},{"cell_type":"code","execution_count":null,"metadata":{"cell_id":"e36b7b53f6da49ce976109396a776406","deepnote_app_block_visible":true,"deepnote_app_coordinates":{"h":5,"w":12,"x":0,"y":0},"deepnote_cell_type":"code","deepnote_to_be_reexecuted":false,"execution_millis":350,"execution_start":1696524888132,"source_hash":null},"outputs":[{"name":"stderr","output_type":"stream","text":["/tmp/ipykernel_144/1530004256.py:2: SettingWithCopyWarning: \n","A value is trying to be set on a copy of a slice from a DataFrame.\n","Try using .loc[row_indexer,col_indexer] = value instead\n","\n","See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n","  clean_stock_df['primary_key'] = clean_stock_df['company'] + '_' + clean_stock_df['dates'].astype(str)\n"]},{"data":{"application/vnd.deepnote.dataframe.v3+json":{"column_count":5,"columns":[{"dtype":"object","name":"company","stats":{"categories":[{"count":1,"name":"Apple"},{"count":1,"name":"Amgen"},{"count":28,"name":"28 others"}],"nan_count":0,"unique_count":30}},{"dtype":"object","name":"symbol","stats":{"categories":[{"count":1,"name":"AAPL"},{"count":1,"name":"AMGN"},{"count":28,"name":"28 others"}],"nan_count":0,"unique_count":30}},{"dtype":"object","name":"dates","stats":{"categories":[{"count":30,"name":"2023-09-01"}],"nan_count":0,"unique_count":1}},{"dtype":"object","name":"stock_rec","stats":{"categories":[{"count":18,"name":"Sell"},{"count":12,"name":"Buy"}],"nan_count":0,"unique_count":2}},{"dtype":"object","name":"primary_key","stats":{"categories":[{"count":1,"name":"Apple_2023-09-01"},{"count":1,"name":"Amgen_2023-09-01"},{"count":28,"name":"28 others"}],"nan_count":0,"unique_count":30}},{"dtype":"int64","name":"_deepnote_index_column"}],"row_count":30,"rows":[{"_deepnote_index_column":23,"company":"Apple","dates":"2023-09-01","primary_key":"Apple_2023-09-01","stock_rec":"Sell","symbol":"AAPL"},{"_deepnote_index_column":647,"company":"Amgen","dates":"2023-09-01","primary_key":"Amgen_2023-09-01","stock_rec":"Buy","symbol":"AMGN"},{"_deepnote_index_column":623,"company":"Boeing","dates":"2023-09-01","primary_key":"Boeing_2023-09-01","stock_rec":"Sell","symbol":"BA"},{"_deepnote_index_column":407,"company":"Caterpillar","dates":"2023-09-01","primary_key":"Caterpillar_2023-09-01","stock_rec":"Buy","symbol":"CAT"},{"_deepnote_index_column":671,"company":"Salesforce","dates":"2023-09-01","primary_key":"Salesforce_2023-09-01","stock_rec":"Sell","symbol":"CRM"},{"_deepnote_index_column":215,"company":"Cisco","dates":"2023-09-01","primary_key":"Cisco_2023-09-01","stock_rec":"Buy","symbol":"CSCO"},{"_deepnote_index_column":383,"company":"Chevron","dates":"2023-09-01","primary_key":"Chevron_2023-09-01","stock_rec":"Buy","symbol":"CVX"},{"_deepnote_index_column":551,"company":"Disney","dates":"2023-09-01","primary_key":"Disney_2023-09-01","stock_rec":"Sell","symbol":"DIS"},{"_deepnote_index_column":263,"company":"Dow Chemical","dates":"2023-09-01","primary_key":"Dow Chemical_2023-09-01","stock_rec":"Sell","symbol":"DOW"},{"_deepnote_index_column":455,"company":"Goldman Sachs","dates":"2023-09-01","primary_key":"Goldman Sachs_2023-09-01","stock_rec":"Sell","symbol":"GS"}]},"text/html":["<div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>company</th>\n","      <th>symbol</th>\n","      <th>dates</th>\n","      <th>stock_rec</th>\n","      <th>primary_key</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>23</th>\n","      <td>Apple</td>\n","      <td>AAPL</td>\n","      <td>2023-09-01</td>\n","      <td>Sell</td>\n","      <td>Apple_2023-09-01</td>\n","    </tr>\n","    <tr>\n","      <th>647</th>\n","      <td>Amgen</td>\n","      <td>AMGN</td>\n","      <td>2023-09-01</td>\n","      <td>Buy</td>\n","      <td>Amgen_2023-09-01</td>\n","    </tr>\n","    <tr>\n","      <th>623</th>\n","      <td>Boeing</td>\n","      <td>BA</td>\n","      <td>2023-09-01</td>\n","      <td>Sell</td>\n","      <td>Boeing_2023-09-01</td>\n","    </tr>\n","    <tr>\n","      <th>407</th>\n","      <td>Caterpillar</td>\n","      <td>CAT</td>\n","      <td>2023-09-01</td>\n","      <td>Buy</td>\n","      <td>Caterpillar_2023-09-01</td>\n","    </tr>\n","    <tr>\n","      <th>671</th>\n","      <td>Salesforce</td>\n","      <td>CRM</td>\n","      <td>2023-09-01</td>\n","      <td>Sell</td>\n","      <td>Salesforce_2023-09-01</td>\n","    </tr>\n","    <tr>\n","      <th>215</th>\n","      <td>Cisco</td>\n","      <td>CSCO</td>\n","      <td>2023-09-01</td>\n","      <td>Buy</td>\n","      <td>Cisco_2023-09-01</td>\n","    </tr>\n","    <tr>\n","      <th>383</th>\n","      <td>Chevron</td>\n","      <td>CVX</td>\n","      <td>2023-09-01</td>\n","      <td>Buy</td>\n","      <td>Chevron_2023-09-01</td>\n","    </tr>\n","    <tr>\n","      <th>551</th>\n","      <td>Disney</td>\n","      <td>DIS</td>\n","      <td>2023-09-01</td>\n","      <td>Sell</td>\n","      <td>Disney_2023-09-01</td>\n","    </tr>\n","    <tr>\n","      <th>263</th>\n","      <td>Dow Chemical</td>\n","      <td>DOW</td>\n","      <td>2023-09-01</td>\n","      <td>Sell</td>\n","      <td>Dow Chemical_2023-09-01</td>\n","    </tr>\n","    <tr>\n","      <th>455</th>\n","      <td>Goldman Sachs</td>\n","      <td>GS</td>\n","      <td>2023-09-01</td>\n","      <td>Sell</td>\n","      <td>Goldman Sachs_2023-09-01</td>\n","    </tr>\n","    <tr>\n","      <th>503</th>\n","      <td>Home Depot</td>\n","      <td>HD</td>\n","      <td>2023-09-01</td>\n","      <td>Buy</td>\n","      <td>Home Depot_2023-09-01</td>\n","    </tr>\n","    <tr>\n","      <th>575</th>\n","      <td>IBM</td>\n","      <td>IBM</td>\n","      <td>2023-09-01</td>\n","      <td>Sell</td>\n","      <td>IBM_2023-09-01</td>\n","    </tr>\n","    <tr>\n","      <th>335</th>\n","      <td>Intel</td>\n","      <td>INTC</td>\n","      <td>2023-09-01</td>\n","      <td>Buy</td>\n","      <td>Intel_2023-09-01</td>\n","    </tr>\n","    <tr>\n","      <th>71</th>\n","      <td>Johnson &amp; Johnson</td>\n","      <td>JNJ</td>\n","      <td>2023-09-01</td>\n","      <td>Buy</td>\n","      <td>Johnson &amp; Johnson_2023-09-01</td>\n","    </tr>\n","    <tr>\n","      <th>311</th>\n","      <td>JPMorgan Chase</td>\n","      <td>JPM</td>\n","      <td>2023-09-01</td>\n","      <td>Sell</td>\n","      <td>JPMorgan Chase_2023-09-01</td>\n","    </tr>\n","    <tr>\n","      <th>239</th>\n","      <td>Coca-Cola</td>\n","      <td>KO</td>\n","      <td>2023-09-01</td>\n","      <td>Buy</td>\n","      <td>Coca-Cola_2023-09-01</td>\n","    </tr>\n","    <tr>\n","      <th>599</th>\n","      <td>McDonalds</td>\n","      <td>MCD</td>\n","      <td>2023-09-01</td>\n","      <td>Sell</td>\n","      <td>McDonalds_2023-09-01</td>\n","    </tr>\n","    <tr>\n","      <th>431</th>\n","      <td>3M</td>\n","      <td>MMM</td>\n","      <td>2023-09-01</td>\n","      <td>Sell</td>\n","      <td>3M_2023-09-01</td>\n","    </tr>\n","    <tr>\n","      <th>527</th>\n","      <td>Merck</td>\n","      <td>MRK</td>\n","      <td>2023-09-01</td>\n","      <td>Sell</td>\n","      <td>Merck_2023-09-01</td>\n","    </tr>\n","    <tr>\n","      <th>47</th>\n","      <td>Microsoft</td>\n","      <td>MSFT</td>\n","      <td>2023-09-01</td>\n","      <td>Sell</td>\n","      <td>Microsoft_2023-09-01</td>\n","    </tr>\n","    <tr>\n","      <th>479</th>\n","      <td>Nike</td>\n","      <td>NKE</td>\n","      <td>2023-09-01</td>\n","      <td>Buy</td>\n","      <td>Nike_2023-09-01</td>\n","    </tr>\n","    <tr>\n","      <th>719</th>\n","      <td>Pfizer</td>\n","      <td>PFE</td>\n","      <td>2023-09-01</td>\n","      <td>Sell</td>\n","      <td>Pfizer_2023-09-01</td>\n","    </tr>\n","    <tr>\n","      <th>95</th>\n","      <td>Procter &amp; Gamble</td>\n","      <td>PG</td>\n","      <td>2023-09-01</td>\n","      <td>Sell</td>\n","      <td>Procter &amp; Gamble_2023-09-01</td>\n","    </tr>\n","    <tr>\n","      <th>143</th>\n","      <td>Raytheon</td>\n","      <td>RTX</td>\n","      <td>2023-09-01</td>\n","      <td>Buy</td>\n","      <td>Raytheon_2023-09-01</td>\n","    </tr>\n","    <tr>\n","      <th>287</th>\n","      <td>Travelers</td>\n","      <td>TRV</td>\n","      <td>2023-09-01</td>\n","      <td>Buy</td>\n","      <td>Travelers_2023-09-01</td>\n","    </tr>\n","    <tr>\n","      <th>167</th>\n","      <td>UnitedHealth</td>\n","      <td>UNH</td>\n","      <td>2023-09-01</td>\n","      <td>Sell</td>\n","      <td>UnitedHealth_2023-09-01</td>\n","    </tr>\n","    <tr>\n","      <th>119</th>\n","      <td>Visa</td>\n","      <td>V</td>\n","      <td>2023-09-01</td>\n","      <td>Sell</td>\n","      <td>Visa_2023-09-01</td>\n","    </tr>\n","    <tr>\n","      <th>191</th>\n","      <td>Verizon</td>\n","      <td>VZ</td>\n","      <td>2023-09-01</td>\n","      <td>Sell</td>\n","      <td>Verizon_2023-09-01</td>\n","    </tr>\n","    <tr>\n","      <th>359</th>\n","      <td>Walgreens</td>\n","      <td>WBA</td>\n","      <td>2023-09-01</td>\n","      <td>Sell</td>\n","      <td>Walgreens_2023-09-01</td>\n","    </tr>\n","    <tr>\n","      <th>695</th>\n","      <td>Exxon Mobil</td>\n","      <td>XOM</td>\n","      <td>2023-09-01</td>\n","      <td>Buy</td>\n","      <td>Exxon Mobil_2023-09-01</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["               company symbol       dates stock_rec  \\\n","23               Apple   AAPL  2023-09-01      Sell   \n","647              Amgen   AMGN  2023-09-01       Buy   \n","623             Boeing     BA  2023-09-01      Sell   \n","407        Caterpillar    CAT  2023-09-01       Buy   \n","671         Salesforce    CRM  2023-09-01      Sell   \n","215              Cisco   CSCO  2023-09-01       Buy   \n","383            Chevron    CVX  2023-09-01       Buy   \n","551             Disney    DIS  2023-09-01      Sell   \n","263       Dow Chemical    DOW  2023-09-01      Sell   \n","455      Goldman Sachs     GS  2023-09-01      Sell   \n","503         Home Depot     HD  2023-09-01       Buy   \n","575                IBM    IBM  2023-09-01      Sell   \n","335              Intel   INTC  2023-09-01       Buy   \n","71   Johnson & Johnson    JNJ  2023-09-01       Buy   \n","311     JPMorgan Chase    JPM  2023-09-01      Sell   \n","239          Coca-Cola     KO  2023-09-01       Buy   \n","599          McDonalds    MCD  2023-09-01      Sell   \n","431                 3M    MMM  2023-09-01      Sell   \n","527              Merck    MRK  2023-09-01      Sell   \n","47           Microsoft   MSFT  2023-09-01      Sell   \n","479               Nike    NKE  2023-09-01       Buy   \n","719             Pfizer    PFE  2023-09-01      Sell   \n","95    Procter & Gamble     PG  2023-09-01      Sell   \n","143           Raytheon    RTX  2023-09-01       Buy   \n","287          Travelers    TRV  2023-09-01       Buy   \n","167       UnitedHealth    UNH  2023-09-01      Sell   \n","119               Visa      V  2023-09-01      Sell   \n","191            Verizon     VZ  2023-09-01      Sell   \n","359          Walgreens    WBA  2023-09-01      Sell   \n","695        Exxon Mobil    XOM  2023-09-01       Buy   \n","\n","                      primary_key  \n","23               Apple_2023-09-01  \n","647              Amgen_2023-09-01  \n","623             Boeing_2023-09-01  \n","407        Caterpillar_2023-09-01  \n","671         Salesforce_2023-09-01  \n","215              Cisco_2023-09-01  \n","383            Chevron_2023-09-01  \n","551             Disney_2023-09-01  \n","263       Dow Chemical_2023-09-01  \n","455      Goldman Sachs_2023-09-01  \n","503         Home Depot_2023-09-01  \n","575                IBM_2023-09-01  \n","335              Intel_2023-09-01  \n","71   Johnson & Johnson_2023-09-01  \n","311     JPMorgan Chase_2023-09-01  \n","239          Coca-Cola_2023-09-01  \n","599          McDonalds_2023-09-01  \n","431                 3M_2023-09-01  \n","527              Merck_2023-09-01  \n","47           Microsoft_2023-09-01  \n","479               Nike_2023-09-01  \n","719             Pfizer_2023-09-01  \n","95    Procter & Gamble_2023-09-01  \n","143           Raytheon_2023-09-01  \n","287          Travelers_2023-09-01  \n","167       UnitedHealth_2023-09-01  \n","119               Visa_2023-09-01  \n","191            Verizon_2023-09-01  \n","359          Walgreens_2023-09-01  \n","695        Exxon Mobil_2023-09-01  "]},"metadata":{},"output_type":"display_data"}],"source":["clean_stock_df = df_stock_data[['company', 'symbol', 'dates', 'stock_rec']]\n","clean_stock_df['primary_key'] = clean_stock_df['company'] + '_' + clean_stock_df['dates'].astype(str)\n","display(clean_stock_df)"]},{"cell_type":"code","execution_count":null,"metadata":{"cell_id":"c554a5a41f7b498885deafe306b4ea9a","deepnote_app_block_visible":true,"deepnote_app_coordinates":{"h":5,"w":12,"x":0,"y":0},"deepnote_cell_type":"code","deepnote_table_invalid":false,"deepnote_table_loading":false,"deepnote_table_state":{"filters":[],"pageIndex":0,"pageSize":100,"sortBy":[]},"deepnote_to_be_reexecuted":false,"execution_millis":358,"execution_start":1696524898498,"source_hash":null},"outputs":[{"data":{"application/vnd.deepnote.dataframe.v3+json":{"column_count":4,"columns":[{"dtype":"object","name":"company","stats":{"categories":[{"count":1,"name":"3M"},{"count":1,"name":"Amgen"},{"count":28,"name":"28 others"}],"nan_count":0,"unique_count":30}},{"dtype":"object","name":"date","stats":{"categories":[{"count":30,"name":"2023-09-01"}],"nan_count":0,"unique_count":1}},{"dtype":"object","name":"sentiment_score","stats":{"categories":[{"count":16,"name":"positive"},{"count":11,"name":"neutral"},{"count":3,"name":"negative"}],"nan_count":0,"unique_count":3}},{"dtype":"object","name":"primary_key","stats":{"categories":[{"count":1,"name":"3M_2023-09-01"},{"count":1,"name":"Amgen_2023-09-01"},{"count":28,"name":"28 others"}],"nan_count":0,"unique_count":30}},{"dtype":"int64","name":"_deepnote_index_column"}],"row_count":30,"rows":[{"_deepnote_index_column":0,"company":"3M","date":"2023-09-01","primary_key":"3M_2023-09-01","sentiment_score":"positive"},{"_deepnote_index_column":1,"company":"Amgen","date":"2023-09-01","primary_key":"Amgen_2023-09-01","sentiment_score":"positive"},{"_deepnote_index_column":2,"company":"Apple","date":"2023-09-01","primary_key":"Apple_2023-09-01","sentiment_score":"positive"},{"_deepnote_index_column":3,"company":"Boeing","date":"2023-09-01","primary_key":"Boeing_2023-09-01","sentiment_score":"neutral"},{"_deepnote_index_column":4,"company":"Caterpillar","date":"2023-09-01","primary_key":"Caterpillar_2023-09-01","sentiment_score":"negative"},{"_deepnote_index_column":5,"company":"Chevron","date":"2023-09-01","primary_key":"Chevron_2023-09-01","sentiment_score":"neutral"},{"_deepnote_index_column":6,"company":"Cisco","date":"2023-09-01","primary_key":"Cisco_2023-09-01","sentiment_score":"positive"},{"_deepnote_index_column":7,"company":"Coca-Cola","date":"2023-09-01","primary_key":"Coca-Cola_2023-09-01","sentiment_score":"positive"},{"_deepnote_index_column":8,"company":"Disney","date":"2023-09-01","primary_key":"Disney_2023-09-01","sentiment_score":"neutral"},{"_deepnote_index_column":9,"company":"Dow Chemical","date":"2023-09-01","primary_key":"Dow Chemical_2023-09-01","sentiment_score":"neutral"},{"_deepnote_index_column":10,"company":"Exxon Mobil","date":"2023-09-01","primary_key":"Exxon Mobil_2023-09-01","sentiment_score":"neutral"},{"_deepnote_index_column":11,"company":"Goldman Sachs","date":"2023-09-01","primary_key":"Goldman Sachs_2023-09-01","sentiment_score":"positive"},{"_deepnote_index_column":12,"company":"Home Depot","date":"2023-09-01","primary_key":"Home Depot_2023-09-01","sentiment_score":"neutral"},{"_deepnote_index_column":13,"company":"IBM","date":"2023-09-01","primary_key":"IBM_2023-09-01","sentiment_score":"positive"},{"_deepnote_index_column":14,"company":"Intel","date":"2023-09-01","primary_key":"Intel_2023-09-01","sentiment_score":"positive"},{"_deepnote_index_column":15,"company":"JPMorgan Chase","date":"2023-09-01","primary_key":"JPMorgan Chase_2023-09-01","sentiment_score":"positive"},{"_deepnote_index_column":16,"company":"Johnson & Johnson","date":"2023-09-01","primary_key":"Johnson & Johnson_2023-09-01","sentiment_score":"positive"},{"_deepnote_index_column":17,"company":"McDonalds","date":"2023-09-01","primary_key":"McDonalds_2023-09-01","sentiment_score":"positive"},{"_deepnote_index_column":18,"company":"Merck","date":"2023-09-01","primary_key":"Merck_2023-09-01","sentiment_score":"neutral"},{"_deepnote_index_column":19,"company":"Microsoft","date":"2023-09-01","primary_key":"Microsoft_2023-09-01","sentiment_score":"positive"},{"_deepnote_index_column":20,"company":"Nike","date":"2023-09-01","primary_key":"Nike_2023-09-01","sentiment_score":"positive"},{"_deepnote_index_column":21,"company":"Pfizer","date":"2023-09-01","primary_key":"Pfizer_2023-09-01","sentiment_score":"positive"},{"_deepnote_index_column":22,"company":"Procter & Gamble","date":"2023-09-01","primary_key":"Procter & Gamble_2023-09-01","sentiment_score":"negative"},{"_deepnote_index_column":23,"company":"Raytheon","date":"2023-09-01","primary_key":"Raytheon_2023-09-01","sentiment_score":"neutral"},{"_deepnote_index_column":24,"company":"Salesforce","date":"2023-09-01","primary_key":"Salesforce_2023-09-01","sentiment_score":"positive"},{"_deepnote_index_column":25,"company":"Travelers","date":"2023-09-01","primary_key":"Travelers_2023-09-01","sentiment_score":"negative"},{"_deepnote_index_column":26,"company":"UnitedHealth","date":"2023-09-01","primary_key":"UnitedHealth_2023-09-01","sentiment_score":"neutral"},{"_deepnote_index_column":27,"company":"Verizon","date":"2023-09-01","primary_key":"Verizon_2023-09-01","sentiment_score":"positive"},{"_deepnote_index_column":28,"company":"Visa","date":"2023-09-01","primary_key":"Visa_2023-09-01","sentiment_score":"neutral"},{"_deepnote_index_column":29,"company":"Walgreens","date":"2023-09-01","primary_key":"Walgreens_2023-09-01","sentiment_score":"neutral"}]},"text/html":["<div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>company</th>\n","      <th>date</th>\n","      <th>sentiment_score</th>\n","      <th>primary_key</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>3M</td>\n","      <td>2023-09-01</td>\n","      <td>positive</td>\n","      <td>3M_2023-09-01</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>Amgen</td>\n","      <td>2023-09-01</td>\n","      <td>positive</td>\n","      <td>Amgen_2023-09-01</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>Apple</td>\n","      <td>2023-09-01</td>\n","      <td>positive</td>\n","      <td>Apple_2023-09-01</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>Boeing</td>\n","      <td>2023-09-01</td>\n","      <td>neutral</td>\n","      <td>Boeing_2023-09-01</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>Caterpillar</td>\n","      <td>2023-09-01</td>\n","      <td>negative</td>\n","      <td>Caterpillar_2023-09-01</td>\n","    </tr>\n","    <tr>\n","      <th>5</th>\n","      <td>Chevron</td>\n","      <td>2023-09-01</td>\n","      <td>neutral</td>\n","      <td>Chevron_2023-09-01</td>\n","    </tr>\n","    <tr>\n","      <th>6</th>\n","      <td>Cisco</td>\n","      <td>2023-09-01</td>\n","      <td>positive</td>\n","      <td>Cisco_2023-09-01</td>\n","    </tr>\n","    <tr>\n","      <th>7</th>\n","      <td>Coca-Cola</td>\n","      <td>2023-09-01</td>\n","      <td>positive</td>\n","      <td>Coca-Cola_2023-09-01</td>\n","    </tr>\n","    <tr>\n","      <th>8</th>\n","      <td>Disney</td>\n","      <td>2023-09-01</td>\n","      <td>neutral</td>\n","      <td>Disney_2023-09-01</td>\n","    </tr>\n","    <tr>\n","      <th>9</th>\n","      <td>Dow Chemical</td>\n","      <td>2023-09-01</td>\n","      <td>neutral</td>\n","      <td>Dow Chemical_2023-09-01</td>\n","    </tr>\n","    <tr>\n","      <th>10</th>\n","      <td>Exxon Mobil</td>\n","      <td>2023-09-01</td>\n","      <td>neutral</td>\n","      <td>Exxon Mobil_2023-09-01</td>\n","    </tr>\n","    <tr>\n","      <th>11</th>\n","      <td>Goldman Sachs</td>\n","      <td>2023-09-01</td>\n","      <td>positive</td>\n","      <td>Goldman Sachs_2023-09-01</td>\n","    </tr>\n","    <tr>\n","      <th>12</th>\n","      <td>Home Depot</td>\n","      <td>2023-09-01</td>\n","      <td>neutral</td>\n","      <td>Home Depot_2023-09-01</td>\n","    </tr>\n","    <tr>\n","      <th>13</th>\n","      <td>IBM</td>\n","      <td>2023-09-01</td>\n","      <td>positive</td>\n","      <td>IBM_2023-09-01</td>\n","    </tr>\n","    <tr>\n","      <th>14</th>\n","      <td>Intel</td>\n","      <td>2023-09-01</td>\n","      <td>positive</td>\n","      <td>Intel_2023-09-01</td>\n","    </tr>\n","    <tr>\n","      <th>15</th>\n","      <td>JPMorgan Chase</td>\n","      <td>2023-09-01</td>\n","      <td>positive</td>\n","      <td>JPMorgan Chase_2023-09-01</td>\n","    </tr>\n","    <tr>\n","      <th>16</th>\n","      <td>Johnson &amp; Johnson</td>\n","      <td>2023-09-01</td>\n","      <td>positive</td>\n","      <td>Johnson &amp; Johnson_2023-09-01</td>\n","    </tr>\n","    <tr>\n","      <th>17</th>\n","      <td>McDonalds</td>\n","      <td>2023-09-01</td>\n","      <td>positive</td>\n","      <td>McDonalds_2023-09-01</td>\n","    </tr>\n","    <tr>\n","      <th>18</th>\n","      <td>Merck</td>\n","      <td>2023-09-01</td>\n","      <td>neutral</td>\n","      <td>Merck_2023-09-01</td>\n","    </tr>\n","    <tr>\n","      <th>19</th>\n","      <td>Microsoft</td>\n","      <td>2023-09-01</td>\n","      <td>positive</td>\n","      <td>Microsoft_2023-09-01</td>\n","    </tr>\n","    <tr>\n","      <th>20</th>\n","      <td>Nike</td>\n","      <td>2023-09-01</td>\n","      <td>positive</td>\n","      <td>Nike_2023-09-01</td>\n","    </tr>\n","    <tr>\n","      <th>21</th>\n","      <td>Pfizer</td>\n","      <td>2023-09-01</td>\n","      <td>positive</td>\n","      <td>Pfizer_2023-09-01</td>\n","    </tr>\n","    <tr>\n","      <th>22</th>\n","      <td>Procter &amp; Gamble</td>\n","      <td>2023-09-01</td>\n","      <td>negative</td>\n","      <td>Procter &amp; Gamble_2023-09-01</td>\n","    </tr>\n","    <tr>\n","      <th>23</th>\n","      <td>Raytheon</td>\n","      <td>2023-09-01</td>\n","      <td>neutral</td>\n","      <td>Raytheon_2023-09-01</td>\n","    </tr>\n","    <tr>\n","      <th>24</th>\n","      <td>Salesforce</td>\n","      <td>2023-09-01</td>\n","      <td>positive</td>\n","      <td>Salesforce_2023-09-01</td>\n","    </tr>\n","    <tr>\n","      <th>25</th>\n","      <td>Travelers</td>\n","      <td>2023-09-01</td>\n","      <td>negative</td>\n","      <td>Travelers_2023-09-01</td>\n","    </tr>\n","    <tr>\n","      <th>26</th>\n","      <td>UnitedHealth</td>\n","      <td>2023-09-01</td>\n","      <td>neutral</td>\n","      <td>UnitedHealth_2023-09-01</td>\n","    </tr>\n","    <tr>\n","      <th>27</th>\n","      <td>Verizon</td>\n","      <td>2023-09-01</td>\n","      <td>positive</td>\n","      <td>Verizon_2023-09-01</td>\n","    </tr>\n","    <tr>\n","      <th>28</th>\n","      <td>Visa</td>\n","      <td>2023-09-01</td>\n","      <td>neutral</td>\n","      <td>Visa_2023-09-01</td>\n","    </tr>\n","    <tr>\n","      <th>29</th>\n","      <td>Walgreens</td>\n","      <td>2023-09-01</td>\n","      <td>neutral</td>\n","      <td>Walgreens_2023-09-01</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["              company        date sentiment_score  \\\n","0                  3M  2023-09-01        positive   \n","1               Amgen  2023-09-01        positive   \n","2               Apple  2023-09-01        positive   \n","3              Boeing  2023-09-01         neutral   \n","4         Caterpillar  2023-09-01        negative   \n","5             Chevron  2023-09-01         neutral   \n","6               Cisco  2023-09-01        positive   \n","7           Coca-Cola  2023-09-01        positive   \n","8              Disney  2023-09-01         neutral   \n","9        Dow Chemical  2023-09-01         neutral   \n","10        Exxon Mobil  2023-09-01         neutral   \n","11      Goldman Sachs  2023-09-01        positive   \n","12         Home Depot  2023-09-01         neutral   \n","13                IBM  2023-09-01        positive   \n","14              Intel  2023-09-01        positive   \n","15     JPMorgan Chase  2023-09-01        positive   \n","16  Johnson & Johnson  2023-09-01        positive   \n","17          McDonalds  2023-09-01        positive   \n","18              Merck  2023-09-01         neutral   \n","19          Microsoft  2023-09-01        positive   \n","20               Nike  2023-09-01        positive   \n","21             Pfizer  2023-09-01        positive   \n","22   Procter & Gamble  2023-09-01        negative   \n","23           Raytheon  2023-09-01         neutral   \n","24         Salesforce  2023-09-01        positive   \n","25          Travelers  2023-09-01        negative   \n","26       UnitedHealth  2023-09-01         neutral   \n","27            Verizon  2023-09-01        positive   \n","28               Visa  2023-09-01         neutral   \n","29          Walgreens  2023-09-01         neutral   \n","\n","                     primary_key  \n","0                  3M_2023-09-01  \n","1               Amgen_2023-09-01  \n","2               Apple_2023-09-01  \n","3              Boeing_2023-09-01  \n","4         Caterpillar_2023-09-01  \n","5             Chevron_2023-09-01  \n","6               Cisco_2023-09-01  \n","7           Coca-Cola_2023-09-01  \n","8              Disney_2023-09-01  \n","9        Dow Chemical_2023-09-01  \n","10        Exxon Mobil_2023-09-01  \n","11      Goldman Sachs_2023-09-01  \n","12         Home Depot_2023-09-01  \n","13                IBM_2023-09-01  \n","14              Intel_2023-09-01  \n","15     JPMorgan Chase_2023-09-01  \n","16  Johnson & Johnson_2023-09-01  \n","17          McDonalds_2023-09-01  \n","18              Merck_2023-09-01  \n","19          Microsoft_2023-09-01  \n","20               Nike_2023-09-01  \n","21             Pfizer_2023-09-01  \n","22   Procter & Gamble_2023-09-01  \n","23           Raytheon_2023-09-01  \n","24         Salesforce_2023-09-01  \n","25          Travelers_2023-09-01  \n","26       UnitedHealth_2023-09-01  \n","27            Verizon_2023-09-01  \n","28               Visa_2023-09-01  \n","29          Walgreens_2023-09-01  "]},"metadata":{},"output_type":"display_data"}],"source":["clean_result_df = result_df[['company', 'date', 'sentiment_score']]\n","clean_result_df['primary_key'] = clean_result_df['company'] + '_' + clean_result_df['date'].astype(str)\n","display(clean_result_df)"]},{"cell_type":"code","execution_count":null,"metadata":{"cell_id":"4ee46283587a4244a93d24a7e20c4ba4","deepnote_app_block_visible":true,"deepnote_app_coordinates":{"h":5,"w":12,"x":0,"y":0},"deepnote_cell_type":"code","deepnote_to_be_reexecuted":false,"execution_millis":302,"execution_start":1696524905226,"source_hash":null},"outputs":[{"data":{"application/vnd.deepnote.dataframe.v3+json":{"column_count":5,"columns":[{"dtype":"object","name":"primary_key","stats":{"categories":[{"count":1,"name":"Apple_2023-09-01"},{"count":1,"name":"Amgen_2023-09-01"},{"count":28,"name":"28 others"}],"nan_count":0,"unique_count":30}},{"dtype":"object","name":"symbol","stats":{"categories":[{"count":1,"name":"AAPL"},{"count":1,"name":"AMGN"},{"count":28,"name":"28 others"}],"nan_count":0,"unique_count":30}},{"dtype":"object","name":"date","stats":{"categories":[{"count":30,"name":"2023-09-01"}],"nan_count":0,"unique_count":1}},{"dtype":"object","name":"sentiment_score","stats":{"categories":[{"count":16,"name":"positive"},{"count":11,"name":"neutral"},{"count":3,"name":"negative"}],"nan_count":0,"unique_count":3}},{"dtype":"object","name":"stock_rec","stats":{"categories":[{"count":18,"name":"Sell"},{"count":12,"name":"Buy"}],"nan_count":0,"unique_count":2}},{"dtype":"int64","name":"_deepnote_index_column"}],"row_count":30,"rows":[{"_deepnote_index_column":0,"date":"2023-09-01","primary_key":"Apple_2023-09-01","sentiment_score":"positive","stock_rec":"Sell","symbol":"AAPL"},{"_deepnote_index_column":1,"date":"2023-09-01","primary_key":"Amgen_2023-09-01","sentiment_score":"positive","stock_rec":"Buy","symbol":"AMGN"},{"_deepnote_index_column":2,"date":"2023-09-01","primary_key":"Boeing_2023-09-01","sentiment_score":"neutral","stock_rec":"Sell","symbol":"BA"},{"_deepnote_index_column":3,"date":"2023-09-01","primary_key":"Caterpillar_2023-09-01","sentiment_score":"negative","stock_rec":"Buy","symbol":"CAT"},{"_deepnote_index_column":4,"date":"2023-09-01","primary_key":"Salesforce_2023-09-01","sentiment_score":"positive","stock_rec":"Sell","symbol":"CRM"},{"_deepnote_index_column":5,"date":"2023-09-01","primary_key":"Cisco_2023-09-01","sentiment_score":"positive","stock_rec":"Buy","symbol":"CSCO"},{"_deepnote_index_column":6,"date":"2023-09-01","primary_key":"Chevron_2023-09-01","sentiment_score":"neutral","stock_rec":"Buy","symbol":"CVX"},{"_deepnote_index_column":7,"date":"2023-09-01","primary_key":"Disney_2023-09-01","sentiment_score":"neutral","stock_rec":"Sell","symbol":"DIS"},{"_deepnote_index_column":8,"date":"2023-09-01","primary_key":"Dow Chemical_2023-09-01","sentiment_score":"neutral","stock_rec":"Sell","symbol":"DOW"},{"_deepnote_index_column":9,"date":"2023-09-01","primary_key":"Goldman Sachs_2023-09-01","sentiment_score":"positive","stock_rec":"Sell","symbol":"GS"}]},"text/html":["<div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>primary_key</th>\n","      <th>symbol</th>\n","      <th>date</th>\n","      <th>sentiment_score</th>\n","      <th>stock_rec</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>Apple_2023-09-01</td>\n","      <td>AAPL</td>\n","      <td>2023-09-01</td>\n","      <td>positive</td>\n","      <td>Sell</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>Amgen_2023-09-01</td>\n","      <td>AMGN</td>\n","      <td>2023-09-01</td>\n","      <td>positive</td>\n","      <td>Buy</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>Boeing_2023-09-01</td>\n","      <td>BA</td>\n","      <td>2023-09-01</td>\n","      <td>neutral</td>\n","      <td>Sell</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>Caterpillar_2023-09-01</td>\n","      <td>CAT</td>\n","      <td>2023-09-01</td>\n","      <td>negative</td>\n","      <td>Buy</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>Salesforce_2023-09-01</td>\n","      <td>CRM</td>\n","      <td>2023-09-01</td>\n","      <td>positive</td>\n","      <td>Sell</td>\n","    </tr>\n","    <tr>\n","      <th>5</th>\n","      <td>Cisco_2023-09-01</td>\n","      <td>CSCO</td>\n","      <td>2023-09-01</td>\n","      <td>positive</td>\n","      <td>Buy</td>\n","    </tr>\n","    <tr>\n","      <th>6</th>\n","      <td>Chevron_2023-09-01</td>\n","      <td>CVX</td>\n","      <td>2023-09-01</td>\n","      <td>neutral</td>\n","      <td>Buy</td>\n","    </tr>\n","    <tr>\n","      <th>7</th>\n","      <td>Disney_2023-09-01</td>\n","      <td>DIS</td>\n","      <td>2023-09-01</td>\n","      <td>neutral</td>\n","      <td>Sell</td>\n","    </tr>\n","    <tr>\n","      <th>8</th>\n","      <td>Dow Chemical_2023-09-01</td>\n","      <td>DOW</td>\n","      <td>2023-09-01</td>\n","      <td>neutral</td>\n","      <td>Sell</td>\n","    </tr>\n","    <tr>\n","      <th>9</th>\n","      <td>Goldman Sachs_2023-09-01</td>\n","      <td>GS</td>\n","      <td>2023-09-01</td>\n","      <td>positive</td>\n","      <td>Sell</td>\n","    </tr>\n","    <tr>\n","      <th>10</th>\n","      <td>Home Depot_2023-09-01</td>\n","      <td>HD</td>\n","      <td>2023-09-01</td>\n","      <td>neutral</td>\n","      <td>Buy</td>\n","    </tr>\n","    <tr>\n","      <th>11</th>\n","      <td>IBM_2023-09-01</td>\n","      <td>IBM</td>\n","      <td>2023-09-01</td>\n","      <td>positive</td>\n","      <td>Sell</td>\n","    </tr>\n","    <tr>\n","      <th>12</th>\n","      <td>Intel_2023-09-01</td>\n","      <td>INTC</td>\n","      <td>2023-09-01</td>\n","      <td>positive</td>\n","      <td>Buy</td>\n","    </tr>\n","    <tr>\n","      <th>13</th>\n","      <td>Johnson &amp; Johnson_2023-09-01</td>\n","      <td>JNJ</td>\n","      <td>2023-09-01</td>\n","      <td>positive</td>\n","      <td>Buy</td>\n","    </tr>\n","    <tr>\n","      <th>14</th>\n","      <td>JPMorgan Chase_2023-09-01</td>\n","      <td>JPM</td>\n","      <td>2023-09-01</td>\n","      <td>positive</td>\n","      <td>Sell</td>\n","    </tr>\n","    <tr>\n","      <th>15</th>\n","      <td>Coca-Cola_2023-09-01</td>\n","      <td>KO</td>\n","      <td>2023-09-01</td>\n","      <td>positive</td>\n","      <td>Buy</td>\n","    </tr>\n","    <tr>\n","      <th>16</th>\n","      <td>McDonalds_2023-09-01</td>\n","      <td>MCD</td>\n","      <td>2023-09-01</td>\n","      <td>positive</td>\n","      <td>Sell</td>\n","    </tr>\n","    <tr>\n","      <th>17</th>\n","      <td>3M_2023-09-01</td>\n","      <td>MMM</td>\n","      <td>2023-09-01</td>\n","      <td>positive</td>\n","      <td>Sell</td>\n","    </tr>\n","    <tr>\n","      <th>18</th>\n","      <td>Merck_2023-09-01</td>\n","      <td>MRK</td>\n","      <td>2023-09-01</td>\n","      <td>neutral</td>\n","      <td>Sell</td>\n","    </tr>\n","    <tr>\n","      <th>19</th>\n","      <td>Microsoft_2023-09-01</td>\n","      <td>MSFT</td>\n","      <td>2023-09-01</td>\n","      <td>positive</td>\n","      <td>Sell</td>\n","    </tr>\n","    <tr>\n","      <th>20</th>\n","      <td>Nike_2023-09-01</td>\n","      <td>NKE</td>\n","      <td>2023-09-01</td>\n","      <td>positive</td>\n","      <td>Buy</td>\n","    </tr>\n","    <tr>\n","      <th>21</th>\n","      <td>Pfizer_2023-09-01</td>\n","      <td>PFE</td>\n","      <td>2023-09-01</td>\n","      <td>positive</td>\n","      <td>Sell</td>\n","    </tr>\n","    <tr>\n","      <th>22</th>\n","      <td>Procter &amp; Gamble_2023-09-01</td>\n","      <td>PG</td>\n","      <td>2023-09-01</td>\n","      <td>negative</td>\n","      <td>Sell</td>\n","    </tr>\n","    <tr>\n","      <th>23</th>\n","      <td>Raytheon_2023-09-01</td>\n","      <td>RTX</td>\n","      <td>2023-09-01</td>\n","      <td>neutral</td>\n","      <td>Buy</td>\n","    </tr>\n","    <tr>\n","      <th>24</th>\n","      <td>Travelers_2023-09-01</td>\n","      <td>TRV</td>\n","      <td>2023-09-01</td>\n","      <td>negative</td>\n","      <td>Buy</td>\n","    </tr>\n","    <tr>\n","      <th>25</th>\n","      <td>UnitedHealth_2023-09-01</td>\n","      <td>UNH</td>\n","      <td>2023-09-01</td>\n","      <td>neutral</td>\n","      <td>Sell</td>\n","    </tr>\n","    <tr>\n","      <th>26</th>\n","      <td>Visa_2023-09-01</td>\n","      <td>V</td>\n","      <td>2023-09-01</td>\n","      <td>neutral</td>\n","      <td>Sell</td>\n","    </tr>\n","    <tr>\n","      <th>27</th>\n","      <td>Verizon_2023-09-01</td>\n","      <td>VZ</td>\n","      <td>2023-09-01</td>\n","      <td>positive</td>\n","      <td>Sell</td>\n","    </tr>\n","    <tr>\n","      <th>28</th>\n","      <td>Walgreens_2023-09-01</td>\n","      <td>WBA</td>\n","      <td>2023-09-01</td>\n","      <td>neutral</td>\n","      <td>Sell</td>\n","    </tr>\n","    <tr>\n","      <th>29</th>\n","      <td>Exxon Mobil_2023-09-01</td>\n","      <td>XOM</td>\n","      <td>2023-09-01</td>\n","      <td>neutral</td>\n","      <td>Buy</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["                     primary_key symbol        date sentiment_score stock_rec\n","0               Apple_2023-09-01   AAPL  2023-09-01        positive      Sell\n","1               Amgen_2023-09-01   AMGN  2023-09-01        positive       Buy\n","2              Boeing_2023-09-01     BA  2023-09-01         neutral      Sell\n","3         Caterpillar_2023-09-01    CAT  2023-09-01        negative       Buy\n","4          Salesforce_2023-09-01    CRM  2023-09-01        positive      Sell\n","5               Cisco_2023-09-01   CSCO  2023-09-01        positive       Buy\n","6             Chevron_2023-09-01    CVX  2023-09-01         neutral       Buy\n","7              Disney_2023-09-01    DIS  2023-09-01         neutral      Sell\n","8        Dow Chemical_2023-09-01    DOW  2023-09-01         neutral      Sell\n","9       Goldman Sachs_2023-09-01     GS  2023-09-01        positive      Sell\n","10         Home Depot_2023-09-01     HD  2023-09-01         neutral       Buy\n","11                IBM_2023-09-01    IBM  2023-09-01        positive      Sell\n","12              Intel_2023-09-01   INTC  2023-09-01        positive       Buy\n","13  Johnson & Johnson_2023-09-01    JNJ  2023-09-01        positive       Buy\n","14     JPMorgan Chase_2023-09-01    JPM  2023-09-01        positive      Sell\n","15          Coca-Cola_2023-09-01     KO  2023-09-01        positive       Buy\n","16          McDonalds_2023-09-01    MCD  2023-09-01        positive      Sell\n","17                 3M_2023-09-01    MMM  2023-09-01        positive      Sell\n","18              Merck_2023-09-01    MRK  2023-09-01         neutral      Sell\n","19          Microsoft_2023-09-01   MSFT  2023-09-01        positive      Sell\n","20               Nike_2023-09-01    NKE  2023-09-01        positive       Buy\n","21             Pfizer_2023-09-01    PFE  2023-09-01        positive      Sell\n","22   Procter & Gamble_2023-09-01     PG  2023-09-01        negative      Sell\n","23           Raytheon_2023-09-01    RTX  2023-09-01         neutral       Buy\n","24          Travelers_2023-09-01    TRV  2023-09-01        negative       Buy\n","25       UnitedHealth_2023-09-01    UNH  2023-09-01         neutral      Sell\n","26               Visa_2023-09-01      V  2023-09-01         neutral      Sell\n","27            Verizon_2023-09-01     VZ  2023-09-01        positive      Sell\n","28          Walgreens_2023-09-01    WBA  2023-09-01         neutral      Sell\n","29        Exxon Mobil_2023-09-01    XOM  2023-09-01         neutral       Buy"]},"metadata":{},"output_type":"display_data"}],"source":["merged_df = pd.merge(clean_stock_df, clean_result_df, how='inner', on='primary_key')\n","merged_df = merged_df[['primary_key', 'symbol', 'date', 'sentiment_score', 'stock_rec']]\n","display(merged_df)\n"]},{"cell_type":"code","execution_count":null,"metadata":{"cell_id":"baa9242e948b4952840e80be41843007","deepnote_app_block_visible":true,"deepnote_app_coordinates":{"h":5,"w":12,"x":0,"y":0},"deepnote_cell_type":"code","deepnote_table_invalid":false,"deepnote_table_loading":false,"deepnote_table_state":{"filters":[],"pageIndex":0,"pageSize":50,"sortBy":[]},"deepnote_to_be_reexecuted":false,"execution_millis":193,"execution_start":1696524910369,"source_hash":null},"outputs":[{"data":{"application/vnd.deepnote.dataframe.v3+json":{"column_count":6,"columns":[{"dtype":"object","name":"primary_key","stats":{"categories":[{"count":1,"name":"Apple_2023-09-01"},{"count":1,"name":"Amgen_2023-09-01"},{"count":28,"name":"28 others"}],"nan_count":0,"unique_count":30}},{"dtype":"object","name":"symbol","stats":{"categories":[{"count":1,"name":"AAPL"},{"count":1,"name":"AMGN"},{"count":28,"name":"28 others"}],"nan_count":0,"unique_count":30}},{"dtype":"object","name":"date","stats":{"categories":[{"count":30,"name":"2023-09-01"}],"nan_count":0,"unique_count":1}},{"dtype":"object","name":"sentiment_score","stats":{"categories":[{"count":16,"name":"positive"},{"count":11,"name":"neutral"},{"count":3,"name":"negative"}],"nan_count":0,"unique_count":3}},{"dtype":"object","name":"stock_rec","stats":{"categories":[{"count":18,"name":"Sell"},{"count":12,"name":"Buy"}],"nan_count":0,"unique_count":2}},{"dtype":"object","name":"total_rec","stats":{"categories":[{"count":12,"name":"Hold"},{"count":7,"name":"Sell"},{"count":11,"name":"3 others"}],"nan_count":0,"unique_count":5}},{"dtype":"int64","name":"_deepnote_index_column"}],"row_count":30,"rows":[{"_deepnote_index_column":0,"date":"2023-09-01","primary_key":"Apple_2023-09-01","sentiment_score":"positive","stock_rec":"Sell","symbol":"AAPL","total_rec":"Hold"},{"_deepnote_index_column":1,"date":"2023-09-01","primary_key":"Amgen_2023-09-01","sentiment_score":"positive","stock_rec":"Buy","symbol":"AMGN","total_rec":"Strong Buy"},{"_deepnote_index_column":2,"date":"2023-09-01","primary_key":"Boeing_2023-09-01","sentiment_score":"neutral","stock_rec":"Sell","symbol":"BA","total_rec":"Sell"},{"_deepnote_index_column":3,"date":"2023-09-01","primary_key":"Caterpillar_2023-09-01","sentiment_score":"negative","stock_rec":"Buy","symbol":"CAT","total_rec":"Hold"},{"_deepnote_index_column":4,"date":"2023-09-01","primary_key":"Salesforce_2023-09-01","sentiment_score":"positive","stock_rec":"Sell","symbol":"CRM","total_rec":"Hold"},{"_deepnote_index_column":5,"date":"2023-09-01","primary_key":"Cisco_2023-09-01","sentiment_score":"positive","stock_rec":"Buy","symbol":"CSCO","total_rec":"Strong Buy"},{"_deepnote_index_column":6,"date":"2023-09-01","primary_key":"Chevron_2023-09-01","sentiment_score":"neutral","stock_rec":"Buy","symbol":"CVX","total_rec":"Buy"},{"_deepnote_index_column":7,"date":"2023-09-01","primary_key":"Disney_2023-09-01","sentiment_score":"neutral","stock_rec":"Sell","symbol":"DIS","total_rec":"Sell"},{"_deepnote_index_column":8,"date":"2023-09-01","primary_key":"Dow Chemical_2023-09-01","sentiment_score":"neutral","stock_rec":"Sell","symbol":"DOW","total_rec":"Sell"},{"_deepnote_index_column":9,"date":"2023-09-01","primary_key":"Goldman Sachs_2023-09-01","sentiment_score":"positive","stock_rec":"Sell","symbol":"GS","total_rec":"Hold"},{"_deepnote_index_column":10,"date":"2023-09-01","primary_key":"Home Depot_2023-09-01","sentiment_score":"neutral","stock_rec":"Buy","symbol":"HD","total_rec":"Buy"},{"_deepnote_index_column":11,"date":"2023-09-01","primary_key":"IBM_2023-09-01","sentiment_score":"positive","stock_rec":"Sell","symbol":"IBM","total_rec":"Hold"},{"_deepnote_index_column":12,"date":"2023-09-01","primary_key":"Intel_2023-09-01","sentiment_score":"positive","stock_rec":"Buy","symbol":"INTC","total_rec":"Strong Buy"},{"_deepnote_index_column":13,"date":"2023-09-01","primary_key":"Johnson & Johnson_2023-09-01","sentiment_score":"positive","stock_rec":"Buy","symbol":"JNJ","total_rec":"Strong Buy"},{"_deepnote_index_column":14,"date":"2023-09-01","primary_key":"JPMorgan Chase_2023-09-01","sentiment_score":"positive","stock_rec":"Sell","symbol":"JPM","total_rec":"Hold"},{"_deepnote_index_column":15,"date":"2023-09-01","primary_key":"Coca-Cola_2023-09-01","sentiment_score":"positive","stock_rec":"Buy","symbol":"KO","total_rec":"Strong Buy"},{"_deepnote_index_column":16,"date":"2023-09-01","primary_key":"McDonalds_2023-09-01","sentiment_score":"positive","stock_rec":"Sell","symbol":"MCD","total_rec":"Hold"},{"_deepnote_index_column":17,"date":"2023-09-01","primary_key":"3M_2023-09-01","sentiment_score":"positive","stock_rec":"Sell","symbol":"MMM","total_rec":"Hold"},{"_deepnote_index_column":18,"date":"2023-09-01","primary_key":"Merck_2023-09-01","sentiment_score":"neutral","stock_rec":"Sell","symbol":"MRK","total_rec":"Sell"},{"_deepnote_index_column":19,"date":"2023-09-01","primary_key":"Microsoft_2023-09-01","sentiment_score":"positive","stock_rec":"Sell","symbol":"MSFT","total_rec":"Hold"},{"_deepnote_index_column":20,"date":"2023-09-01","primary_key":"Nike_2023-09-01","sentiment_score":"positive","stock_rec":"Buy","symbol":"NKE","total_rec":"Strong Buy"},{"_deepnote_index_column":21,"date":"2023-09-01","primary_key":"Pfizer_2023-09-01","sentiment_score":"positive","stock_rec":"Sell","symbol":"PFE","total_rec":"Hold"},{"_deepnote_index_column":22,"date":"2023-09-01","primary_key":"Procter & Gamble_2023-09-01","sentiment_score":"negative","stock_rec":"Sell","symbol":"PG","total_rec":"Strong Sell"},{"_deepnote_index_column":23,"date":"2023-09-01","primary_key":"Raytheon_2023-09-01","sentiment_score":"neutral","stock_rec":"Buy","symbol":"RTX","total_rec":"Buy"},{"_deepnote_index_column":24,"date":"2023-09-01","primary_key":"Travelers_2023-09-01","sentiment_score":"negative","stock_rec":"Buy","symbol":"TRV","total_rec":"Hold"},{"_deepnote_index_column":25,"date":"2023-09-01","primary_key":"UnitedHealth_2023-09-01","sentiment_score":"neutral","stock_rec":"Sell","symbol":"UNH","total_rec":"Sell"},{"_deepnote_index_column":26,"date":"2023-09-01","primary_key":"Visa_2023-09-01","sentiment_score":"neutral","stock_rec":"Sell","symbol":"V","total_rec":"Sell"},{"_deepnote_index_column":27,"date":"2023-09-01","primary_key":"Verizon_2023-09-01","sentiment_score":"positive","stock_rec":"Sell","symbol":"VZ","total_rec":"Hold"},{"_deepnote_index_column":28,"date":"2023-09-01","primary_key":"Walgreens_2023-09-01","sentiment_score":"neutral","stock_rec":"Sell","symbol":"WBA","total_rec":"Sell"},{"_deepnote_index_column":29,"date":"2023-09-01","primary_key":"Exxon Mobil_2023-09-01","sentiment_score":"neutral","stock_rec":"Buy","symbol":"XOM","total_rec":"Buy"}]},"text/html":["<div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>primary_key</th>\n","      <th>symbol</th>\n","      <th>date</th>\n","      <th>sentiment_score</th>\n","      <th>stock_rec</th>\n","      <th>total_rec</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>Apple_2023-09-01</td>\n","      <td>AAPL</td>\n","      <td>2023-09-01</td>\n","      <td>positive</td>\n","      <td>Sell</td>\n","      <td>Hold</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>Amgen_2023-09-01</td>\n","      <td>AMGN</td>\n","      <td>2023-09-01</td>\n","      <td>positive</td>\n","      <td>Buy</td>\n","      <td>Strong Buy</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>Boeing_2023-09-01</td>\n","      <td>BA</td>\n","      <td>2023-09-01</td>\n","      <td>neutral</td>\n","      <td>Sell</td>\n","      <td>Sell</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>Caterpillar_2023-09-01</td>\n","      <td>CAT</td>\n","      <td>2023-09-01</td>\n","      <td>negative</td>\n","      <td>Buy</td>\n","      <td>Hold</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>Salesforce_2023-09-01</td>\n","      <td>CRM</td>\n","      <td>2023-09-01</td>\n","      <td>positive</td>\n","      <td>Sell</td>\n","      <td>Hold</td>\n","    </tr>\n","    <tr>\n","      <th>5</th>\n","      <td>Cisco_2023-09-01</td>\n","      <td>CSCO</td>\n","      <td>2023-09-01</td>\n","      <td>positive</td>\n","      <td>Buy</td>\n","      <td>Strong Buy</td>\n","    </tr>\n","    <tr>\n","      <th>6</th>\n","      <td>Chevron_2023-09-01</td>\n","      <td>CVX</td>\n","      <td>2023-09-01</td>\n","      <td>neutral</td>\n","      <td>Buy</td>\n","      <td>Buy</td>\n","    </tr>\n","    <tr>\n","      <th>7</th>\n","      <td>Disney_2023-09-01</td>\n","      <td>DIS</td>\n","      <td>2023-09-01</td>\n","      <td>neutral</td>\n","      <td>Sell</td>\n","      <td>Sell</td>\n","    </tr>\n","    <tr>\n","      <th>8</th>\n","      <td>Dow Chemical_2023-09-01</td>\n","      <td>DOW</td>\n","      <td>2023-09-01</td>\n","      <td>neutral</td>\n","      <td>Sell</td>\n","      <td>Sell</td>\n","    </tr>\n","    <tr>\n","      <th>9</th>\n","      <td>Goldman Sachs_2023-09-01</td>\n","      <td>GS</td>\n","      <td>2023-09-01</td>\n","      <td>positive</td>\n","      <td>Sell</td>\n","      <td>Hold</td>\n","    </tr>\n","    <tr>\n","      <th>10</th>\n","      <td>Home Depot_2023-09-01</td>\n","      <td>HD</td>\n","      <td>2023-09-01</td>\n","      <td>neutral</td>\n","      <td>Buy</td>\n","      <td>Buy</td>\n","    </tr>\n","    <tr>\n","      <th>11</th>\n","      <td>IBM_2023-09-01</td>\n","      <td>IBM</td>\n","      <td>2023-09-01</td>\n","      <td>positive</td>\n","      <td>Sell</td>\n","      <td>Hold</td>\n","    </tr>\n","    <tr>\n","      <th>12</th>\n","      <td>Intel_2023-09-01</td>\n","      <td>INTC</td>\n","      <td>2023-09-01</td>\n","      <td>positive</td>\n","      <td>Buy</td>\n","      <td>Strong Buy</td>\n","    </tr>\n","    <tr>\n","      <th>13</th>\n","      <td>Johnson &amp; Johnson_2023-09-01</td>\n","      <td>JNJ</td>\n","      <td>2023-09-01</td>\n","      <td>positive</td>\n","      <td>Buy</td>\n","      <td>Strong Buy</td>\n","    </tr>\n","    <tr>\n","      <th>14</th>\n","      <td>JPMorgan Chase_2023-09-01</td>\n","      <td>JPM</td>\n","      <td>2023-09-01</td>\n","      <td>positive</td>\n","      <td>Sell</td>\n","      <td>Hold</td>\n","    </tr>\n","    <tr>\n","      <th>15</th>\n","      <td>Coca-Cola_2023-09-01</td>\n","      <td>KO</td>\n","      <td>2023-09-01</td>\n","      <td>positive</td>\n","      <td>Buy</td>\n","      <td>Strong Buy</td>\n","    </tr>\n","    <tr>\n","      <th>16</th>\n","      <td>McDonalds_2023-09-01</td>\n","      <td>MCD</td>\n","      <td>2023-09-01</td>\n","      <td>positive</td>\n","      <td>Sell</td>\n","      <td>Hold</td>\n","    </tr>\n","    <tr>\n","      <th>17</th>\n","      <td>3M_2023-09-01</td>\n","      <td>MMM</td>\n","      <td>2023-09-01</td>\n","      <td>positive</td>\n","      <td>Sell</td>\n","      <td>Hold</td>\n","    </tr>\n","    <tr>\n","      <th>18</th>\n","      <td>Merck_2023-09-01</td>\n","      <td>MRK</td>\n","      <td>2023-09-01</td>\n","      <td>neutral</td>\n","      <td>Sell</td>\n","      <td>Sell</td>\n","    </tr>\n","    <tr>\n","      <th>19</th>\n","      <td>Microsoft_2023-09-01</td>\n","      <td>MSFT</td>\n","      <td>2023-09-01</td>\n","      <td>positive</td>\n","      <td>Sell</td>\n","      <td>Hold</td>\n","    </tr>\n","    <tr>\n","      <th>20</th>\n","      <td>Nike_2023-09-01</td>\n","      <td>NKE</td>\n","      <td>2023-09-01</td>\n","      <td>positive</td>\n","      <td>Buy</td>\n","      <td>Strong Buy</td>\n","    </tr>\n","    <tr>\n","      <th>21</th>\n","      <td>Pfizer_2023-09-01</td>\n","      <td>PFE</td>\n","      <td>2023-09-01</td>\n","      <td>positive</td>\n","      <td>Sell</td>\n","      <td>Hold</td>\n","    </tr>\n","    <tr>\n","      <th>22</th>\n","      <td>Procter &amp; Gamble_2023-09-01</td>\n","      <td>PG</td>\n","      <td>2023-09-01</td>\n","      <td>negative</td>\n","      <td>Sell</td>\n","      <td>Strong Sell</td>\n","    </tr>\n","    <tr>\n","      <th>23</th>\n","      <td>Raytheon_2023-09-01</td>\n","      <td>RTX</td>\n","      <td>2023-09-01</td>\n","      <td>neutral</td>\n","      <td>Buy</td>\n","      <td>Buy</td>\n","    </tr>\n","    <tr>\n","      <th>24</th>\n","      <td>Travelers_2023-09-01</td>\n","      <td>TRV</td>\n","      <td>2023-09-01</td>\n","      <td>negative</td>\n","      <td>Buy</td>\n","      <td>Hold</td>\n","    </tr>\n","    <tr>\n","      <th>25</th>\n","      <td>UnitedHealth_2023-09-01</td>\n","      <td>UNH</td>\n","      <td>2023-09-01</td>\n","      <td>neutral</td>\n","      <td>Sell</td>\n","      <td>Sell</td>\n","    </tr>\n","    <tr>\n","      <th>26</th>\n","      <td>Visa_2023-09-01</td>\n","      <td>V</td>\n","      <td>2023-09-01</td>\n","      <td>neutral</td>\n","      <td>Sell</td>\n","      <td>Sell</td>\n","    </tr>\n","    <tr>\n","      <th>27</th>\n","      <td>Verizon_2023-09-01</td>\n","      <td>VZ</td>\n","      <td>2023-09-01</td>\n","      <td>positive</td>\n","      <td>Sell</td>\n","      <td>Hold</td>\n","    </tr>\n","    <tr>\n","      <th>28</th>\n","      <td>Walgreens_2023-09-01</td>\n","      <td>WBA</td>\n","      <td>2023-09-01</td>\n","      <td>neutral</td>\n","      <td>Sell</td>\n","      <td>Sell</td>\n","    </tr>\n","    <tr>\n","      <th>29</th>\n","      <td>Exxon Mobil_2023-09-01</td>\n","      <td>XOM</td>\n","      <td>2023-09-01</td>\n","      <td>neutral</td>\n","      <td>Buy</td>\n","      <td>Buy</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["                     primary_key symbol        date sentiment_score stock_rec  \\\n","0               Apple_2023-09-01   AAPL  2023-09-01        positive      Sell   \n","1               Amgen_2023-09-01   AMGN  2023-09-01        positive       Buy   \n","2              Boeing_2023-09-01     BA  2023-09-01         neutral      Sell   \n","3         Caterpillar_2023-09-01    CAT  2023-09-01        negative       Buy   \n","4          Salesforce_2023-09-01    CRM  2023-09-01        positive      Sell   \n","5               Cisco_2023-09-01   CSCO  2023-09-01        positive       Buy   \n","6             Chevron_2023-09-01    CVX  2023-09-01         neutral       Buy   \n","7              Disney_2023-09-01    DIS  2023-09-01         neutral      Sell   \n","8        Dow Chemical_2023-09-01    DOW  2023-09-01         neutral      Sell   \n","9       Goldman Sachs_2023-09-01     GS  2023-09-01        positive      Sell   \n","10         Home Depot_2023-09-01     HD  2023-09-01         neutral       Buy   \n","11                IBM_2023-09-01    IBM  2023-09-01        positive      Sell   \n","12              Intel_2023-09-01   INTC  2023-09-01        positive       Buy   \n","13  Johnson & Johnson_2023-09-01    JNJ  2023-09-01        positive       Buy   \n","14     JPMorgan Chase_2023-09-01    JPM  2023-09-01        positive      Sell   \n","15          Coca-Cola_2023-09-01     KO  2023-09-01        positive       Buy   \n","16          McDonalds_2023-09-01    MCD  2023-09-01        positive      Sell   \n","17                 3M_2023-09-01    MMM  2023-09-01        positive      Sell   \n","18              Merck_2023-09-01    MRK  2023-09-01         neutral      Sell   \n","19          Microsoft_2023-09-01   MSFT  2023-09-01        positive      Sell   \n","20               Nike_2023-09-01    NKE  2023-09-01        positive       Buy   \n","21             Pfizer_2023-09-01    PFE  2023-09-01        positive      Sell   \n","22   Procter & Gamble_2023-09-01     PG  2023-09-01        negative      Sell   \n","23           Raytheon_2023-09-01    RTX  2023-09-01         neutral       Buy   \n","24          Travelers_2023-09-01    TRV  2023-09-01        negative       Buy   \n","25       UnitedHealth_2023-09-01    UNH  2023-09-01         neutral      Sell   \n","26               Visa_2023-09-01      V  2023-09-01         neutral      Sell   \n","27            Verizon_2023-09-01     VZ  2023-09-01        positive      Sell   \n","28          Walgreens_2023-09-01    WBA  2023-09-01         neutral      Sell   \n","29        Exxon Mobil_2023-09-01    XOM  2023-09-01         neutral       Buy   \n","\n","      total_rec  \n","0          Hold  \n","1    Strong Buy  \n","2          Sell  \n","3          Hold  \n","4          Hold  \n","5    Strong Buy  \n","6           Buy  \n","7          Sell  \n","8          Sell  \n","9          Hold  \n","10          Buy  \n","11         Hold  \n","12   Strong Buy  \n","13   Strong Buy  \n","14         Hold  \n","15   Strong Buy  \n","16         Hold  \n","17         Hold  \n","18         Sell  \n","19         Hold  \n","20   Strong Buy  \n","21         Hold  \n","22  Strong Sell  \n","23          Buy  \n","24         Hold  \n","25         Sell  \n","26         Sell  \n","27         Hold  \n","28         Sell  \n","29          Buy  "]},"metadata":{},"output_type":"display_data"}],"source":["def total_rec(row):\n","    if row['stock_rec'] == 'Buy' and row['sentiment_score']=='positive':\n","        return \"Strong Buy\"\n","    elif row['stock_rec'] == 'Buy' and row['sentiment_score']=='neutral':\n","        return \"Buy\"\n","    elif row['stock_rec'] == 'Buy' and row['sentiment_score']=='negative':\n","        return \"Hold\"\n","    elif row['stock_rec'] == 'Sell' and row['sentiment_score']=='positive':\n","        return \"Hold\"\n","    elif row['stock_rec'] == 'Sell' and row['sentiment_score']=='neutral':\n","        return \"Sell\"    \n","    else:\n","        return \"Strong Sell\" \n","\n","merged_df['total_rec'] = merged_df.apply(total_rec, axis=1)  \n","display(merged_df)"]},{"cell_type":"markdown","metadata":{"created_in_deepnote_cell":true,"deepnote_cell_type":"markdown"},"source":["<a style='text-decoration:none;line-height:16px;display:flex;color:#5B5B62;padding:10px;justify-content:end;' href='https://deepnote.com?utm_source=created-in-deepnote-cell&projectId=f872869b-62ce-4c14-91be-a1c997c72366' target=\"_blank\">\n","<img alt='Created in deepnote.com' style='display:inline;max-height:16px;margin:0px;margin-right:7.5px;' src='data:image/svg+xml;base64,PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiPz4KPHN2ZyB3aWR0aD0iODBweCIgaGVpZ2h0PSI4MHB4IiB2aWV3Qm94PSIwIDAgODAgODAiIHZlcnNpb249IjEuMSIgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIiB4bWxuczp4bGluaz0iaHR0cDovL3d3dy53My5vcmcvMTk5OS94bGluayI+CiAgICA8IS0tIEdlbmVyYXRvcjogU2tldGNoIDU0LjEgKDc2NDkwKSAtIGh0dHBzOi8vc2tldGNoYXBwLmNvbSAtLT4KICAgIDx0aXRsZT5Hcm91cCAzPC90aXRsZT4KICAgIDxkZXNjPkNyZWF0ZWQgd2l0aCBTa2V0Y2guPC9kZXNjPgogICAgPGcgaWQ9IkxhbmRpbmciIHN0cm9rZT0ibm9uZSIgc3Ryb2tlLXdpZHRoPSIxIiBmaWxsPSJub25lIiBmaWxsLXJ1bGU9ImV2ZW5vZGQiPgogICAgICAgIDxnIGlkPSJBcnRib2FyZCIgdHJhbnNmb3JtPSJ0cmFuc2xhdGUoLTEyMzUuMDAwMDAwLCAtNzkuMDAwMDAwKSI+CiAgICAgICAgICAgIDxnIGlkPSJHcm91cC0zIiB0cmFuc2Zvcm09InRyYW5zbGF0ZSgxMjM1LjAwMDAwMCwgNzkuMDAwMDAwKSI+CiAgICAgICAgICAgICAgICA8cG9seWdvbiBpZD0iUGF0aC0yMCIgZmlsbD0iIzAyNjVCNCIgcG9pbnRzPSIyLjM3NjIzNzYyIDgwIDM4LjA0NzY2NjcgODAgNTcuODIxNzgyMiA3My44MDU3NTkyIDU3LjgyMTc4MjIgMzIuNzU5MjczOSAzOS4xNDAyMjc4IDMxLjY4MzE2ODMiPjwvcG9seWdvbj4KICAgICAgICAgICAgICAgIDxwYXRoIGQ9Ik0zNS4wMDc3MTgsODAgQzQyLjkwNjIwMDcsNzYuNDU0OTM1OCA0Ny41NjQ5MTY3LDcxLjU0MjI2NzEgNDguOTgzODY2LDY1LjI2MTk5MzkgQzUxLjExMjI4OTksNTUuODQxNTg0MiA0MS42NzcxNzk1LDQ5LjIxMjIyODQgMjUuNjIzOTg0Niw0OS4yMTIyMjg0IEMyNS40ODQ5Mjg5LDQ5LjEyNjg0NDggMjkuODI2MTI5Niw0My4yODM4MjQ4IDM4LjY0NzU4NjksMzEuNjgzMTY4MyBMNzIuODcxMjg3MSwzMi41NTQ0MjUgTDY1LjI4MDk3Myw2Ny42NzYzNDIxIEw1MS4xMTIyODk5LDc3LjM3NjE0NCBMMzUuMDA3NzE4LDgwIFoiIGlkPSJQYXRoLTIyIiBmaWxsPSIjMDAyODY4Ij48L3BhdGg+CiAgICAgICAgICAgICAgICA8cGF0aCBkPSJNMCwzNy43MzA0NDA1IEwyNy4xMTQ1MzcsMC4yNTcxMTE0MzYgQzYyLjM3MTUxMjMsLTEuOTkwNzE3MDEgODAsMTAuNTAwMzkyNyA4MCwzNy43MzA0NDA1IEM4MCw2NC45NjA0ODgyIDY0Ljc3NjUwMzgsNzkuMDUwMzQxNCAzNC4zMjk1MTEzLDgwIEM0Ny4wNTUzNDg5LDc3LjU2NzA4MDggNTMuNDE4MjY3Nyw3MC4zMTM2MTAzIDUzLjQxODI2NzcsNTguMjM5NTg4NSBDNTMuNDE4MjY3Nyw0MC4xMjg1NTU3IDM2LjMwMzk1NDQsMzcuNzMwNDQwNSAyNS4yMjc0MTcsMzcuNzMwNDQwNSBDMTcuODQzMDU4NiwzNy43MzA0NDA1IDkuNDMzOTE5NjYsMzcuNzMwNDQwNSAwLDM3LjczMDQ0MDUgWiIgaWQ9IlBhdGgtMTkiIGZpbGw9IiMzNzkzRUYiPjwvcGF0aD4KICAgICAgICAgICAgPC9nPgogICAgICAgIDwvZz4KICAgIDwvZz4KPC9zdmc+' > </img>\n","Created in <span style='font-weight:600;margin-left:4px;'>Deepnote</span></a>"]}],"metadata":{"deepnote_app_clear_outputs":false,"deepnote_app_execution_enabled":false,"deepnote_app_layout":"powerful-article","deepnote_app_run_on_input_enabled":true,"deepnote_app_table_of_contents_enabled":true,"deepnote_app_width":"full-width","deepnote_execution_queue":[],"deepnote_notebook_id":"0d68b46f16ae450aab91f5b51bf1bbc8","deepnote_persisted_session":{"createdAt":"2023-10-05T17:17:51.730Z"},"language_info":{"name":"python"}},"nbformat":4,"nbformat_minor":0}