Name: Amazon Market Data In 21st Century
Creator: Kaggle
License: https://opensource.org/licenses/MIT

About this Dataset

Amazon Market Data In 21st Century

In this dataset, each year's data was separated by with csv files. There are data from 2000 to 2023. Here is the list of the features:

datetime
open
high
low
close
volume

Also, for better results, day of the week info can be gained through datetime feature

Tables

Amazon2000

@kaggle.renjiabarai_amazon_market_data_in_21st_century.amazon2000

13.37 KB
243 rows
6 columns


CREATE TABLE amazon2000 (
  "datetime" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT
);

Amazon2001

@kaggle.renjiabarai_amazon_market_data_in_21st_century.amazon2001

13.77 KB
239 rows
6 columns


CREATE TABLE amazon2001 (
  "datetime" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT
);

Amazon2002

@kaggle.renjiabarai_amazon_market_data_in_21st_century.amazon2002

13.91 KB
243 rows
6 columns


CREATE TABLE amazon2002 (
  "datetime" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT
);

Amazon2003

@kaggle.renjiabarai_amazon_market_data_in_21st_century.amazon2003

14.62 KB
242 rows
6 columns


CREATE TABLE amazon2003 (
  "datetime" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT
);

Amazon2004

@kaggle.renjiabarai_amazon_market_data_in_21st_century.amazon2004

14.68 KB
244 rows
6 columns


CREATE TABLE amazon2004 (
  "datetime" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT
);

Amazon2005

@kaggle.renjiabarai_amazon_market_data_in_21st_century.amazon2005

14.43 KB
242 rows
6 columns


CREATE TABLE amazon2005 (
  "datetime" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT
);

Amazon2006

@kaggle.renjiabarai_amazon_market_data_in_21st_century.amazon2006

14.46 KB
242 rows
6 columns


CREATE TABLE amazon2006 (
  "datetime" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT
);

Amazon2007

@kaggle.renjiabarai_amazon_market_data_in_21st_century.amazon2007

14.69 KB
242 rows
6 columns


CREATE TABLE amazon2007 (
  "datetime" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT
);

Amazon2008

@kaggle.renjiabarai_amazon_market_data_in_21st_century.amazon2008

14.81 KB
243 rows
6 columns


CREATE TABLE amazon2008 (
  "datetime" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT
);

Amazon2009

@kaggle.renjiabarai_amazon_market_data_in_21st_century.amazon2009

15.02 KB
243 rows
6 columns


CREATE TABLE amazon2009 (
  "datetime" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT
);

Amazon2010

@kaggle.renjiabarai_amazon_market_data_in_21st_century.amazon2010

14.88 KB
244 rows
6 columns


CREATE TABLE amazon2010 (
  "datetime" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT
);

Amazon2011

@kaggle.renjiabarai_amazon_market_data_in_21st_century.amazon2011

14.94 KB
242 rows
6 columns


CREATE TABLE amazon2011 (
  "datetime" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT
);

Amazon2012

@kaggle.renjiabarai_amazon_market_data_in_21st_century.amazon2012

14.93 KB
241 rows
6 columns


CREATE TABLE amazon2012 (
  "datetime" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT
);

Amazon2013

@kaggle.renjiabarai_amazon_market_data_in_21st_century.amazon2013

15.07 KB
243 rows
6 columns


CREATE TABLE amazon2013 (
  "datetime" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT
);

Amazon2014

@kaggle.renjiabarai_amazon_market_data_in_21st_century.amazon2014

15.07 KB
242 rows
6 columns


CREATE TABLE amazon2014 (
  "datetime" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT
);

Amazon2015

@kaggle.renjiabarai_amazon_market_data_in_21st_century.amazon2015

15.36 KB
243 rows
6 columns


CREATE TABLE amazon2015 (
  "datetime" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT
);

Amazon2016

@kaggle.renjiabarai_amazon_market_data_in_21st_century.amazon2016

15.06 KB
243 rows
6 columns


CREATE TABLE amazon2016 (
  "datetime" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT
);

Amazon2017

@kaggle.renjiabarai_amazon_market_data_in_21st_century.amazon2017

15.06 KB
242 rows
6 columns


CREATE TABLE amazon2017 (
  "datetime" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT
);

Amazon2018

@kaggle.renjiabarai_amazon_market_data_in_21st_century.amazon2018

15.2 KB
242 rows
6 columns


CREATE TABLE amazon2018 (
  "datetime" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT
);

Amazon2019

@kaggle.renjiabarai_amazon_market_data_in_21st_century.amazon2019

14.86 KB
243 rows
6 columns


CREATE TABLE amazon2019 (
  "datetime" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT
);

Amazon2020

@kaggle.renjiabarai_amazon_market_data_in_21st_century.amazon2020

15.17 KB
243 rows
6 columns


CREATE TABLE amazon2020 (
  "datetime" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT
);

Amazon2021

@kaggle.renjiabarai_amazon_market_data_in_21st_century.amazon2021

15.08 KB
244 rows
6 columns


CREATE TABLE amazon2021 (
  "datetime" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT
);

Amazon2022

@kaggle.renjiabarai_amazon_market_data_in_21st_century.amazon2022

14.68 KB
241 rows
6 columns


CREATE TABLE amazon2022 (
  "datetime" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT
);

Amazon2023

@kaggle.renjiabarai_amazon_market_data_in_21st_century.amazon2023

13.89 KB
241 rows
6 columns


CREATE TABLE amazon2023 (
  "datetime" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT
);