PREVIEW / stock_daily / 2006-09-27

all stock daily files

  file:    by_date/stock_daily/2006/2006-09-27.parquet
  size:    151 KB
  rows:    4,513
  symbols: 2,850

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-27	AAPL	Stock	2.7561	2.7668	2.7079	2.7289	810373200.0
2006-09-27	MSFT	Stock	27.18	27.47	27.12	27.44	66233900.0
2006-09-27	NVDA	Stock	0.5023	0.5183	0.4975	0.5023	578142000.0
2006-09-27	AMZN	Stock	1.614	1.623	1.5965	1.6165	109396000.0
2006-09-27	CL	Stock	31.065	31.175	30.955	31.02	4265000.0
2006-09-27	A	Stock	23.5694	23.6409	22.9757	23.083	5656308.0
2006-09-27	AABA-DELISTED	Stock	25.0	25.0100002288818	24.6000003814697	24.6499996185303	29835900.0
2006-09-27	AACC-DELISTED	Stock	15.55	16.08	15.52	16.0	173684.0
2006-09-27	AACQW-DELISTED	Stock	0.39	0.41	0.39	0.41	52000.0
2006-09-27	AAI-DELISTED	Stock	10.2	10.25	9.81	9.9	2037000.0
2006-09-27	AAIC-DELISTED	Stock	165.0	166.4	162.602	164.8	744300.0
2006-09-27	AAME	Stock	2.4	2.55	2.34	2.45	2600.0
2006-09-27	AAON	Stock	3.0354	3.1276	3.0038	3.1276	117703.0
2006-09-27	AAP	Stock	34.21	34.24	33.34	33.51	963100.0
2006-09-27	AATI-DELISTED	Stock	5.74	5.8	5.37	5.5	641811.0
2006-09-27	AAU-DELISTED	Stock	2.26	2.2638	2.2	2.23	48000.0
2006-09-27	AAUAF-DELISTED	Stock	2.26	2.2638	2.2	2.23	48000.0
2006-09-27	AAV-DELISTED	Stock	12.63	12.84	12.31	12.3525	1028000.0
2006-09-27	AAWW-DELISTED	Stock	43.84	43.95	43.69	43.89	37771.0
2006-09-27	AAXN-DELISTED	Stock	7.30000019073486	7.46999979019165	7.23999977111816	7.30999994277954	466200.0
2006-09-27	AB	Stock	69.65	70.1	69.14	69.98	273900.0
2006-09-27	ABAX-DELISTED	Stock	22.25	23.775	22.25	23.69	280128.0
2006-09-27	ABB-DELISTED	Stock	13.17	13.22	13.15	13.2	1924400.0
2006-09-27	ABBC-DELISTED	Stock	15.15	15.28	15.1	15.25	8914.0
2006-09-27	ABC-DELISTED	Stock	22.2	22.38	22.0	22.3	2108200.0
2006-09-27	ABCB	Stock	26.7768	27.0978	26.6893	27.0978	14805.0
2006-09-27	ABCO-DELISTED	Stock	25.22	25.44	25.18	25.44	95857.0
2006-09-27	ABCW-DELISTED	Stock	28.94	29.06	28.77	28.89	46790.0
2006-09-27	ABD-DELISTED	Stock	21.85	22.5	21.79	22.45	365490.0
2006-09-27	ABE-DELISTED	Stock	14.1199	14.25	13.85	14.02	10700.0
2006-09-27	ABFS-DELISTED	Stock	44.41	44.71	43.43	43.69	572462.0
2006-09-27	ABG	Stock	20.35	20.49	20.19	20.36	271800.0
2006-09-27	ABK-DELISTED	Stock	83.0	83.19	82.23	82.45	678300.0
2006-09-27	ABM	Stock	19.0	19.15	18.94	19.08	185200.0
2006-09-27	ABMD-DELISTED	Stock	14.89	15.35	14.89	15.1	98459.0
2006-09-27	ABP-DELISTED	Stock	3.1	3.19	3.03	3.1	222500.0
2006-09-27	ABR	Stock	25.48	26.05	25.48	25.9	76400.0
2006-09-27	ABT	Stock	23.064	23.2175	22.8193	23.2079	10694873.0
2006-09-27	ABTL-DELISTED	Stock	15.0	15.15	14.95	14.95	5824.0
2006-09-27	ABV-DELISTED	Stock	44.74	45.45	44.63	45.1	388000.0
2006-09-27	ABVA-DELISTED	Stock	16.95	17.1	16.15	16.535	8862.0
2006-09-27	ABX-DELISTED	Stock	30.59	31.1	30.19	31.02	6041700.0
2006-09-27	ACAD	Stock	8.37	8.64	8.37	8.57	120100.0
2006-09-27	ACAP-DELISTED	Stock	49.59	49.74	49.09	49.17	49210.0
2006-09-27	ACAS-DELISTED	Stock	39.23	39.43	39.04	39.13	773283.0
2006-09-27	ACAT-DELISTED	Stock	16.6	17.7	16.4	17.56	196423.0
2006-09-27	ACC-DELISTED	Stock	25.59	25.75	25.5	25.58	111000.0
2006-09-27	ACCL-DELISTED	Stock	5.47	6.5	5.45	6.43	202883.0
2006-09-27	ACCO	Stock	21.85	22.5	21.79	22.45	396300.0
2006-09-27	ACCP-DELISTED	Stock	0.85	0.95	0.85	0.95	1200.0

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

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