PREVIEW / stock_daily / 2001-09-18

all stock daily files

  file:    by_date/stock_daily/2001/2001-09-18.parquet
  size:    101 KB
  rows:    3,001
  symbols: 1,869

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-18	AAPL	Stock	0.3018	0.3164	0.2888	0.2907	327101600.0
2001-09-18	MSFT	Stock	26.705	27.5	26.585	27.16	83182600.0
2001-09-18	NVDA	Stock	0.2887	0.2908	0.2597	0.2662	894372000.0
2001-09-18	AMZN	Stock	0.3795	0.3875	0.3625	0.3645	125418000.0
2001-09-18	CL	Stock	29.15	29.25	28.625	29.0	5810400.0
2001-09-18	A	Stock	15.3791	16.0229	15.0215	15.5436	2132090.0
2001-09-18	AABA-DELISTED	Stock	5.40000009536743	5.56500005722046	5.0149998664856	5.05000019073486	20893400.0
2001-09-18	AAI-DELISTED	Stock	3.69	3.85	3.26	3.48	2570500.0
2001-09-18	AAIC-DELISTED	Stock	113.0	115.0	111.2	115.0	16400.0
2001-09-18	AAME	Stock	1.3	1.3	1.2	1.2	40600.0
2001-09-18	AAON	Stock	1.6914	1.6973	1.6505	1.6534	1201141.0
2001-09-18	AAXN-DELISTED	Stock	0.689166665077209	0.729166686534882	0.689166665077209	0.708333313465118	531600.0
2001-09-18	ABAX-DELISTED	Stock	4.2	4.2	4.03	4.05	17000.0
2001-09-18	ABB-DELISTED	Stock	7.8	8.09	7.75	8.03	23300.0
2001-09-18	ABC-DELISTED	Stock	16.0	16.3	16.0	16.11	4412400.0
2001-09-18	ABCB	Stock	10.537	10.5937	10.537	10.5856	14558.0
2001-09-18	ABCW-DELISTED	Stock	16.02	16.35	15.95	16.22	32100.0
2001-09-18	ABE-DELISTED	Stock	6.25	6.35	6.13	6.25	35900.0
2001-09-18	ABFS-DELISTED	Stock	22.65	23.0	21.31	21.6	177400.0
2001-09-18	ABK-DELISTED	Stock	54.85	54.85	53.0	53.15	787100.0
2001-09-18	ABM	Stock	14.75	14.945	14.675	14.715	139600.0
2001-09-18	ABMD-DELISTED	Stock	15.35	15.99	14.48	14.64	96300.0
2001-09-18	ABP-DELISTED	Stock	2.15	2.34	2.05	2.1	116000.0
2001-09-18	ABT	Stock	22.7144	22.8805	22.3104	22.6291	10206485.0
2001-09-18	ABTL-DELISTED	Stock	5.75	6.25	5.65	5.9	36200.0
2001-09-18	ABV-DELISTED	Stock	17.35	17.65	16.91	17.15	444000.0
2001-09-18	ABX-DELISTED	Stock	16.53	16.78	15.979	16.67	3042780.0
2001-09-18	ACAP-DELISTED	Stock	20.81	21.4	20.8	21.0	84800.0
2001-09-18	ACAS-DELISTED	Stock	26.93	27.5	26.75	27.1	199200.0
2001-09-18	ACAT-DELISTED	Stock	14.965	15.15	14.95	14.95	59800.0
2001-09-18	ACCL-DELISTED	Stock	9.65966987609863	9.77552032470703	9.41347026824951	9.77552032470703	411300.0
2001-09-18	ACE-DELISTED	Stock	28.51	29.09	25.99	26.0	7045981.0
2001-09-18	ACF-DELISTED	Stock	33.75	34.95	33.4	34.02	1402500.0
2001-09-18	ACG-DELISTED	Stock	8.83	8.83	8.43	8.5	327900.0
2001-09-18	ACGL	Stock	2.0	2.0	1.8889	1.9722	23400.0
2001-09-18	ACGN-DELISTED	Stock	963.3288	1144.6712	940.6712	1144.6712	6800.0
2001-09-18	ACH	Stock	12.7667	13.0	12.5267	12.66	106500.0
2001-09-18	ACLS	Stock	47.88	49.08	46.8	47.96	435225.0
2001-09-18	ACO-DELISTED	Stock	5.91	5.91	5.6	5.6	22000.0
2001-09-18	ACPW-DELISTED	Stock	26.25	27.2	23.0	23.25	106620.0
2001-09-18	ACS-DELISTED	Stock	41.125	41.85	41.0	41.535	589100.0
2001-09-18	ACTA-DELISTED	Stock	10.2	11.4	9.8	10.0	54900.0
2001-09-18	ACTT-DELISTED	Stock	7.99	8.2	7.06	7.42	226400.0
2001-09-18	ACTU-DELISTED	Stock	5.21	5.36	4.05	4.15	615300.0
2001-09-18	ACXM-DELISTED	Stock	11.42	11.45	9.92	9.96	1088500.0
2001-09-18	ACY-DELISTED	Stock	5.38	5.6	5.31	5.6	6300.0
2001-09-18	AD	Stock	32.6	33.0	32.5467	32.7	104250.0
2001-09-18	ADAT-DELISTED	Stock	54.9	65.88	54.0	65.88	2700.0
2001-09-18	ADBE	Stock	15.17	15.565	14.775	15.05	9046600.0
2001-09-18	ADC	Stock	18.95	19.0	18.65	18.76	7800.0

> showing 50 of 3,001 rows — these rows as CSV

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