PREVIEW / stock_daily / 2017-02-07

all stock daily files

  file:    by_date/stock_daily/2017/2017-02-07.parquet
  size:    216 KB
  rows:    6,483
  symbols: 3,082

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
2017-02-07	AAPL	Stock	32.635	33.0225	32.6125	32.8825	152735200.0
2017-02-07	MSFT	Stock	63.74	63.78	63.23	63.43	20277200.0
2017-02-07	NVDA	Stock	2.9675	3.023	2.9475	2.9782	746224000.0
2017-02-07	AMZN	Stock	40.4655	40.808	40.375	40.625	69322000.0
2017-02-07	GOOGL	Stock	41.275	41.596	41.1646	41.4615	33332100.0
2017-02-07	META	Stock	132.24	133.0	131.66	131.84	14596400.0
2017-02-07	TSLA	Stock	17.2127	17.3333	17.0947	17.1653	63672000.0
2017-02-07	TLT	Stock	119.78	121.01	119.47	120.6	8418420.0
2017-02-07	ES	Stock	55.66	55.9	55.53	55.78	784400.0
2017-02-07	CL	Stock	65.73	66.79	65.72	66.56	3255600.0
2017-02-07	A	Stock	49.42	49.78	49.26	49.64	2170700.0
2017-02-07	AA	Stock	38.04	38.25	37.31	37.97	3270000.0
2017-02-07	AAAP-DELISTED	Stock	34.3	35.16	34.3	34.97	194042.0
2017-02-07	AABA-DELISTED	Stock	44.43	44.5934	44.19	44.37	4084552.0
2017-02-07	AAC-DELISTED	Stock	7.93	7.97	7.8	7.95	75243.0
2017-02-07	AACG	Stock	3.18	3.35	3.18	3.23	4700.0
2017-02-07	AAIC-DELISTED	Stock	15.46	15.51	15.18	15.27	266612.0
2017-02-07	AAL	Stock	45.75	46.13	45.01	45.17	6120000.0
2017-02-07	AAMC-DELISTED	Stock	24.1176	24.7059	23.2794	23.7221	20169.0
2017-02-07	AAME	Stock	3.66	3.66	3.66	3.66	300.0
2017-02-07	AAMI	Stock	14.95	14.95	14.63	14.69	368300.0
2017-02-07	AAOI	Stock	32.2	32.21	31.23	31.56	383500.0
2017-02-07	AAON	Stock	22.4333	22.6667	22.3	22.6667	147600.0
2017-02-07	AAP	Stock	161.21	162.06	157.78	159.18	1191300.0
2017-02-07	AAT	Stock	42.98	43.34	42.44	42.52	172300.0
2017-02-07	AAU-DELISTED	Stock	1.27	1.27	1.23	1.25	438144.0
2017-02-07	AAUAF-DELISTED	Stock	1.27	1.27	1.23	1.25	443134.0
2017-02-07	AAV-DELISTED	Stock	6.05	6.1	6.0	6.1	102304.0
2017-02-07	AAWW-DELISTED	Stock	51.7	51.8	51.15	51.6	84493.0
2017-02-07	AAXJ	Stock	59.54	59.54	59.27	59.37	383157.0
2017-02-07	AAXN-DELISTED	Stock	27.02	27.41	26.68	26.82	864675.0
2017-02-07	AB	Stock	23.5	23.52	23.2	23.25	275000.0
2017-02-07	ABAC-DELISTED	Stock	3.8	3.85	3.73	3.73	13538.0
2017-02-07	ABAX-DELISTED	Stock	51.18	51.585	50.37	50.6	114206.0
2017-02-07	ABB-DELISTED	Stock	23.43	23.52	23.385	23.435	1648635.0
2017-02-07	ABBNY-DELISTED	Stock	23.43	23.52	23.385	23.45	1698708.0
2017-02-07	ABBV	Stock	60.65	60.87	60.4	60.56	4210300.0
2017-02-07	ABC-DELISTED	Stock	89.85	91.64	89.71	90.33	1782849.0
2017-02-07	ABCB	Stock	46.3	46.4	45.55	45.65	179500.0
2017-02-07	ABCD-DELISTED	Stock	5.06	5.095	5.0	5.01	26669.0
2017-02-07	ABCO-DELISTED	Stock	47.0	47.05	45.9559	46.675	602487.0
2017-02-07	ABDC-DELISTED	Stock	12.16	12.3	12.12	12.261	41254.0
2017-02-07	ABE-DELISTED	Stock	11.9014	11.9014	11.85	11.8932	52391.0
2017-02-07	ABEO	Stock	123.75	135.0	123.75	133.75	11068.0
2017-02-07	ABEOW-DELISTED	Stock	3.0	3.0	3.0	3.0	974.0
2017-02-07	ABEV	Stock	5.43	5.48	5.38	5.39	11045100.0
2017-02-07	ABG	Stock	67.0	71.0	66.0	66.2	638100.0
2017-02-07	ABIL-DELISTED	Stock	3.2	3.215	3.1401	3.19	21453.0
2017-02-07	ABM	Stock	40.45	40.64	40.16	40.19	435700.0
2017-02-07	ABMD-DELISTED	Stock	111.21	111.82	109.35	109.94	374395.0

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

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