PREVIEW / stock_daily / 2006-09-01

all stock daily files

  file:    by_date/stock_daily/2006/2006-09-01.parquet
  size:    149 KB
  rows:    4,484
  symbols: 2,823

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-01	AAPL	Stock	2.4457	2.4518	2.4221	2.4421	408494800.0
2006-09-01	MSFT	Stock	25.89	25.97	25.64	25.84	31594600.0
2006-09-01	NVDA	Stock	0.478	0.4818	0.463	0.4648	605742000.0
2006-09-01	AMZN	Stock	1.5425	1.59	1.5425	1.588	131264000.0
2006-09-01	CL	Stock	30.16	30.36	29.99	30.325	3355200.0
2006-09-01	A	Stock	23.0043	23.0687	22.5465	22.5465	3110270.0
2006-09-01	AABA-DELISTED	Stock	28.9099998474121	29.5300006866455	28.9099998474121	29.4899997711182	11573600.0
2006-09-01	AACC-DELISTED	Stock	14.82	15.09	14.75	14.75	218073.0
2006-09-01	AAI-DELISTED	Stock	11.53	11.59	11.09	11.1	2233300.0
2006-09-01	AAIC-DELISTED	Stock	164.4	165.0	161.8	162.6	993300.0
2006-09-01	AAON	Stock	3.229	3.229	3.1737	3.1895	104794.0
2006-09-01	AAP	Stock	30.24	30.8	30.05	30.7	466500.0
2006-09-01	AATI-DELISTED	Stock	9.5	9.58	9.26	9.27	178108.0
2006-09-01	AAU-DELISTED	Stock	2.67	2.67	2.54	2.55	111200.0
2006-09-01	AAUAF-DELISTED	Stock	2.67	2.67	2.54	2.55	111200.0
2006-09-01	AAV-DELISTED	Stock	16.02	16.13	16.0	16.04	234600.0
2006-09-01	AAWW-DELISTED	Stock	44.23	44.42	44.02	44.07	46699.0
2006-09-01	AAXN-DELISTED	Stock	7.84999990463257	7.90999984741211	7.80000019073486	7.8600001335144	474100.0
2006-09-01	AB	Stock	66.9	67.35	66.5	66.88	111400.0
2006-09-01	ABAX-DELISTED	Stock	24.0	24.14	23.69	23.91	122461.0
2006-09-01	ABB-DELISTED	Stock	13.35	13.38	13.29	13.36	1160500.0
2006-09-01	ABBC-DELISTED	Stock	14.95	15.25	14.91	15.03	8647.0
2006-09-01	ABC-DELISTED	Stock	22.24	22.72	22.2	22.72	1304200.0
2006-09-01	ABCB	Stock	25.3957	25.9014	25.2595	25.2984	15422.0
2006-09-01	ABCO-DELISTED	Stock	25.33	26.0	24.92	25.06	95518.0
2006-09-01	ABCW-DELISTED	Stock	29.33	29.49	29.13	29.14	18710.0
2006-09-01	ABD-DELISTED	Stock	21.75	22.09	21.55	22.06	158800.0
2006-09-01	ABE-DELISTED	Stock	13.5	13.68	13.3901	13.65	12100.0
2006-09-01	ABFS-DELISTED	Stock	44.38	44.81	43.93	44.43	278646.0
2006-09-01	ABG	Stock	20.67	20.72	20.32	20.54	73900.0
2006-09-01	ABK-DELISTED	Stock	86.75	86.97	86.42	86.58	322400.0
2006-09-01	ABM	Stock	18.01	18.62	17.95	18.46	155000.0
2006-09-01	ABMD-DELISTED	Stock	14.95	14.95	14.52	14.71	80634.0
2006-09-01	ABP-DELISTED	Stock	4.05	4.11	4.02	4.1	104300.0
2006-09-01	ABR	Stock	25.2	25.24	25.01	25.06	73800.0
2006-09-01	ABT	Stock	23.4142	23.4142	23.0688	23.2079	9611088.0
2006-09-01	ABTL-DELISTED	Stock	14.0	14.1	13.8	13.95	15036.0
2006-09-01	ABV-DELISTED	Stock	45.15	46.11	45.15	45.83	525100.0
2006-09-01	ABVA-DELISTED	Stock	16.95	17.05	16.334	17.05	20600.0
2006-09-01	ABX-DELISTED	Stock	33.33	33.61	33.06	33.38	3185500.0
2006-09-01	ACAD	Stock	8.72	8.81	8.31	8.36	107100.0
2006-09-01	ACAP-DELISTED	Stock	49.53	50.0	49.41	49.83	16407.0
2006-09-01	ACAS-DELISTED	Stock	38.0	38.19	37.65	38.05	900478.0
2006-09-01	ACAT-DELISTED	Stock	16.71	16.85	16.53	16.65	76579.0
2006-09-01	ACC-DELISTED	Stock	25.9	25.9	25.4	25.45	43600.0
2006-09-01	ACCL-DELISTED	Stock	5.5	5.58	5.4	5.48	58075.0
2006-09-01	ACCO	Stock	21.75	22.09	21.55	22.06	158800.0
2006-09-01	ACCP-DELISTED	Stock	0.85	0.85	0.85	0.85	5750.0
2006-09-01	ACE-DELISTED	Stock	54.23	54.23	53.64	53.99	805100.0
2006-09-01	ACF-DELISTED	Stock	23.45	23.58	23.23	23.39	617600.0

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

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