PREVIEW / stock_daily / 2016-11-14

all stock daily files

  file:    by_date/stock_daily/2016/2016-11-14.parquet
  size:    215 KB
  rows:    6,538
  symbols: 3,168

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-14	AAPL	Stock	26.9275	26.9525	26.02	26.4275	204702000.0
2016-11-14	MSFT	Stock	59.02	59.08	57.28	58.12	41328400.0
2016-11-14	NVDA	Stock	2.2023	2.2048	2.0905	2.091	1348796000.0
2016-11-14	AMZN	Stock	37.2755	37.3	35.505	35.9535	146426000.0
2016-11-14	GOOGL	Stock	38.588	38.589	37.1795	37.661	73765480.0
2016-11-14	META	Stock	119.13	119.13	113.55	115.08	51377000.0
2016-11-14	TSLA	Stock	12.5333	12.55	11.8793	12.0967	98283000.0
2016-11-14	TLT	Stock	121.28	122.66	120.73	121.31	21174373.0
2016-11-14	ES	Stock	51.46	51.84	51.28	51.69	1553600.0
2016-11-14	CL	Stock	67.14	67.36	66.53	66.58	3894000.0
2016-11-14	A	Stock	46.66	46.73	45.18	45.33	3443200.0
2016-11-14	AA	Stock	29.5	29.94	28.61	29.62	5156700.0
2016-11-14	AAAP-DELISTED	Stock	36.28	36.52	36.01	36.48	40020.0
2016-11-14	AABA-DELISTED	Stock	40.36	40.39	38.87	39.3	11952752.0
2016-11-14	AAC-DELISTED	Stock	8.91	9.78	8.87	9.28	605077.0
2016-11-14	AACG	Stock	3.98	4.1	3.96	3.97	1000.0
2016-11-14	AAIC-DELISTED	Stock	15.37	16.04	15.3	15.74	655801.0
2016-11-14	AAL	Stock	43.01	43.61	42.98	43.4	7773600.0
2016-11-14	AAMC-DELISTED	Stock	10.7647	10.7647	8.7941	9.7059	73239.0
2016-11-14	AAME	Stock	3.69	3.7	3.66	3.7	1000.0
2016-11-14	AAMI	Stock	14.12	14.46	14.0	14.46	339800.0
2016-11-14	AAOI	Stock	25.22	25.5	24.47	24.6	547700.0
2016-11-14	AAON	Stock	21.5	22.0667	21.4667	22.0333	309450.0
2016-11-14	AAP	Stock	145.28	147.0	142.2	142.9	3409800.0
2016-11-14	AAT	Stock	39.83	41.1	39.45	41.01	318100.0
2016-11-14	AAU-DELISTED	Stock	1.13	1.2	1.12	1.18	427424.0
2016-11-14	AAUAF-DELISTED	Stock	1.13	1.2	1.12	1.18	429122.0
2016-11-14	AAV-DELISTED	Stock	6.5	6.75	6.5	6.65	64233.0
2016-11-14	AAWW-DELISTED	Stock	48.35	50.5	45.68	50.5	342975.0
2016-11-14	AAXJ	Stock	55.29	55.63	54.97	55.29	2079838.0
2016-11-14	AAXN-DELISTED	Stock	27.24	27.91	27.18	27.51	1071451.0
2016-11-14	AB	Stock	23.25	24.0	23.15	23.85	528600.0
2016-11-14	ABAC-DELISTED	Stock	2.85	2.9398	2.85	2.86	3315.0
2016-11-14	ABAX-DELISTED	Stock	52.18	53.12	51.73	52.44	124744.0
2016-11-14	ABB-DELISTED	Stock	21.08	21.18	21.02	21.16	1859725.0
2016-11-14	ABBNY-DELISTED	Stock	21.07	21.18	21.02	21.16	1901540.0
2016-11-14	ABBV	Stock	63.4	63.64	62.25	62.97	8315700.0
2016-11-14	ABC-DELISTED	Stock	81.64	82.58	79.38	81.33	3899577.0
2016-11-14	ABCB	Stock	43.5	43.9	42.35	42.55	389800.0
2016-11-14	ABCD-DELISTED	Stock	5.0	5.02	4.87	5.02	39729.0
2016-11-14	ABCO-DELISTED	Stock	33.3	33.9	32.6	32.85	795876.0
2016-11-14	ABDC-DELISTED	Stock	12.29	12.56	11.68	11.77	64573.0
2016-11-14	ABE-DELISTED	Stock	11.38	11.48	11.04	11.2203	13982.0
2016-11-14	ABEO	Stock	163.75	185.0	162.5	185.0	39996.0
2016-11-14	ABEOW-DELISTED	Stock	3.45	3.75	3.45	3.6314	10229.0
2016-11-14	ABEV	Stock	5.0	5.05	4.96	5.01	37705000.0
2016-11-14	ABG	Stock	55.0	58.8	54.55	57.95	366500.0
2016-11-14	ABIL-DELISTED	Stock	2.98	3.0	2.925	2.95	9768.0
2016-11-14	ABM	Stock	42.06	43.0	41.78	42.93	450200.0
2016-11-14	ABMD-DELISTED	Stock	111.08	111.9	108.81	110.01	648275.0

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

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