PREVIEW / stock_daily / 2016-07-07

all stock daily files

  file:    by_date/stock_daily/2016/2016-07-07.parquet
  size:    218 KB
  rows:    6,527
  symbols: 3,246

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-07	AAPL	Stock	23.925	24.125	23.905	23.985	100558400.0
2016-07-07	MSFT	Stock	51.42	51.61	51.07	51.38	19585200.0
2016-07-07	NVDA	Stock	1.1992	1.2265	1.1938	1.2222	395400000.0
2016-07-07	AMZN	Stock	36.9665	36.9775	36.5815	36.8285	58916000.0
2016-07-07	GOOGL	Stock	35.5055	35.5085	35.0335	35.363	21173960.0
2016-07-07	META	Stock	116.63	116.97	115.36	115.85	16630200.0
2016-07-07	TSLA	Stock	14.2067	14.5413	14.2007	14.396	54180000.0
2016-07-07	TLT	Stock	142.09	143.19	141.78	142.55	9676415.0
2016-07-07	ES	Stock	60.18	60.23	59.08	59.35	1856300.0
2016-07-07	CL	Stock	73.28	73.71	73.08	73.4	2782200.0
2016-07-07	A	Stock	44.47	44.74	44.18	44.42	1860700.0
2016-07-07	AA.B-DELISTED	Stock	32.9548	33.5	32.8232	33.12	10283.0
2016-07-07	AAAP-DELISTED	Stock	30.25	30.75	30.21	30.72	74796.0
2016-07-07	AABA-DELISTED	Stock	37.57	37.76	37.29	37.53	7195731.0
2016-07-07	AAC-DELISTED	Stock	22.41	22.87	22.31	22.77	29296.0
2016-07-07	AACG	Stock	4.4	4.54	4.35	4.46	7500.0
2016-07-07	AAIC-DELISTED	Stock	12.76	13.01	12.67	12.78	172728.0
2016-07-07	AAL	Stock	28.39	29.47	28.31	29.4	11779800.0
2016-07-07	AAMC-DELISTED	Stock	4.0294	4.2555	3.8853	3.9706	79781.0
2016-07-07	AAME	Stock	4.15	4.15	4.15	4.15	500.0
2016-07-07	AAMI	Stock	12.87	13.09	12.69	12.86	140400.0
2016-07-07	AAOI	Stock	10.82	11.2	10.82	11.1	177600.0
2016-07-07	AAON	Stock	18.02	18.1333	17.8267	17.8933	177300.0
2016-07-07	AAP	Stock	161.54	162.61	160.05	161.13	672400.0
2016-07-07	AAT	Stock	43.24	43.24	42.17	42.87	234800.0
2016-07-07	AAU-DELISTED	Stock	1.53	1.6	1.47	1.515	535501.0
2016-07-07	AAUAF-DELISTED	Stock	1.53	1.6	1.47	1.53	560010.0
2016-07-07	AAV-DELISTED	Stock	5.92	6.04	5.75	5.8	154957.0
2016-07-07	AAWW-DELISTED	Stock	39.9	40.9	39.48	39.9	115597.0
2016-07-07	AAXJ	Stock	54.35	54.5999	54.03	54.21	495304.0
2016-07-07	AAXN-DELISTED	Stock	25.09	25.8483	25.09	25.775	914485.0
2016-07-07	AB	Stock	22.96	23.26	22.75	22.96	126000.0
2016-07-07	ABAC-DELISTED	Stock	0.82	0.82	0.8111	0.8167	1600.0
2016-07-07	ABAX-DELISTED	Stock	48.64	49.0	48.25	48.43	64745.0
2016-07-07	ABB-DELISTED	Stock	19.44	19.55	19.29	19.37	1577047.0
2016-07-07	ABBNY-DELISTED	Stock	19.44	19.55	19.29	19.37	1740142.0
2016-07-07	ABBV	Stock	63.6	63.75	63.21	63.43	7081900.0
2016-07-07	ABC-DELISTED	Stock	81.09	81.53	80.53	80.99	1612550.0
2016-07-07	ABCB	Stock	29.13	29.41	29.0	29.19	94300.0
2016-07-07	ABCD-DELISTED	Stock	4.56	4.58	4.53	4.56	10109.0
2016-07-07	ABCO-DELISTED	Stock	35.72	36.4	35.01	35.9	278887.0
2016-07-07	ABDC-DELISTED	Stock	12.24	12.24	12.2	12.23	62945.0
2016-07-07	ABE-DELISTED	Stock	12.2456	12.2456	12.23	12.23	2099.0
2016-07-07	ABEO	Stock	58.5	61.0	58.0	58.0	796.0
2016-07-07	ABEV	Stock	5.75	5.76	5.66	5.67	10352900.0
2016-07-07	ABG	Stock	51.92	53.54	51.07	51.59	411000.0
2016-07-07	ABIL-DELISTED	Stock	3.83	4.23	3.83	4.09	66284.0
2016-07-07	ABM	Stock	36.35	36.52	36.05	36.27	139300.0
2016-07-07	ABMD-DELISTED	Stock	111.96	114.5	111.14	113.54	522635.0
2016-07-07	ABR	Stock	7.06	7.12	7.03	7.04	38700.0

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

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