PREVIEW / stock_daily / 2006-10-20

all stock daily files

  file:    by_date/stock_daily/2006/2006-10-20.parquet
  size:    152 KB
  rows:    4,525
  symbols: 2,852

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-10-20	AAPL	Stock	2.8204	2.8568	2.8096	2.8554	639413600.0
2006-10-20	MSFT	Stock	28.48	28.49	28.17	28.43	48887800.0
2006-10-20	NVDA	Stock	0.5402	0.5405	0.5222	0.5298	359478000.0
2006-10-20	AMZN	Stock	1.6345	1.6345	1.6105	1.6285	116788000.0
2006-10-20	CL	Stock	30.15	30.43	30.09	30.37	6463000.0
2006-10-20	A	Stock	25.0143	25.0644	24.7854	24.9785	2711281.0
2006-10-20	AABA-DELISTED	Stock	23.2199993133545	23.2700004577637	22.6499996185303	23.2099990844727	49795600.0
2006-10-20	AACC-DELISTED	Stock	17.63	17.74	17.31	17.47	88032.0
2006-10-20	AACQU-DELISTED	Stock	6.03	6.03	6.03	6.03	3400.0
2006-10-20	AACQW-DELISTED	Stock	0.38	0.39	0.38	0.39	55000.0
2006-10-20	AAI-DELISTED	Stock	10.63	11.19	10.54	11.06	3017900.0
2006-10-20	AAIC-DELISTED	Stock	160.4	160.4	157.0	158.0	770200.0
2006-10-20	AAME	Stock	2.59	2.96	2.59	2.92	9000.0
2006-10-20	AAON	Stock	3.1605	3.1631	3.1394	3.1565	50878.0
2006-10-20	AAP	Stock	35.58	35.77	35.22	35.46	629600.0
2006-10-20	AATI-DELISTED	Stock	5.47	5.48	5.3	5.42	214362.0
2006-10-20	AAU-DELISTED	Stock	2.49	2.5	2.44	2.5	27600.0
2006-10-20	AAUAF-DELISTED	Stock	2.49	2.5	2.44	2.5	27600.0
2006-10-20	AAV-DELISTED	Stock	14.1	14.1	13.65	13.95	589900.0
2006-10-20	AAWW-DELISTED	Stock	48.23	48.23	47.28	47.68	87686.0
2006-10-20	AAXN-DELISTED	Stock	9.47999954223633	9.47999954223633	9.14999961853027	9.15999984741211	683100.0
2006-10-20	AB	Stock	75.87	76.0	74.29	74.5	344000.0
2006-10-20	ABAX-DELISTED	Stock	21.88	22.28	21.82	22.19	149797.0
2006-10-20	ABB-DELISTED	Stock	14.24	14.37	14.19	14.34	5919800.0
2006-10-20	ABBC-DELISTED	Stock	15.9899	16.0	15.9899	16.0	3620.0
2006-10-20	ABC-DELISTED	Stock	23.32	23.4	23.25	23.33	877400.0
2006-10-20	ABCB	Stock	27.2826	27.3312	26.9325	27.2437	40303.0
2006-10-20	ABCO-DELISTED	Stock	27.83	27.84	27.38	27.5	170270.0
2006-10-20	ABCW-DELISTED	Stock	29.46	29.46	29.06	29.23	12280.0
2006-10-20	ABD-DELISTED	Stock	24.0	24.0	23.3	23.76	205300.0
2006-10-20	ABE-DELISTED	Stock	15.58	15.58	15.2	15.21	22900.0
2006-10-20	ABFS-DELISTED	Stock	45.17	45.1799	43.99	45.03	743729.0
2006-10-20	ABG	Stock	23.87	24.04	23.78	23.99	375000.0
2006-10-20	ABK-DELISTED	Stock	84.6	85.0	84.19	84.79	599900.0
2006-10-20	ABM	Stock	19.67	19.74	19.59	19.66	109300.0
2006-10-20	ABMD-DELISTED	Stock	14.18	14.2	13.59	13.94	66051.0
2006-10-20	ABP-DELISTED	Stock	3.66	3.69	3.65	3.66	46900.0
2006-10-20	ABR	Stock	27.0	27.32	26.9	27.32	47300.0
2006-10-20	ABT	Stock	23.1024	23.4526	22.8961	23.4046	14867236.0
2006-10-20	ABTL-DELISTED	Stock	16.602	16.602	16.198	16.4	4019.0
2006-10-20	ABV-DELISTED	Stock	45.5	45.6	44.34	44.59	538200.0
2006-10-20	ABVA-DELISTED	Stock	17.28	17.28	17.27	17.27	527.0
2006-10-20	ABX-DELISTED	Stock	30.71	30.94	29.99	30.03	3027000.0
2006-10-20	ACAD	Stock	10.47	10.47	9.89	10.04	127200.0
2006-10-20	ACAP-DELISTED	Stock	52.07	52.69	51.56	52.49	26993.0
2006-10-20	ACAS-DELISTED	Stock	41.64	41.72	41.18	41.52	981075.0
2006-10-20	ACAT-DELISTED	Stock	17.0	17.0	16.45	16.49	74409.0
2006-10-20	ACC-DELISTED	Stock	26.85	26.85	26.55	26.66	41900.0
2006-10-20	ACCL-DELISTED	Stock	6.25	6.36	6.17	6.28	36887.0
2006-10-20	ACCO	Stock	24.0	24.0	23.3	23.76	226600.0

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

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