Git Product home page Git Product logo

amazon-stock-analysis-msexcel-db's Introduction

Amazon-Stock-Analysis-MSExcel-DB

About Amazon

Amazon.com, Inc. is an American multinational technology company that focuses on e-commerce, cloud computing, digital streaming, and artificial intelligence. It is one of the Big Five companies in the U.S. information technology industry, along with Google, Apple, Microsoft, and Facebook. The company has been referred to as "one of the most influential economic and cultural forces in the world," as well as the world's most valuable brand.

About the Dataset

The dataset provides historical data at the daily level from December 2020 to November 2021. Their columns include the following:

  • Date : Date the data was recorded
  • Open : Price from the first transaction of a trading day
  • High : Maximum price in a trading day
  • Low : Minimum price in a trading day
  • Close : Price from the last transaction of a trading day
  • Volume : Number of units traded in a day

All displayed currencies are in USD.

Analysis Derived from the Dataset

  • On any given day, the company's value is just as likely to increase as it is to decrease.

  • July 2021 had the highest Average Closing Value

  • There is a very strong linear relationship between the daily High and Low values. As one variable increases/decreases, so does the other. With an R-squared value very close to 1, almost all the variability in one variable can be explained by the variability in the other.

  • Half of the time, the number of units traded in a day was roughly between 1.5 and 3.0 million and the other half of the time, roughly between 3.0 and 10.0 million units were traded. Usually, 5.7 milllion or fewer units were traded in a day but one day in the year saw as many as 10 million units traded.

  • Maximum trading occurred on 30th July 2021 with approximately 9.96 million units traded that day. Minimum trading occurred on 24th December 2020 with approximately 1.45 million units traded that day. There does not seem to be any particular pattern with respect to the number of units being traded throughout the year. Most days see the trading of between 2 and 6 million units. The number of Amazon units traded dropped from 9.96 million to 2.18 million from 30th July 2021 to 4th August 2021.

  • Although it's not always perfect, there does appear to be a relationship between the daily High-Low difference and the number of units traded. Loosely speaking, when the High-Low difference is larger, more units are traded. Conversely, when the High-Low difference is smaller, fewer units are traded.

amazon-stock-analysis-msexcel-db's People

Contributors

varshaa-t avatar

Stargazers

 avatar  avatar

Watchers

 avatar

Forkers

defuze2605

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.