PREVIEW / stock_daily / 2014-07-31

all stock daily files

  file:    by_date/stock_daily/2014/2014-07-31.parquet
  size:    221 KB
  rows:    6,621
  symbols: 3,583

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
2014-07-31	AAPL	Stock	24.29	24.3625	23.8325	23.9	227372000.0
2014-07-31	MSFT	Stock	43.38	43.69	43.08	43.16	31537500.0
2014-07-31	NVDA	Stock	0.4465	0.45	0.4368	0.4375	401880000.0
2014-07-31	AMZN	Stock	16.0005	16.034	15.593	15.6495	103840000.0
2014-07-31	GOOGL	Stock	29.448	29.5995	28.884	28.9775	46209420.0
2014-07-31	META	Stock	74.0	74.17	72.44	72.65	43992000.0
2014-07-31	TSLA	Stock	15.284	15.4267	14.7667	14.8867	116236500.0
2014-07-31	TLT	Stock	113.53	114.58	113.47	113.98	18254147.0
2014-07-31	ES	Stock	44.67	44.85	43.78	43.9	1759500.0
2014-07-31	CL	Stock	64.73	64.99	63.4	63.4	6849300.0
2014-07-31	A	Stock	40.2146	40.4721	39.9356	40.1216	3785924.0
2014-07-31	AABA-DELISTED	Stock	36.26	36.49	35.68	35.82	17181579.0
2014-07-31	AACG	Stock	4.79	4.9	4.77	4.9	1700.0
2014-07-31	AAIC-DELISTED	Stock	26.35	26.48	26.08	26.08	464944.0
2014-07-31	AAL	Stock	38.9	39.4	38.05	38.85	13532100.0
2014-07-31	AAMC-DELISTED	Stock	198.8235	198.8235	180.3	180.3	58973.0
2014-07-31	AAME	Stock	4.05	4.09	4.05	4.09	10000.0
2014-07-31	AAOI	Stock	18.72	18.99	17.99	18.0	199600.0
2014-07-31	AAON	Stock	13.0733	13.4067	12.9467	13.08	291600.0
2014-07-31	AAP	Stock	123.86	124.54	121.03	121.11	891300.0
2014-07-31	AAT	Stock	34.78	34.99	34.22	34.29	215400.0
2014-07-31	AAU-DELISTED	Stock	1.41	1.44	1.371	1.41	95306.0
2014-07-31	AAUAF-DELISTED	Stock	1.41	1.44	1.371	1.41	96039.0
2014-07-31	AAV-DELISTED	Stock	5.38	5.4299	5.2805	5.34	589282.0
2014-07-31	AAVL-DELISTED	Stock	25.0	28.95	24.05	27.68	6183292.0
2014-07-31	AAWW-DELISTED	Stock	36.49	36.99	33.76	34.22	715546.0
2014-07-31	AAXJ	Stock	65.6	65.6	64.4	64.49	342468.0
2014-07-31	AAXN-DELISTED	Stock	13.13	13.2	12.0	12.055	2004302.0
2014-07-31	AB	Stock	26.39	26.42	25.28	26.14	712800.0
2014-07-31	ABAC-DELISTED	Stock	2.0	2.0	1.96	1.99	18018.0
2014-07-31	ABAX-DELISTED	Stock	47.16	47.79	46.89	47.42	178598.0
2014-07-31	ABB-DELISTED	Stock	23.17	23.255	22.98	23.0	1273180.0
2014-07-31	ABBNY-DELISTED	Stock	23.17	23.255	22.98	23.0	1392142.0
2014-07-31	ABBV	Stock	53.13	53.4	52.3	52.34	15479900.0
2014-07-31	ABC-DELISTED	Stock	77.67	78.04	76.72	76.92	1903197.0
2014-07-31	ABCB	Stock	21.47	21.95	21.47	21.84	239100.0
2014-07-31	ABCD-DELISTED	Stock	1.87	1.98	1.8575	1.95	22881.0
2014-07-31	ABCO-DELISTED	Stock	50.56	50.87	50.0	50.14	263980.0
2014-07-31	ABDC-DELISTED	Stock	13.54	13.69	13.15	13.15	113905.0
2014-07-31	ABE-DELISTED	Stock	14.44	14.462	14.28	14.2963	21742.0
2014-07-31	ABEO	Stock	337.5	337.5	312.5	325.0	24.0
2014-07-31	ABEV	Stock	7.04	7.05	6.86	6.89	26796500.0
2014-07-31	ABG	Stock	68.51	68.71	67.36	67.53	204800.0
2014-07-31	ABGB-DELISTED	Stock	27.45	27.45	26.57	26.57	5270.0
2014-07-31	ABM	Stock	24.72	24.87	24.47	24.61	199600.0
2014-07-31	ABMD-DELISTED	Stock	25.1	25.9799	24.82	25.59	679021.0
2014-07-31	ABR	Stock	7.1	7.14	7.05	7.07	69800.0
2014-07-31	ABR.A-DELISTED	Stock	25.01	25.0799	24.98	25.0799	2350.0
2014-07-31	ABR.B-DELISTED	Stock	24.57	24.63	24.4957	24.4957	8791.0
2014-07-31	ABR.C-DELISTED	Stock	25.37	25.401	25.37	25.37	1654.0

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

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