PREVIEW / stock_daily / 2001-07-09

all stock daily files

  file:    by_date/stock_daily/2001/2001-07-09.parquet
  size:    101 KB
  rows:    2,948
  symbols: 1,834

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
2001-07-09	AAPL	Stock	0.3945	0.4107	0.3871	0.4054	337467200.0
2001-07-09	MSFT	Stock	33.1	33.455	32.52	32.845	66476600.0
2001-07-09	NVDA	Stock	0.3319	0.3399	0.3221	0.3253	1014072000.0
2001-07-09	AMZN	Stock	0.7675	0.795	0.7555	0.7905	160020000.0
2001-07-09	CL	Stock	29.52	29.535	29.0	29.215	3962600.0
2001-07-09	A	Stock	21.5665	21.9242	21.1803	21.3948	1387934.0
2001-07-09	AABA-DELISTED	Stock	9.07499980926514	9.4350004196167	9.01000022888184	9.28499984741211	14335000.0
2001-07-09	AAI-DELISTED	Stock	10.0	10.56	10.0	10.54	530200.0
2001-07-09	AAIC-DELISTED	Stock	134.2	140.0	134.2	139.4	32500.0
2001-07-09	AAME	Stock	1.55	1.55	1.55	1.55	500.0
2001-07-09	AAON	Stock	1.551	1.6066	1.5451	1.5873	768867.0
2001-07-09	AAXN-DELISTED	Stock	0.516666650772095	0.520833313465118	0.5	0.5	96000.0
2001-07-09	ABAX-DELISTED	Stock	5.28	5.35	5.2	5.35	12900.0
2001-07-09	ABB-DELISTED	Stock	13.7	13.79	13.5	13.65	15100.0
2001-07-09	ABC-DELISTED	Stock	13.75	13.8299999237061	13.6875	13.8100004196167	3058800.0
2001-07-09	ABCB	Stock	9.5967	9.5967	9.0699	9.078	4318.0
2001-07-09	ABCW-DELISTED	Stock	15.4	15.4	15.0	15.0	10600.0
2001-07-09	ABE-DELISTED	Stock	7.95	7.97	7.91	7.95	12400.0
2001-07-09	ABFS-DELISTED	Stock	22.9	24.31	22.9	23.55	336900.0
2001-07-09	ABK-DELISTED	Stock	59.55	59.9	58.54	58.68	370700.0
2001-07-09	ABM	Stock	18.2	18.35	18.06	18.325	87200.0
2001-07-09	ABMD-DELISTED	Stock	24.06	24.52	23.62	24.3	218200.0
2001-07-09	ABP-DELISTED	Stock	3.05	3.05	2.88	2.88	61800.0
2001-07-09	ABT	Stock	21.3228	21.6999	20.9188	21.5024	8255052.0
2001-07-09	ABTL-DELISTED	Stock	7.55	8.35	7.5	8.05	22500.0
2001-07-09	ABV-DELISTED	Stock	20.48	20.48	19.75	20.12	281700.0
2001-07-09	ABX-DELISTED	Stock	14.66	14.7	14.51	14.59	745155.0
2001-07-09	ACAP-DELISTED	Stock	20.01	20.29	18.98	19.5	123400.0
2001-07-09	ACAS-DELISTED	Stock	26.51	26.55	26.12	26.37	155200.0
2001-07-09	ACAT-DELISTED	Stock	14.95	15.04	14.75	14.75	82100.0
2001-07-09	ACCL-DELISTED	Stock	14.4822998046875	14.584400177002	14.4822998046875	14.584400177002	272700.0
2001-07-09	ACE-DELISTED	Stock	37.8	37.89	37.02	37.03	464700.0
2001-07-09	ACF-DELISTED	Stock	54.4	54.4	53.8	54.15	1045800.0
2001-07-09	ACG-DELISTED	Stock	8.72	8.8	8.63	8.65	419500.0
2001-07-09	ACGL	Stock	1.8722	1.8722	1.8611	1.8711	55800.0
2001-07-09	ACGN-DELISTED	Stock	1269.3288	1303.3288	1269.3288	1303.3288	9300.0
2001-07-09	ACH	Stock	12.1867	12.4	12.1667	12.4	125850.0
2001-07-09	ACLS	Stock	53.72	55.0	51.6	54.04	174825.0
2001-07-09	ACO-DELISTED	Stock	5.85	6.0	5.8	5.96	8400.0
2001-07-09	ACPW-DELISTED	Stock	79.7	80.55	76.7	79.95	36620.0
2001-07-09	ACS-DELISTED	Stock	35.755	36.2	35.56	36.07	329000.0
2001-07-09	ACTA-DELISTED	Stock	35.0	37.8	33.4	37.4	54200.0
2001-07-09	ACTT-DELISTED	Stock	6.42	6.52	6.42	6.42	3300.0
2001-07-09	ACTU-DELISTED	Stock	7.76	7.79	7.29	7.38	352400.0
2001-07-09	ACXM-DELISTED	Stock	11.54	11.59	10.75	11.06	1542500.0
2001-07-09	ACY-DELISTED	Stock	5.15	5.15	5.1	5.1	1300.0
2001-07-09	AD	Stock	38.6667	38.9467	38.3333	38.9467	190650.0
2001-07-09	ADAT-DELISTED	Stock	86.4	87.66	84.96	87.66	1446.0
2001-07-09	ADBE	Stock	21.51	22.1	21.44	21.99	9362600.0
2001-07-09	ADC	Stock	18.75	18.75	18.36	18.58	10300.0

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

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