PREVIEW / stock_daily / 2012-04-26

all stock daily files

  file:    by_date/stock_daily/2012/2012-04-26.parquet
  size:    199 KB
  rows:    6,178
  symbols: 3,544

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
2012-04-26	AAPL	Stock	21.9382	21.9532	21.5046	21.7036	536068400.0
2012-04-26	MSFT	Stock	32.12	32.23	31.92	32.11	40308100.0
2012-04-26	NVDA	Stock	0.3268	0.33	0.3245	0.3273	539208000.0
2012-04-26	AMZN	Stock	9.6785	9.818	9.651	9.7995	204680000.0
2012-04-26	TSLA	Stock	2.1973	2.2347	2.194	2.2327	6379500.0
2012-04-26	TLT	Stock	117.42	117.46	116.59	117.19	5134789.0
2012-04-26	ES	Stock	36.47	36.79	36.35	36.7	1579400.0
2012-04-26	CL	Stock	49.78	49.92	49.26	49.735	3556400.0
2012-04-26	A	Stock	29.4134	30.093	29.392	30.0358	3424121.0
2012-04-26	AABA-DELISTED	Stock	15.44	15.55	15.38	15.54	12022983.0
2012-04-26	AACC-DELISTED	Stock	4.85	5.11	4.76	5.11	46774.0
2012-04-26	AACG	Stock	6.58	6.76	6.49	6.49	2100.0
2012-04-26	AAIC-DELISTED	Stock	23.44	23.64	23.02	23.51	70163.0
2012-04-26	AAME	Stock	2.88	2.91	2.66	2.9	5400.0
2012-04-26	AAMRQ-DELISTED	Stock	0.585	0.596	0.555	0.59	3189576.0
2012-04-26	AAON	Stock	5.8133	5.9319	5.8074	5.8756	97200.0
2012-04-26	AAP	Stock	89.79	92.6	88.5	91.43	1845700.0
2012-04-26	AAT	Stock	23.32	23.8	23.01	23.49	130100.0
2012-04-26	AAU-DELISTED	Stock	2.22	2.29	2.21	2.28	100895.0
2012-04-26	AAUAF-DELISTED	Stock	2.22	2.3	2.21	2.28	101379.0
2012-04-26	AAV-DELISTED	Stock	3.14	3.22	3.1	3.17	198579.0
2012-04-26	AAWW-DELISTED	Stock	45.03	45.22	44.5	45.01	143940.0
2012-04-26	AAXJ	Stock	55.9	56.303	55.64	56.24	218974.0
2012-04-26	AAXN-DELISTED	Stock	4.45	4.58	4.29	4.33	1067269.0
2012-04-26	AB	Stock	14.32	14.33	14.14	14.32	133900.0
2012-04-26	ABAC-DELISTED	Stock	2.0	2.01	1.8808	1.9	16537.0
2012-04-26	ABAX-DELISTED	Stock	29.59	29.88	29.3	29.76	170000.0
2012-04-26	ABB-DELISTED	Stock	18.78	19.18	18.75	19.08	5515137.0
2012-04-26	ABBNY-DELISTED	Stock	18.78	19.18	18.75	19.08	5522537.0
2012-04-26	ABC-DELISTED	Stock	37.87	37.87	36.87	36.98	4169011.0
2012-04-26	ABCB	Stock	12.62	12.64	12.43	12.51	25700.0
2012-04-26	ABCD-DELISTED	Stock	2.58	2.58	2.43	2.45	5105.0
2012-04-26	ABCO-DELISTED	Stock	44.2	44.66	43.97	44.27	81919.0
2012-04-26	ABCW-DELISTED	Stock	0.7832	0.7832	0.7028	0.7832	10440.0
2012-04-26	ABD-DELISTED	Stock	10.52	10.86	10.46	10.76	1333590.0
2012-04-26	ABE-DELISTED	Stock	19.42	19.47	19.27	19.375	4373.0
2012-04-26	ABEO	Stock	1287.5	1375.0	1187.5	1275.0	58.0
2012-04-26	ABFS-DELISTED	Stock	17.8	17.8	17.24	17.37	388490.0
2012-04-26	ABG	Stock	27.23	27.78	26.39	27.72	634600.0
2012-04-26	ABH-DELISTED	Stock	13.52	13.53	13.38	13.51	99788.0
2012-04-26	ABM	Stock	23.25	23.42	23.16	23.33	106300.0
2012-04-26	ABMD-DELISTED	Stock	23.62	24.59	23.46	24.41	645357.0
2012-04-26	ABR	Stock	5.65	5.8	5.64	5.8	15000.0
2012-04-26	ABT	Stock	29.5365	29.786	29.4453	29.6804	14027720.0
2012-04-26	ABTL-DELISTED	Stock	4.6449	4.6449	4.443	4.6	1158.0
2012-04-26	ABUS	Stock	2.41	2.45	2.41	2.45	1000.0
2012-04-26	ABV-DELISTED	Stock	43.32	43.58	43.15	43.32	2645786.0
2012-04-26	ABVT-DELISTED	Stock	83.08	83.17	83.08	83.16	420462.0
2012-04-26	ABX-DELISTED	Stock	39.93	40.24	39.62	39.97	8721995.0
2012-04-26	ACAD	Stock	1.29	1.48	1.29	1.45	670100.0

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

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