PREVIEW / stock_daily / 2012-01-13

all stock daily files

  file:    by_date/stock_daily/2012/2012-01-13.parquet
  size:    196 KB
  rows:    6,112
  symbols: 3,531

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-01-13	AAPL	Stock	14.9893	15.0161	14.9521	14.9932	226021600.0
2012-01-13	MSFT	Stock	27.93	28.25	27.79	28.25	60196100.0
2012-01-13	NVDA	Stock	0.35	0.3508	0.3415	0.3433	504300000.0
2012-01-13	AMZN	Stock	8.7905	8.94	8.675	8.921	95070000.0
2012-01-13	TSLA	Stock	1.8933	1.9	1.5093	1.5193	82506000.0
2012-01-13	TLT	Stock	121.1	121.64	120.81	120.88	9818911.0
2012-01-13	ES	Stock	34.13	34.23	33.92	34.23	910500.0
2012-01-13	CL	Stock	44.135	44.325	43.925	44.26	14450200.0
2012-01-13	A	Stock	27.9399	28.0472	27.5393	27.9399	5058383.0
2012-01-13	AABA-DELISTED	Stock	15.68	15.68	15.43	15.49	11665364.0
2012-01-13	AACC-DELISTED	Stock	4.16	4.24	4.14	4.2	26277.0
2012-01-13	AACG	Stock	7.55	7.59	7.55	7.59	1100.0
2012-01-13	AAIC-DELISTED	Stock	21.23	21.92	21.23	21.88	50949.0
2012-01-13	AAME	Stock	2.0	2.0	1.96	1.97	4000.0
2012-01-13	AAMRQ-DELISTED	Stock	0.429	0.4335	0.39	0.41	12800278.0
2012-01-13	AAON	Stock	5.9111	5.9793	5.8281	5.9437	203850.0
2012-01-13	AAP	Stock	71.04	72.02	71.02	71.46	318300.0
2012-01-13	AAT	Stock	20.2	20.71	20.2	20.69	87900.0
2012-01-13	AAU-DELISTED	Stock	2.65	2.7	2.53	2.66	105860.0
2012-01-13	AAUAF-DELISTED	Stock	2.64	2.69	2.52	2.67	106559.0
2012-01-13	AAV-DELISTED	Stock	3.8	3.82	3.65	3.67	391376.0
2012-01-13	AAWW-DELISTED	Stock	40.16	40.74	39.84	40.61	383443.0
2012-01-13	AAXJ	Stock	51.75	51.84	51.35	51.77	632956.0
2012-01-13	AAXN-DELISTED	Stock	5.16	5.18	5.0822	5.16	268938.0
2012-01-13	AB	Stock	14.39	14.5	14.29	14.5	297900.0
2012-01-13	ABAC-DELISTED	Stock	1.68	1.7	1.6501	1.7	17040.0
2012-01-13	ABAX-DELISTED	Stock	27.44	27.82	27.42	27.78	66462.0
2012-01-13	ABB-DELISTED	Stock	19.84	19.98	19.6399	19.92	2176633.0
2012-01-13	ABBNY-DELISTED	Stock	19.84	19.98	19.6399	19.93	2178213.0
2012-01-13	ABC-DELISTED	Stock	38.42	38.54	37.68	37.8	2457273.0
2012-01-13	ABCB	Stock	10.46	10.67	10.46	10.59	20900.0
2012-01-13	ABCD-DELISTED	Stock	3.17	3.18	3.11	3.15	30522.0
2012-01-13	ABCO-DELISTED	Stock	36.94	37.59	36.94	37.38	160540.0
2012-01-13	ABCW-DELISTED	Stock	0.3213	0.3213	0.3213	0.3213	9960.0
2012-01-13	ABD-DELISTED	Stock	9.27	9.63	9.25	9.58	260520.0
2012-01-13	ABE-DELISTED	Stock	17.92	18.02	17.7	17.82	1574.0
2012-01-13	ABEO	Stock	1712.5	1712.5	1637.5	1687.5	8.0
2012-01-13	ABFS-DELISTED	Stock	20.87	21.17	20.62	20.92	147395.0
2012-01-13	ABG	Stock	22.27	23.31	22.27	22.84	258600.0
2012-01-13	ABH-DELISTED	Stock	15.29	15.33	14.96	15.05	204025.0
2012-01-13	ABM	Stock	20.69	20.87	20.51	20.7	164400.0
2012-01-13	ABMD-DELISTED	Stock	18.04	18.49	17.83	17.97	247840.0
2012-01-13	ABR	Stock	4.12	4.12	4.05	4.11	34800.0
2012-01-13	ABT	Stock	26.4034	26.6481	26.3602	26.5953	14115882.0
2012-01-13	ABTL-DELISTED	Stock	3.8	3.8801	3.7747	3.8	7649.0
2012-01-13	ABUS	Stock	1.98	2.15	1.98	2.15	9600.0
2012-01-13	ABV-DELISTED	Stock	35.8	36.03	35.53	35.89	1728696.0
2012-01-13	ABVA-DELISTED	Stock	3.5	3.5	3.49	3.4999	700.0
2012-01-13	ABVT-DELISTED	Stock	65.15	65.26	64.5	65.09	120775.0
2012-01-13	ABX-DELISTED	Stock	48.35	48.39	47.5	48.325	3630088.0

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

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