PREVIEW / stock_daily / 2006-09-26

all stock daily files

  file:    by_date/stock_daily/2006/2006-09-26.parquet
  size:    151 KB
  rows:    4,525
  symbols: 2,858

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-26	AAPL	Stock	2.7207	2.7779	2.7179	2.7718	1102948000.0
2006-09-26	MSFT	Stock	26.91	27.32	26.88	27.2	54766500.0
2006-09-26	NVDA	Stock	0.5142	0.5155	0.4973	0.5038	516120000.0
2006-09-26	AMZN	Stock	1.5945	1.6295	1.59	1.625	132022000.0
2006-09-26	CL	Stock	31.08	31.45	31.025	31.18	4371200.0
2006-09-26	A	Stock	23.4764	23.784	23.269	23.5622	3220712.0
2006-09-26	AABA-DELISTED	Stock	25.4400005340576	25.4799995422363	24.8099994659424	25.0499992370605	34950100.0
2006-09-26	AACC-DELISTED	Stock	14.94	15.72	14.94	15.67	309504.0
2006-09-26	AAI-DELISTED	Stock	10.27	10.49	10.17	10.19	1692900.0
2006-09-26	AAIC-DELISTED	Stock	161.0	166.4	160.2	166.2	1226100.0
2006-09-26	AAME	Stock	2.5	2.65	2.39	2.43	5200.0
2006-09-26	AAON	Stock	2.9761	3.0578	2.9682	3.0578	83531.0
2006-09-26	AAP	Stock	33.97	34.26	33.89	34.2	1013000.0
2006-09-26	AATI-DELISTED	Stock	5.71	5.89	5.7	5.795	602238.0
2006-09-26	AAU-DELISTED	Stock	2.1801	2.27	2.17	2.25	20300.0
2006-09-26	AAUAF-DELISTED	Stock	2.1801	2.27	2.17	2.25	20300.0
2006-09-26	AAV-DELISTED	Stock	12.34	12.7	12.25	12.6203	898700.0
2006-09-26	AAWW-DELISTED	Stock	43.64	44.0	43.63	43.84	46020.0
2006-09-26	AAXN-DELISTED	Stock	7.40000009536743	7.5	7.32000017166138	7.34999990463257	528000.0
2006-09-26	AB	Stock	69.1	69.77	68.65	69.5	249300.0
2006-09-26	ABAX-DELISTED	Stock	22.53	22.54	22.043	22.35	435317.0
2006-09-26	ABB-DELISTED	Stock	13.21	13.31	13.14	13.29	1955600.0
2006-09-26	ABBC-DELISTED	Stock	15.22	15.24	15.13	15.14	900.0
2006-09-26	ABC-DELISTED	Stock	22.44	22.48	22.0	22.22	2002173.0
2006-09-26	ABCB	Stock	27.3799	27.3799	26.7963	26.8643	39377.0
2006-09-26	ABCO-DELISTED	Stock	25.41	25.56	25.08	25.39	127445.0
2006-09-26	ABCW-DELISTED	Stock	29.07	29.3	28.6	29.07	18400.0
2006-09-26	ABD-DELISTED	Stock	21.75	22.07	21.44	21.95	308130.0
2006-09-26	ABE-DELISTED	Stock	13.64	14.15	13.64	14.02	10800.0
2006-09-26	ABFS-DELISTED	Stock	43.18	44.76	43.18	44.46	489437.0
2006-09-26	ABG	Stock	19.87	20.47	19.83	20.35	483900.0
2006-09-26	ABK-DELISTED	Stock	83.1	83.39	83.0	83.06	675300.0
2006-09-26	ABM	Stock	19.0	19.18	18.88	19.0	258900.0
2006-09-26	ABMD-DELISTED	Stock	15.1	15.25	14.77	14.98	73724.0
2006-09-26	ABP-DELISTED	Stock	2.98	3.1	2.9	3.05	493600.0
2006-09-26	ABR	Stock	25.83	25.94	25.57	25.57	119700.0
2006-09-26	ABT	Stock	23.0592	23.1024	22.8097	23.064	9970613.0
2006-09-26	ABTL-DELISTED	Stock	15.05	15.35	15.05	15.1	5401.0
2006-09-26	ABV-DELISTED	Stock	44.28	45.0	44.15	45.0	341600.0
2006-09-26	ABVA-DELISTED	Stock	16.61	16.65	16.55	16.55	7141.0
2006-09-26	ABX-DELISTED	Stock	29.1	30.31	29.08	30.22	4421520.0
2006-09-26	ACAD	Stock	8.3	8.49	8.17	8.38	88300.0
2006-09-26	ACAP-DELISTED	Stock	50.72	51.22	49.57	49.86	45595.0
2006-09-26	ACAS-DELISTED	Stock	38.68	39.27	38.66	39.26	1052992.0
2006-09-26	ACAT-DELISTED	Stock	16.745	16.755	16.355	16.735	46780.0
2006-09-26	ACC-DELISTED	Stock	25.73	25.73	25.49	25.58	139300.0
2006-09-26	ACCL-DELISTED	Stock	5.43	5.48	5.4	5.48	47527.0
2006-09-26	ACCO	Stock	21.73	22.05	21.42	21.97	337000.0
2006-09-26	ACCP-DELISTED	Stock	0.95	0.95	0.95	0.95	500.0
2006-09-26	ACE-DELISTED	Stock	55.01	56.1	54.96	55.96	1372300.0

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

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