PREVIEW / stock_daily / 2000-10-17

all stock daily files

  file:    by_date/stock_daily/2000/2000-10-17.parquet
  size:    90 KB
  rows:    2,867
  symbols: 1,787

schema

  date         DATE
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

date	symbol	asset_type	open	high	low	close	volume
2000-10-17	AAPL	Stock	0.3873	0.3917	0.3516	0.3594	601720000.0
2000-10-17	MSFT	Stock	25.9375	26.2188	25.125	25.2188	81276600.0
2000-10-17	NVDA	Stock	0.2641	0.2651	0.243	0.2458	463248000.0
2000-10-17	AMZN	Stock	1.2438	1.2594	1.0438	1.0969	302810000.0
2000-10-17	CL	Stock	25.525	25.725	25.375	25.45	3330400.0
2000-10-17	A	Stock	33.3065	33.3512	30.49	30.9818	2883235.0
2000-10-17	AABA-DELISTED	Stock	27.96875	28.0625	23.71875	24.46875	58899000.0
2000-10-17	AAI-DELISTED	Stock	4.31	4.44	4.25	4.25	195200.0
2000-10-17	AAIC-DELISTED	Stock	155.0	155.0	143.75	145.0	15500.0
2000-10-17	AAME	Stock	2.0	2.0	2.0	2.0	3900.0
2000-10-17	AAON	Stock	1.3461	1.3535	1.3352	1.3388	119602.0
2000-10-17	ABAX-DELISTED	Stock	5.875	6.0	5.5	5.5625	67100.0
2000-10-17	ABC-DELISTED	Stock	11.265625	11.5625	11.125	11.5	1056800.0
2000-10-17	ABCB	Stock	7.2948	7.2948	7.2948	7.2948	247.0
2000-10-17	ABCW-DELISTED	Stock	14.63	14.81	14.06	14.06	15100.0
2000-10-17	ABE-DELISTED	Stock	11.625	11.75	11.625	11.625	44300.0
2000-10-17	ABFS-DELISTED	Stock	15.3125	15.4375	14.6875	14.6875	155700.0
2000-10-17	ABK-DELISTED	Stock	73.0	74.19	71.63	72.94	418400.0
2000-10-17	ABM	Stock	12.8438	12.9062	12.7812	12.8438	45400.0
2000-10-17	ABMD-DELISTED	Stock	33.5	33.5	30.125	31.875	142800.0
2000-10-17	ABP-DELISTED	Stock	3.63	3.75	3.5	3.63	105100.0
2000-10-17	ABT	Stock	23.0062	23.5392	22.6414	23.1184	11923790.0
2000-10-17	ABTL-DELISTED	Stock	30.31	30.31	27.5	30.0	66100.0
2000-10-17	ABV-DELISTED	Stock	23.0	23.625	23.0	23.625	572900.0
2000-10-17	ABX-DELISTED	Stock	13.626	13.688	13.313	13.375	1099979.0
2000-10-17	ACAS-DELISTED	Stock	21.875	21.9375	21.5	21.5	178700.0
2000-10-17	ACAT-DELISTED	Stock	11.938	12.063	11.938	11.938	113996.0
2000-10-17	ACCL-DELISTED	Stock	15.6099996566772	15.7049999237061	14.7089996337891	14.8439998626709	753800.0
2000-10-17	ACE-DELISTED	Stock	35.06	35.38	33.94	34.69	833800.0
2000-10-17	ACF-DELISTED	Stock	28.06	28.63	25.88	26.06	1079500.0
2000-10-17	ACG-DELISTED	Stock	7.25	7.25	7.125	7.1875	58100.0
2000-10-17	ACGL	Stock	1.7292	1.7569	1.7292	1.7569	33300.0
2000-10-17	ACGN-DELISTED	Stock	1097.9688	1097.9688	986.0	1062.5	45000.0
2000-10-17	ACH	Stock	10.375	10.375	10.1667	10.2083	52800.0
2000-10-17	ACLS	Stock	43.25	43.5	33.5	35.0	325400.0
2000-10-17	ACO-DELISTED	Stock	5.4375	5.5625	5.3125	5.375	56600.0
2000-10-17	ACPW-DELISTED	Stock	230.0	232.03	188.75	199.37	72260.0
2000-10-17	ACS-DELISTED	Stock	25.4375	25.5938	25.3125	25.5938	142900.0
2000-10-17	ACTA-DELISTED	Stock	255.0	257.5	205.0	207.5	276200.0
2000-10-17	ACTT-DELISTED	Stock	8.2031	8.8125	8.125	8.6875	45800.0
2000-10-17	ACTU-DELISTED	Stock	27.41	28.0	26.63	27.69	675900.0
2000-10-17	ACXM-DELISTED	Stock	34.75	34.8125	32.375	32.5	933600.0
2000-10-17	ACY-DELISTED	Stock	5.38	5.38	5.25	5.38	6600.0
2000-10-17	AD	Stock	40.6667	40.6667	33.56	35.8667	1260150.0
2000-10-17	ADAT-DELISTED	Stock	67.5	68.62	60.75	61.88	6700.0
2000-10-17	ADBE	Stock	34.0	34.0156	31.4844	33.2344	16645600.0
2000-10-17	ADC	Stock	14.4375	14.5625	14.25	14.25	5800.0
2000-10-17	ADEP-DELISTED	Stock	171.56	194.69	170.31	179.38	54100.0
2000-10-17	ADGF-DELISTED	Stock	1.09	1.25	1.06	1.06	7600.0
2000-10-17	ADI	Stock	66.875	67.875	64.3125	67.25	4783200.0

> showing 50 of 2,867 rows — these rows as CSV

> unlock the full archive -- $79 one-time