PREVIEW / stock_daily / 2016-08-26

all stock daily files

  file:    by_date/stock_daily/2016/2016-08-26.parquet
  size:    220 KB
  rows:    6,542
  symbols: 3,230

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-08-26	AAPL	Stock	26.8525	26.9875	26.5775	26.735	111065200.0
2016-08-26	MSFT	Stock	58.28	58.7	57.69	58.03	20971200.0
2016-08-26	NVDA	Stock	1.5423	1.5595	1.53	1.5508	300024000.0
2016-08-26	AMZN	Stock	38.0025	38.5	37.99	38.45	55536000.0
2016-08-26	GOOGL	Stock	39.6245	39.97	39.4703	39.661	24977620.0
2016-08-26	META	Stock	124.05	125.19	123.91	124.96	17504800.0
2016-08-26	TSLA	Stock	14.8093	14.8573	14.588	14.666	33585000.0
2016-08-26	TLT	Stock	139.73	140.69	138.22	138.36	12962524.0
2016-08-26	ES	Stock	55.42	55.77	54.06	54.12	1401700.0
2016-08-26	CL	Stock	74.64	75.35	74.21	74.47	2040000.0
2016-08-26	A	Stock	47.41	47.79	47.07	47.32	1581200.0
2016-08-26	AA.B-DELISTED	Stock	34.6	34.9899	34.39	34.5	28858.0
2016-08-26	AAAP-DELISTED	Stock	33.0	34.06	32.321	33.19	40393.0
2016-08-26	AABA-DELISTED	Stock	42.15	42.61	41.94	42.28	5970726.0
2016-08-26	AAC-DELISTED	Stock	18.73	19.1504	18.21	18.5	116061.0
2016-08-26	AACG	Stock	4.04	4.5	4.04	4.46	3200.0
2016-08-26	AAIC-DELISTED	Stock	14.8	14.8	14.48	14.58	131790.0
2016-08-26	AAL	Stock	36.68	36.84	36.02	36.23	6257700.0
2016-08-26	AAMC-DELISTED	Stock	3.7529	3.9088	3.6824	3.7647	83626.0
2016-08-26	AAME	Stock	3.63	3.63	3.12	3.54	16700.0
2016-08-26	AAMI	Stock	13.42	13.47	13.2	13.34	97600.0
2016-08-26	AAOI	Stock	16.0	16.42	15.59	16.37	609500.0
2016-08-26	AAON	Stock	18.6333	18.72	18.3333	18.4533	69150.0
2016-08-26	AAP	Stock	159.69	160.62	156.2	156.83	958600.0
2016-08-26	AAT	Stock	44.57	44.88	43.77	44.2	113000.0
2016-08-26	AAU-DELISTED	Stock	1.42	1.49	1.36	1.36	424898.0
2016-08-26	AAUAF-DELISTED	Stock	1.42	1.49	1.36	1.36	427515.0
2016-08-26	AAV-DELISTED	Stock	7.07	7.22	7.06	7.07	144239.0
2016-08-26	AAWW-DELISTED	Stock	36.22	38.36	35.58	36.33	620369.0
2016-08-26	AAXJ	Stock	59.18	59.74	58.38	58.75	1832883.0
2016-08-26	AAXN-DELISTED	Stock	28.67	28.84	28.42	28.51	460364.0
2016-08-26	AB	Stock	21.96	22.13	21.78	21.9	285200.0
2016-08-26	ABAC-DELISTED	Stock	0.835	0.835	0.777	0.799	62042.0
2016-08-26	ABAX-DELISTED	Stock	49.63	50.48	49.501	50.39	45380.0
2016-08-26	ABB-DELISTED	Stock	22.03	22.26	21.76	21.85	1397556.0
2016-08-26	ABBNY-DELISTED	Stock	22.03	22.26	21.76	21.84	1455403.0
2016-08-26	ABBV	Stock	64.68	65.02	64.21	64.61	7041600.0
2016-08-26	ABC-DELISTED	Stock	85.67	86.565	85.15	85.77	1600478.0
2016-08-26	ABCB	Stock	33.95	34.32	33.8	34.01	91000.0
2016-08-26	ABCD-DELISTED	Stock	4.59	4.64	4.59	4.63	2332.0
2016-08-26	ABCO-DELISTED	Stock	42.1	42.64	41.465	42.07	164676.0
2016-08-26	ABDC-DELISTED	Stock	12.58	12.6	12.45	12.5	44592.0
2016-08-26	ABE-DELISTED	Stock	12.71	12.76	12.56	12.56	7156.0
2016-08-26	ABEO	Stock	108.25	109.25	104.0	107.75	1588.0
2016-08-26	ABEOW-DELISTED	Stock	2.1057	2.1057	2.1057	2.1057	100.0
2016-08-26	ABEV	Stock	5.99	6.06	5.84	5.86	24226500.0
2016-08-26	ABG	Stock	53.21	54.28	52.61	52.85	259400.0
2016-08-26	ABIL-DELISTED	Stock	4.2	4.5	4.125	4.33	104205.0
2016-08-26	ABM	Stock	38.21	38.54	37.77	38.03	163900.0
2016-08-26	ABMD-DELISTED	Stock	117.28	118.99	116.36	118.69	213926.0

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

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