Microsoft Vs Apple: Stock Performance

Exploring the Stock Prices and Growth Trends of Two Tech Giants Over Time

@kaggle.prathamjyotsingh_microsoft_vs_apple_stock_performance

Table List

6 tables(480.68 KB)

Aapl Stock Price

@kaggle.prathamjyotsingh_microsoft_vs_apple_stock_performance.aapl_stock_price

242.81 KB
6281 rows
6 columns

date Date	open_price Open Price	high_price High Price	low_price Low Price	close_price Close Price	volume Volume
Mon Nov 01 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	80	80.69	77.37	77.62	2487300
Tue Nov 02 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	78	81.69	77.31	80.25	3564600
Wed Nov 03 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	81.62	83.25	81	81.5	2932700
Thu Nov 04 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	82.06	85.37	80.62	83.62	3384700
Fri Nov 05 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	84.62	88.37	84	88.31	3721500
Mon Nov 08 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	87.75	97.73	86.75	96.37	8490400
Tue Nov 09 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	94.37	94.5	88	89.62	7224800
Wed Nov 10 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	88.25	93.25	88.12	91.44	5159800
Thu Nov 11 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	91.59	92.62	89.87	92.25	2409600
Fri Nov 12 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	91.94	92	87.37	90.62	2491600


CREATE TABLE aapl_stock_price (
  "date" TIMESTAMP,
  "open_price" DOUBLE,
  "high_price" DOUBLE,
  "low_price" DOUBLE,
  "close_price" DOUBLE,
  "volume" DOUBLE
);