PREVIEW / stock_daily / 2006-08-17

all stock daily files

  file:    by_date/stock_daily/2006/2006-08-17.parquet
  size:    149 KB
  rows:    4,483
  symbols: 2,830

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-08-17	AAPL	Stock	2.4286	2.4521	2.3993	2.4139	581148400.0
2006-08-17	MSFT	Stock	24.7	24.75	24.61	24.7	45674800.0
2006-08-17	NVDA	Stock	0.4502	0.462	0.4442	0.4487	814224000.0
2006-08-17	AMZN	Stock	1.398	1.4875	1.3915	1.4545	189926000.0
2006-08-17	CL	Stock	29.885	29.885	29.345	29.51	6150600.0
2006-08-17	A	Stock	22.8898	23.1259	22.6896	23.0901	3098108.0
2006-08-17	AABA-DELISTED	Stock	28.3799991607666	29.3199996948242	28.3400001525879	28.9099998474121	17251600.0
2006-08-17	AACC-DELISTED	Stock	15.6	16.5	15.55	16.42	257167.0
2006-08-17	AACQ-DELISTED	Stock	5.32	5.32	5.32	5.32	15900.0
2006-08-17	AACQW-DELISTED	Stock	0.41	0.41	0.41	0.41	20000.0
2006-08-17	AAI-DELISTED	Stock	11.89	11.95	11.43	11.54	1670600.0
2006-08-17	AAIC-DELISTED	Stock	181.4	182.8	180.6	181.0	897300.0
2006-08-17	AAME	Stock	2.7	2.7	2.67	2.67	1400.0
2006-08-17	AAON	Stock	3.0591	3.15	3.0591	3.1328	113906.0
2006-08-17	AAP	Stock	31.05	31.15	30.8	30.96	872100.0
2006-08-17	AATI-DELISTED	Stock	9.92	10.0	9.67	9.71	90816.0
2006-08-17	AAU-DELISTED	Stock	2.62	2.68	2.62	2.66	71900.0
2006-08-17	AAUAF-DELISTED	Stock	2.62	2.68	2.62	2.66	71900.0
2006-08-17	AAV-DELISTED	Stock	16.17	16.18	15.88	15.91	416700.0
2006-08-17	AAWW-DELISTED	Stock	40.63	42.2	40.63	41.7	117370.0
2006-08-17	AAXN-DELISTED	Stock	7.67999982833862	7.73000001907349	7.44999980926514	7.67999982833862	1193500.0
2006-08-17	AB	Stock	69.51	69.65	68.84	69.15	142700.0
2006-08-17	ABAX-DELISTED	Stock	23.05	23.68	22.95	22.97	182017.0
2006-08-17	ABB-DELISTED	Stock	13.42	13.5	13.29	13.36	2567600.0
2006-08-17	ABBC-DELISTED	Stock	14.795	14.86	14.7	14.78	7385.0
2006-08-17	ABC-DELISTED	Stock	21.8	21.88	21.65	21.78	2106600.0
2006-08-17	ABCB	Stock	25.5999	25.7458	24.9969	25.5513	49247.0
2006-08-17	ABCO-DELISTED	Stock	25.53	25.92	25.4	25.57	139101.0
2006-08-17	ABCW-DELISTED	Stock	29.16	29.62	29.1	29.37	26010.0
2006-08-17	ABD-DELISTED	Stock	18.63	18.85	18.53	18.66	487600.0
2006-08-17	ABE-DELISTED	Stock	13.27	13.56	13.25	13.55	11500.0
2006-08-17	ABFS-DELISTED	Stock	45.15	45.96	44.94	45.36	252178.0
2006-08-17	ABG	Stock	20.73	20.79	20.62	20.62	41000.0
2006-08-17	ABK-DELISTED	Stock	84.45	85.02	84.26	85.0	823400.0
2006-08-17	ABM	Stock	17.85	18.07	17.85	17.94	107900.0
2006-08-17	ABMD-DELISTED	Stock	13.41	13.75	13.41	13.73	148549.0
2006-08-17	ABP-DELISTED	Stock	4.1	4.17	3.96	4.08	252600.0
2006-08-17	ABR	Stock	25.16	25.18	24.8	25.06	57300.0
2006-08-17	ABT	Stock	23.5534	23.6302	23.3327	23.5726	13077324.0
2006-08-17	ABTL-DELISTED	Stock	14.1	15.45	14.1	15.0	118721.0
2006-08-17	ABV-DELISTED	Stock	42.92	44.2	42.86	43.61	773600.0
2006-08-17	ABVA-DELISTED	Stock	16.79	16.93	16.7	16.93	2500.0
2006-08-17	ABX-DELISTED	Stock	31.25	31.46	30.68	30.99	2913800.0
2006-08-17	ACAD	Stock	6.95	7.56	6.9	7.35	582800.0
2006-08-17	ACAP-DELISTED	Stock	47.61	49.9	47.61	49.75	50167.0
2006-08-17	ACAS-DELISTED	Stock	37.8	38.3343	37.75	38.3158	1000821.0
2006-08-17	ACAT-DELISTED	Stock	17.81	18.52	17.81	18.47	67330.0
2006-08-17	ACC-DELISTED	Stock	24.99	25.24	24.88	25.22	176657.0
2006-08-17	ACCL-DELISTED	Stock	6.0	6.18	6.0	6.05	28741.0
2006-08-17	ACCO	Stock	18.63	18.85	18.53	18.66	489700.0

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

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