PREVIEW / stock_daily / 2001-07-27

all stock daily files

  file:    by_date/stock_daily/2001/2001-07-27.parquet
  size:    100 KB
  rows:    2,939
  symbols: 1,826

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-27	AAPL	Stock	0.3348	0.3438	0.3304	0.3386	334135200.0
2001-07-27	MSFT	Stock	33.025	33.125	32.525	32.735	65396000.0
2001-07-27	NVDA	Stock	0.3285	0.3411	0.3188	0.3375	1094688000.0
2001-07-27	AMZN	Stock	0.6165	0.6215	0.585	0.6125	181518000.0
2001-07-27	CL	Stock	27.1	27.1	26.75	26.995	3247200.0
2001-07-27	A	Stock	20.8512	21.5951	20.608	21.5308	1849135.0
2001-07-27	AABA-DELISTED	Stock	8.71000003814697	9.25	8.60000038146973	9.01000022888184	12615800.0
2001-07-27	AAI-DELISTED	Stock	8.95	9.0	8.65	8.85	204400.0
2001-07-27	AAIC-DELISTED	Stock	139.0	139.0	137.0	137.4	46600.0
2001-07-27	AAME	Stock	1.65	1.65	1.65	1.65	3500.0
2001-07-27	AAON	Stock	1.7547	1.7675	1.7301	1.7576	533081.0
2001-07-27	AAXN-DELISTED	Stock	0.479999989271164	0.488333344459534	0.47749999165535	0.488333344459534	55200.0
2001-07-27	ABAX-DELISTED	Stock	5.35	5.35	5.21	5.26	10700.0
2001-07-27	ABB-DELISTED	Stock	10.63	10.83	10.63	10.7	7400.0
2001-07-27	ABC-DELISTED	Stock	14.375	14.8500003814697	14.3400001525879	14.6525001525879	3768000.0
2001-07-27	ABCB	Stock	10.2938	10.4559	9.929	10.2371	2714.0
2001-07-27	ABCW-DELISTED	Stock	16.16	16.43	16.1	16.22	40900.0
2001-07-27	ABE-DELISTED	Stock	7.52	7.6	7.5	7.6	51100.0
2001-07-27	ABFS-DELISTED	Stock	26.85	28.0	26.83	27.66	143600.0
2001-07-27	ABK-DELISTED	Stock	56.7	57.2	56.0	56.82	308800.0
2001-07-27	ABM	Stock	17.85	18.075	17.775	17.975	80400.0
2001-07-27	ABMD-DELISTED	Stock	18.6	19.05	17.8	19.0	82500.0
2001-07-27	ABP-DELISTED	Stock	3.5	3.57	3.45	3.5	25100.0
2001-07-27	ABT	Stock	23.1633	23.3339	22.9972	23.1364	3392286.0
2001-07-27	ABTL-DELISTED	Stock	5.1	5.1	4.85	5.05	25400.0
2001-07-27	ABV-DELISTED	Stock	20.48	20.75	20.12	20.58	128200.0
2001-07-27	ABX-DELISTED	Stock	15.1	15.38	15.05	15.25	851800.0
2001-07-27	ACAP-DELISTED	Stock	20.49	20.5	20.25	20.4	39500.0
2001-07-27	ACAS-DELISTED	Stock	27.73	27.93	27.3	27.71	163000.0
2001-07-27	ACAT-DELISTED	Stock	14.75	14.75	14.4	14.55	223600.0
2001-07-27	ACCL-DELISTED	Stock	12.2237997055054	12.2375001907349	12.0500001907349	12.2375001907349	283100.0
2001-07-27	ACE-DELISTED	Stock	32.5	34.0	32.5	33.2	1208100.0
2001-07-27	ACF-DELISTED	Stock	60.75	61.85	60.6	60.95	841100.0
2001-07-27	ACG-DELISTED	Stock	8.73	8.75	8.65	8.72	195600.0
2001-07-27	ACGL	Stock	1.8767	1.8767	1.8767	1.8767	27900.0
2001-07-27	ACGN-DELISTED	Stock	895.3288	986.0	861.3288	986.0	289800.0
2001-07-27	ACH	Stock	12.2667	12.56	12.2	12.2067	47400.0
2001-07-27	ACLS	Stock	53.84	56.4	53.2	56.16	208850.0
2001-07-27	ACO-DELISTED	Stock	6.15	6.18	6.05	6.09	26400.0
2001-07-27	ACPW-DELISTED	Stock	45.15	49.0	44.55	47.0	133560.0
2001-07-27	ACS-DELISTED	Stock	41.25	42.3	41.2	41.595	537100.0
2001-07-27	ACTA-DELISTED	Stock	28.2	28.4	26.6	27.4	23900.0
2001-07-27	ACTT-DELISTED	Stock	4.03	4.08	3.95	3.98	55100.0
2001-07-27	ACTU-DELISTED	Stock	9.99	9.99	9.5	9.9	243300.0
2001-07-27	ACXM-DELISTED	Stock	11.06	11.39	10.8	11.11	1160600.0
2001-07-27	ACY-DELISTED	Stock	5.15	5.2	5.15	5.18	9200.0
2001-07-27	AD	Stock	37.1	38.0933	35.6667	37.4667	208200.0
2001-07-27	ADAT-DELISTED	Stock	87.57	90.09	87.57	89.55	1545.0
2001-07-27	ADBE	Stock	21.495	22.19	21.35	21.53	4719000.0
2001-07-27	ADC	Stock	19.75	19.85	19.7	19.7	4200.0

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

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