PREVIEW / stock_daily / 2016-11-08

all stock daily files

  file:    by_date/stock_daily/2016/2016-11-08.parquet
  size:    212 KB
  rows:    6,461
  symbols: 3,137

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-11-08	AAPL	Stock	27.5775	27.93	27.425	27.765	97016800.0
2016-11-08	MSFT	Stock	60.55	60.78	60.15	60.47	22935400.0
2016-11-08	NVDA	Stock	1.7885	1.7942	1.7625	1.779	429884000.0
2016-11-08	AMZN	Stock	39.2485	39.587	38.955	39.3875	68252000.0
2016-11-08	GOOGL	Stock	40.1015	40.802	39.981	40.599	35381380.0
2016-11-08	META	Stock	122.03	124.61	121.54	124.22	19460800.0
2016-11-08	TSLA	Stock	12.9193	13.166	12.7507	12.996	49014000.0
2016-11-08	TLT	Stock	131.02	131.21	129.71	130.09	7576518.0
2016-11-08	ES	Stock	54.47	55.33	54.44	55.03	1901500.0
2016-11-08	CL	Stock	70.51	71.73	70.36	71.59	4051400.0
2016-11-08	A	Stock	45.48	45.96	45.32	45.62	2136700.0
2016-11-08	AA	Stock	24.3	26.59	24.3	26.4	6471300.0
2016-11-08	AAAP-DELISTED	Stock	35.94	36.88	35.8	36.57	69329.0
2016-11-08	AABA-DELISTED	Stock	40.97	41.28	40.68	41.16	3880503.0
2016-11-08	AAC-DELISTED	Stock	7.59	7.63	6.97	6.99	787246.0
2016-11-08	AACG	Stock	3.7	3.75	3.5	3.65	23300.0
2016-11-08	AAIC-DELISTED	Stock	14.58	14.71	14.48	14.57	140326.0
2016-11-08	AAL	Stock	41.42	41.85	41.02	41.7	5725800.0
2016-11-08	AAMC-DELISTED	Stock	10.25	10.2647	9.7661	10.0441	38437.0
2016-11-08	AAME	Stock	3.85	3.97	3.85	3.9	1100.0
2016-11-08	AAMI	Stock	12.1	12.28	12.1	12.22	136000.0
2016-11-08	AAOI	Stock	23.18	23.37	22.01	22.76	706500.0
2016-11-08	AAON	Stock	18.8333	19.1333	18.72	18.9	121050.0
2016-11-08	AAP	Stock	137.45	139.0	136.1	137.67	921000.0
2016-11-08	AAT	Stock	39.56	40.04	39.55	39.86	153400.0
2016-11-08	AAU-DELISTED	Stock	1.37	1.39	1.32	1.35	156697.0
2016-11-08	AAUAF-DELISTED	Stock	1.37	1.39	1.32	1.32	157593.0
2016-11-08	AAV-DELISTED	Stock	6.6	6.695	6.55	6.55	67289.0
2016-11-08	AAWW-DELISTED	Stock	44.65	45.2	41.51	44.75	151574.0
2016-11-08	AAXJ	Stock	58.8	59.64	58.77	59.39	602515.0
2016-11-08	AAXN-DELISTED	Stock	22.21	22.49	21.93	22.49	868716.0
2016-11-08	AB	Stock	21.0	21.15	20.85	20.9	241600.0
2016-11-08	ABAC-DELISTED	Stock	2.7	2.97	2.69	2.75	6597.0
2016-11-08	ABAX-DELISTED	Stock	47.81	48.7	45.76	48.27	56994.0
2016-11-08	ABB-DELISTED	Stock	20.65	20.92	20.65	20.9	1818443.0
2016-11-08	ABBNY-DELISTED	Stock	20.65	20.92	20.65	20.9	1856709.0
2016-11-08	ABBV	Stock	58.8	59.61	58.03	58.81	9353200.0
2016-11-08	ABC-DELISTED	Stock	71.03	71.16	68.705	69.04	4220237.0
2016-11-08	ABCB	Stock	36.75	37.05	36.7	36.85	103200.0
2016-11-08	ABCD-DELISTED	Stock	5.3	5.35	5.08	5.12	7461.0
2016-11-08	ABCO-DELISTED	Stock	34.7	35.4	34.35	35.3	564072.0
2016-11-08	ABDC-DELISTED	Stock	12.21	12.25	11.95	11.97	46070.0
2016-11-08	ABE-DELISTED	Stock	12.04	12.22	12.04	12.0913	7439.0
2016-11-08	ABEO	Stock	137.5	147.5	131.25	132.5	13924.0
2016-11-08	ABEOW-DELISTED	Stock	2.45	2.63	2.3	2.53	6600.0
2016-11-08	ABEV	Stock	5.56	5.68	5.5	5.66	17250800.0
2016-11-08	ABG	Stock	50.25	50.45	48.55	49.85	193300.0
2016-11-08	ABIL-DELISTED	Stock	2.94	3.0899	2.94	2.989	13913.0
2016-11-08	ABM	Stock	38.96	39.54	38.96	39.38	157600.0
2016-11-08	ABMD-DELISTED	Stock	106.47	108.64	105.7	107.9	288649.0

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

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