PREVIEW / stock_daily / 2003-07-09

all stock daily files

  file:    by_date/stock_daily/2003/2003-07-09.parquet
  size:    116 KB
  rows:    3,397
  symbols: 2,091

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
2003-07-09	AAPL	Stock	0.3609	0.3652	0.3552	0.3552	213645600.0
2003-07-09	MSFT	Stock	27.56	27.7	27.25	27.47	62300700.0
2003-07-09	NVDA	Stock	0.2063	0.2146	0.206	0.2112	755352000.0
2003-07-09	AMZN	Stock	2.027	2.0365	1.9935	2.025	156644000.0
2003-07-09	CL	Stock	28.9	29.0	28.675	28.81	2716600.0
2003-07-09	A	Stock	15.4936	15.701	15.0286	15.5722	3286838.0
2003-07-09	AABA-DELISTED	Stock	17.5349998474121	17.8950004577637	17.0049991607666	17.6450004577637	45663200.0
2003-07-09	AAI-DELISTED	Stock	12.48	12.55	12.35	12.4	1884300.0
2003-07-09	AAIC-DELISTED	Stock	292.0	295.0	289.0	294.6	532800.0
2003-07-09	AAME	Stock	2.34	2.53	2.29	2.29	6400.0
2003-07-09	AAON	Stock	2.6021	2.6114	2.5613	2.585	177694.0
2003-07-09	AAP	Stock	21.2	21.44	20.9033	20.95	1354200.0
2003-07-09	AAXN-DELISTED	Stock	1.0533332824707	1.07083332538605	1.0533332824707	1.05833327770233	198000.0
2003-07-09	ABAX-DELISTED	Stock	6.97	6.97	6.56	6.75	16900.0
2003-07-09	ABB-DELISTED	Stock	3.44	3.44	3.31	3.38	144900.0
2003-07-09	ABC-DELISTED	Stock	18.05	18.12	17.78	17.78	4018400.0
2003-07-09	ABCB	Stock	12.8308	13.0902	12.8064	12.928	25044.0
2003-07-09	ABCO-DELISTED	Stock	21.03	22.3	20.79	21.82	437136.0
2003-07-09	ABCW-DELISTED	Stock	26.11	26.12	25.6	25.91	91120.0
2003-07-09	ABE-DELISTED	Stock	6.2	6.25	6.2	6.25	3100.0
2003-07-09	ABFS-DELISTED	Stock	28.07	29.01	27.74	28.6	676573.0
2003-07-09	ABG	Stock	13.82	14.0	13.5	14.0	60600.0
2003-07-09	ABK-DELISTED	Stock	66.18	66.48	65.66	66.2	469400.0
2003-07-09	ABM	Stock	15.6	15.99	15.55	15.98	133300.0
2003-07-09	ABMD-DELISTED	Stock	5.18	5.24	4.93	5.15	31789.0
2003-07-09	ABP-DELISTED	Stock	1.04	1.1	1.04	1.07	17800.0
2003-07-09	ABT	Stock	19.8459	20.0434	19.5362	19.608	5974370.0
2003-07-09	ABTL-DELISTED	Stock	34.1	35.45	33.25	35.05	118500.0
2003-07-09	ABV-DELISTED	Stock	20.8	20.93	20.8	20.87	562900.0
2003-07-09	ABVA-DELISTED	Stock	17.5	17.5	17.25	17.28	1900.0
2003-07-09	ABX-DELISTED	Stock	17.46	17.56	17.23	17.24	2672847.0
2003-07-09	ACAP-DELISTED	Stock	26.66	27.1	26.45	27.1	56400.0
2003-07-09	ACAS-DELISTED	Stock	27.54	27.67	27.24	27.37	349000.0
2003-07-09	ACAT-DELISTED	Stock	19.51	19.649	19.19	19.54	51516.0
2003-07-09	ACCL-DELISTED	Stock	7.03838014602661	7.27009010314941	7.03838014602661	7.27009010314941	175300.0
2003-07-09	ACE-DELISTED	Stock	34.86	35.48	34.69	34.76	1441313.0
2003-07-09	ACF-DELISTED	Stock	10.09	10.4	9.76	9.77	2840300.0
2003-07-09	ACG-DELISTED	Stock	8.89	8.98	8.86	8.95	1107700.0
2003-07-09	ACGL	Stock	3.9144	3.9833	3.9144	3.9556	416700.0
2003-07-09	ACGN-DELISTED	Stock	963.3288	1144.6712	963.3288	1144.6712	81300.0
2003-07-09	ACH	Stock	15.26	15.28	15.0	15.2467	153600.0
2003-07-09	ACH-DELISTED	Stock	7.063	7.251	7.013	7.213	85196.0
2003-07-09	ACLS	Stock	27.48	30.28	27.36	29.16	719175.0
2003-07-09	ACO-DELISTED	Stock	8.99	9.19	8.75	9.0	47700.0
2003-07-09	ACPW-DELISTED	Stock	7.9	8.95	7.9	8.9	37977.0
2003-07-09	ACS-DELISTED	Stock	46.25	46.25	44.88	45.08	1444200.0
2003-07-09	ACTA-DELISTED	Stock	9.4	10.2	9.4	10.0	414000.0
2003-07-09	ACTG	Stock	1.37	1.38	1.33	1.36	55700.0
2003-07-09	ACTI-DELISTED	Stock	9.87	9.91	9.75	9.9	232336.0
2003-07-09	ACTT-DELISTED	Stock	1.88	1.89	1.83	1.89	8963.0

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

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