Stock Market Analysis

Quantitative Analysis of Stock Market

@kaggle.thesnak_stock_market_analysis

Table List

1 table(16.36 KB)

Stocks

@kaggle.thesnak_stock_market_analysis.stocks

16.36 KB
248 rows
8 columns

ticker Ticker	date Date	open Open	high High	low Low	close Close	adj_close Adj Close	volume Volume
AAPL	Tue Feb 07 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	150.63999938964844	155.22999572753906	150.63999938964844	154.64999389648438	154.4142303466797	83322600
AAPL	Wed Feb 08 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	153.8800048828125	154.5800018310547	151.1699981689453	151.9199981689453	151.6884002685547	64120100
AAPL	Thu Feb 09 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	153.77999877929688	154.3300018310547	150.4199981689453	150.8699951171875	150.63999938964844	56007100
AAPL	Fri Feb 10 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	149.4600067138672	151.33999633789062	149.22000122070312	151.00999450683594	151.00999450683594	57450700
AAPL	Mon Feb 13 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	150.9499969482422	154.25999450683594	150.9199981689453	153.85000610351562	153.85000610351562	62199000
AAPL	Tue Feb 14 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	152.1199951171875	153.77000427246094	150.86000061035156	153.1999969482422	153.1999969482422	61707600
AAPL	Wed Feb 15 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	153.11000061035156	155.5	152.8800048828125	155.3300018310547	155.3300018310547	65573800
AAPL	Thu Feb 16 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	153.50999450683594	156.3300018310547	153.35000610351562	153.7100067138672	153.7100067138672	68167900
AAPL	Fri Feb 17 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	152.35000610351562	153	150.85000610351562	152.5500030517578	152.5500030517578	59144100
AAPL	Tue Feb 21 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	150.1999969482422	151.3000030517578	148.41000366210938	148.47999572753906	148.47999572753906	58867200


CREATE TABLE stocks (
  "ticker" VARCHAR,
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "adj_close" DOUBLE,
  "volume" BIGINT
);