PREVIEW / stock_daily / 2006-09-06

all stock daily files

  file:    by_date/stock_daily/2006/2006-09-06.parquet
  size:    149 KB
  rows:    4,481
  symbols: 2,826

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-06	AAPL	Stock	2.5386	2.5604	2.4893	2.5011	974103200.0
2006-09-06	MSFT	Stock	25.51	25.72	25.51	25.61	50160400.0
2006-09-06	NVDA	Stock	0.4667	0.4673	0.45	0.4512	493572000.0
2006-09-06	AMZN	Stock	1.588	1.599	1.5325	1.54	182282000.0
2006-09-06	CL	Stock	30.325	30.705	30.245	30.665	3958200.0
2006-09-06	A	Stock	22.4249	22.432	21.9242	21.9528	3316755.0
2006-09-06	AABA-DELISTED	Stock	28.9400005340576	29.0100002288818	28.4899997711182	28.5	12800600.0
2006-09-06	AACC-DELISTED	Stock	14.81	14.91	14.67	14.72	100362.0
2006-09-06	AACQW-DELISTED	Stock	0.38	0.38	0.38	0.38	3000.0
2006-09-06	AAI-DELISTED	Stock	11.0	11.15	10.85	10.85	1027000.0
2006-09-06	AAIC-DELISTED	Stock	161.0	161.2	158.6	158.6	1214200.0
2006-09-06	AAON	Stock	3.2698	3.2816	3.196	3.1987	135928.0
2006-09-06	AAP	Stock	31.16	31.4	30.8	31.1	983700.0
2006-09-06	AATI-DELISTED	Stock	9.26	9.35	9.0	9.07	228464.0
2006-09-06	AAU-DELISTED	Stock	2.65	2.7	2.65	2.65	46890.0
2006-09-06	AAUAF-DELISTED	Stock	2.66	2.7	2.65	2.65	46800.0
2006-09-06	AAV-DELISTED	Stock	15.85	15.85	15.28	15.3811	813300.0
2006-09-06	AAWW-DELISTED	Stock	43.92	43.9399	43.37	43.86	30513.0
2006-09-06	AAXN-DELISTED	Stock	7.96000003814697	7.96000003814697	7.69000005722046	7.69999980926514	472500.0
2006-09-06	AB	Stock	66.21	67.44	66.21	66.7	196400.0
2006-09-06	ABAX-DELISTED	Stock	23.75	23.8	23.0	23.0	116343.0
2006-09-06	ABB-DELISTED	Stock	13.5	13.55	13.4	13.42	2346300.0
2006-09-06	ABBC-DELISTED	Stock	15.16	15.21	14.85	14.97	33651.0
2006-09-06	ABC-DELISTED	Stock	22.48	22.58	22.32	22.38	1402600.0
2006-09-06	ABCB	Stock	25.4832	25.7264	25.3957	25.3957	9150.0
2006-09-06	ABCO-DELISTED	Stock	24.96	24.96	24.57	24.68	164834.0
2006-09-06	ABCW-DELISTED	Stock	29.26	29.43	28.84	28.84	16260.0
2006-09-06	ABD-DELISTED	Stock	22.32	22.32	21.72	21.81	291800.0
2006-09-06	ABE-DELISTED	Stock	13.8	13.9	13.6	13.8301	28200.0
2006-09-06	ABFS-DELISTED	Stock	44.25	44.25	43.36	43.37	431763.0
2006-09-06	ABG	Stock	20.62	20.94	20.55	20.73	61800.0
2006-09-06	ABK-DELISTED	Stock	85.3	85.35	84.65	84.86	680800.0
2006-09-06	ABM	Stock	18.31	18.41	18.11	18.3	101200.0
2006-09-06	ABMD-DELISTED	Stock	15.14	15.27	14.14	14.86	458417.0
2006-09-06	ABP-DELISTED	Stock	4.05	4.09	4.0	4.0	49500.0
2006-09-06	ABR	Stock	25.1	25.12	24.95	24.95	98600.0
2006-09-06	ABT	Stock	23.1264	23.1551	22.6993	22.9968	9711963.0
2006-09-06	ABTL-DELISTED	Stock	13.75	13.8	13.0	13.2	80476.0
2006-09-06	ABV-DELISTED	Stock	45.77	45.77	44.31	44.33	272800.0
2006-09-06	ABVA-DELISTED	Stock	16.35	16.91	16.35	16.35	2320.0
2006-09-06	ABVT-DELISTED	Stock	47.75	47.75	47.75	47.75	10400.0
2006-09-06	ABX-DELISTED	Stock	33.98	34.47	33.52	33.56	4494200.0
2006-09-06	ACAD	Stock	7.71	8.01	7.64	7.96	352000.0
2006-09-06	ACAP-DELISTED	Stock	48.68	48.69	47.15	47.48	23698.0
2006-09-06	ACAS-DELISTED	Stock	37.81	37.81	37.17	37.42	812823.0
2006-09-06	ACAT-DELISTED	Stock	16.4	16.4	15.73	15.75	86413.0
2006-09-06	ACC-DELISTED	Stock	25.3	25.4	25.07	25.26	113300.0
2006-09-06	ACCL-DELISTED	Stock	5.51	5.55	5.3	5.31	72497.0
2006-09-06	ACCO	Stock	22.32	22.32	21.72	21.81	298200.0
2006-09-06	ACCP-DELISTED	Stock	0.78	0.78	0.78	0.78	2500.0

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

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