PREVIEW / stock_daily / 2006-09-20

all stock daily files

  file:    by_date/stock_daily/2006/2006-09-20.parquet
  size:    151 KB
  rows:    4,515
  symbols: 2,851

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-09-20	AAPL	Stock	2.6564	2.7029	2.6507	2.6879	822791200.0
2006-09-20	MSFT	Stock	27.01	27.23	26.99	27.18	71676400.0
2006-09-20	NVDA	Stock	0.5045	0.5168	0.5035	0.5162	511884000.0
2006-09-20	AMZN	Stock	1.5905	1.6405	1.59	1.606	170978000.0
2006-09-20	CL	Stock	30.9	31.11	30.775	30.925	2223400.0
2006-09-20	A	Stock	22.7682	23.3834	22.7396	23.319	4959824.0
2006-09-20	AABA-DELISTED	Stock	26.0400009155273	26.0900001525879	25.3799991607666	25.6399993896484	55636600.0
2006-09-20	AACC-DELISTED	Stock	14.58	15.07	14.45	15.04	73567.0
2006-09-20	AACQ-DELISTED	Stock	5.37	5.37	5.36	5.36	3000.0
2006-09-20	AACQW-DELISTED	Stock	0.43	0.43	0.41	0.42	129000.0
2006-09-20	AAI-DELISTED	Stock	10.21	10.27	10.04	10.16	2057600.0
2006-09-20	AAIC-DELISTED	Stock	168.4	170.8	167.6	168.4	651300.0
2006-09-20	AAME	Stock	2.46	2.46	2.25	2.45	11500.0
2006-09-20	AAON	Stock	3.0301	3.0512	2.9419	3.0183	195159.0
2006-09-20	AAP	Stock	32.55	33.5	32.55	33.23	1820900.0
2006-09-20	AATI-DELISTED	Stock	7.78	7.8	7.33	7.37	289925.0
2006-09-20	AAU-DELISTED	Stock	2.31	2.3799	2.31	2.32	23000.0
2006-09-20	AAUAF-DELISTED	Stock	2.31	2.3799	2.31	2.32	23000.0
2006-09-20	AAV-DELISTED	Stock	14.01	14.14	13.8	13.8001	531200.0
2006-09-20	AAWW-DELISTED	Stock	44.05	44.48	43.98	44.25	157980.0
2006-09-20	AAXN-DELISTED	Stock	7.44999980926514	7.5	7.34999990463257	7.40000009536743	420300.0
2006-09-20	AB	Stock	66.84	68.17	66.78	67.47	268900.0
2006-09-20	ABAX-DELISTED	Stock	23.68	23.93	23.39	23.7	97772.0
2006-09-20	ABB-DELISTED	Stock	13.37	13.47	13.36	13.42	2046100.0
2006-09-20	ABBC-DELISTED	Stock	15.06	15.21	15.06	15.2	3216.0
2006-09-20	ABC-DELISTED	Stock	23.12	23.26	23.0	23.11	2043600.0
2006-09-20	ABCB	Stock	25.5318	26.7379	25.5318	26.7379	24572.0
2006-09-20	ABCO-DELISTED	Stock	25.23	25.73	25.23	25.61	106108.0
2006-09-20	ABCW-DELISTED	Stock	29.24	29.51	29.11	29.39	23470.0
2006-09-20	ABD-DELISTED	Stock	20.07	20.45	20.07	20.39	340800.0
2006-09-20	ABE-DELISTED	Stock	14.5	14.5	13.9	14.15	24500.0
2006-09-20	ABFS-DELISTED	Stock	44.0	44.7	43.87	44.27	390909.0
2006-09-20	ABG	Stock	18.63	19.69	18.63	19.5	1957200.0
2006-09-20	ABK-DELISTED	Stock	83.5	83.75	82.9	83.75	572200.0
2006-09-20	ABM	Stock	18.87	18.88	18.51	18.87	312500.0
2006-09-20	ABMD-DELISTED	Stock	15.07	15.2299	14.92	15.03	105824.0
2006-09-20	ABP-DELISTED	Stock	3.6	3.71	3.5	3.55	322600.0
2006-09-20	ABR	Stock	25.74	25.9	25.58	25.75	59400.0
2006-09-20	ABT	Stock	23.6781	23.7021	23.2607	23.2943	9934973.0
2006-09-20	ABTL-DELISTED	Stock	15.425	15.475	15.026	15.375	8157.0
2006-09-20	ABV-DELISTED	Stock	45.02	45.5	44.3	44.61	536600.0
2006-09-20	ABVA-DELISTED	Stock	16.95	16.95	16.9	16.9	900.0
2006-09-20	ABVT-DELISTED	Stock	48.0	48.0	48.0	48.0	100.0
2006-09-20	ABX-DELISTED	Stock	28.95	29.07	28.26	28.35	4955300.0
2006-09-20	ACAD	Stock	8.1	8.31	8.06	8.22	72000.0
2006-09-20	ACAP-DELISTED	Stock	50.95	51.1	49.91	50.45	46817.0
2006-09-20	ACAS-DELISTED	Stock	38.2	38.58	38.1	38.49	868500.0
2006-09-20	ACAT-DELISTED	Stock	16.4	16.78	16.2	16.58	45292.0
2006-09-20	ACC-DELISTED	Stock	25.75	25.98	25.59	25.9	178700.0
2006-09-20	ACCL-DELISTED	Stock	5.54	5.54	5.45	5.46	15046.0

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

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