PREVIEW / stock_daily / 2006-11-08

all stock daily files

  file:    by_date/stock_daily/2006/2006-11-08.parquet
  size:    152 KB
  rows:    4,559
  symbols: 2,885

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-08	AAPL	Stock	2.8579	2.9532	2.8532	2.9446	690916800.0
2006-11-08	MSFT	Stock	28.78	29.23	28.66	28.98	77403300.0
2006-11-08	NVDA	Stock	0.5643	0.5837	0.563	0.5767	648324000.0
2006-11-08	AMZN	Stock	1.929	1.974	1.923	1.9735	163198000.0
2006-11-08	CL	Stock	32.5	32.535	32.32	32.5	5107400.0
2006-11-08	A	Stock	23.877	24.2346	23.8197	24.0844	2743016.0
2006-11-08	AABA-DELISTED	Stock	26.3600006103516	27.25	26.3099994659424	26.8999996185303	23384800.0
2006-11-08	AACC-DELISTED	Stock	16.89	16.99	16.8	16.95	98372.0
2006-11-08	AACQ-DELISTED	Stock	5.43	5.43	5.43	5.43	12000.0
2006-11-08	AACQU-DELISTED	Stock	6.55	6.55	6.55	6.55	5000.0
2006-11-08	AACQW-DELISTED	Stock	0.56	0.57	0.56	0.57	120000.0
2006-11-08	AAI-DELISTED	Stock	10.15	10.18	9.82	10.13	2026800.0
2006-11-08	AAIC-DELISTED	Stock	146.4	148.0	144.8	145.6	1524000.0
2006-11-08	AAME	Stock	2.61	2.74	2.61	2.72	1700.0
2006-11-08	AAON	Stock	3.1539	3.279	3.0749	3.2764	333366.0
2006-11-08	AAP	Stock	35.84	36.79	35.63	36.73	763000.0
2006-11-08	AATI-DELISTED	Stock	5.64	5.64	5.52	5.55	244740.0
2006-11-08	AAU-DELISTED	Stock	2.63	2.69	2.62	2.66	39600.0
2006-11-08	AAUAF-DELISTED	Stock	2.63	2.69	2.62	2.66	39600.0
2006-11-08	AAV-DELISTED	Stock	11.3	11.56	11.05	11.4586	856100.0
2006-11-08	AAWW-DELISTED	Stock	43.05	43.12	41.37	41.49	414536.0
2006-11-08	AAXN-DELISTED	Stock	9.0600004196167	9.22000026702881	9.0	9.18000030517578	667500.0
2006-11-08	AB	Stock	77.87	78.6	77.6	78.27	364700.0
2006-11-08	ABAX-DELISTED	Stock	19.93	20.62	19.9	20.31	123692.0
2006-11-08	ABB-DELISTED	Stock	15.12	15.3	15.09	15.25	1210000.0
2006-11-08	ABBC-DELISTED	Stock	15.895	16.06	15.85	15.9	7505.0
2006-11-08	ABC-DELISTED	Stock	22.4	22.9	22.4	22.82	2838000.0
2006-11-08	ABCB	Stock	26.4072	26.8254	26.2321	26.8254	21077.0
2006-11-08	ABCO-DELISTED	Stock	27.7	28.33	27.67	28.19	170719.0
2006-11-08	ABCW-DELISTED	Stock	28.83	29.47	28.81	29.35	36080.0
2006-11-08	ABD-DELISTED	Stock	24.73	25.1	24.55	24.58	310500.0
2006-11-08	ABE-DELISTED	Stock	17.1	17.18	16.95	17.1	19300.0
2006-11-08	ABFS-DELISTED	Stock	39.55	40.2	39.15	39.99	538161.0
2006-11-08	ABG	Stock	23.5	24.61	23.5	24.54	443900.0
2006-11-08	ABK-DELISTED	Stock	84.5	85.33	84.47	84.75	531200.0
2006-11-08	ABM	Stock	20.05	20.42	20.05	20.36	126100.0
2006-11-08	ABMD-DELISTED	Stock	13.1	13.5	13.0	13.3	113047.0
2006-11-08	ABP-DELISTED	Stock	3.4	3.41	3.3	3.36	140600.0
2006-11-08	ABR	Stock	27.79	28.01	27.3	27.98	163000.0
2006-11-08	ABT	Stock	22.7905	22.8241	22.5746	22.6849	15578574.0
2006-11-08	ABTL-DELISTED	Stock	16.2	16.401	16.199	16.3	4248.0
2006-11-08	ABV-DELISTED	Stock	44.98	45.6	44.6	45.418	391200.0
2006-11-08	ABVA-DELISTED	Stock	16.244	16.25	15.94	16.25	8075.0
2006-11-08	ABX-DELISTED	Stock	30.0	30.02	29.11	29.47	6220100.0
2006-11-08	ACAD	Stock	9.92	9.92	9.65	9.76	137700.0
2006-11-08	ACAP-DELISTED	Stock	36.38	37.72	36.38	37.56	39998.0
2006-11-08	ACAS-DELISTED	Stock	42.31	43.16	42.25	42.82	1140071.0
2006-11-08	ACAT-DELISTED	Stock	17.32	18.2	17.16	18.1	143478.0
2006-11-08	ACC-DELISTED	Stock	27.37	27.37	26.77	27.28	122131.0
2006-11-08	ACCL-DELISTED	Stock	6.2	6.28	6.15	6.26	26026.0

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

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