PREVIEW / stock_daily / 2016-11-29

all stock daily files

  file:    by_date/stock_daily/2016/2016-11-29.parquet
  size:    215 KB
  rows:    6,523
  symbols: 3,166

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-29	AAPL	Stock	27.695	28.0075	27.5175	27.865	114115200.0
2016-11-29	MSFT	Stock	60.65	61.41	60.52	61.09	22366700.0
2016-11-29	NVDA	Stock	2.35	2.361	2.3132	2.3313	444568000.0
2016-11-29	AMZN	Stock	38.4	38.4945	38.066	38.126	65446000.0
2016-11-29	GOOGL	Stock	39.419	39.822	39.267	39.472	31239620.0
2016-11-29	META	Stock	120.57	122.1	120.4	120.87	18891000.0
2016-11-29	TSLA	Stock	13.0373	13.1153	12.6333	12.638	66589500.0
2016-11-29	TLT	Stock	121.44	122.4	121.21	122.22	8363000.0
2016-11-29	ES	Stock	53.71	54.32	53.63	53.75	1927800.0
2016-11-29	CL	Stock	66.65	66.75	66.26	66.53	2674100.0
2016-11-29	A	Stock	43.6	44.63	43.52	44.48	1951900.0
2016-11-29	AA	Stock	30.02	30.5	29.73	29.73	4928200.0
2016-11-29	AAAP-DELISTED	Stock	29.06	30.89	28.1414	29.25	206432.0
2016-11-29	AABA-DELISTED	Stock	41.43	41.83	41.12	41.6	7495083.0
2016-11-29	AAC-DELISTED	Stock	8.68	8.92	8.61	8.7	122749.0
2016-11-29	AACG	Stock	4.08	4.13	4.08	4.08	600.0
2016-11-29	AAIC-DELISTED	Stock	16.56	16.69	16.4353	16.64	188833.0
2016-11-29	AAL	Stock	46.59	47.14	46.17	46.89	4885400.0
2016-11-29	AAMC-DELISTED	Stock	8.7353	8.7353	8.5	8.5	21131.0
2016-11-29	AAME	Stock	4.0	4.0	3.75	3.75	800.0
2016-11-29	AAMI	Stock	14.6	14.63	14.468	14.55	87700.0
2016-11-29	AAOI	Stock	25.07	25.41	24.95	25.04	301400.0
2016-11-29	AAON	Stock	22.3333	22.3333	21.3333	22.1333	222900.0
2016-11-29	AAP	Stock	172.34	173.49	169.7	169.8	639600.0
2016-11-29	AAT	Stock	40.58	40.93	40.47	40.67	179100.0
2016-11-29	AAU-DELISTED	Stock	1.07	1.11	1.04	1.11	183568.0
2016-11-29	AAUAF-DELISTED	Stock	1.07	1.11	1.04	1.11	184531.0
2016-11-29	AAV-DELISTED	Stock	6.8	6.95	6.7	6.75	91975.0
2016-11-29	AAWW-DELISTED	Stock	50.2	50.7	49.6	49.95	196253.0
2016-11-29	AAXJ	Stock	56.65	57.04	56.59	56.91	335216.0
2016-11-29	AAXN-DELISTED	Stock	27.7	28.0	27.54	27.54	311967.0
2016-11-29	AB	Stock	23.25	23.45	22.55	22.7	288100.0
2016-11-29	ABAC-DELISTED	Stock	3.11	3.28	3.02	3.21	11617.0
2016-11-29	ABAX-DELISTED	Stock	52.0	52.685	51.385	52.18	58551.0
2016-11-29	ABB-DELISTED	Stock	20.28	20.475	20.26	20.38	855412.0
2016-11-29	ABBNY-DELISTED	Stock	20.28	20.475	20.26	20.38	889060.0
2016-11-29	ABBV	Stock	59.7	62.1	59.52	61.59	11858800.0
2016-11-29	ABC-DELISTED	Stock	78.65	79.36	77.53	77.6	1983198.0
2016-11-29	ABCB	Stock	43.85	44.7	43.75	44.5	122400.0
2016-11-29	ABCD-DELISTED	Stock	4.99	5.13	4.96	5.03	63534.0
2016-11-29	ABCO-DELISTED	Stock	36.85	37.25	36.25	36.6	215604.0
2016-11-29	ABDC-DELISTED	Stock	12.27	12.58	11.86	12.01	69702.0
2016-11-29	ABE-DELISTED	Stock	11.2158	11.33	11.21	11.27	9378.0
2016-11-29	ABEO	Stock	172.5	172.5	160.0	163.75	13152.0
2016-11-29	ABEOW-DELISTED	Stock	3.3	3.32	3.25	3.29	5400.0
2016-11-29	ABEV	Stock	5.05	5.08	4.95	4.99	39724300.0
2016-11-29	ABG	Stock	59.35	60.25	58.4	58.7	166800.0
2016-11-29	ABIL-DELISTED	Stock	3.46	3.54	3.36	3.53	27810.0
2016-11-29	ABM	Stock	44.39	44.94	44.38	44.78	292500.0
2016-11-29	ABMD-DELISTED	Stock	112.47	113.23	111.47	112.08	238582.0

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

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