PREVIEW / stock_daily / 2014-08-07

all stock daily files

  file:    by_date/stock_daily/2014/2014-08-07.parquet
  size:    220 KB
  rows:    6,588
  symbols: 3,559

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-08-07	AAPL	Stock	23.7325	23.9875	23.525	23.62	186844000.0
2014-08-07	MSFT	Stock	42.84	43.45	42.65	43.23	30314900.0
2014-08-07	NVDA	Stock	0.4448	0.4488	0.4335	0.4365	407696000.0
2014-08-07	AMZN	Stock	15.7605	15.794	15.4825	15.5725	58712000.0
2014-08-07	GOOGL	Stock	28.8025	28.9155	28.4715	28.5905	23260540.0
2014-08-07	META	Stock	73.0	74.0	72.7	73.17	38141000.0
2014-08-07	TSLA	Stock	16.6747	17.1127	16.608	16.826	112183500.0
2014-08-07	TLT	Stock	114.84	115.77	114.57	115.77	9750472.0
2014-08-07	ES	Stock	42.18	42.7	42.18	42.46	1552300.0
2014-08-07	CL	Stock	64.97	65.07	64.31	64.45	2797600.0
2014-08-07	A	Stock	40.0429	40.0572	39.3276	39.3777	2276643.0
2014-08-07	AABA-DELISTED	Stock	35.89	36.0	35.54	35.65	10864819.0
2014-08-07	AACG	Stock	4.59	4.59	4.48	4.48	1100.0
2014-08-07	AAIC-DELISTED	Stock	26.7	26.85	26.52	26.67	178740.0
2014-08-07	AAL	Stock	37.7	38.41	36.5	36.86	9886800.0
2014-08-07	AAMC-DELISTED	Stock	177.7941	177.9412	174.25	175.9882	16187.0
2014-08-07	AAME	Stock	4.14	4.25	4.14	4.25	800.0
2014-08-07	AAOI	Stock	19.68	19.68	19.02	19.05	53700.0
2014-08-07	AAON	Stock	12.0267	12.9	12.0067	12.6067	520650.0
2014-08-07	AAP	Stock	123.97	124.28	121.63	121.85	567900.0
2014-08-07	AAT	Stock	34.55	34.73	34.33	34.5	126200.0
2014-08-07	AAU-DELISTED	Stock	1.4	1.412	1.39	1.407	51247.0
2014-08-07	AAUAF-DELISTED	Stock	1.4	1.41	1.39	1.41	52255.0
2014-08-07	AAV-DELISTED	Stock	5.4	5.41	5.24	5.36	424375.0
2014-08-07	AAVL-DELISTED	Stock	23.45	25.0	22.82	23.02	70772.0
2014-08-07	AAWW-DELISTED	Stock	32.46	33.01	32.27	32.35	254859.0
2014-08-07	AAXJ	Stock	64.34	64.43	63.81	63.95	229512.0
2014-08-07	AAXN-DELISTED	Stock	12.68	12.69	12.17	12.19	983380.0
2014-08-07	AB	Stock	25.95	26.29	25.5	25.61	227600.0
2014-08-07	ABAC-DELISTED	Stock	2.0	2.0	1.91	2.0	24816.0
2014-08-07	ABAX-DELISTED	Stock	46.45	46.45	45.48	45.52	119037.0
2014-08-07	ABB-DELISTED	Stock	22.45	22.5	22.23	22.27	1272488.0
2014-08-07	ABBNY-DELISTED	Stock	22.45	22.5	22.23	22.27	1337460.0
2014-08-07	ABBV	Stock	51.59	52.71	51.42	52.43	17171700.0
2014-08-07	ABC-DELISTED	Stock	76.37	76.4577	74.86	74.96	1877689.0
2014-08-07	ABCB	Stock	21.75	21.82	21.39	21.61	60000.0
2014-08-07	ABCD-DELISTED	Stock	1.94	1.97	1.78	1.88	78441.0
2014-08-07	ABCO-DELISTED	Stock	48.56	49.19	48.12	48.87	178215.0
2014-08-07	ABDC-DELISTED	Stock	12.7	12.97	12.61	12.78	65663.0
2014-08-07	ABE-DELISTED	Stock	14.44	14.44	14.27	14.28	7981.0
2014-08-07	ABEO	Stock	325.0	337.5	325.0	337.5	22.0
2014-08-07	ABEV	Stock	6.8	6.85	6.72	6.73	11898000.0
2014-08-07	ABG	Stock	68.49	68.76	66.32	66.67	284000.0
2014-08-07	ABGB-DELISTED	Stock	24.35	24.35	23.7254	23.73	18466.0
2014-08-07	ABM	Stock	25.07	25.07	24.73	24.87	83000.0
2014-08-07	ABMD-DELISTED	Stock	25.36	25.89	25.24	25.43	191097.0
2014-08-07	ABR	Stock	6.97	7.0	6.92	6.93	54600.0
2014-08-07	ABR.A-DELISTED	Stock	24.8497	24.94	24.832	24.9199	4700.0
2014-08-07	ABR.B-DELISTED	Stock	24.5599	24.5599	24.38	24.4999	1804.0
2014-08-07	ABR.C-DELISTED	Stock	25.2	25.3499	25.2	25.28	4367.0

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

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