PREVIEW / stock_daily / 2006-08-16

all stock daily files

  file:    by_date/stock_daily/2006/2006-08-16.parquet
  size:    149 KB
  rows:    4,486
  symbols: 2,829

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-16	AAPL	Stock	2.3964	2.4311	2.3689	2.4279	781284000.0
2006-08-16	MSFT	Stock	24.61	24.73	24.47	24.7	52373600.0
2006-08-16	NVDA	Stock	0.4277	0.4577	0.4167	0.4558	1029246000.0
2006-08-16	AMZN	Stock	1.3985	1.407	1.376	1.3975	152732000.0
2006-08-16	CL	Stock	29.95	30.045	29.785	29.885	3899000.0
2006-08-16	A	Stock	22.7039	23.0901	22.0601	22.897	5767309.0
2006-08-16	AABA-DELISTED	Stock	28.3500003814697	28.4599990844727	27.9699993133545	28.3899993896484	12589400.0
2006-08-16	AACC-DELISTED	Stock	15.46	15.81	15.15	15.7	164690.0
2006-08-16	AACQ-DELISTED	Stock	5.35	5.35	5.33	5.34	67316.0
2006-08-16	AACQW-DELISTED	Stock	0.4	0.43	0.4	0.43	90000.0
2006-08-16	AAI-DELISTED	Stock	11.32	11.68	11.32	11.58	972300.0
2006-08-16	AAIC-DELISTED	Stock	182.0	186.4	180.6	181.8	1966800.0
2006-08-16	AAME	Stock	2.7	2.7	2.7	2.7	3400.0
2006-08-16	AAON	Stock	3.0894	3.1328	3.013	3.0802	186806.0
2006-08-16	AAP	Stock	29.62	31.19	29.62	31.09	2186600.0
2006-08-16	AATI-DELISTED	Stock	9.57	9.95	9.43	9.9	193187.0
2006-08-16	AAU-DELISTED	Stock	2.53	2.65	2.53	2.62	17900.0
2006-08-16	AAUAF-DELISTED	Stock	2.53	2.65	2.53	2.62	17900.0
2006-08-16	AAV-DELISTED	Stock	16.07	16.18	15.96	16.16	341900.0
2006-08-16	AAWW-DELISTED	Stock	39.56	40.75	39.46	40.74	93654.0
2006-08-16	AAXN-DELISTED	Stock	7.21000003814697	7.69999980926514	7.21000003814697	7.67999982833862	2858400.0
2006-08-16	AB	Stock	68.47	70.0	68.47	69.4	314300.0
2006-08-16	ABAX-DELISTED	Stock	23.36	23.65	23.1	23.16	142679.0
2006-08-16	ABB-DELISTED	Stock	13.4	13.55	13.4	13.52	2034200.0
2006-08-16	ABBC-DELISTED	Stock	14.84	14.84	14.6	14.78	7921.0
2006-08-16	ABC-DELISTED	Stock	21.75	21.89	21.69	21.86	2022800.0
2006-08-16	ABCB	Stock	25.8723	26.6504	25.6972	25.775	34648.0
2006-08-16	ABCO-DELISTED	Stock	25.19	25.72	25.19	25.7	131150.0
2006-08-16	ABCW-DELISTED	Stock	28.93	29.52	28.91	29.31	23260.0
2006-08-16	ABD-DELISTED	Stock	18.675	18.905	18.535	18.715	578920.0
2006-08-16	ABE-DELISTED	Stock	13.91	13.98	13.5	13.56	14700.0
2006-08-16	ABFS-DELISTED	Stock	44.46	45.65	44.13	45.27	268615.0
2006-08-16	ABG	Stock	20.52	20.94	20.43	20.83	54500.0
2006-08-16	ABK-DELISTED	Stock	84.68	84.86	84.26	84.57	776600.0
2006-08-16	ABM	Stock	17.15	18.3	17.11	17.97	523400.0
2006-08-16	ABMD-DELISTED	Stock	13.75	13.75	13.27	13.49	50535.0
2006-08-16	ABP-DELISTED	Stock	4.05	4.19	4.01	4.09	257900.0
2006-08-16	ABR	Stock	25.0	25.19	24.97	25.16	78700.0
2006-08-16	ABT	Stock	23.5102	23.6445	23.4382	23.6445	14031263.0
2006-08-16	ABTL-DELISTED	Stock	15.0	15.25	13.7	14.25	88027.0
2006-08-16	ABV-DELISTED	Stock	42.44	42.87	42.33	42.79	688200.0
2006-08-16	ABVA-DELISTED	Stock	16.45	16.75	16.34	16.48	2100.0
2006-08-16	ABVT-DELISTED	Stock	47.25	47.31	47.25	47.31	11600.0
2006-08-16	ABX-DELISTED	Stock	31.17	31.69	31.17	31.46	2538900.0
2006-08-16	ACAD	Stock	6.39	7.09	6.38	6.9	750400.0
2006-08-16	ACAP-DELISTED	Stock	47.87	47.94	47.42	47.63	19110.0
2006-08-16	ACAS-DELISTED	Stock	37.83	38.04	37.57	37.98	847676.0
2006-08-16	ACAT-DELISTED	Stock	18.07	18.07	17.91	17.93	20118.0
2006-08-16	ACC-DELISTED	Stock	25.2	25.25	25.16	25.2	60300.0
2006-08-16	ACCL-DELISTED	Stock	6.25	6.28	6.05	6.07	36262.0

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

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