PREVIEW / stock_daily / 2006-09-05

all stock daily files

  file:    by_date/stock_daily/2006/2006-09-05.parquet
  size:    149 KB
  rows:    4,501
  symbols: 2,842

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-05	AAPL	Stock	2.4632	2.5536	2.4482	2.5529	1012457600.0
2006-09-05	MSFT	Stock	25.69	25.96	25.56	25.61	44222400.0
2006-09-05	NVDA	Stock	0.4663	0.4768	0.4595	0.475	549354000.0
2006-09-05	AMZN	Stock	1.5805	1.615	1.562	1.6115	149354000.0
2006-09-05	CL	Stock	30.375	30.47	30.17	30.385	3187800.0
2006-09-05	A	Stock	22.4177	22.6395	22.0815	22.5823	2906861.0
2006-09-05	AABA-DELISTED	Stock	29.4500007629395	29.4799995422363	28.9500007629395	29.0699996948242	11425600.0
2006-09-05	AACC-DELISTED	Stock	14.88	14.97	14.8	14.88	205250.0
2006-09-05	AACQU-DELISTED	Stock	6.05	6.05	6.05	6.05	2000.0
2006-09-05	AAI-DELISTED	Stock	11.19	11.29	10.98	11.14	2154400.0
2006-09-05	AAIC-DELISTED	Stock	162.6	164.2	161.6	162.6	1047500.0
2006-09-05	AAME	Stock	2.6	3.0	2.6	2.87	6800.0
2006-09-05	AAON	Stock	3.2105	3.3027	3.1974	3.3014	100237.0
2006-09-05	AAP	Stock	30.78	31.3	30.78	31.21	822300.0
2006-09-05	AATI-DELISTED	Stock	9.3	9.46	9.2	9.34	192234.0
2006-09-05	AAU-DELISTED	Stock	2.59	2.75	2.59	2.6999	91100.0
2006-09-05	AAUAF-DELISTED	Stock	2.59	2.75	2.59	2.6999	91100.0
2006-09-05	AAV-DELISTED	Stock	16.0	16.01	15.82	15.87	499200.0
2006-09-05	AAWW-DELISTED	Stock	43.93	44.19	43.03	44.0	34637.0
2006-09-05	AAXN-DELISTED	Stock	8.0	8.01000022888184	7.90000009536743	7.96999979019165	498900.0
2006-09-05	AB	Stock	67.13	67.2	65.85	66.01	116100.0
2006-09-05	ABAX-DELISTED	Stock	24.11	24.16	23.78	23.99	309158.0
2006-09-05	ABB-DELISTED	Stock	13.55	13.71	13.53	13.7	3507800.0
2006-09-05	ABBC-DELISTED	Stock	15.1	15.26	15.09	15.24	24599.0
2006-09-05	ABC-DELISTED	Stock	22.74	22.74	22.52	22.56	1423600.0
2006-09-05	ABCB	Stock	24.8996	26.0863	24.8996	25.6972	46883.0
2006-09-05	ABCO-DELISTED	Stock	25.0	25.24	24.44	25.19	97158.0
2006-09-05	ABCW-DELISTED	Stock	29.12	29.53	29.11	29.49	25310.0
2006-09-05	ABD-DELISTED	Stock	22.1	22.43	22.09	22.36	179900.0
2006-09-05	ABE-DELISTED	Stock	13.65	13.9	13.6	13.85	48700.0
2006-09-05	ABFS-DELISTED	Stock	44.2	44.57	44.08	44.28	333008.0
2006-09-05	ABG	Stock	20.59	20.79	20.5	20.67	103500.0
2006-09-05	ABK-DELISTED	Stock	86.74	87.25	85.78	85.8	970000.0
2006-09-05	ABM	Stock	18.56	18.63	18.31	18.46	120300.0
2006-09-05	ABMD-DELISTED	Stock	14.75	16.19	14.52	14.92	1109477.0
2006-09-05	ABP-DELISTED	Stock	4.05	4.12	3.99	4.12	238200.0
2006-09-05	ABR	Stock	25.01	25.36	24.9	25.31	52600.0
2006-09-05	ABT	Stock	23.3039	23.4622	23.1312	23.1983	9928512.0
2006-09-05	ABTL-DELISTED	Stock	13.8	14.0	13.7	13.7	19677.0
2006-09-05	ABV-DELISTED	Stock	45.75	45.94	45.25	45.75	247800.0
2006-09-05	ABVA-DELISTED	Stock	16.28	16.95	16.28	16.32	55308.0
2006-09-05	ABVT-DELISTED	Stock	47.5	47.5	47.5	47.5	400.0
2006-09-05	ABX-DELISTED	Stock	33.7	34.23	33.58	34.04	4282600.0
2006-09-05	ACAD	Stock	8.51	8.52	7.8	7.81	269000.0
2006-09-05	ACAP-DELISTED	Stock	49.78	49.78	48.98	48.98	17643.0
2006-09-05	ACAS-DELISTED	Stock	38.01	38.1	37.65	37.78	836457.0
2006-09-05	ACAT-DELISTED	Stock	16.68	16.68	16.39	16.44	54116.0
2006-09-05	ACC-DELISTED	Stock	25.26	25.48	25.18	25.44	44400.0
2006-09-05	ACCL-DELISTED	Stock	5.51	5.65	5.45	5.53	90000.0
2006-09-05	ACCO	Stock	22.1	22.43	22.09	22.36	230600.0

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

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