PREVIEW / stock_daily / 2006-12-08

all stock daily files

  file:    by_date/stock_daily/2006/2006-12-08.parquet
  size:    155 KB
  rows:    4,621
  symbols: 2,923

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-12-08	AAPL	Stock	3.1154	3.1925	3.1071	3.1521	784277200.0
2006-12-08	MSFT	Stock	28.82	29.4	28.8	29.4	108854900.0
2006-12-08	NVDA	Stock	0.5902	0.6007	0.5817	0.5925	564858000.0
2006-12-08	AMZN	Stock	1.896	1.9475	1.885	1.923	102794000.0
2006-12-08	CL	Stock	32.825	32.85	32.525	32.8	1798800.0
2006-12-08	A	Stock	23.7482	24.0987	23.6338	23.9127	1995645.0
2006-12-08	AABA-DELISTED	Stock	26.6499996185303	26.7800006866455	26.2700004577637	26.3400001525879	19262200.0
2006-12-08	AACC-DELISTED	Stock	16.35	16.51	16.12	16.14	31368.0
2006-12-08	AACQ-DELISTED	Stock	5.46	5.46	5.46	5.46	1000.0
2006-12-08	AACQW-DELISTED	Stock	0.56	0.59	0.56	0.59	48600.0
2006-12-08	AAI-DELISTED	Stock	12.39	12.65	12.336	12.55	957300.0
2006-12-08	AAIC-DELISTED	Stock	154.6	155.6	151.0	152.0	1457800.0
2006-12-08	AAME	Stock	2.94	2.94	2.87	2.87	2200.0
2006-12-08	AAON	Stock	3.6306	3.6543	3.6148	3.6543	83531.0
2006-12-08	AAP	Stock	37.0	37.45	36.99	37.01	1387800.0
2006-12-08	AATI-DELISTED	Stock	5.42	5.5	5.35	5.39	240423.0
2006-12-08	AAU-DELISTED	Stock	2.4	2.45	2.33	2.4199	85000.0
2006-12-08	AAUAF-DELISTED	Stock	2.4	2.45	2.33	2.4199	85000.0
2006-12-08	AAV-DELISTED	Stock	12.12	12.12	11.84	11.8725	526000.0
2006-12-08	AAWW-DELISTED	Stock	44.32	45.6	44.32	45.26	187789.0
2006-12-08	AAXN-DELISTED	Stock	8.47000026702881	8.53999996185303	8.42000007629395	8.46000003814697	525600.0
2006-12-08	AB	Stock	79.89	80.43	78.87	79.21	171100.0
2006-12-08	ABAX-DELISTED	Stock	19.29	19.57	19.25	19.43	108615.0
2006-12-08	ABB-DELISTED	Stock	16.96	17.08	16.84	16.98	4075300.0
2006-12-08	ABBC-DELISTED	Stock	19.31	19.31	19.25	19.29	3168.0
2006-12-08	ABC-DELISTED	Stock	23.2	23.22	22.9	22.98	2355800.0
2006-12-08	ABCB	Stock	26.9325	27.2924	26.9325	26.9422	8533.0
2006-12-08	ABCO-DELISTED	Stock	26.88	26.9	26.5	26.61	294311.0
2006-12-08	ABCW-DELISTED	Stock	28.82	28.89	28.52	28.6	14520.0
2006-12-08	ABD-DELISTED	Stock	25.45	26.0	25.06	25.82	116100.0
2006-12-08	ABE-DELISTED	Stock	19.12	19.16	18.95	19.05	82600.0
2006-12-08	ABFS-DELISTED	Stock	37.35	37.81	37.33	37.35	413925.0
2006-12-08	ABG	Stock	23.83	23.93	23.65	23.9	352700.0
2006-12-08	ABK-DELISTED	Stock	85.3	85.77	84.8	85.37	214400.0
2006-12-08	ABM	Stock	20.75	20.95	20.48	20.95	78600.0
2006-12-08	ABMD-DELISTED	Stock	12.81	13.53	12.8	13.29	105225.0
2006-12-08	ABP-DELISTED	Stock	3.97	4.0	3.93	3.94	138100.0
2006-12-08	ABR	Stock	28.68	29.03	28.5	28.67	63700.0
2006-12-08	ABT	Stock	23.1216	23.1695	22.9392	23.0112	6290329.0
2006-12-08	ABTL-DELISTED	Stock	16.45	17.134	16.15	16.45	158716.0
2006-12-08	ABV-DELISTED	Stock	47.4	47.74	47.32	47.5	317300.0
2006-12-08	ABVA-DELISTED	Stock	16.16	16.16	16.11	16.15	1929.0
2006-12-08	ABX-DELISTED	Stock	30.87	31.0	29.98	30.16	3802400.0
2006-12-08	ACAD	Stock	8.96	9.19	8.87	8.96	84600.0
2006-12-08	ACAP-DELISTED	Stock	39.15	40.22	38.79	39.67	52374.0
2006-12-08	ACAS-DELISTED	Stock	44.57	44.83	44.47	44.62	422111.0
2006-12-08	ACAT-DELISTED	Stock	17.93	18.07	17.53	17.71	63518.0
2006-12-08	ACC-DELISTED	Stock	29.66	29.77	29.34	29.34	109800.0
2006-12-08	ACCL-DELISTED	Stock	5.98	6.07	5.98	6.04	47199.0
2006-12-08	ACCO	Stock	25.45	26.0	25.06	25.82	134300.0

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

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