PREVIEW / stock_daily / 2006-09-29

all stock daily files

  file:    by_date/stock_daily/2006/2006-09-29.parquet
  size:    151 KB
  rows:    4,521
  symbols: 2,853

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-29	AAPL	Stock	2.7539	2.7686	2.7386	2.7493	405812400.0
2006-09-29	MSFT	Stock	27.35	27.42	27.21	27.35	34283500.0
2006-09-29	NVDA	Stock	0.4962	0.5	0.4905	0.4932	373890000.0
2006-09-29	AMZN	Stock	1.6005	1.617	1.577	1.606	104544000.0
2006-09-29	CL	Stock	31.21	31.37	30.945	31.05	4343800.0
2006-09-29	A	Stock	23.6052	23.7268	23.3476	23.3834	2035208.0
2006-09-29	AABA-DELISTED	Stock	25.5	25.5900001525879	25.2399997711182	25.2800006866455	18982600.0
2006-09-29	AACC-DELISTED	Stock	16.2	16.63	16.09	16.25	219871.0
2006-09-29	AACQ-DELISTED	Stock	5.345	5.36	5.345	5.35	342767.0
2006-09-29	AACQU-DELISTED	Stock	6.05	6.1	6.05	6.1	15500.0
2006-09-29	AACQW-DELISTED	Stock	0.395	0.46	0.395	0.46	430697.0
2006-09-29	AAI-DELISTED	Stock	9.95	10.16	9.89	9.92	1278600.0
2006-09-29	AAIC-DELISTED	Stock	162.2	162.8	160.2	160.6	726600.0
2006-09-29	AAME	Stock	2.59	2.59	2.43	2.43	2000.0
2006-09-29	AAON	Stock	3.096	3.1144	2.9919	3.0038	105553.0
2006-09-29	AAP	Stock	33.73	34.03	32.94	32.94	777300.0
2006-09-29	AATI-DELISTED	Stock	5.47	5.52	5.33	5.48	511515.0
2006-09-29	AAU-DELISTED	Stock	2.2	2.28	2.16	2.27	30800.0
2006-09-29	AAUAF-DELISTED	Stock	2.2	2.28	2.16	2.27	30800.0
2006-09-29	AAV-DELISTED	Stock	12.23	12.3	11.95	12.3	651900.0
2006-09-29	AAWW-DELISTED	Stock	43.74	43.98	43.47	43.53	100264.0
2006-09-29	AAXN-DELISTED	Stock	7.25	7.84999990463257	7.25	7.65999984741211	1396500.0
2006-09-29	AB	Stock	69.2	69.38	68.89	68.99	129600.0
2006-09-29	ABAX-DELISTED	Stock	23.27	23.63	23.18	23.35	218090.0
2006-09-29	ABB-DELISTED	Stock	13.16	13.23	13.15	13.18	1264700.0
2006-09-29	ABBC-DELISTED	Stock	15.15	15.2	15.01	15.01	14607.0
2006-09-29	ABC-DELISTED	Stock	22.61	22.74	22.5	22.62	2523800.0
2006-09-29	ABCB	Stock	26.9033	26.9714	26.4461	26.4656	18815.0
2006-09-29	ABCO-DELISTED	Stock	25.46	25.5	25.22	25.27	196256.0
2006-09-29	ABCW-DELISTED	Stock	29.11	29.11	28.59	28.6	29770.0
2006-09-29	ABD-DELISTED	Stock	22.3	22.36	22.06	22.26	312700.0
2006-09-29	ABE-DELISTED	Stock	13.76	14.3883	13.76	14.27	20900.0
2006-09-29	ABFS-DELISTED	Stock	43.88	43.88	42.66	43.05	463885.0
2006-09-29	ABG	Stock	20.43	20.8	20.42	20.6	394400.0
2006-09-29	ABK-DELISTED	Stock	83.33	83.58	82.55	82.55	787200.0
2006-09-29	ABM	Stock	18.9	18.91	18.69	18.76	281700.0
2006-09-29	ABMD-DELISTED	Stock	15.14	15.18	14.73	14.76	92920.0
2006-09-29	ABP-DELISTED	Stock	3.1	3.12	3.05	3.06	144700.0
2006-09-29	ABR	Stock	25.7	25.93	25.56	25.56	138200.0
2006-09-29	ABT	Stock	23.1024	23.3615	23.0496	23.2991	7481451.0
2006-09-29	ABTL-DELISTED	Stock	14.775	15.026	14.625	14.625	22381.0
2006-09-29	ABV-DELISTED	Stock	45.2	45.57	44.95	45.3	297500.0
2006-09-29	ABVA-DELISTED	Stock	16.72	16.92	16.6	16.8	1300.0
2006-09-29	ABVT-DELISTED	Stock	49.0	54.0	49.0	54.0	16.0
2006-09-29	ABX-DELISTED	Stock	30.63	31.29	30.27	30.74	3180663.0
2006-09-29	ACAD	Stock	8.62	8.74	8.61	8.64	122300.0
2006-09-29	ACAP-DELISTED	Stock	48.85	49.55	48.42	48.42	26796.0
2006-09-29	ACAS-DELISTED	Stock	39.35	39.74	39.22	39.47	1323380.0
2006-09-29	ACAT-DELISTED	Stock	17.23	17.39	16.54	16.59	158292.0
2006-09-29	ACC-DELISTED	Stock	25.59	25.96	25.45	25.5	290400.0

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

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