PREVIEW / stock_daily / 2012-02-17

all stock daily files

  file:    by_date/stock_daily/2012/2012-02-17.parquet
  size:    201 KB
  rows:    6,212
  symbols: 3,581

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-17	AAPL	Stock	17.9682	18.1346	17.8679	17.9329	535805200.0
2012-02-17	MSFT	Stock	31.2	31.32	30.95	31.25	70036500.0
2012-02-17	NVDA	Stock	0.4115	0.4142	0.3925	0.3962	1020360000.0
2012-02-17	AMZN	Stock	9.0045	9.1705	8.968	9.125	148362000.0
2012-02-17	TSLA	Stock	2.266	2.3313	2.2333	2.3313	20650500.0
2012-02-17	TLT	Stock	115.86	116.61	115.76	116.58	6338146.0
2012-02-17	ES	Stock	36.29	36.46	35.85	36.1	1452400.0
2012-02-17	CL	Stock	46.8	46.925	46.44	46.625	3483800.0
2012-02-17	A	Stock	31.5021	31.5737	30.7439	30.8584	5687344.0
2012-02-17	AABA-DELISTED	Stock	15.41	15.44	15.0	15.001	22540920.0
2012-02-17	AACC-DELISTED	Stock	4.46	4.52	4.38	4.52	10778.0
2012-02-17	AAIC-DELISTED	Stock	23.53	24.15	23.434	24.02	33404.0
2012-02-17	AAME	Stock	2.28	2.3	2.25	2.29	11800.0
2012-02-17	AAMRQ-DELISTED	Stock	0.507	0.555	0.507	0.5385	4620170.0
2012-02-17	AAON	Stock	5.7363	5.7363	5.6711	5.6978	105300.0
2012-02-17	AAP	Stock	86.45	87.49	85.48	85.57	2096100.0
2012-02-17	AAT	Stock	22.52	22.53	22.2	22.52	147000.0
2012-02-17	AAU-DELISTED	Stock	2.68	2.71	2.62	2.69	124552.0
2012-02-17	AAUAF-DELISTED	Stock	2.68	2.71	2.62	2.69	125152.0
2012-02-17	AAV-DELISTED	Stock	3.78	4.09	3.77	4.04	991054.0
2012-02-17	AAWW-DELISTED	Stock	45.89	46.34	45.43	45.94	482419.0
2012-02-17	AAXJ	Stock	57.88	57.99	57.61	57.81	161068.0
2012-02-17	AAXN-DELISTED	Stock	4.27	4.5	4.22	4.49	610531.0
2012-02-17	AB	Stock	13.8	13.85	13.39	13.61	729400.0
2012-02-17	ABAC-DELISTED	Stock	1.5999	1.68	1.5999	1.68	7188.0
2012-02-17	ABAX-DELISTED	Stock	26.38	26.81	26.111	26.24	137597.0
2012-02-17	ABB-DELISTED	Stock	21.0	21.12	20.84	21.02	2856671.0
2012-02-17	ABBNY-DELISTED	Stock	21.0	21.12	20.84	21.03	3087671.0
2012-02-17	ABC-DELISTED	Stock	37.04	37.15	36.555	36.65	3125669.0
2012-02-17	ABCB	Stock	11.3	11.36	11.05	11.27	31000.0
2012-02-17	ABCD-DELISTED	Stock	3.19	3.24	3.04	3.04	17806.0
2012-02-17	ABCO-DELISTED	Stock	38.28	38.28	37.85	38.16	118492.0
2012-02-17	ABCW-DELISTED	Stock	0.3815	0.3815	0.3213	0.3715	25220.0
2012-02-17	ABD-DELISTED	Stock	12.0	12.25	11.92	12.1	971240.0
2012-02-17	ABE-DELISTED	Stock	18.78	18.9	18.77	18.78	64608.0
2012-02-17	ABEO	Stock	1712.5	1737.5	1650.0	1712.5	10.0
2012-02-17	ABFS-DELISTED	Stock	19.38	19.5	19.1	19.26	122150.0
2012-02-17	ABG	Stock	26.12	26.12	25.66	25.92	286600.0
2012-02-17	ABH-DELISTED	Stock	15.28	15.53	15.28	15.5	340501.0
2012-02-17	ABM	Stock	22.85	23.0	22.6	22.71	196500.0
2012-02-17	ABMD-DELISTED	Stock	23.17	23.29	22.22	22.37	593446.0
2012-02-17	ABR	Stock	4.83	4.84	4.69	4.77	18700.0
2012-02-17	ABT	Stock	26.9696	27.0991	26.888	27.0415	16231972.0
2012-02-17	ABTL-DELISTED	Stock	4.9442	5.25	4.9442	5.25	23705.0
2012-02-17	ABUS	Stock	2.36	2.36	2.36	2.36	2000.0
2012-02-17	ABV-DELISTED	Stock	38.8	39.015	38.44	38.71	2369992.0
2012-02-17	ABVA-DELISTED	Stock	3.48	3.55	3.48	3.54	6854.0
2012-02-17	ABVT-DELISTED	Stock	69.99	70.68	69.91	70.17	101892.0
2012-02-17	ABX-DELISTED	Stock	48.46	48.5	46.89	47.05	7123682.0
2012-02-17	ACAD	Stock	1.86	1.86	1.78	1.79	122100.0

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

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