PREVIEW / stock_daily / 2006-11-28

all stock daily files

  file:    by_date/stock_daily/2006/2006-11-28.parquet
  size:    155 KB
  rows:    4,631
  symbols: 2,937

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-11-28	AAPL	Stock	3.2271	3.2846	3.2111	3.2789	1036173600.0
2006-11-28	MSFT	Stock	29.34	29.42	29.13	29.39	52602300.0
2006-11-28	NVDA	Stock	0.5865	0.6048	0.5773	0.5995	480966000.0
2006-11-28	AMZN	Stock	2.0375	2.0535	2.015	2.046	141986000.0
2006-11-28	CL	Stock	32.79	32.79	32.255	32.54	3142000.0
2006-11-28	A	Stock	23.319	23.5265	23.1044	23.319	5114863.0
2006-11-28	AABA-DELISTED	Stock	27.0300006866455	27.2399997711182	26.8500003814697	27.0	14940800.0
2006-11-28	AACC-DELISTED	Stock	16.58	16.63	16.43	16.51	120074.0
2006-11-28	AACQU-DELISTED	Stock	6.6	6.6	6.57	6.57	1890.0
2006-11-28	AACQW-DELISTED	Stock	0.6	0.6	0.57	0.6	65000.0
2006-11-28	AAI-DELISTED	Stock	12.63	12.83	12.36	12.82	1710600.0
2006-11-28	AAIC-DELISTED	Stock	145.0	148.8	143.8	147.4	1102300.0
2006-11-28	AAME	Stock	2.85	2.85	2.81	2.82	5600.0
2006-11-28	AAON	Stock	3.4015	3.5319	3.3738	3.3778	258947.0
2006-11-28	AAP	Stock	36.79	36.96	36.56	36.58	703200.0
2006-11-28	AATI-DELISTED	Stock	5.44	5.67	5.35	5.6	175925.0
2006-11-28	AAU-DELISTED	Stock	2.6	2.62	2.52	2.58	64800.0
2006-11-28	AAUAF-DELISTED	Stock	2.6	2.62	2.52	2.58	64800.0
2006-11-28	AAV-DELISTED	Stock	12.73	12.73	12.48	12.58	658000.0
2006-11-28	AAWW-DELISTED	Stock	40.14	40.41	39.7	40.26	145705.0
2006-11-28	AAXN-DELISTED	Stock	8.52000045776367	8.65999984741211	8.31999969482422	8.46000003814697	952200.0
2006-11-28	AB	Stock	74.61	75.69	74.33	75.12	292500.0
2006-11-28	ABAX-DELISTED	Stock	19.75	19.86	19.1	19.33	205421.0
2006-11-28	ABB-DELISTED	Stock	15.56	15.74	15.55	15.74	868800.0
2006-11-28	ABBC-DELISTED	Stock	15.6	15.65	15.45	15.51	2800.0
2006-11-28	ABC-DELISTED	Stock	22.51	22.84	22.48	22.62	2032000.0
2006-11-28	ABCB	Stock	26.6018	27.7008	26.3489	26.9908	20871.0
2006-11-28	ABCO-DELISTED	Stock	28.06	28.13	27.63	27.89	1496743.0
2006-11-28	ABCW-DELISTED	Stock	28.39	28.56	28.37	28.45	33840.0
2006-11-28	ABD-DELISTED	Stock	24.9	25.17	24.84	25.01	169710.0
2006-11-28	ABE-DELISTED	Stock	16.55	16.64	16.4	16.56	28200.0
2006-11-28	ABFS-DELISTED	Stock	38.45	38.45	37.79	38.09	235881.0
2006-11-28	ABG	Stock	23.46	23.51	23.18	23.24	239200.0
2006-11-28	ABK-DELISTED	Stock	83.47	84.74	83.38	84.49	839800.0
2006-11-28	ABM	Stock	20.24	20.59	20.24	20.58	104800.0
2006-11-28	ABMD-DELISTED	Stock	12.33	12.41	12.25	12.38	97935.0
2006-11-28	ABP-DELISTED	Stock	3.79	3.89	3.73	3.88	138900.0
2006-11-28	ABR	Stock	28.25	28.37	28.02	28.25	64900.0
2006-11-28	ABT	Stock	22.2531	22.4546	22.186	22.2627	10289287.0
2006-11-28	ABTL-DELISTED	Stock	15.001	15.001	14.649	14.699	160559.0
2006-11-28	ABV-DELISTED	Stock	45.4	45.4	44.7	45.18	568800.0
2006-11-28	ABVA-DELISTED	Stock	16.15	16.2	16.1	16.1	3261.0
2006-11-28	ABX-DELISTED	Stock	29.76	30.1625	29.56	30.1476	4095306.0
2006-11-28	ACAD	Stock	9.01	9.08	8.7	8.98	125500.0
2006-11-28	ACAP-DELISTED	Stock	37.58	38.57	37.19	38.22	29180.0
2006-11-28	ACAS-DELISTED	Stock	44.07	44.46	43.79	44.39	482655.0
2006-11-28	ACAT-DELISTED	Stock	16.94	16.98	16.61	16.81	79848.0
2006-11-28	ACC-DELISTED	Stock	28.14	28.42	28.1	28.28	142100.0
2006-11-28	ACCL-DELISTED	Stock	6.16	6.24	6.1	6.15	27711.0
2006-11-28	ACCO	Stock	24.9	25.17	24.84	25.01	195500.0

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

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