S&P-500 Stock Market Exhaustive Dataset

Feel free to experiment with data carefully preprocessed from year 2000-2022

@kaggle.sandeepkumarkushwaha_sp500_stock_market_latest_exhaustive

Table List

1 table(777.39 KB)

Sp500 Exhaustivedata

@kaggle.sandeepkumarkushwaha_sp500_stock_market_latest_exhaustive.sp500_exhaustivedata

777.39 KB
5601 rows
26 columns

date Date	openprice OpenPrice	highprice HighPrice	lowprice LowPrice	closedprice ClosedPrice	adjustedclosedprice AdjustedClosedPrice	volumeoftransactions VolumeOfTransactions	opn1p_open_price_next_1_period OPN1P Open Price Next 1 Period	hpn1p_high_price_next_1_period HPN1P High Price Next 1 Period	lpn1p_low_price_next_1_period LPN1P Low Price Next 1 Period	cpn1p_close_price_next_1_period CPN1P Close Price Next 1 Period	close_price_next_2_periods Close Price Next 2 Periods	cpn3p_close_price_next_3_periods CPN3P Close Price Next 3 Periods	cpn4p_close_price_next_4_periods CPN4P Close Price Next 4 Periods	cpn5p_close_price_next_5_periods CPN5P Close Price Next 5 Periods	apn5p_average_price_next_5_periods APN5P Average Price Next 5 Periods	apn10p_average_price_next_10_periods APN10P Average Price Next 10 Periods	lpn5p_lowest_price_next_5_periods LPN5P Lowest Price Next 5 Periods	mpn5p_median_price_next_5_periods MPN5P Median Price Next 5 Periods	hpn5p_highest_price_next_5_periods HPN5P Highest Price Next 5 Periods	lpn10p_lowest_price_next_10_periods LPN10P Lowest Price Next 10 Periods	mpn10p_median_price_next_10_periods MPN10P Median Price Next 10 Periods	hpn10p_highest_price_next_10_periods HPN10P Highest Price Next 10 Periods	lpn20p_lowest_price_next_20_periods LPN20P Lowest Price Next 20 Periods	mpn20p_median_price_next_20_periods MPN20P Median Price Next 20 Periods	hpn20p_highest_price_next_20_periods HPN20P Highest Price Next 20 Periods
03-01-2000	1469.25	1478	1438.36	1455.22	1455.22	931800000	1455.22	1455.22	1397.43	1399.42	1402.11	1403.45	1441.47	1457.6	1420.07	1434.34	1377.68	1411.9	1464.36	1377.68	1441.47	1473	1350.14	1429.66	1473
04-01-2000	1455.22	1455.22	1397.43	1399.42	1399.42	1009000000	1399.42	1413.27	1377.68	1402.11	1403.45	1441.47	1457.6	1438.56	1424.16	1437.19	1377.68	1421.78	1464.36	1377.68	1441.78	1473	1350.14	1422.44	1473
05-01-2000	1399.42	1413.27	1377.68	1402.11	1402.11	1085500000	1402.11	1411.9	1392.1	1403.45	1441.47	1457.6	1438.56	1432.25	1431.57	1442.52	1392.1	1438.56	1464.36	1392.1	1448	1473	1350.14	1425.38	1473
06-01-2000	1402.11	1411.9	1392.1	1403.45	1403.45	1092300000	1403.45	1441.47	1400.73	1441.47	1457.6	1438.56	1432.25	1449.68	1439.51	1446.77	1400.73	1441.47	1464.36	1400.73	1449.18	1473	1350.14	1426.77	1473
07-01-2000	1403.45	1441.47	1400.73	1441.47	1441.47	1225200000	1441.47	1464.36	1441.47	1457.6	1438.56	1432.25	1449.68	1465.15	1447.03	1446.91	1427.08	1447.31	1473	1395.42	1449.68	1473	1350.14	1426.13	1473
10-01-2000	1441.47	1464.36	1441.47	1457.6	1457.6	1064800000	1457.6	1458.66	1434.42	1438.56	1432.25	1449.68	1465.15	1455.14	1448.62	1442.14	1427.08	1449.68	1473	1388.49	1446.44	1473	1350.14	1424.97	1473
11-01-2000	1457.6	1458.66	1434.42	1438.56	1438.56	1014000000	1438.56	1442.6	1427.08	1432.25	1449.68	1465.15	1455.14	1455.9	1450.21	1438.08	1427.08	1451.3	1473	1388.49	1443.76	1473	1350.14	1424.37	1473
12-01-2000	1438.56	1442.6	1427.08	1432.25	1432.25	974600000	1432.25	1454.2	1432.25	1449.68	1465.15	1455.14	1455.9	1445.57	1453.47	1434.38	1432.25	1455.14	1473	1370.99	1443.51	1473	1350.14	1422.69	1473
13-01-2000	1432.25	1454.2	1432.25	1449.68	1449.68	1030400000	1449.68	1473	1449.68	1465.15	1455.14	1455.9	1445.57	1441.36	1454.04	1428.01	1438.54	1455.14	1473	1356.2	1440.48	1473	1350.14	1417.84	1473
14-01-2000	1449.68	1473	1449.68	1465.15	1465.15	1085900000	1465.15	1465.15	1451.3	1455.14	1455.9	1445.57	1441.36	1401.53	1446.78	1419.56	1395.42	1451.43	1465.71	1350.14	1413.49	1465.71	1350.14	1414.26	1465.71


CREATE TABLE sp500_exhaustivedata (
  "date" VARCHAR,
  "openprice" DOUBLE,
  "highprice" DOUBLE,
  "lowprice" DOUBLE,
  "closedprice" DOUBLE,
  "adjustedclosedprice" DOUBLE,
  "volumeoftransactions" BIGINT,
  "opn1p_open_price_next_1_period" DOUBLE,
  "hpn1p_high_price_next_1_period" DOUBLE,
  "lpn1p_low_price_next_1_period" DOUBLE,
  "cpn1p_close_price_next_1_period" DOUBLE,
  "close_price_next_2_periods" DOUBLE,
  "cpn3p_close_price_next_3_periods" DOUBLE,
  "cpn4p_close_price_next_4_periods" DOUBLE,
  "cpn5p_close_price_next_5_periods" DOUBLE,
  "apn5p_average_price_next_5_periods" DOUBLE,
  "apn10p_average_price_next_10_periods" DOUBLE,
  "lpn5p_lowest_price_next_5_periods" DOUBLE,
  "mpn5p_median_price_next_5_periods" DOUBLE,
  "hpn5p_highest_price_next_5_periods" DOUBLE,
  "lpn10p_lowest_price_next_10_periods" DOUBLE,
  "mpn10p_median_price_next_10_periods" DOUBLE,
  "hpn10p_highest_price_next_10_periods" DOUBLE,
  "lpn20p_lowest_price_next_20_periods" DOUBLE,
  "mpn20p_median_price_next_20_periods" DOUBLE,
  "hpn20p_highest_price_next_20_periods" DOUBLE
);