PREVIEW / stock_daily / 2006-08-29

all stock daily files

  file:    by_date/stock_daily/2006/2006-08-29.parquet
  size:    149 KB
  rows:    4,497
  symbols: 2,847

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
2006-08-29	AAPL	Stock	2.3925	2.4021	2.3257	2.3743	947332400.0
2006-08-29	MSFT	Stock	25.92	25.98	25.63	25.84	42711200.0
2006-08-29	NVDA	Stock	0.4608	0.4793	0.4575	0.4772	727962000.0
2006-08-29	AMZN	Stock	1.4485	1.486	1.4375	1.476	147962000.0
2006-08-29	CL	Stock	29.375	29.74	29.335	29.725	3311800.0
2006-08-29	A	Stock	22.0887	22.4964	22.0744	22.432	3132079.0
2006-08-29	AABA-DELISTED	Stock	28.8600006103516	29.0100002288818	28.5100002288818	28.9599990844727	9888800.0
2006-08-29	AACC-DELISTED	Stock	14.86	14.94	14.6	14.94	272647.0
2006-08-29	AACQ-DELISTED	Stock	5.3	5.3	5.3	5.3	5000.0
2006-08-29	AACQW-DELISTED	Stock	0.38	0.38	0.38	0.38	2000.0
2006-08-29	AAI-DELISTED	Stock	11.44	11.54	11.15	11.39	1035900.0
2006-08-29	AAIC-DELISTED	Stock	165.8	168.6	161.8	168.2	1185500.0
2006-08-29	AAME	Stock	2.65	2.65	2.6	2.65	1400.0
2006-08-29	AAON	Stock	2.9946	3.1381	2.984	3.0604	149597.0
2006-08-29	AAP	Stock	29.5	29.66	29.28	29.61	697000.0
2006-08-29	AATI-DELISTED	Stock	9.3	9.34	8.88	9.0	109530.0
2006-08-29	AAU-DELISTED	Stock	2.62	2.715	2.6	2.715	20100.0
2006-08-29	AAUAF-DELISTED	Stock	2.62	2.715	2.6	2.715	20100.0
2006-08-29	AAV-DELISTED	Stock	16.11	16.11	15.93	15.97	414900.0
2006-08-29	AAWW-DELISTED	Stock	43.12	43.6	42.78	43.24	147149.0
2006-08-29	AAXN-DELISTED	Stock	7.73000001907349	7.88000011444092	7.73000001907349	7.8600001335144	411200.0
2006-08-29	AB	Stock	65.71	65.94	64.75	65.67	216200.0
2006-08-29	ABAX-DELISTED	Stock	23.82	24.56	23.33	24.23	213488.0
2006-08-29	ABB-DELISTED	Stock	13.39	13.51	13.23	13.49	2232100.0
2006-08-29	ABBC-DELISTED	Stock	14.63	14.75	14.29	14.69	24320.0
2006-08-29	ABC-DELISTED	Stock	22.46	22.49	22.12	22.33	1707600.0
2006-08-29	ABCB	Stock	26.3392	26.631	25.9599	26.31	43182.0
2006-08-29	ABCO-DELISTED	Stock	24.98	25.95	24.48	25.73	230426.0
2006-08-29	ABCW-DELISTED	Stock	29.01	29.39	28.62	29.39	29820.0
2006-08-29	ABD-DELISTED	Stock	21.28	21.29	20.6	21.14	307300.0
2006-08-29	ABE-DELISTED	Stock	13.5	13.5	13.35	13.38	4300.0
2006-08-29	ABFS-DELISTED	Stock	44.39	45.15	44.0	44.86	441213.0
2006-08-29	ABG	Stock	20.47	20.59	19.87	20.55	269600.0
2006-08-29	ABK-DELISTED	Stock	85.9	86.95	85.88	86.56	831800.0
2006-08-29	ABM	Stock	17.68	18.09	17.55	18.0	132600.0
2006-08-29	ABMD-DELISTED	Stock	13.49	13.81	13.29	13.7934	82319.0
2006-08-29	ABP-DELISTED	Stock	4.12	4.17	4.01	4.13	144000.0
2006-08-29	ABR	Stock	25.23	25.25	25.03	25.08	101600.0
2006-08-29	ABT	Stock	23.4142	23.5822	23.3135	23.491	9125469.0
2006-08-29	ABTL-DELISTED	Stock	14.301	14.301	13.749	13.799	44659.0
2006-08-29	ABV-DELISTED	Stock	44.35	45.26	44.07	45.26	516600.0
2006-08-29	ABVA-DELISTED	Stock	16.9	17.0	16.9	17.0	2048.0
2006-08-29	ABX-DELISTED	Stock	32.59	32.93	32.35	32.91	2802700.0
2006-08-29	ACAD	Stock	8.1	8.35	8.1	8.33	145900.0
2006-08-29	ACAP-DELISTED	Stock	47.88	49.06	47.25	48.85	31898.0
2006-08-29	ACAS-DELISTED	Stock	38.09	38.36	38.0	38.34	627536.0
2006-08-29	ACAT-DELISTED	Stock	16.49	16.83	16.49	16.77	122383.0
2006-08-29	ACC-DELISTED	Stock	25.5	25.77	25.07	25.74	55200.0
2006-08-29	ACCL-DELISTED	Stock	5.65	5.6708	5.42	5.5	54611.0
2006-08-29	ACCO	Stock	21.28	21.29	20.6	21.14	310300.0

> showing 50 of 4,497 rows — these rows as CSV

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