PREVIEW / stock_daily / 2014-07-08

all stock daily files

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

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-08	AAPL	Stock	24.0675	24.2	23.48	23.8375	260888000.0
2014-07-08	MSFT	Stock	41.87	42.0	41.61	41.78	31218200.0
2014-07-08	NVDA	Stock	0.4662	0.4683	0.4593	0.4638	221940000.0
2014-07-08	AMZN	Stock	16.655	16.687	16.07	16.1905	85432000.0
2014-07-08	GOOGL	Stock	29.3182	29.3985	28.7	28.92	42598480.0
2014-07-08	META	Stock	65.06	65.56	62.21	62.76	68926000.0
2014-07-08	TSLA	Stock	14.5767	14.7307	14.2847	14.6047	117543000.0
2014-07-08	TLT	Stock	112.24	112.86	112.24	112.74	6353288.0
2014-07-08	ES	Stock	45.71	46.18	45.71	45.97	1175700.0
2014-07-08	CL	Stock	68.59	69.58	68.55	69.5	3835000.0
2014-07-08	A	Stock	41.3734	41.4378	40.7153	40.8798	2259028.0
2014-07-08	AABA-DELISTED	Stock	35.64	35.66	34.28	34.53	21711879.0
2014-07-08	AACG	Stock	4.39	4.48	3.79	4.48	38200.0
2014-07-08	AAIC-DELISTED	Stock	26.4	26.7	26.4	26.64	217024.0
2014-07-08	AAL	Stock	39.14	40.33	37.9	40.26	26399400.0
2014-07-08	AAMC-DELISTED	Stock	188.2353	188.2353	183.8235	188.2353	34683.0
2014-07-08	AAME	Stock	3.86	3.96	3.85	3.96	9500.0
2014-07-08	AAOI	Stock	22.25	22.5	21.61	22.45	220300.0
2014-07-08	AAON	Stock	14.7067	14.7511	14.28	14.5422	649350.0
2014-07-08	AAP	Stock	133.99	133.99	131.64	132.27	484300.0
2014-07-08	AAT	Stock	34.51	34.96	34.42	34.87	86400.0
2014-07-08	AAU-DELISTED	Stock	1.5	1.5116	1.4	1.43	92775.0
2014-07-08	AAUAF-DELISTED	Stock	1.5	1.5	1.39	1.43	97201.0
2014-07-08	AAV-DELISTED	Stock	6.46	6.46	6.15	6.31	690669.0
2014-07-08	AAWW-DELISTED	Stock	36.46	36.46	35.48	35.85	227623.0
2014-07-08	AAXJ	Stock	63.69	64.0	63.59	63.73	540766.0
2014-07-08	AAXN-DELISTED	Stock	12.88	13.02	11.97	12.0	2013866.0
2014-07-08	AB	Stock	26.36	26.55	26.19	26.45	273200.0
2014-07-08	ABAC-DELISTED	Stock	2.1	2.1	2.05	2.0501	13451.0
2014-07-08	ABAX-DELISTED	Stock	43.68	43.68	42.61	43.04	180025.0
2014-07-08	ABB-DELISTED	Stock	23.03	23.04	22.8	22.85	1692733.0
2014-07-08	ABBNY-DELISTED	Stock	23.03	23.04	22.8	22.85	1818777.0
2014-07-08	ABBV	Stock	56.68	56.97	55.48	55.69	9297300.0
2014-07-08	ABC-DELISTED	Stock	73.0	73.07	72.6	72.89	997423.0
2014-07-08	ABCB	Stock	22.08	22.08	21.59	21.83	46400.0
2014-07-08	ABCD-DELISTED	Stock	2.051	2.09	2.001	2.0239	6918.0
2014-07-08	ABCO-DELISTED	Stock	55.22	55.22	51.01	51.45	188155.0
2014-07-08	ABDC-DELISTED	Stock	14.74	14.83	14.32	14.48	32993.0
2014-07-08	ABE-DELISTED	Stock	14.41	14.54	14.41	14.4755	3188.0
2014-07-08	ABEO	Stock	362.5	400.0	337.5	337.5	69.0
2014-07-08	ABEV	Stock	7.21	7.22	7.13	7.15	4086500.0
2014-07-08	ABG	Stock	70.54	71.58	69.93	71.02	304600.0
2014-07-08	ABGB-DELISTED	Stock	26.0	26.0199	25.591	25.81	6197.0
2014-07-08	ABM	Stock	26.4	26.49	26.14	26.36	197300.0
2014-07-08	ABMD-DELISTED	Stock	25.23	25.23	24.67	24.78	650053.0
2014-07-08	ABR	Stock	6.91	6.94	6.88	6.92	79200.0
2014-07-08	ABR.A-DELISTED	Stock	24.6999	24.6999	24.5602	24.5968	3145.0
2014-07-08	ABR.B-DELISTED	Stock	24.48	24.4995	24.48	24.4995	500.0
2014-07-08	ABR.C-DELISTED	Stock	25.24	25.24	25.16	25.1999	4005.0
2014-07-08	ABRN-DELISTED	Stock	24.98	25.0701	24.98	24.99	12930.0

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

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