PREVIEW / stock_daily / 2011-09-14

all stock daily files

  file:    by_date/stock_daily/2011/2011-09-14.parquet
  size:    194 KB
  rows:    6,076
  symbols: 3,511

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-14	AAPL	Stock	13.8221	14.0075	13.7771	13.9036	534724400.0
2011-09-14	MSFT	Stock	26.17	26.8	25.89	26.5	66739200.0
2011-09-14	NVDA	Stock	0.3728	0.3868	0.3725	0.382	1547192000.0
2011-09-14	AMZN	Stock	11.011	11.2495	10.836	11.1285	117634000.0
2011-09-14	TSLA	Stock	1.6167	1.656	1.586	1.6227	12462000.0
2011-09-14	TLT	Stock	111.97	113.35	111.82	113.16	11952411.0
2011-09-14	ES	Stock	33.79	34.34	33.44	34.02	1130100.0
2011-09-14	CL	Stock	44.755	46.11	44.73	45.695	8185000.0
2011-09-14	A	Stock	25.1216	26.6381	24.7711	26.166	9617122.0
2011-09-14	AABA-DELISTED	Stock	14.47	14.94	14.335	14.545	36627157.0
2011-09-14	AACC-DELISTED	Stock	4.0	4.0	3.96	3.99	14180.0
2011-09-14	AACG	Stock	9.08	9.37	9.08	9.34	6700.0
2011-09-14	AAIC-DELISTED	Stock	24.84	24.86	23.87	24.25	72945.0
2011-09-14	AAME	Stock	2.04	2.04	1.95	2.04	2700.0
2011-09-14	AAON	Stock	4.9511	5.037	4.8237	4.9244	177188.0
2011-09-14	AAP	Stock	60.95	62.12	60.49	61.48	1004000.0
2011-09-14	AAT	Stock	19.02	19.52	18.81	18.99	205600.0
2011-09-14	AATI-DELISTED	Stock	4.5	4.61	4.42	4.48	503796.0
2011-09-14	AAU-DELISTED	Stock	3.31	3.31	3.13	3.22	123358.0
2011-09-14	AAUAF-DELISTED	Stock	3.35	3.35	3.17	3.22	122457.0
2011-09-14	AAV-DELISTED	Stock	5.18	5.28	5.04	5.1905	242594.0
2011-09-14	AAWW-DELISTED	Stock	45.3	46.81	44.01	45.7	234933.0
2011-09-14	AAXJ	Stock	52.58	53.13	51.72	52.76	253481.0
2011-09-14	AAXN-DELISTED	Stock	4.47	4.54	4.4	4.48	461668.0
2011-09-14	AB	Stock	16.72	16.72	16.2	16.37	362300.0
2011-09-14	ABAC-DELISTED	Stock	2.1	2.17	2.01	2.01	28855.0
2011-09-14	ABAX-DELISTED	Stock	24.81	25.4	24.06	24.92	126463.0
2011-09-14	ABB-DELISTED	Stock	18.2	18.74	17.85	18.51	2818118.0
2011-09-14	ABBC-DELISTED	Stock	8.24	8.56	8.12	8.4	54130.0
2011-09-14	ABBNY-DELISTED	Stock	18.2	18.74	17.85	18.5	2813583.0
2011-09-14	ABC-DELISTED	Stock	38.7	39.58	38.05	39.15	1971920.0
2011-09-14	ABCB	Stock	8.99	9.14	8.62	8.95	45200.0
2011-09-14	ABCD-DELISTED	Stock	3.05	3.0998	3.0	3.07	47408.0
2011-09-14	ABCO-DELISTED	Stock	29.89	30.5	29.33	29.58	457970.0
2011-09-14	ABCW-DELISTED	Stock	0.55	0.62	0.54	0.62	54840.0
2011-09-14	ABD-DELISTED	Stock	5.72	5.9304	5.49	5.77	233100.0
2011-09-14	ABE-DELISTED	Stock	17.7	17.8	17.6135	17.75	18487.0
2011-09-14	ABEO	Stock	2262.5	2625.0	2262.5	2625.0	7.0
2011-09-14	ABFS-DELISTED	Stock	19.93	20.76	19.32	20.55	588139.0
2011-09-14	ABG	Stock	19.59	20.05	19.05	19.73	527900.0
2011-09-14	ABH-DELISTED	Stock	16.22	16.56	15.92	16.34	288427.0
2011-09-14	ABM	Stock	19.3	19.38	18.81	19.15	498700.0
2011-09-14	ABMD-DELISTED	Stock	10.95	11.47	10.73	11.22	280063.0
2011-09-14	ABR	Stock	4.18	4.25	4.07	4.19	36000.0
2011-09-14	ABT	Stock	24.393	24.6665	23.9756	24.4314	14342226.0
2011-09-14	ABTL-DELISTED	Stock	4.2672	4.6068	4.2672	4.5828	1603.0
2011-09-14	ABUS	Stock	2.12	2.14	1.85	2.06	6800.0
2011-09-14	ABV-DELISTED	Stock	32.47	32.92	32.0	32.68	3398444.0
2011-09-14	ABVA-DELISTED	Stock	4.77	4.77	4.68	4.68	731.0
2011-09-14	ABVT-DELISTED	Stock	56.64	57.69	55.48	57.08	113203.0

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

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