PREVIEW / stock_daily / 2012-05-14

all stock daily files

  file:    by_date/stock_daily/2012/2012-05-14.parquet
  size:    200 KB
  rows:    6,199
  symbols: 3,571

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-05-14	AAPL	Stock	20.0918	20.2682	19.9143	19.9364	352626400.0
2012-05-14	MSFT	Stock	30.82	31.04	30.64	30.68	40528900.0
2012-05-14	NVDA	Stock	0.3275	0.3333	0.3208	0.3283	437472000.0
2012-05-14	AMZN	Stock	11.28	11.3645	11.1255	11.1465	61932000.0
2012-05-14	TSLA	Stock	2.128	2.142	2.0033	2.004	20713500.0
2012-05-14	TLT	Stock	120.87	121.3	120.5999	121.17	8789541.0
2012-05-14	ES	Stock	36.36	36.49	35.96	36.2	1553700.0
2012-05-14	CL	Stock	49.38	49.675	49.38	49.505	3184600.0
2012-05-14	A	Stock	27.804	28.2117	27.4964	27.8255	5526574.0
2012-05-14	AABA-DELISTED	Stock	15.49	15.77	15.4	15.49	30742198.0
2012-05-14	AACC-DELISTED	Stock	5.82	6.0	5.636	5.95	53669.0
2012-05-14	AACG	Stock	6.51	6.51	6.5	6.5	1100.0
2012-05-14	AAIC-DELISTED	Stock	23.36	23.45	23.174	23.33	74042.0
2012-05-14	AAME	Stock	2.85	2.85	2.66	2.81	7700.0
2012-05-14	AAMRQ-DELISTED	Stock	0.515	0.53	0.51	0.511	1042200.0
2012-05-14	AAON	Stock	5.5852	5.6978	5.5852	5.6504	230850.0
2012-05-14	AAP	Stock	85.57	86.46	82.27	82.34	2547400.0
2012-05-14	AAT	Stock	23.75	24.08	23.51	23.6	90300.0
2012-05-14	AAU-DELISTED	Stock	1.98	2.0668	1.95	2.0	145195.0
2012-05-14	AAUAF-DELISTED	Stock	1.98	2.0668	1.95	2.0	145495.0
2012-05-14	AAV-DELISTED	Stock	3.09	3.09	2.95	2.99	446005.0
2012-05-14	AAWW-DELISTED	Stock	48.57	49.33	48.08	48.23	223993.0
2012-05-14	AAXJ	Stock	52.845	52.96	52.49	52.61	409100.0
2012-05-14	AAXN-DELISTED	Stock	5.13	5.29	4.95	5.2	485378.0
2012-05-14	AB	Stock	14.58	14.93	14.55	14.82	179500.0
2012-05-14	ABAC-DELISTED	Stock	1.56	1.61	1.55	1.55	12708.0
2012-05-14	ABAX-DELISTED	Stock	34.36	34.89	34.295	34.56	99356.0
2012-05-14	ABB-DELISTED	Stock	16.59	16.62	16.45	16.47	3066542.0
2012-05-14	ABBNY-DELISTED	Stock	16.59	16.62	16.45	16.47	3069077.0
2012-05-14	ABC-DELISTED	Stock	36.35	36.87	36.2413	36.66	1879740.0
2012-05-14	ABCB	Stock	12.27	12.44	12.19	12.19	30600.0
2012-05-14	ABCD-DELISTED	Stock	1.91	2.03	1.68	1.77	55648.0
2012-05-14	ABCO-DELISTED	Stock	46.38	47.0	46.38	46.95	238565.0
2012-05-14	ABCW-DELISTED	Stock	0.5924	0.6225	0.5522	0.5522	23170.0
2012-05-14	ABE-DELISTED	Stock	18.9	18.9	18.68	18.74	3583.0
2012-05-14	ABEO	Stock	1125.0	1125.0	1062.5	1125.0	3.0
2012-05-14	ABFS-DELISTED	Stock	13.21	13.37	13.04	13.13	445052.0
2012-05-14	ABG	Stock	25.81	26.32	25.56	25.76	370900.0
2012-05-14	ABH-DELISTED	Stock	11.3	11.3	10.94	11.0	263780.0
2012-05-14	ABM	Stock	22.3	22.51	22.13	22.37	138000.0
2012-05-14	ABMD-DELISTED	Stock	22.88	23.55	22.53	23.14	636198.0
2012-05-14	ABR	Stock	6.16	6.32	6.1	6.32	70100.0
2012-05-14	ABT	Stock	29.4885	29.7668	29.4741	29.5941	11130888.0
2012-05-14	ABTL-DELISTED	Stock	3.7029	3.85	3.7029	3.85	27347.0
2012-05-14	ABUS	Stock	2.2	2.2	2.13	2.16	2400.0
2012-05-14	ABV-DELISTED	Stock	38.57	38.97	38.28	38.78	2733098.0
2012-05-14	ABVA-DELISTED	Stock	4.3601	4.37	4.35	4.37	1100.0
2012-05-14	ABVT-DELISTED	Stock	83.24	83.27	83.19	83.23	301229.0
2012-05-14	ABX-DELISTED	Stock	36.62	37.46	36.1	36.54	7037770.0
2012-05-14	ACAD	Stock	1.52	1.63	1.5	1.59	356000.0

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

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