PREVIEW / stock_daily / 2012-02-08

all stock daily files

  file:    by_date/stock_daily/2012/2012-02-08.parquet
  size:    199 KB
  rows:    6,184
  symbols: 3,568

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-08	AAPL	Stock	16.8036	17.0282	16.775	17.0243	407890000.0
2012-02-08	MSFT	Stock	30.26	30.67	30.22	30.66	49659100.0
2012-02-08	NVDA	Stock	0.3935	0.4155	0.3915	0.4078	847612000.0
2012-02-08	AMZN	Stock	9.2475	9.3245	9.1455	9.274	109532000.0
2012-02-08	TSLA	Stock	2.1067	2.134	2.086	2.1287	9355500.0
2012-02-08	TLT	Stock	116.2	116.79	115.98	116.36	7614647.0
2012-02-08	ES	Stock	35.48	35.63	35.22	35.62	917700.0
2012-02-08	CL	Stock	45.92	45.92	45.455	45.735	3217400.0
2012-02-08	A	Stock	31.9742	32.2246	31.7668	32.1674	3033101.0
2012-02-08	AABA-DELISTED	Stock	15.96	15.97	15.72	15.78	12910362.0
2012-02-08	AACC-DELISTED	Stock	4.6	4.71	4.6	4.65	22261.0
2012-02-08	AACG	Stock	7.16	7.24	7.05	7.24	3300.0
2012-02-08	AAIC-DELISTED	Stock	23.65	24.13	23.55	24.08	70380.0
2012-02-08	AAME	Stock	2.05	2.05	2.03	2.05	6100.0
2012-02-08	AAMRQ-DELISTED	Stock	0.6495	0.65	0.625	0.6445	3298468.0
2012-02-08	AAON	Stock	6.2163	6.2252	5.9615	5.9822	285525.0
2012-02-08	AAP	Stock	77.23	79.07	77.01	78.83	2775800.0
2012-02-08	AAT	Stock	22.83	22.98	22.43	22.66	118600.0
2012-02-08	AAU-DELISTED	Stock	2.61	2.636	2.51	2.51	152055.0
2012-02-08	AAUAF-DELISTED	Stock	2.61	2.636	2.51	2.51	152466.0
2012-02-08	AAV-DELISTED	Stock	3.76	3.8	3.7	3.74	256616.0
2012-02-08	AAWW-DELISTED	Stock	52.11	52.13	50.47	51.02	396327.0
2012-02-08	AAXJ	Stock	57.19	57.44	57.05	57.28	398084.0
2012-02-08	AAXN-DELISTED	Stock	4.85	4.9	4.76	4.9	160028.0
2012-02-08	AB	Stock	16.32	16.62	16.2	16.29	216000.0
2012-02-08	ABAC-DELISTED	Stock	1.6	1.64	1.55	1.6	46586.0
2012-02-08	ABAX-DELISTED	Stock	28.79	29.14	28.31	28.52	30055.0
2012-02-08	ABB-DELISTED	Stock	21.6	21.719	21.405	21.63	1917793.0
2012-02-08	ABBNY-DELISTED	Stock	21.6	21.719	21.405	21.63	1918793.0
2012-02-08	ABC-DELISTED	Stock	38.98	39.52	38.73	39.33	2100884.0
2012-02-08	ABCB	Stock	11.17	11.25	11.05	11.23	40000.0
2012-02-08	ABCD-DELISTED	Stock	3.25	3.27	3.2	3.27	6605.0
2012-02-08	ABCO-DELISTED	Stock	36.5	37.36	36.04	36.39	117158.0
2012-02-08	ABCW-DELISTED	Stock	0.502	0.502	0.3514	0.3514	5350.0
2012-02-08	ABD-DELISTED	Stock	11.2	11.3	11.04	11.3	365830.0
2012-02-08	ABE-DELISTED	Stock	19.3	19.4	19.298	19.383	2400.0
2012-02-08	ABEO	Stock	1725.0	1750.0	1662.5	1750.0	10.0
2012-02-08	ABFS-DELISTED	Stock	18.75	19.04	18.5	18.83	228423.0
2012-02-08	ABG	Stock	24.65	24.9	24.0	24.19	179900.0
2012-02-08	ABH-DELISTED	Stock	15.97	16.22	15.9	16.0	418283.0
2012-02-08	ABM	Stock	22.81	23.2	22.53	22.73	107800.0
2012-02-08	ABMD-DELISTED	Stock	23.5	23.6671	23.0	23.5799	1812321.0
2012-02-08	ABR	Stock	4.44	4.58	4.44	4.57	47200.0
2012-02-08	ABT	Stock	26.7824	26.7824	26.5713	26.6625	10981451.0
2012-02-08	ABTL-DELISTED	Stock	4.5929	4.7949	4.5929	4.6	8694.0
2012-02-08	ABUS	Stock	2.15	2.15	2.02	2.12	6800.0
2012-02-08	ABV-DELISTED	Stock	37.48	37.535	36.83	36.99	1684198.0
2012-02-08	ABVA-DELISTED	Stock	3.44	3.6	3.44	3.5999	7920.0
2012-02-08	ABVT-DELISTED	Stock	69.09	70.33	68.88	70.27	107935.0
2012-02-08	ABX-DELISTED	Stock	49.41	49.8305	48.86	49.06	4867256.0

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

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