PREVIEW / stock_daily / 2016-05-17

all stock daily files

  file:    by_date/stock_daily/2016/2016-05-17.parquet
  size:    220 KB
  rows:    6,601
  symbols: 3,311

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-05-17	AAPL	Stock	23.6375	23.675	23.2525	23.3725	187667600.0
2016-05-17	MSFT	Stock	51.72	51.73	50.36	50.51	27803500.0
2016-05-17	NVDA	Stock	1.05	1.0645	1.0365	1.057	628392000.0
2016-05-17	AMZN	Stock	35.495	35.7235	34.6955	34.7635	102428000.0
2016-05-17	GOOGL	Stock	36.553	36.7925	35.9	36.0095	33403520.0
2016-05-17	META	Stock	118.82	119.01	117.2	117.35	21328600.0
2016-05-17	TSLA	Stock	13.9367	13.988	13.6013	13.644	42654000.0
2016-05-17	TLT	Stock	131.21	131.83	131.21	131.36	4449130.0
2016-05-17	ES	Stock	57.21	57.27	55.62	55.82	2676900.0
2016-05-17	CL	Stock	71.96	71.97	70.46	70.85	3467300.0
2016-05-17	A	Stock	44.96	45.34	43.63	44.41	7130400.0
2016-05-17	AA.B-DELISTED	Stock	32.79	33.23	32.44	32.44	116040.0
2016-05-17	AAAP-DELISTED	Stock	28.13	28.76	27.75	27.86	72301.0
2016-05-17	AABA-DELISTED	Stock	37.44	37.6997	37.25	37.27	10728442.0
2016-05-17	AAC-DELISTED	Stock	20.61	20.61	19.39	19.71	141474.0
2016-05-17	AACG	Stock	5.18	5.36	5.18	5.33	17900.0
2016-05-17	AAIC-DELISTED	Stock	12.53	12.72	12.35	12.42	223358.0
2016-05-17	AAL	Stock	32.25	33.29	32.02	32.64	13303400.0
2016-05-17	AAMC-DELISTED	Stock	3.8912	4.1941	3.6265	3.7	126371.0
2016-05-17	AAME	Stock	3.45	3.53	3.31	3.35	6000.0
2016-05-17	AAMI	Stock	13.86	14.14	13.65	13.73	211300.0
2016-05-17	AAOI	Stock	9.29	9.555	9.17	9.23	379300.0
2016-05-17	AAON	Stock	18.8467	18.8467	18.0	18.16	321000.0
2016-05-17	AAP	Stock	146.93	146.93	143.31	144.08	1615500.0
2016-05-17	AAT	Stock	41.01	41.36	40.21	40.38	275100.0
2016-05-17	AAU-DELISTED	Stock	1.18	1.3	1.18	1.21	436000.0
2016-05-17	AAUAF-DELISTED	Stock	1.18	1.3	1.18	1.21	439712.0
2016-05-17	AAV-DELISTED	Stock	5.89	5.93	5.85	5.86	57716.0
2016-05-17	AAWW-DELISTED	Stock	43.55	43.9	42.39	42.645	391671.0
2016-05-17	AAXJ	Stock	51.9	52.05	51.57	51.71	434993.0
2016-05-17	AAXN-DELISTED	Stock	19.42	20.93	19.37	20.7	2378372.0
2016-05-17	AB	Stock	22.2	22.81	22.18	22.36	203300.0
2016-05-17	ABAC-DELISTED	Stock	0.6053	0.6399	0.5977	0.6075	14800.0
2016-05-17	ABAX-DELISTED	Stock	44.04	44.58	43.48	43.7	135116.0
2016-05-17	ABB-DELISTED	Stock	20.43	20.56	20.27	20.3	1662300.0
2016-05-17	ABBNY-DELISTED	Stock	20.43	20.56	20.27	20.32	1704261.0
2016-05-17	ABBV	Stock	62.44	62.79	58.5	60.25	31528900.0
2016-05-17	ABC-DELISTED	Stock	74.4	75.06	74.06	74.51	2714622.0
2016-05-17	ABCB	Stock	30.97	31.32	29.99	30.19	152600.0
2016-05-17	ABCD-DELISTED	Stock	4.27	4.27	4.05	4.11	26465.0
2016-05-17	ABCO-DELISTED	Stock	33.36	33.87	32.39	32.7	350950.0
2016-05-17	ABDC-DELISTED	Stock	11.9	12.08	11.69	11.98	24014.0
2016-05-17	ABE-DELISTED	Stock	11.78	11.821	11.715	11.715	3600.0
2016-05-17	ABEO	Stock	60.25	61.5	59.25	60.5	2632.0
2016-05-17	ABEV	Stock	5.26	5.3	5.21	5.27	11922200.0
2016-05-17	ABG	Stock	53.25	55.02	53.09	54.05	333400.0
2016-05-17	ABIL-DELISTED	Stock	3.14	3.15	2.9	2.96	50287.0
2016-05-17	ABM	Stock	33.0	33.23	32.67	32.89	384500.0
2016-05-17	ABMD-DELISTED	Stock	95.69	96.42	93.49	94.14	414992.0
2016-05-17	ABR	Stock	6.9	6.9	6.68	6.76	74300.0

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

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