PREVIEW / stock_daily / 2012-05-16

all stock daily files

  file:    by_date/stock_daily/2012/2012-05-16.parquet
  size:    200 KB
  rows:    6,179
  symbols: 3,540

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-05-16	AAPL	Stock	19.7875	19.8889	19.3229	19.5029	560896000.0
2012-05-16	MSFT	Stock	30.31	30.32	29.74	29.9	60083700.0
2012-05-16	NVDA	Stock	0.3255	0.3293	0.3175	0.3185	470484000.0
2012-05-16	AMZN	Stock	11.25	11.4	11.125	11.203	105236000.0
2012-05-16	TSLA	Stock	1.972	2.012	1.9253	1.9453	18856500.0
2012-05-16	TLT	Stock	120.98	122.18	120.72	122.01	6465152.0
2012-05-16	ES	Stock	35.88	35.97	35.55	35.55	1791400.0
2012-05-16	CL	Stock	50.575	50.97	50.505	50.66	4099400.0
2012-05-16	A	Stock	29.0916	29.3276	28.3977	28.4406	4976321.0
2012-05-16	AABA-DELISTED	Stock	15.43	15.57	15.26	15.28	17207996.0
2012-05-16	AACC-DELISTED	Stock	5.94	5.955	5.89	5.94	11402.0
2012-05-16	AACG	Stock	6.75	6.75	6.75	6.75	6500.0
2012-05-16	AAIC-DELISTED	Stock	23.36	23.43	23.18	23.19	32238.0
2012-05-16	AAME	Stock	2.74	2.8	2.72	2.75	5300.0
2012-05-16	AAMRQ-DELISTED	Stock	0.511	0.53	0.501	0.501	669500.0
2012-05-16	AAON	Stock	5.7778	5.8104	5.6356	5.6474	170100.0
2012-05-16	AAP	Stock	81.14	83.17	81.0	82.1	1405300.0
2012-05-16	AAT	Stock	23.86	23.86	23.65	23.65	79000.0
2012-05-16	AAU-DELISTED	Stock	1.76	1.86	1.67	1.8	171755.0
2012-05-16	AAUAF-DELISTED	Stock	1.69	1.88	1.69	1.78	170353.0
2012-05-16	AAV-DELISTED	Stock	2.91	3.05	2.89	2.91	301541.0
2012-05-16	AAWW-DELISTED	Stock	47.7	48.1606	46.78	46.87	219394.0
2012-05-16	AAXJ	Stock	51.67	51.924	51.23	51.28	9223701.0
2012-05-16	AAXN-DELISTED	Stock	5.16	5.27	5.13	5.17	383450.0
2012-05-16	AB	Stock	14.58	14.96	14.39	14.43	138800.0
2012-05-16	ABAC-DELISTED	Stock	1.38	1.4	1.32	1.33	14070.0
2012-05-16	ABAX-DELISTED	Stock	34.46	34.64	34.09	34.27	75713.0
2012-05-16	ABB-DELISTED	Stock	16.66	16.75	16.25	16.26	4495869.0
2012-05-16	ABBNY-DELISTED	Stock	16.66	16.75	16.25	16.25	4550964.0
2012-05-16	ABC-DELISTED	Stock	36.54	37.01	36.48	36.71	3169312.0
2012-05-16	ABCB	Stock	12.06	12.26	11.77	11.78	70300.0
2012-05-16	ABCD-DELISTED	Stock	1.8	1.82	1.36	1.47	94918.0
2012-05-16	ABCO-DELISTED	Stock	47.0	47.82	46.81	47.52	326134.0
2012-05-16	ABCW-DELISTED	Stock	0.6225	0.6225	0.4418	0.5824	102120.0
2012-05-16	ABE-DELISTED	Stock	18.49	18.52	18.27	18.52	3988.0
2012-05-16	ABEO	Stock	1062.5	1112.5	750.0	800.0	198.0
2012-05-16	ABFS-DELISTED	Stock	13.17	13.29	13.03	13.04	365207.0
2012-05-16	ABG	Stock	26.02	26.55	25.81	25.84	379100.0
2012-05-16	ABH-DELISTED	Stock	10.64	10.88	10.6	10.6	241490.0
2012-05-16	ABM	Stock	22.77	23.28	22.77	22.91	259500.0
2012-05-16	ABMD-DELISTED	Stock	26.17	26.17	22.98	23.25	1809689.0
2012-05-16	ABR	Stock	6.67	6.67	6.22	6.25	61400.0
2012-05-16	ABT	Stock	29.8628	30.0931	29.714	30.0115	13199250.0
2012-05-16	ABTL-DELISTED	Stock	3.85	3.946	3.7555	3.8	20220.0
2012-05-16	ABUS	Stock	2.0	2.5	2.0	2.05	19000.0
2012-05-16	ABV-DELISTED	Stock	39.33	39.36	38.34	38.77	3474459.0
2012-05-16	ABVA-DELISTED	Stock	4.21	4.26	4.21	4.26	1135.0
2012-05-16	ABVT-DELISTED	Stock	83.25	83.28	83.23	83.26	281485.0
2012-05-16	ABX-DELISTED	Stock	35.18	36.17	34.8	35.2	11175085.0
2012-05-16	ACAD	Stock	1.58	1.64	1.52	1.56	282000.0

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

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