PREVIEW / stock_daily / 2012-02-09

all stock daily files

  file:    by_date/stock_daily/2012/2012-02-09.parquet
  size:    199 KB
  rows:    6,192
  symbols: 3,569

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-09	AAPL	Stock	17.17	17.7411	17.1629	17.6132	884214800.0
2012-02-09	MSFT	Stock	30.68	30.8	30.48	30.77	50481600.0
2012-02-09	NVDA	Stock	0.4128	0.415	0.4068	0.4075	561944000.0
2012-02-09	AMZN	Stock	9.225	9.2845	9.088	9.249	143784000.0
2012-02-09	TSLA	Stock	2.1333	2.1933	2.0953	2.172	19156500.0
2012-02-09	TLT	Stock	115.86	116.04	114.62	115.49	11477841.0
2012-02-09	ES	Stock	35.65	35.67	35.33	35.46	979400.0
2012-02-09	CL	Stock	45.72	45.9	45.53	45.88	3353800.0
2012-02-09	A	Stock	32.1888	32.4392	31.6881	32.2532	3132918.0
2012-02-09	AABA-DELISTED	Stock	16.1	16.1	15.9	15.99	19515012.0
2012-02-09	AACC-DELISTED	Stock	4.7	4.72	4.56	4.59	24399.0
2012-02-09	AACG	Stock	7.2	7.24	7.14	7.17	1600.0
2012-02-09	AAIC-DELISTED	Stock	24.14	24.37	23.33	24.06	90574.0
2012-02-09	AAME	Stock	2.03	2.05	2.03	2.05	2100.0
2012-02-09	AAMRQ-DELISTED	Stock	0.6371	0.645	0.621	0.625	5678450.0
2012-02-09	AAON	Stock	5.9852	6.0267	5.7985	5.8548	174825.0
2012-02-09	AAP	Stock	78.8	80.31	78.58	80.12	2236200.0
2012-02-09	AAT	Stock	22.7	22.7	22.19	22.23	106000.0
2012-02-09	AAU-DELISTED	Stock	2.54	2.63	2.51	2.51	163096.0
2012-02-09	AAUAF-DELISTED	Stock	2.54	2.63	2.51	2.51	163496.0
2012-02-09	AAV-DELISTED	Stock	3.76	3.8	3.68	3.78	353831.0
2012-02-09	AAWW-DELISTED	Stock	51.0	51.2277	50.21	50.3	227696.0
2012-02-09	AAXJ	Stock	57.52	57.52	57.04	57.37	282033.0
2012-02-09	AAXN-DELISTED	Stock	4.91	4.94	4.859	4.92	140246.0
2012-02-09	AB	Stock	16.33	16.68	16.18	16.51	426700.0
2012-02-09	ABAC-DELISTED	Stock	1.5801	1.69	1.5801	1.61	60436.0
2012-02-09	ABAX-DELISTED	Stock	28.52	28.52	27.71	27.88	52526.0
2012-02-09	ABB-DELISTED	Stock	21.79	21.93	21.6	21.84	1874324.0
2012-02-09	ABBNY-DELISTED	Stock	21.79	21.93	21.6	21.83	1875656.0
2012-02-09	ABC-DELISTED	Stock	39.33	39.33	38.945	38.98	1452308.0
2012-02-09	ABCB	Stock	11.24	11.24	11.05	11.05	42500.0
2012-02-09	ABCD-DELISTED	Stock	3.2	3.249	3.145	3.145	10871.0
2012-02-09	ABCO-DELISTED	Stock	36.39	37.05	36.39	36.84	201276.0
2012-02-09	ABCW-DELISTED	Stock	0.4518	0.4518	0.4518	0.4518	400.0
2012-02-09	ABD-DELISTED	Stock	11.305	11.375	11.215	11.295	460780.0
2012-02-09	ABE-DELISTED	Stock	19.31	19.45	19.211	19.45	10202.0
2012-02-09	ABEO	Stock	1750.0	1750.0	1662.5	1750.0	6.0
2012-02-09	ABFS-DELISTED	Stock	18.94	19.48	18.86	19.17	338525.0
2012-02-09	ABG	Stock	24.19	24.67	24.0	24.64	214500.0
2012-02-09	ABH-DELISTED	Stock	15.85	15.88	15.14	15.17	554579.0
2012-02-09	ABM	Stock	22.7	23.03	22.64	22.69	260100.0
2012-02-09	ABMD-DELISTED	Stock	23.79	23.85	23.19	23.19	824748.0
2012-02-09	ABR	Stock	4.57	4.62	4.52	4.59	57300.0
2012-02-09	ABT	Stock	26.6193	26.6769	26.3842	26.5137	11699041.0
2012-02-09	ABTL-DELISTED	Stock	4.7731	4.7976	4.5995	4.6	4901.0
2012-02-09	ABUS	Stock	2.12	2.5	2.12	2.37	35500.0
2012-02-09	ABV-DELISTED	Stock	37.17	37.33	36.63	37.31	2404565.0
2012-02-09	ABVA-DELISTED	Stock	3.55	3.55	3.48	3.48	1800.0
2012-02-09	ABVT-DELISTED	Stock	70.27	70.27	68.78	70.03	68615.0
2012-02-09	ABX-DELISTED	Stock	49.62	49.85	48.8	49.0	4650169.0

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

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