PREVIEW / stock_daily / 2011-07-13

all stock daily files

  file:    by_date/stock_daily/2011/2011-07-13.parquet
  size:    198 KB
  rows:    6,128
  symbols: 3,556

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-13	AAPL	Stock	12.7975	12.8571	12.7279	12.7864	391638800.0
2011-07-13	MSFT	Stock	26.6	26.96	26.51	26.63	40861800.0
2011-07-13	NVDA	Stock	0.3723	0.3748	0.363	0.3665	634368000.0
2011-07-13	AMZN	Stock	10.735	10.8415	10.607	10.675	84598000.0
2011-07-13	TSLA	Stock	1.8953	1.9353	1.86	1.9093	15990000.0
2011-07-13	TLT	Stock	96.71	97.43	96.11	97.4	13119566.0
2011-07-13	ES	Stock	35.49	35.57	35.14	35.17	1010600.0
2011-07-13	CL	Stock	44.175	44.375	43.87	43.95	2664200.0
2011-07-13	A	Stock	34.5136	34.8283	33.7625	34.4349	7282182.0
2011-07-13	AABA-DELISTED	Stock	15.01	15.1	14.87	14.9	16201021.0
2011-07-13	AACC-DELISTED	Stock	4.1	4.29	4.1	4.27	13700.0
2011-07-13	AACG	Stock	10.78	11.1	10.75	10.79	3800.0
2011-07-13	AAIC-DELISTED	Stock	30.93	31.34	30.93	31.33	37635.0
2011-07-13	AAME	Stock	2.05	2.05	2.05	2.05	5100.0
2011-07-13	AAON	Stock	6.7822	7.0489	6.7822	7.0252	280125.0
2011-07-13	AAP	Stock	58.57	58.73	56.91	56.96	2111300.0
2011-07-13	AAT	Stock	22.91	22.91	22.17	22.4	131800.0
2011-07-13	AATI-DELISTED	Stock	6.07	6.1	6.06	6.08	247473.0
2011-07-13	AAU-DELISTED	Stock	3.82	4.2	3.82	4.08	595496.0
2011-07-13	AAUAF-DELISTED	Stock	3.82	4.2	3.82	4.09	596496.0
2011-07-13	AAV-DELISTED	Stock	7.49	7.64	7.48	7.49	185608.0
2011-07-13	AAWW-DELISTED	Stock	59.01	59.06	56.55	57.79	341935.0
2011-07-13	AAXJ	Stock	61.3	61.91	61.16	61.21	555734.0
2011-07-13	AAXN-DELISTED	Stock	4.4	4.4264	4.31	4.34	159248.0
2011-07-13	AB	Stock	19.8	19.97	19.07	19.23	522000.0
2011-07-13	ABAC-DELISTED	Stock	2.71	2.9	2.6601	2.9	48834.0
2011-07-13	ABAX-DELISTED	Stock	29.16	30.19	29.16	29.79	77434.0
2011-07-13	ABB-DELISTED	Stock	25.79	26.39	25.77	26.1	4654916.0
2011-07-13	ABBC-DELISTED	Stock	10.46	10.65	10.29	10.52	36241.0
2011-07-13	ABBNY-DELISTED	Stock	25.79	26.39	25.77	26.1	4670384.0
2011-07-13	ABC-DELISTED	Stock	42.5	42.78	42.2	42.29	873335.0
2011-07-13	ABCB	Stock	9.19	9.41	8.76	9.29	34200.0
2011-07-13	ABCD-DELISTED	Stock	3.32	3.38	3.32	3.37	16920.0
2011-07-13	ABCO-DELISTED	Stock	28.07	28.54	28.07	28.32	44426.0
2011-07-13	ABCW-DELISTED	Stock	0.6811	0.7187	0.6789	0.6789	14170.0
2011-07-13	ABD-DELISTED	Stock	7.93	8.04	7.79	7.86	139560.0
2011-07-13	ABE-DELISTED	Stock	18.85	19.09	18.75	19.018	16790.0
2011-07-13	ABEO	Stock	2200.0	2750.0	2075.0	2475.0	64.0
2011-07-13	ABFS-DELISTED	Stock	26.72	26.78	26.28	26.42	450253.0
2011-07-13	ABG	Stock	19.09	19.71	18.9	19.42	216300.0
2011-07-13	ABH-DELISTED	Stock	19.95	20.02	19.71	19.97	345135.0
2011-07-13	ABM	Stock	23.6	23.8	23.51	23.72	252900.0
2011-07-13	ABMD-DELISTED	Stock	16.43	17.28	16.31	16.57	164758.0
2011-07-13	ABR	Stock	4.64	4.65	4.59	4.63	59100.0
2011-07-13	ABT	Stock	25.463	25.5925	25.2375	25.319	14600667.0
2011-07-13	ABTL-DELISTED	Stock	5.85	5.85	5.4	5.5	38901.0
2011-07-13	ABUS	Stock	2.3	2.41	2.3	2.4	2600.0
2011-07-13	ABV-DELISTED	Stock	31.89	32.15	31.2902	31.81	2720455.0
2011-07-13	ABVA-DELISTED	Stock	4.79	4.85	4.54	4.85	5200.0
2011-07-13	ABVT-DELISTED	Stock	67.67	69.68	67.63	69.39	414685.0

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

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