PREVIEW / stock_daily / 2016-07-08

all stock daily files

  file:    by_date/stock_daily/2016/2016-07-08.parquet
  size:    220 KB
  rows:    6,553
  symbols: 3,261

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
2016-07-08	AAPL	Stock	24.1225	24.2225	24.0125	24.17	115648400.0
2016-07-08	MSFT	Stock	51.73	52.36	51.55	52.3	28391000.0
2016-07-08	NVDA	Stock	1.2352	1.2773	1.2305	1.2713	481932000.0
2016-07-08	AMZN	Stock	37.007	37.305	36.9	37.2905	68584000.0
2016-07-08	GOOGL	Stock	35.528	35.895	35.4055	35.889	29946460.0
2016-07-08	META	Stock	116.43	117.5	115.85	117.24	18142600.0
2016-07-08	TSLA	Stock	14.52	14.654	14.3	14.452	61122000.0
2016-07-08	TLT	Stock	142.92	143.62	142.36	143.6	10355253.0
2016-07-08	ES	Stock	59.01	59.6	58.48	59.57	2079300.0
2016-07-08	CL	Stock	73.77	74.27	73.42	74.25	2921200.0
2016-07-08	A	Stock	44.86	45.55	44.86	45.48	1838100.0
2016-07-08	AA.B-DELISTED	Stock	33.69	34.45	33.62	34.36	49883.0
2016-07-08	AAAP-DELISTED	Stock	30.74	30.74	30.41	30.72	7152.0
2016-07-08	AABA-DELISTED	Stock	37.46	37.84	37.06	37.73	8158659.0
2016-07-08	AAC-DELISTED	Stock	23.0	23.2	22.55	22.64	145634.0
2016-07-08	AACG	Stock	4.45	4.45	4.09	4.22	6800.0
2016-07-08	AAIC-DELISTED	Stock	12.96	13.01	12.86	12.9	204559.0
2016-07-08	AAL	Stock	29.8	30.28	29.7	30.04	13659300.0
2016-07-08	AAMC-DELISTED	Stock	4.1088	4.1176	3.9235	3.95	55981.0
2016-07-08	AAME	Stock	4.15	4.15	4.07	4.1	2500.0
2016-07-08	AAMI	Stock	12.99	13.22	12.97	13.18	209600.0
2016-07-08	AAOI	Stock	11.2	11.48	11.19	11.3	227800.0
2016-07-08	AAON	Stock	18.0	18.32	17.92	18.28	363000.0
2016-07-08	AAP	Stock	162.29	165.26	161.68	164.85	911100.0
2016-07-08	AAT	Stock	43.05	43.47	42.87	43.38	392800.0
2016-07-08	AAU-DELISTED	Stock	1.53	1.54	1.43	1.4799	1045947.0
2016-07-08	AAUAF-DELISTED	Stock	1.53	1.54	1.43	1.47	1065087.0
2016-07-08	AAV-DELISTED	Stock	5.85	5.9	5.8	5.81	60940.0
2016-07-08	AAWW-DELISTED	Stock	40.41	41.21	39.77	40.99	187688.0
2016-07-08	AAXJ	Stock	54.58	55.06	54.51	54.99	644357.0
2016-07-08	AAXN-DELISTED	Stock	26.99	27.8	26.7	27.3	3165404.0
2016-07-08	AB	Stock	23.19	23.4	23.06	23.18	178000.0
2016-07-08	ABAC-DELISTED	Stock	0.85	0.85	0.745	0.8089	12494.0
2016-07-08	ABAX-DELISTED	Stock	48.83	51.03	48.67	50.95	166945.0
2016-07-08	ABB-DELISTED	Stock	18.74	18.935	18.72	18.91	1482358.0
2016-07-08	ABBNY-DELISTED	Stock	18.75	18.935	18.72	18.9	1528012.0
2016-07-08	ABBV	Stock	63.48	64.48	62.74	64.16	7921700.0
2016-07-08	ABC-DELISTED	Stock	81.71	82.079	81.25	81.91	1386443.0
2016-07-08	ABCB	Stock	29.56	29.81	29.47	29.58	133800.0
2016-07-08	ABCD-DELISTED	Stock	4.56	4.76	4.55	4.74	22869.0
2016-07-08	ABCO-DELISTED	Stock	36.27	38.0	35.94	37.42	362499.0
2016-07-08	ABDC-DELISTED	Stock	12.25	12.444	12.21	12.3	63939.0
2016-07-08	ABE-DELISTED	Stock	12.23	12.38	12.23	12.361	4982.0
2016-07-08	ABEO	Stock	58.75	60.0	58.75	59.25	1340.0
2016-07-08	ABEOW-DELISTED	Stock	1.05	1.05	1.05	1.05	100.0
2016-07-08	ABEV	Stock	5.8	5.95	5.78	5.9	15527900.0
2016-07-08	ABG	Stock	52.3	54.91	52.3	54.63	284200.0
2016-07-08	ABIL-DELISTED	Stock	4.1	4.43	4.0	4.22	73463.0
2016-07-08	ABM	Stock	36.54	37.07	36.54	36.82	240900.0
2016-07-08	ABMD-DELISTED	Stock	114.08	115.89	112.86	114.14	575058.0

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

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