Google Historical Stock Prices

Analyzing Historical Stock Data: Price Trends, Volume, and Corporate Actions

@kaggle.yaminh_google_historical_stock_prices

Table List

1 table(93.89 KB)

Google Stock

@kaggle.yaminh_google_historical_stock_prices.google_stock

93.89 KB
1258 rows
13 columns

date Date	close Close	adjclose AdjClose	high High	adjhigh AdjHigh	low Low	adjlow AdjLow	open Open	adjopen AdjOpen	volume Volume	adjvolume AdjVolume	splitfactor SplitFactor
2018-09-05 00:00:00+00:00	1186.48	1186.48	1199.01	1199.01	1162	1162	1193.8	1193.8	2061309	2061309	1
2016-11-04 00:00:00+00:00	762.02	762.02	770.36	770.36	750.5611	750.5611	750.66	750.66	2134812	2134812	1
2016-08-25 00:00:00+00:00	769.41	769.41	771.89	771.89	763.1846	763.1846	767	767	926883	926883	1
2016-09-13 00:00:00+00:00	759.69	759.69	766.2195	766.2195	755.8	755.8	764.48	764.48	1395046	1395046	1
2020-09-17 00:00:00+00:00	1495.53	1495.53	1508.2984	1508.2984	1470.0001	1470.0001	1496	1496	1879751	1879751	1
2018-02-20 00:00:00+00:00	1102.46	1102.46	1113.95	1113.95	1088.52	1088.52	1090.57	1090.57	1381603	1381603	1
2019-08-08 00:00:00+00:00	1204.8	1204.8	1205.01	1205.01	1173.02	1173.02	1182.83	1182.83	1467997	1467997	1
2020-08-07 00:00:00+00:00	1494.49	1494.49	1516.845	1516.845	1481.64	1481.64	1500	1500	1577826	1577826	1
2020-12-28 00:00:00+00:00	1776.09	1776.09	1790.7276	1790.7276	1746.335	1746.335	1751.635	1751.635	1390962	1390962	1
2020-07-28 00:00:00+00:00	1500.34	1500.34	1526.48	1526.48	1497.66	1497.66	1525.18	1525.18	1702174	1702174	1


CREATE TABLE google_stock (
  "date" VARCHAR,
  "close" DOUBLE,
  "adjclose" DOUBLE,
  "high" DOUBLE,
  "adjhigh" DOUBLE,
  "low" DOUBLE,
  "adjlow" DOUBLE,
  "open" DOUBLE,
  "adjopen" DOUBLE,
  "volume" BIGINT,
  "adjvolume" BIGINT,
  "divcash" BIGINT,
  "splitfactor" BIGINT
);