PREVIEW / stock_daily / 2006-09-08

all stock daily files

  file:    by_date/stock_daily/2006/2006-09-08.parquet
  size:    149 KB
  rows:    4,472
  symbols: 2,813

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-08	AAPL	Stock	2.6204	2.6275	2.5682	2.59	895921600.0
2006-09-08	MSFT	Stock	25.53	25.79	25.46	25.6	36866800.0
2006-09-08	NVDA	Stock	0.4675	0.4695	0.4515	0.4617	447978000.0
2006-09-08	AMZN	Stock	1.5095	1.533	1.497	1.5255	104544000.0
2006-09-08	CL	Stock	30.43	30.61	30.28	30.38	2772400.0
2006-09-08	A	Stock	21.8169	22.0672	21.7811	21.9456	1691580.0
2006-09-08	AABA-DELISTED	Stock	28.0400009155273	28.3199996948242	27.9699993133545	28.1399993896484	9781800.0
2006-09-08	AACC-DELISTED	Stock	14.45	14.59	14.26	14.43	222843.0
2006-09-08	AACQ-DELISTED	Stock	5.32	5.37	5.32	5.37	27500.0
2006-09-08	AACQU-DELISTED	Stock	6.08	6.08	6.08	6.08	500.0
2006-09-08	AAI-DELISTED	Stock	10.05	10.1	9.06	9.46	9061600.0
2006-09-08	AAIC-DELISTED	Stock	156.0	161.0	156.0	160.6	879300.0
2006-09-08	AAON	Stock	2.9498	2.9616	2.8194	2.8194	285525.0
2006-09-08	AAP	Stock	31.26	31.6	31.02	31.32	2303900.0
2006-09-08	AATI-DELISTED	Stock	8.54	8.55	8.27	8.42	90395.0
2006-09-08	AAU-DELISTED	Stock	2.55	2.57	2.5	2.52	43500.0
2006-09-08	AAUAF-DELISTED	Stock	2.55	2.57	2.5	2.52	43500.0
2006-09-08	AAV-DELISTED	Stock	14.89	14.93	14.55	14.82	596800.0
2006-09-08	AAWW-DELISTED	Stock	43.31	43.31	42.39	42.86	49877.0
2006-09-08	AAXN-DELISTED	Stock	7.55999994277954	7.6399998664856	7.48999977111816	7.5	383200.0
2006-09-08	AB	Stock	66.6	67.01	66.36	66.87	119200.0
2006-09-08	ABAX-DELISTED	Stock	22.26	22.8	22.2484	22.31	139103.0
2006-09-08	ABB-DELISTED	Stock	13.25	13.25	13.18	13.18	1883300.0
2006-09-08	ABBC-DELISTED	Stock	14.96	15.0	14.96	15.0	300.0
2006-09-08	ABC-DELISTED	Stock	22.43	22.5497	22.4	22.44	1156800.0
2006-09-08	ABCB	Stock	24.8413	25.454	24.7635	25.2498	11618.0
2006-09-08	ABCO-DELISTED	Stock	24.77	24.98	24.22	24.46	145200.0
2006-09-08	ABCW-DELISTED	Stock	28.84	28.92	28.57	28.6	65380.0
2006-09-08	ABD-DELISTED	Stock	21.27	21.37	21.0	21.27	74000.0
2006-09-08	ABE-DELISTED	Stock	13.45	13.5	13.45	13.5	8700.0
2006-09-08	ABFS-DELISTED	Stock	43.04	43.49	42.75	43.23	314152.0
2006-09-08	ABG	Stock	20.4	20.41	19.68	19.89	175700.0
2006-09-08	ABK-DELISTED	Stock	84.42	84.58	83.79	84.32	716500.0
2006-09-08	ABM	Stock	18.19	18.35	17.86	18.27	187600.0
2006-09-08	ABMD-DELISTED	Stock	14.55	14.82	14.51	14.66	150924.0
2006-09-08	ABP-DELISTED	Stock	4.05	4.09	3.92	4.05	148900.0
2006-09-08	ABR	Stock	24.77	24.99	24.75	24.96	59700.0
2006-09-08	ABT	Stock	22.9824	23.491	22.9824	23.4622	12019383.0
2006-09-08	ABTL-DELISTED	Stock	13.88	16.101	13.88	16.0	144534.0
2006-09-08	ABV-DELISTED	Stock	44.2	44.7	43.78	44.57	346700.0
2006-09-08	ABVA-DELISTED	Stock	17.0	17.11	16.75	17.11	3230.0
2006-09-08	ABX-DELISTED	Stock	32.1	32.1	31.33	31.38	5268600.0
2006-09-08	ACAD	Stock	8.05	8.09	7.65	7.72	339800.0
2006-09-08	ACAP-DELISTED	Stock	46.54	46.8	46.22	46.75	24832.0
2006-09-08	ACAS-DELISTED	Stock	36.75	37.17	36.55	37.1	626700.0
2006-09-08	ACAT-DELISTED	Stock	15.77	16.15	15.59	16.13	85193.0
2006-09-08	ACC-DELISTED	Stock	24.75	24.87	24.47	24.72	124400.0
2006-09-08	ACCL-DELISTED	Stock	5.4	5.4	5.3	5.36	59951.0
2006-09-08	ACCO	Stock	21.28	21.38	21.0	21.26	76300.0
2006-09-08	ACCP-DELISTED	Stock	0.84	0.85	0.8	0.85	1600.0

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

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