PREVIEW / stock_daily / 2001-09-27

all stock daily files

  file:    by_date/stock_daily/2001/2001-09-27.parquet
  size:    99 KB
  rows:    2,981
  symbols: 1,851

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-09-27	AAPL	Stock	0.2723	0.2813	0.2714	0.277	322240800.0
2001-09-27	MSFT	Stock	25.05	25.34	24.0	24.98	81191200.0
2001-09-27	NVDA	Stock	0.2307	0.2333	0.2126	0.2187	907296000.0
2001-09-27	AMZN	Stock	0.3235	0.332	0.2835	0.31	165500000.0
2001-09-27	CL	Stock	28.35	29.025	28.25	28.985	4150800.0
2001-09-27	A	Stock	13.6338	13.7625	13.176	13.7625	2527025.0
2001-09-27	AABA-DELISTED	Stock	4.01999998092651	4.625	4.01000022888184	4.55499982833862	29073200.0
2001-09-27	AAI-DELISTED	Stock	3.71	3.79	3.58	3.77	887000.0
2001-09-27	AAIC-DELISTED	Stock	100.0	102.0	99.6	100.2	9800.0
2001-09-27	AAME	Stock	1.25	1.25	1.19	1.25	46100.0
2001-09-27	AAON	Stock	1.7933	1.8348	1.7125	1.7125	683437.0
2001-09-27	AAXN-DELISTED	Stock	0.691666662693024	0.729166686534882	0.691666662693024	0.725000023841858	776400.0
2001-09-27	ABAX-DELISTED	Stock	3.9	4.24	3.9	4.0	31300.0
2001-09-27	ABB-DELISTED	Stock	6.75	7.09	6.65	7.09	286800.0
2001-09-27	ABC-DELISTED	Stock	17.08	17.44	17.0	17.3	4659200.0
2001-09-27	ABCB	Stock	10.537	10.9422	10.537	10.5856	8637.0
2001-09-27	ABCW-DELISTED	Stock	16.38	16.77	16.38	16.38	21100.0
2001-09-27	ABE-DELISTED	Stock	6.16	6.19	6.11	6.19	8800.0
2001-09-27	ABFS-DELISTED	Stock	19.26	19.45	18.0	19.36	108500.0
2001-09-27	ABK-DELISTED	Stock	51.1	53.45	50.75	53.37	538600.0
2001-09-27	ABM	Stock	12.85	12.95	12.825	12.84	74200.0
2001-09-27	ABMD-DELISTED	Stock	14.2	16.12	14.19	16.06	269500.0
2001-09-27	ABP-DELISTED	Stock	1.65	1.75	1.57	1.72	88400.0
2001-09-27	ABT	Stock	22.3104	22.8939	22.2655	22.8895	9533730.0
2001-09-27	ABTL-DELISTED	Stock	3.85	3.85	3.5	3.6	42200.0
2001-09-27	ABV-DELISTED	Stock	13.75	15.31	13.2	15.2	774500.0
2001-09-27	ABX-DELISTED	Stock	17.505	17.645	17.115	17.615	3303171.0
2001-09-27	ACAP-DELISTED	Stock	19.88	20.95	19.88	20.95	17100.0
2001-09-27	ACAS-DELISTED	Stock	26.3	27.37	26.16	27.17	194500.0
2001-09-27	ACAT-DELISTED	Stock	13.43	14.0	13.08	13.99	51500.0
2001-09-27	ACCL-DELISTED	Stock	8.47140026092529	8.87761974334717	8.47140026092529	8.87761974334717	196800.0
2001-09-27	ACE-DELISTED	Stock	25.05	27.54	24.8	27.54	3856316.0
2001-09-27	ACF-DELISTED	Stock	30.25	30.3	28.8	29.21	1022200.0
2001-09-27	ACG-DELISTED	Stock	8.5	8.65	8.5	8.56	195900.0
2001-09-27	ACGL	Stock	1.8889	1.8889	1.8667	1.8667	45900.0
2001-09-27	ACGN-DELISTED	Stock	816.0	1054.0	816.0	1054.0	20700.0
2001-09-27	ACH	Stock	12.7	13.5667	12.4	13.3333	213300.0
2001-09-27	ACLS	Stock	37.4	38.04	34.2	35.08	182250.0
2001-09-27	ACO-DELISTED	Stock	5.74	5.74	5.6	5.74	9900.0
2001-09-27	ACPW-DELISTED	Stock	26.7	26.7	22.55	25.0	88480.0
2001-09-27	ACS-DELISTED	Stock	38.5	40.1	38.25	40.0	1146100.0
2001-09-27	ACTA-DELISTED	Stock	9.0	9.4	8.0	8.8	55800.0
2001-09-27	ACTT-DELISTED	Stock	8.15	8.2	7.84	8.1995	90700.0
2001-09-27	ACTU-DELISTED	Stock	3.71	4.05	3.66	4.0	198700.0
2001-09-27	ACXM-DELISTED	Stock	9.93	10.05	8.99	10.04	938200.0
2001-09-27	ACY-DELISTED	Stock	5.68	5.7	5.55	5.65	2400.0
2001-09-27	AD	Stock	32.3333	33.1667	32.2	32.6	154650.0
2001-09-27	ADAT-DELISTED	Stock	72.05	72.05	66.03	68.4	1044.0
2001-09-27	ADBE	Stock	11.77	11.82	11.25	11.42	13840600.0
2001-09-27	ADC	Stock	17.75	17.75	17.35	17.46	17100.0

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

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