PREVIEW / stock_daily / 2012-02-24

all stock daily files

  file:    by_date/stock_daily/2012/2012-02-24.parquet
  size:    200 KB
  rows:    6,187
  symbols: 3,562

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-24	AAPL	Stock	18.5596	18.675	18.5229	18.6575	415072000.0
2012-02-24	MSFT	Stock	31.48	31.5	31.24	31.48	35575400.0
2012-02-24	NVDA	Stock	0.399	0.3995	0.393	0.3948	366668000.0
2012-02-24	AMZN	Stock	8.985	9.037	8.9185	8.9565	73374000.0
2012-02-24	TSLA	Stock	2.282	2.3013	2.218	2.25	14398500.0
2012-02-24	TLT	Stock	117.23	117.58	116.95	117.5	5676829.0
2012-02-24	ES	Stock	35.96	36.08	35.64	35.86	3051600.0
2012-02-24	CL	Stock	46.865	46.865	46.335	46.65	3677400.0
2012-02-24	A	Stock	31.1373	31.4664	30.7368	30.7725	4104528.0
2012-02-24	AABA-DELISTED	Stock	14.84	14.97	14.82	14.89	11544639.0
2012-02-24	AACC-DELISTED	Stock	4.38	4.55	4.38	4.5	20399.0
2012-02-24	AACG	Stock	7.48	7.48	7.07	7.26	10300.0
2012-02-24	AAIC-DELISTED	Stock	23.8	23.8	23.32	23.44	42627.0
2012-02-24	AAME	Stock	2.34	2.39	2.2	2.2	6100.0
2012-02-24	AAMRQ-DELISTED	Stock	0.505	0.52	0.504	0.5125	2446388.0
2012-02-24	AAON	Stock	5.9052	5.9437	5.7748	5.7778	106650.0
2012-02-24	AAP	Stock	85.19	85.71	84.38	84.58	925400.0
2012-02-24	AAT	Stock	22.31	22.57	22.27	22.43	55200.0
2012-02-24	AAU-DELISTED	Stock	2.95	2.95	2.8598	2.8598	154345.0
2012-02-24	AAUAF-DELISTED	Stock	2.94	2.94	2.85	2.87	155221.0
2012-02-24	AAV-DELISTED	Stock	4.02	4.05	3.97	3.97	180032.0
2012-02-24	AAWW-DELISTED	Stock	44.6	44.6	42.27	42.46	391184.0
2012-02-24	AAXJ	Stock	57.63	57.85	57.561	57.75	184821.0
2012-02-24	AAXN-DELISTED	Stock	4.16	4.32	4.14	4.17	578859.0
2012-02-24	AB	Stock	14.19	14.2	13.97	14.0	281300.0
2012-02-24	ABAC-DELISTED	Stock	1.6	1.68	1.6	1.64	17395.0
2012-02-24	ABAX-DELISTED	Stock	26.72	26.95	26.5	26.78	41345.0
2012-02-24	ABB-DELISTED	Stock	20.95	21.07	20.87	20.92	1285705.0
2012-02-24	ABBNY-DELISTED	Stock	20.95	21.07	20.87	20.92	1285805.0
2012-02-24	ABC-DELISTED	Stock	37.38	37.75	37.13	37.7	2308182.0
2012-02-24	ABCB	Stock	11.37	11.37	11.2	11.24	29000.0
2012-02-24	ABCD-DELISTED	Stock	3.07	3.07	2.95	2.99	16611.0
2012-02-24	ABCO-DELISTED	Stock	38.98	39.53	38.47	39.39	227596.0
2012-02-24	ABCW-DELISTED	Stock	0.4117	0.4317	0.3615	0.4317	25490.0
2012-02-24	ABD-DELISTED	Stock	12.3	12.4	12.22	12.29	238640.0
2012-02-24	ABE-DELISTED	Stock	18.75	18.85	18.75	18.82	10072.0
2012-02-24	ABEO	Stock	1612.5	1637.5	1587.5	1625.0	11.0
2012-02-24	ABFS-DELISTED	Stock	18.86	18.9	18.46	18.48	133601.0
2012-02-24	ABG	Stock	24.83	25.88	24.69	25.54	660800.0
2012-02-24	ABH-DELISTED	Stock	15.42	15.48	15.19	15.2	83753.0
2012-02-24	ABM	Stock	23.44	24.12	23.44	23.58	310400.0
2012-02-24	ABMD-DELISTED	Stock	21.45	22.2	21.26	22.12	386010.0
2012-02-24	ABR	Stock	4.81	4.81	4.7	4.77	71400.0
2012-02-24	ABT	Stock	27.0271	27.2239	26.984	27.2047	9957482.0
2012-02-24	ABTL-DELISTED	Stock	5.202	5.253	5.0623	5.1	13223.0
2012-02-24	ABUS	Stock	2.38	2.45	2.38	2.4	1500.0
2012-02-24	ABV-DELISTED	Stock	39.07	39.7701	38.82	39.59	2698678.0
2012-02-24	ABVA-DELISTED	Stock	3.62	3.62	3.604	3.604	357.0
2012-02-24	ABVT-DELISTED	Stock	72.41	73.43	70.14	70.97	159260.0
2012-02-24	ABX-DELISTED	Stock	49.44	49.55	48.56	48.84	5684444.0

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

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