PREVIEW / stock_daily / 2000-07-20

all stock daily files

  file:    by_date/stock_daily/2000/2000-07-20.parquet
  size:    87 KB
  rows:    2,744
  symbols: 1,691

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-07-20	AAPL	Stock	0.9821	1.019	0.9665	0.9844	465572800.0
2000-07-20	MSFT	Stock	36.7188	37.625	36.5625	37.4062	54690600.0
2000-07-20	NVDA	Stock	0.2789	0.2938	0.2781	0.2867	142992000.0
2000-07-20	AMZN	Stock	2.0469	2.1688	1.975	2.0156	138914000.0
2000-07-20	CL	Stock	27.5625	28.0	27.0	27.6875	4747800.0
2000-07-20	A	Stock	52.8433	54.5869	38.6266	38.6266	3551619.0
2000-07-20	AABA-DELISTED	Stock	67.0	71.34375	66.84375	69.90625	19580200.0
2000-07-20	AAI-DELISTED	Stock	4.75	4.81	4.56	4.69	94000.0
2000-07-20	AAIC-DELISTED	Stock	152.5	152.5	142.5	143.75	89900.0
2000-07-20	AAME	Stock	2.375	2.375	2.375	2.375	400.0
2000-07-20	AAON	Stock	1.4467	1.5364	1.4339	1.4961	363930.0
2000-07-20	ABAX-DELISTED	Stock	6.6875	6.6875	6.3125	6.3125	33800.0
2000-07-20	ABC-DELISTED	Stock	7.5	7.875	7.5	7.703125	936800.0
2000-07-20	ABCB	Stock	7.8014	7.8014	7.8014	7.8014	370.0
2000-07-20	ABCW-DELISTED	Stock	16.06	16.31	16.06	16.31	165100.0
2000-07-20	ABE-DELISTED	Stock	15.5625	15.5625	15.4375	15.5	23200.0
2000-07-20	ABFS-DELISTED	Stock	12.0	12.25	11.5625	12.0625	370600.0
2000-07-20	ABK-DELISTED	Stock	60.0	61.31	59.5	60.81	667500.0
2000-07-20	ABM	Stock	12.625	12.9375	12.625	12.9375	56200.0
2000-07-20	ABMD-DELISTED	Stock	22.312	22.562	21.6562	22.2812	104600.0
2000-07-20	ABT	Stock	18.5733	18.7136	18.2366	18.461	4544210.0
2000-07-20	ABTL-DELISTED	Stock	32.19	32.19	30.0	30.31	14100.0
2000-07-20	ABV-DELISTED	Stock	20.06	20.62	20.06	20.13	148200.0
2000-07-20	ABX-DELISTED	Stock	17.313	17.376	17.0	17.063	1109284.0
2000-07-20	ACAS-DELISTED	Stock	24.25	25.125	24.1875	24.375	213800.0
2000-07-20	ACAT-DELISTED	Stock	12.38	12.4408	11.999	12.125	20294.0
2000-07-20	ACCL-DELISTED	Stock	30.6840000152588	34.0330009460449	30.6840000152588	33.806999206543	500500.0
2000-07-20	ACE-DELISTED	Stock	30.19	30.94	29.88	30.94	362600.0
2000-07-20	ACF-DELISTED	Stock	19.5	19.63	19.5	19.63	124700.0
2000-07-20	ACG-DELISTED	Stock	7.5	7.5625	7.4375	7.4375	53200.0
2000-07-20	ACGL	Stock	1.7361	1.75	1.7222	1.7361	147600.0
2000-07-20	ACGN-DELISTED	Stock	1097.9688	1151.0088	1097.9688	1151.0088	118900.0
2000-07-20	ACH	Stock	11.4167	11.6667	11.25	11.4167	282900.0
2000-07-20	ACLS	Stock	97.0	101.5	90.5	92.5	330075.0
2000-07-20	ACO-DELISTED	Stock	3.875	3.9375	3.8125	3.8125	19000.0
2000-07-20	ACS-DELISTED	Stock	21.0625	21.375	20.9063	21.0313	241500.0
2000-07-20	ACTA-DELISTED	Stock	820.0	863.75	817.5	848.75	202700.0
2000-07-20	ACTT-DELISTED	Stock	6.3594	6.375	6.1875	6.1875	6200.0
2000-07-20	ACTU-DELISTED	Stock	50.31	51.53	50.0	51.0	336200.0
2000-07-20	ACXM-DELISTED	Stock	27.03	27.09	26.34	26.97	596573.0
2000-07-20	AD	Stock	44.8333	46.75	44.8333	46.5833	326700.0
2000-07-20	ADAT-DELISTED	Stock	108.0	108.56	104.63	108.0	5900.0
2000-07-20	ADBE	Stock	33.1562	34.4375	32.625	34.3125	5474000.0
2000-07-20	ADC	Stock	16.0	16.625	16.0	16.5625	5800.0
2000-07-20	ADEP-DELISTED	Stock	203.59	206.25	190.0	200.62	32100.0
2000-07-20	ADI	Stock	79.0625	80.625	72.9375	74.4375	3774700.0
2000-07-20	ADM	Stock	9.127	9.1837	8.9569	8.9569	1568637.0
2000-07-20	ADMP-DELISTED	Stock	1548.59375	1572.5	1530.0	1532.65625	200.0
2000-07-20	ADSK	Stock	5.7891	6.0625	5.7812	5.8594	4384000.0
2000-07-20	ADTN	Stock	33.0	33.5	32.75	33.3125	400600.0

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

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