PREVIEW / stock_daily / 2011-07-29

all stock daily files

  file:    by_date/stock_daily/2011/2011-07-29.parquet
  size:    198 KB
  rows:    6,135
  symbols: 3,564

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-07-29	AAPL	Stock	13.8443	14.1125	13.7143	13.9457	632584400.0
2011-07-29	MSFT	Stock	27.52	27.71	27.26	27.4	104394800.0
2011-07-29	NVDA	Stock	0.3422	0.349	0.3405	0.3458	677656000.0
2011-07-29	AMZN	Stock	11.0645	11.2875	10.9755	11.126	103354000.0
2011-07-29	TSLA	Stock	1.8533	1.8933	1.8333	1.878	14223000.0
2011-07-29	TLT	Stock	96.89	98.53	96.78	97.92	19582350.0
2011-07-29	ES	Stock	34.21	34.46	33.97	34.0	1752400.0
2011-07-29	CL	Stock	42.34	42.65	42.17	42.19	4304800.0
2011-07-29	A	Stock	29.7139	30.6724	29.5351	30.1574	5363986.0
2011-07-29	AABA-DELISTED	Stock	13.9	14.07	13.04	13.1	66612602.0
2011-07-29	AACC-DELISTED	Stock	5.37	5.46	4.4	4.91	65206.0
2011-07-29	AACG	Stock	9.01	9.51	9.01	9.16	23400.0
2011-07-29	AAIC-DELISTED	Stock	28.0	28.48	27.0	28.08	103798.0
2011-07-29	AAME	Stock	1.98	2.01	1.94	2.01	3900.0
2011-07-29	AAON	Stock	6.477	6.7644	6.4504	6.72	177525.0
2011-07-29	AAP	Stock	54.53	55.44	54.15	54.97	1279100.0
2011-07-29	AAT	Stock	21.82	22.18	21.48	21.99	524000.0
2011-07-29	AATI-DELISTED	Stock	6.03	6.06	6.01	6.05	370566.0
2011-07-29	AAU-DELISTED	Stock	3.46	3.5	3.31	3.31	246267.0
2011-07-29	AAUAF-DELISTED	Stock	3.46	3.5	3.3	3.3	246712.0
2011-07-29	AAV-DELISTED	Stock	6.98	7.08	6.9	6.95	409231.0
2011-07-29	AAWW-DELISTED	Stock	53.29	53.72	52.2	52.39	288341.0
2011-07-29	AAXJ	Stock	61.99	62.64	61.82	62.32	178330.0
2011-07-29	AAXN-DELISTED	Stock	4.1	4.28	4.08	4.11	447479.0
2011-07-29	AB	Stock	17.51	17.74	16.4	17.0	666700.0
2011-07-29	ABAC-DELISTED	Stock	2.53	2.64	2.52	2.55	7748.0
2011-07-29	ABAX-DELISTED	Stock	26.38	26.38	23.07	23.72	764792.0
2011-07-29	ABB-DELISTED	Stock	23.82	24.25	23.69	23.95	3837158.0
2011-07-29	ABBC-DELISTED	Stock	9.75	9.91	9.45	9.91	24077.0
2011-07-29	ABBNY-DELISTED	Stock	23.82	24.25	23.69	23.94	4439108.0
2011-07-29	ABC-DELISTED	Stock	38.25	38.85	37.965	38.3	5942655.0
2011-07-29	ABCB	Stock	9.97	10.15	9.62	10.12	46000.0
2011-07-29	ABCD-DELISTED	Stock	3.21	3.27	3.11	3.18	26461.0
2011-07-29	ABCO-DELISTED	Stock	27.22	27.3	26.7	26.77	78692.0
2011-07-29	ABCW-DELISTED	Stock	0.6799	0.6799	0.66	0.6601	33780.0
2011-07-29	ABD-DELISTED	Stock	8.24	8.81	8.08	8.57	357050.0
2011-07-29	ABE-DELISTED	Stock	18.9	19.11	18.84	18.99	19748.0
2011-07-29	ABEO	Stock	2812.5	2862.5	2812.5	2862.5	3.0
2011-07-29	ABFS-DELISTED	Stock	23.68	24.26	23.5	24.07	258970.0
2011-07-29	ABG	Stock	21.08	21.88	20.96	21.53	492500.0
2011-07-29	ABH-DELISTED	Stock	18.4	18.45	18.1	18.31	1042053.0
2011-07-29	ABM	Stock	22.03	22.53	21.9	22.5	297600.0
2011-07-29	ABMD-DELISTED	Stock	16.27	16.72	16.09	16.51	133151.0
2011-07-29	ABR	Stock	4.44	4.44	4.24	4.24	67300.0
2011-07-29	ABT	Stock	24.6521	24.7577	24.5466	24.6233	16997499.0
2011-07-29	ABTL-DELISTED	Stock	4.8049	5.099	4.8049	5.05	9547.0
2011-07-29	ABUS	Stock	2.37	2.41	2.37	2.41	600.0
2011-07-29	ABV-DELISTED	Stock	30.35	30.42	29.75	30.02	5434157.0
2011-07-29	ABVA-DELISTED	Stock	5.31	5.341	4.89	5.1	84899.0
2011-07-29	ABVT-DELISTED	Stock	60.6	61.358	59.54	60.93	229370.0

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

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