PREVIEW / stock_daily / 2006-12-07

all stock daily files

  file:    by_date/stock_daily/2006/2006-12-07.parquet
  size:    155 KB
  rows:    4,631
  symbols: 2,932

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-07	AAPL	Stock	3.2154	3.2321	3.1036	3.1086	1004827600.0
2006-12-07	MSFT	Stock	28.96	29.07	28.81	28.85	46831100.0
2006-12-07	NVDA	Stock	0.6092	0.6125	0.5892	0.5945	486894000.0
2006-12-07	AMZN	Stock	1.9465	1.9545	1.9025	1.906	132430000.0
2006-12-07	CL	Stock	32.85	33.07	32.765	32.815	1676600.0
2006-12-07	A	Stock	23.8197	24.0701	23.7124	23.7625	3289774.0
2006-12-07	AABA-DELISTED	Stock	26.9500007629395	27.1599998474121	26.6000003814697	26.6299991607666	22407000.0
2006-12-07	AACC-DELISTED	Stock	16.4	16.64	16.15	16.4	75379.0
2006-12-07	AACQ-DELISTED	Stock	5.47	5.47	5.45	5.45	23000.0
2006-12-07	AACQU-DELISTED	Stock	6.53	6.53	6.53	6.53	8000.0
2006-12-07	AACQW-DELISTED	Stock	0.55	0.56	0.55	0.56	10000.0
2006-12-07	AAI-DELISTED	Stock	12.38	12.71	12.36	12.41	1239500.0
2006-12-07	AAIC-DELISTED	Stock	156.6	157.39	153.4	155.6	1268700.0
2006-12-07	AAME	Stock	2.91	2.95	2.91	2.95	3500.0
2006-12-07	AAON	Stock	3.682	3.6886	3.6477	3.6688	224016.0
2006-12-07	AAP	Stock	37.01	38.58	36.98	37.01	2561900.0
2006-12-07	AATI-DELISTED	Stock	5.65	5.8	5.42	5.42	275153.0
2006-12-07	AAU-DELISTED	Stock	2.42	2.42	2.32	2.35	55029.0
2006-12-07	AAUAF-DELISTED	Stock	2.51	2.51	2.41	2.44	53000.0
2006-12-07	AAV-DELISTED	Stock	12.15	12.21	12.0	12.0	587200.0
2006-12-07	AAWW-DELISTED	Stock	43.88	44.85	43.8	44.55	205946.0
2006-12-07	AAXN-DELISTED	Stock	8.5600004196167	8.64999961853027	8.35000038146973	8.35999965667725	599200.0
2006-12-07	AB	Stock	79.75	80.8	79.39	79.7	222900.0
2006-12-07	ABAX-DELISTED	Stock	19.7	19.74	19.17	19.45	107811.0
2006-12-07	ABB-DELISTED	Stock	16.95	17.04	16.84	16.95	3052900.0
2006-12-07	ABBC-DELISTED	Stock	19.32	19.36	19.3	19.3	5312.0
2006-12-07	ABC-DELISTED	Stock	23.22	23.36	23.12	23.18	1807400.0
2006-12-07	ABCB	Stock	26.9325	27.4479	26.6796	26.9033	8122.0
2006-12-07	ABCO-DELISTED	Stock	27.49	27.49	26.86	26.88	200500.0
2006-12-07	ABCW-DELISTED	Stock	29.27	29.3	28.62	28.79	16330.0
2006-12-07	ABD-DELISTED	Stock	25.62	25.9	25.43	25.51	166090.0
2006-12-07	ABE-DELISTED	Stock	18.75	19.43	18.7499	19.1	85000.0
2006-12-07	ABFS-DELISTED	Stock	37.34	37.6	37.09	37.37	374046.0
2006-12-07	ABG	Stock	23.98	23.99	23.75	23.83	126600.0
2006-12-07	ABK-DELISTED	Stock	85.99	85.99	85.08	85.44	389300.0
2006-12-07	ABM	Stock	20.9	20.95	20.75	20.75	91500.0
2006-12-07	ABMD-DELISTED	Stock	12.93	13.0	12.61	12.92	102454.0
2006-12-07	ABP-DELISTED	Stock	4.1	4.13	4.0	4.02	72600.0
2006-12-07	ABR	Stock	28.68	29.0	28.5	28.78	79500.0
2006-12-07	ABT	Stock	23.1839	23.2751	23.016	23.0496	7458524.0
2006-12-07	ABTL-DELISTED	Stock	16.25	16.85	16.247	16.4	33382.0
2006-12-07	ABV-DELISTED	Stock	47.55	47.75	47.34	47.6	543000.0
2006-12-07	ABVA-DELISTED	Stock	16.1499	16.24	16.1499	16.23	1100.0
2006-12-07	ABX-DELISTED	Stock	30.5	30.9	29.96	30.7499	3192200.0
2006-12-07	ACAD	Stock	9.05	9.12	8.97	9.0	111100.0
2006-12-07	ACAP-DELISTED	Stock	39.58	39.75	39.2	39.22	35158.0
2006-12-07	ACAS-DELISTED	Stock	44.87	45.1155	44.44	44.58	864283.0
2006-12-07	ACAT-DELISTED	Stock	17.99	18.21	17.69	18.02	50523.0
2006-12-07	ACC-DELISTED	Stock	29.79	30.01	29.53	29.55	124537.0
2006-12-07	ACCL-DELISTED	Stock	6.0091	6.04	5.95	6.03	32152.0

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

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