PREVIEW / stock_daily / 2012-02-16

all stock daily files

  file:    by_date/stock_daily/2012/2012-02-16.parquet
  size:    200 KB
  rows:    6,178
  symbols: 3,553

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-02-16	AAPL	Stock	17.5536	18.0318	17.3796	17.9361	944552000.0
2012-02-16	MSFT	Stock	30.31	31.55	30.3	31.29	94705100.0
2012-02-16	NVDA	Stock	0.3765	0.4145	0.375	0.4112	1888588000.0
2012-02-16	AMZN	Stock	8.8895	9.084	8.757	8.9965	251276000.0
2012-02-16	TSLA	Stock	2.2333	2.3007	2.1693	2.2787	33295500.0
2012-02-16	TLT	Stock	117.27	117.6	116.13	116.61	9036469.0
2012-02-16	ES	Stock	36.05	36.37	35.78	36.16	2290900.0
2012-02-16	CL	Stock	46.19	46.71	46.19	46.66	3708600.0
2012-02-16	A	Stock	30.7582	31.4378	29.8712	31.3519	9901754.0
2012-02-16	AABA-DELISTED	Stock	15.27	15.38	15.1	15.3543	15322505.0
2012-02-16	AACC-DELISTED	Stock	4.56	4.57	4.37	4.45	14158.0
2012-02-16	AACG	Stock	7.0	7.0	6.97	7.0	1600.0
2012-02-16	AAIC-DELISTED	Stock	22.44	23.69	22.44	23.46	47072.0
2012-02-16	AAME	Stock	2.25	2.27	2.2	2.27	10300.0
2012-02-16	AAMRQ-DELISTED	Stock	0.53	0.538	0.5002	0.507	6804441.0
2012-02-16	AAON	Stock	5.4341	5.7037	5.4341	5.7037	151875.0
2012-02-16	AAP	Stock	84.12	86.3	83.95	85.9	5455800.0
2012-02-16	AAT	Stock	21.65	22.57	21.65	22.53	117300.0
2012-02-16	AAU-DELISTED	Stock	2.51	2.64	2.51	2.63	81048.0
2012-02-16	AAUAF-DELISTED	Stock	2.54	2.67	2.54	2.63	81036.0
2012-02-16	AAV-DELISTED	Stock	3.68	3.77	3.64	3.74	338344.0
2012-02-16	AAWW-DELISTED	Stock	44.29	45.96	44.03	45.89	665108.0
2012-02-16	AAXJ	Stock	57.11	57.68	57.0	57.63	251854.0
2012-02-16	AAXN-DELISTED	Stock	4.45	4.45	4.23	4.26	732418.0
2012-02-16	AB	Stock	13.56	13.92	13.53	13.82	572800.0
2012-02-16	ABAC-DELISTED	Stock	1.58	1.66	1.58	1.65	27593.0
2012-02-16	ABAX-DELISTED	Stock	26.0	26.81	25.56	26.23	305340.0
2012-02-16	ABB-DELISTED	Stock	20.63	21.22	20.61	21.09	10258623.0
2012-02-16	ABBNY-DELISTED	Stock	20.64	21.22	20.61	21.1	10822568.0
2012-02-16	ABC-DELISTED	Stock	36.65	36.99	36.61	36.94	2747467.0
2012-02-16	ABCB	Stock	10.85	11.27	10.68	11.24	31700.0
2012-02-16	ABCD-DELISTED	Stock	3.05	3.18	2.92	3.14	11019.0
2012-02-16	ABCO-DELISTED	Stock	37.85	38.49	37.81	38.15	96386.0
2012-02-16	ABCW-DELISTED	Stock	0.3916	0.3916	0.3213	0.3313	12890.0
2012-02-16	ABD-DELISTED	Stock	11.505	12.005	11.49	11.965	1057320.0
2012-02-16	ABE-DELISTED	Stock	18.76	18.8	18.683	18.78	50855.0
2012-02-16	ABEO	Stock	1700.0	1712.5	1675.0	1712.5	6.0
2012-02-16	ABFS-DELISTED	Stock	18.76	19.3	18.09	19.25	178045.0
2012-02-16	ABG	Stock	25.39	26.38	25.39	26.07	342300.0
2012-02-16	ABH-DELISTED	Stock	14.96	15.41	14.96	15.25	224336.0
2012-02-16	ABM	Stock	22.41	22.88	22.41	22.8	179100.0
2012-02-16	ABMD-DELISTED	Stock	23.63	23.7	22.9	23.13	578815.0
2012-02-16	ABR	Stock	4.89	4.9	4.76	4.82	15900.0
2012-02-16	ABT	Stock	26.6433	26.8352	26.5185	26.7968	12493956.0
2012-02-16	ABTL-DELISTED	Stock	5.0521	5.1031	4.8479	4.95	45438.0
2012-02-16	ABUS	Stock	2.26	2.34	2.26	2.32	2100.0
2012-02-16	ABV-DELISTED	Stock	37.76	38.49	37.69	38.48	2707228.0
2012-02-16	ABVA-DELISTED	Stock	3.41	3.48	3.404	3.46	5755.0
2012-02-16	ABVT-DELISTED	Stock	70.44	70.44	69.46	70.26	173258.0
2012-02-16	ABX-DELISTED	Stock	46.7	48.38	45.89	48.2	10056010.0

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

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