PREVIEW / stock_daily / 2011-09-29

all stock daily files

  file:    by_date/stock_daily/2011/2011-09-29.parquet
  size:    193 KB
  rows:    6,033
  symbols: 3,504

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
2011-09-29	AAPL	Stock	14.3543	14.3646	13.7932	13.9489	651086800.0
2011-09-29	MSFT	Stock	25.98	26.17	25.09	25.45	63407300.0
2011-09-29	NVDA	Stock	0.3415	0.3473	0.3188	0.3273	866416000.0
2011-09-29	AMZN	Stock	11.7085	11.715	10.8145	11.122	187570000.0
2011-09-29	TSLA	Stock	1.7147	1.7213	1.57	1.608	13944000.0
2011-09-29	TLT	Stock	117.61	118.82	117.09	117.84	12341897.0
2011-09-29	ES	Stock	34.17	34.27	33.73	34.11	1971800.0
2011-09-29	CL	Stock	44.8	45.145	44.1	44.77	5136800.0
2011-09-29	A	Stock	23.2475	23.5265	22.432	23.2618	6669439.0
2011-09-29	AABA-DELISTED	Stock	14.34	14.39	13.15	13.42	44968142.0
2011-09-29	AACC-DELISTED	Stock	3.49	3.49	3.3	3.36	37240.0
2011-09-29	AACG	Stock	9.08	9.1	8.82	8.94	5800.0
2011-09-29	AAIC-DELISTED	Stock	24.85	25.07	24.24	24.85	35604.0
2011-09-29	AAME	Stock	1.84	1.89	1.65	1.89	4100.0
2011-09-29	AAON	Stock	4.7941	4.9037	4.6696	4.8444	120825.0
2011-09-29	AAP	Stock	60.37	60.48	57.83	59.0	1050800.0
2011-09-29	AAT	Stock	18.15	18.47	17.96	18.43	154400.0
2011-09-29	AATI-DELISTED	Stock	4.43	4.45	4.23	4.34	279217.0
2011-09-29	AAU-DELISTED	Stock	2.82	2.84	2.6	2.69	322996.0
2011-09-29	AAUAF-DELISTED	Stock	2.82	2.84	2.6	2.66	323396.0
2011-09-29	AAV-DELISTED	Stock	4.38	4.39	3.82	3.94	805123.0
2011-09-29	AAWW-DELISTED	Stock	36.51	36.94	34.61	35.78	264588.0
2011-09-29	AAXJ	Stock	49.45	49.65	48.26	48.82	417110.0
2011-09-29	AAXN-DELISTED	Stock	4.44	4.5	4.27	4.42	382180.0
2011-09-29	AB	Stock	14.37	14.62	14.13	14.48	183300.0
2011-09-29	ABAC-DELISTED	Stock	1.46	1.46	1.31	1.32	27002.0
2011-09-29	ABAX-DELISTED	Stock	24.49	24.71	22.78	23.62	266095.0
2011-09-29	ABB-DELISTED	Stock	18.04	18.23	17.61	17.93	4834960.0
2011-09-29	ABBC-DELISTED	Stock	7.42	7.67	7.27	7.63	15927.0
2011-09-29	ABBNY-DELISTED	Stock	18.04	18.23	17.61	17.95	4971160.0
2011-09-29	ABC-DELISTED	Stock	39.13	39.5201	37.37	37.7	3538736.0
2011-09-29	ABCB	Stock	8.87	8.99	8.57	8.81	69500.0
2011-09-29	ABCD-DELISTED	Stock	3.05	3.05	2.97	3.05	37254.0
2011-09-29	ABCO-DELISTED	Stock	32.13	32.83	31.5	32.14	215628.0
2011-09-29	ABCW-DELISTED	Stock	0.4953	0.5451	0.4949	0.5	16360.0
2011-09-29	ABD-DELISTED	Stock	5.06	5.06	4.64	4.93	470090.0
2011-09-29	ABE-DELISTED	Stock	17.83	17.83	17.12	17.12	8780.0
2011-09-29	ABEO	Stock	2312.5	2500.0	2287.5	2400.0	13.0
2011-09-29	ABFS-DELISTED	Stock	17.52	17.71	16.72	17.23	246877.0
2011-09-29	ABG	Stock	17.54	17.86	16.51	17.39	295600.0
2011-09-29	ABH-DELISTED	Stock	16.03	16.03	14.95	15.07	392917.0
2011-09-29	ABM	Stock	19.44	19.77	19.17	19.76	288700.0
2011-09-29	ABMD-DELISTED	Stock	11.36	11.52	10.57	10.95	84790.0
2011-09-29	ABR	Stock	3.77	3.8	3.7	3.74	111800.0
2011-09-29	ABT	Stock	24.6857	25.0887	24.5802	24.8776	15518133.0
2011-09-29	ABTL-DELISTED	Stock	4.2002	4.2997	4.1498	4.1498	6223.0
2011-09-29	ABUS	Stock	1.85	1.95	1.63	1.95	11400.0
2011-09-29	ABV-DELISTED	Stock	31.26	31.7	30.69	31.13	3189748.0
2011-09-29	ABVA-DELISTED	Stock	4.83	4.95	4.83	4.91	500.0
2011-09-29	ABVT-DELISTED	Stock	54.68	55.51	52.56	54.36	128260.0

> showing 50 of 6,033 rows — these rows as CSV

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