PREVIEW / stock_daily / 2001-08-01

all stock daily files

  file:    by_date/stock_daily/2001/2001-08-01.parquet
  size:    102 KB
  rows:    2,968
  symbols: 1,841

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-08-01	AAPL	Stock	0.3395	0.3532	0.3384	0.3404	304136000.0
2001-08-01	MSFT	Stock	33.4	33.405	32.88	33.235	55679000.0
2001-08-01	NVDA	Stock	0.3437	0.3594	0.3413	0.3577	1204944000.0
2001-08-01	AMZN	Stock	0.6365	0.643	0.6085	0.625	110212000.0
2001-08-01	CL	Stock	27.175	27.2	26.35	26.475	3572400.0
2001-08-01	A	Stock	21.1016	22.8112	20.9013	22.711	3514572.0
2001-08-01	AABA-DELISTED	Stock	9.02999973297119	9.29500007629395	8.9350004196167	9.14500045776367	14035200.0
2001-08-01	AAI-DELISTED	Stock	8.6	8.83	8.55	8.76	296300.0
2001-08-01	AAIC-DELISTED	Stock	137.0	138.0	136.0	136.0	26100.0
2001-08-01	AAME	Stock	1.6	1.6	1.52	1.52	900.0
2001-08-01	AAON	Stock	1.764	1.7705	1.7558	1.7646	435691.0
2001-08-01	AAXN-DELISTED	Stock	0.520833313465118	0.520833313465118	0.516666650772095	0.516666650772095	21600.0
2001-08-01	ABAX-DELISTED	Stock	5.29	5.42	5.28	5.39	38800.0
2001-08-01	ABB-DELISTED	Stock	11.24	11.5	11.05	11.19	18800.0
2001-08-01	ABC-DELISTED	Stock	14.5874996185303	14.5874996185303	14.2250003814697	14.2974996566772	2389200.0
2001-08-01	ABCB	Stock	10.0344	10.2127	9.9695	10.2127	26156.0
2001-08-01	ABCW-DELISTED	Stock	16.301	16.442	16.189	16.24	18510.0
2001-08-01	ABE-DELISTED	Stock	7.69	7.69	7.62	7.62	3100.0
2001-08-01	ABFS-DELISTED	Stock	27.7	28.0	26.65	27.4	1840800.0
2001-08-01	ABK-DELISTED	Stock	58.0	58.05	57.14	57.7	219300.0
2001-08-01	ABM	Stock	18.375	18.645	18.3	18.625	112800.0
2001-08-01	ABMD-DELISTED	Stock	19.25	20.55	18.95	19.91	249400.0
2001-08-01	ABP-DELISTED	Stock	3.4	3.43	3.31	3.4	127200.0
2001-08-01	ABT	Stock	23.9489	23.9758	23.5314	23.8366	8540415.0
2001-08-01	ABTL-DELISTED	Stock	4.2	4.75	3.9	4.75	23200.0
2001-08-01	ABV-DELISTED	Stock	20.6	20.6	19.8	20.24	271500.0
2001-08-01	ABX-DELISTED	Stock	14.96	15.02	14.75	14.77	1168473.0
2001-08-01	ACAP-DELISTED	Stock	20.45	21.5	20.4	21.35	124400.0
2001-08-01	ACAS-DELISTED	Stock	27.65	27.95	27.02	27.95	301500.0
2001-08-01	ACAT-DELISTED	Stock	14.51	14.74	14.28	14.44	16700.0
2001-08-01	ACCL-DELISTED	Stock	11.5488996505737	12.0710000991821	11.5488996505737	12.0710000991821	680600.0
2001-08-01	ACE-DELISTED	Stock	34.96	35.56	34.52	34.64	1158666.0
2001-08-01	ACF-DELISTED	Stock	61.49	63.89	61.21	63.63	654200.0
2001-08-01	ACG-DELISTED	Stock	8.71	8.77	8.65	8.71	239900.0
2001-08-01	ACGN-DELISTED	Stock	1122.0	1167.3288	1042.6712	1122.0	103500.0
2001-08-01	ACH	Stock	12.2333	12.2333	11.7667	11.7667	149250.0
2001-08-01	ACLS	Stock	57.4	60.4	57.4	59.4	236500.0
2001-08-01	ACO-DELISTED	Stock	6.05	6.3	6.05	6.05	14700.0
2001-08-01	ACPW-DELISTED	Stock	46.2	47.0	43.25	44.0	70500.0
2001-08-01	ACS-DELISTED	Stock	41.75	41.755	41.0	41.425	653600.0
2001-08-01	ACTA-DELISTED	Stock	26.8	30.2	26.8	29.6	66400.0
2001-08-01	ACTT-DELISTED	Stock	5.4	5.88	5.16	5.7	21000.0
2001-08-01	ACTU-DELISTED	Stock	10.15	10.37	9.64	10.05	313500.0
2001-08-01	ACXM-DELISTED	Stock	11.69	12.06	11.67	11.8	599400.0
2001-08-01	ACY-DELISTED	Stock	5.2	5.2	5.2	5.2	500.0
2001-08-01	AD	Stock	37.6667	38.8333	37.6667	38.1667	257100.0
2001-08-01	ADAT-DELISTED	Stock	84.6	89.82	82.8	89.1	1281.0
2001-08-01	ADBE	Stock	18.96	19.775	18.925	19.305	11739800.0
2001-08-01	ADC	Stock	19.55	19.55	19.28	19.28	7200.0
2001-08-01	ADEP-DELISTED	Stock	39.85	41.2	38.25	38.45	15400.0

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

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