PREVIEW / stock_daily / 2006-11-09

all stock daily files

  file:    by_date/stock_daily/2006/2006-11-09.parquet
  size:    153 KB
  rows:    4,572
  symbols: 2,892

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-11-09	AAPL	Stock	2.9607	3.0246	2.9329	2.9764	923053600.0
2006-11-09	MSFT	Stock	29.11	29.4	29.0	29.26	89407500.0
2006-11-09	NVDA	Stock	0.5885	0.6033	0.5832	0.5882	1207758000.0
2006-11-09	AMZN	Stock	1.975	1.9885	1.9405	1.942	116142000.0
2006-11-09	CL	Stock	32.6	32.6	32.265	32.525	2806600.0
2006-11-09	A	Stock	24.1989	24.4921	24.1845	24.3777	4703152.0
2006-11-09	AABA-DELISTED	Stock	27.1800003051758	27.6499996185303	26.9599990844727	27.4500007629395	27428600.0
2006-11-09	AACC-DELISTED	Stock	16.93	17.14	16.93	17.05	85113.0
2006-11-09	AACQ-DELISTED	Stock	5.42	5.44	5.42	5.44	15500.0
2006-11-09	AACQU-DELISTED	Stock	6.52	6.55	6.52	6.55	14500.0
2006-11-09	AACQW-DELISTED	Stock	0.57	0.59	0.57	0.59	35000.0
2006-11-09	AAI-DELISTED	Stock	10.08	10.11	9.86	10.01	1668900.0
2006-11-09	AAIC-DELISTED	Stock	144.4	144.8	139.0	140.4	2004800.0
2006-11-09	AAME	Stock	2.66	2.66	2.6	2.61	900.0
2006-11-09	AAON	Stock	3.2922	3.2922	3.2053	3.25	293119.0
2006-11-09	AAP	Stock	36.76	37.32	36.76	37.12	1075100.0
2006-11-09	AATI-DELISTED	Stock	5.59	5.66	5.2901	5.3	256001.0
2006-11-09	AAU-DELISTED	Stock	2.65	2.69	2.61	2.66	67600.0
2006-11-09	AAUAF-DELISTED	Stock	2.65	2.69	2.61	2.66	67600.0
2006-11-09	AAV-DELISTED	Stock	11.74	11.97	11.55	11.8801	1204900.0
2006-11-09	AAWW-DELISTED	Stock	39.8	40.39	38.5	39.23	305530.0
2006-11-09	AAXN-DELISTED	Stock	9.25	9.28999996185303	8.97999954223633	9.05000019073486	744500.0
2006-11-09	AB	Stock	78.2	78.36	76.26	76.45	364800.0
2006-11-09	ABAX-DELISTED	Stock	20.41	20.45	19.85	20.01	197425.0
2006-11-09	ABB-DELISTED	Stock	15.33	15.49	15.33	15.37	1443400.0
2006-11-09	ABBC-DELISTED	Stock	15.95	15.99	15.56	15.6	12224.0
2006-11-09	ABC-DELISTED	Stock	22.93	23.05	22.42	22.46	3079800.0
2006-11-09	ABCB	Stock	26.7963	26.7963	25.5513	25.8334	18815.0
2006-11-09	ABCO-DELISTED	Stock	28.22	28.22	27.85	28.0	169461.0
2006-11-09	ABCW-DELISTED	Stock	29.33	29.35	28.3	28.62	29370.0
2006-11-09	ABD-DELISTED	Stock	24.6	24.77	24.38	24.44	345500.0
2006-11-09	ABE-DELISTED	Stock	17.18	17.182	16.69	16.81	29600.0
2006-11-09	ABFS-DELISTED	Stock	40.03	40.03	39.28	39.43	372206.0
2006-11-09	ABG	Stock	24.55	24.93	24.52	24.88	304600.0
2006-11-09	ABK-DELISTED	Stock	85.0	85.0	84.3	84.6	701500.0
2006-11-09	ABM	Stock	20.11	20.4	19.86	20.04	154900.0
2006-11-09	ABMD-DELISTED	Stock	13.53	14.06	13.02	13.04	432978.0
2006-11-09	ABP-DELISTED	Stock	3.34	3.55	3.33	3.55	234800.0
2006-11-09	ABR	Stock	27.91	27.98	27.36	27.47	89100.0
2006-11-09	ABT	Stock	22.6897	22.7713	21.9173	21.994	22208003.0
2006-11-09	ABTL-DELISTED	Stock	16.25	16.7	16.15	16.25	9927.0
2006-11-09	ABV-DELISTED	Stock	46.04	46.46	45.01	45.04	984700.0
2006-11-09	ABVA-DELISTED	Stock	15.54	16.2	15.54	15.77	16697.0
2006-11-09	ABX-DELISTED	Stock	29.74	30.38	29.23	30.14	10653200.0
2006-11-09	ACAD	Stock	9.81	9.81	9.4	9.45	193400.0
2006-11-09	ACAP-DELISTED	Stock	37.61	37.9	36.57	36.61	29844.0
2006-11-09	ACAS-DELISTED	Stock	43.05	43.05	42.28	42.42	753511.0
2006-11-09	ACAT-DELISTED	Stock	18.13	18.17	17.37	17.51	109597.0
2006-11-09	ACC-DELISTED	Stock	27.4	27.41	26.95	27.21	95700.0
2006-11-09	ACCL-DELISTED	Stock	6.2272	6.34	6.01	6.32	39094.0

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

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