PREVIEW / stock_daily / 2016-10-14

all stock daily files

  file:    by_date/stock_daily/2016/2016-10-14.parquet
  size:    217 KB
  rows:    6,494
  symbols: 3,169

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-10-14	AAPL	Stock	29.47	29.5425	29.2825	29.4075	142608800.0
2016-10-14	MSFT	Stock	57.12	57.74	57.12	57.42	27402500.0
2016-10-14	NVDA	Stock	1.6538	1.665	1.64	1.6498	330636000.0
2016-10-14	AMZN	Stock	41.754	41.787	41.148	41.148	59996000.0
2016-10-14	GOOGL	Stock	40.3725	40.5045	40.116	40.23	22238680.0
2016-10-14	META	Stock	128.49	128.95	127.58	127.88	13345300.0
2016-10-14	TSLA	Stock	13.3773	13.4287	13.0867	13.1007	64048500.0
2016-10-14	TLT	Stock	132.27	132.95	131.53	131.59	11415109.0
2016-10-14	ES	Stock	53.07	53.81	52.95	53.18	1412900.0
2016-10-14	CL	Stock	72.4	72.9	72.16	72.31	2875000.0
2016-10-14	A	Stock	45.38	45.62	45.08	45.08	997100.0
2016-10-14	AA.B-DELISTED	Stock	29.74	29.74	28.96	29.21	111580.0
2016-10-14	AAAP-DELISTED	Stock	38.1	38.69	38.09	38.23	30326.0
2016-10-14	AABA-DELISTED	Stock	42.06	42.25	41.405	41.44	7406581.0
2016-10-14	AAC-DELISTED	Stock	17.34	17.34	17.0	17.12	84680.0
2016-10-14	AACG	Stock	4.15	4.15	3.73	3.78	8400.0
2016-10-14	AAIC-DELISTED	Stock	14.44	14.49	14.26	14.32	143766.0
2016-10-14	AAL	Stock	39.45	39.92	38.59	38.65	8871200.0
2016-10-14	AAMC-DELISTED	Stock	11.6882	12.2971	9.1794	10.2941	539923.0
2016-10-14	AAME	Stock	3.77	3.78	3.76	3.78	1100.0
2016-10-14	AAMI	Stock	13.99	14.06	13.8	13.92	184000.0
2016-10-14	AAOI	Stock	20.4	21.22	20.17	20.29	207100.0
2016-10-14	AAON	Stock	19.6667	19.8	19.5	19.5667	103050.0
2016-10-14	AAP	Stock	147.58	148.56	146.3	146.64	564500.0
2016-10-14	AAT	Stock	40.87	41.05	40.69	40.76	121900.0
2016-10-14	AAU-DELISTED	Stock	1.24	1.26	1.2	1.22	161198.0
2016-10-14	AAUAF-DELISTED	Stock	1.24	1.26	1.2	1.22	162941.0
2016-10-14	AAV-DELISTED	Stock	7.6	7.82	7.55	7.74	328949.0
2016-10-14	AAWW-DELISTED	Stock	41.75	42.37	41.2	41.27	85118.0
2016-10-14	AAXJ	Stock	59.6	59.635	59.0999	59.13	1249119.0
2016-10-14	AAXN-DELISTED	Stock	22.65	23.2799	22.33	22.74	1775574.0
2016-10-14	AB	Stock	22.0	22.2	21.75	21.95	140800.0
2016-10-14	ABAC-DELISTED	Stock	2.13	2.17	2.1	2.1	6012.0
2016-10-14	ABAX-DELISTED	Stock	52.82	52.82	51.94	51.99	50917.0
2016-10-14	ABB-DELISTED	Stock	22.41	22.495	22.33	22.34	1064553.0
2016-10-14	ABBNY-DELISTED	Stock	22.41	22.495	22.33	22.34	1110586.0
2016-10-14	ABBV	Stock	61.45	61.52	60.15	60.17	5606500.0
2016-10-14	ABC-DELISTED	Stock	80.49	80.88	79.79	79.8	1093039.0
2016-10-14	ABCB	Stock	35.43	35.87	35.36	35.78	161600.0
2016-10-14	ABCD-DELISTED	Stock	5.3	5.31	5.26	5.28	12579.0
2016-10-14	ABCO-DELISTED	Stock	43.54	44.04	43.18	43.49	115079.0
2016-10-14	ABDC-DELISTED	Stock	12.85	12.939	12.7585	12.8	29929.0
2016-10-14	ABE-DELISTED	Stock	12.3	12.39	12.29	12.39	23254.0
2016-10-14	ABEO	Stock	169.5	178.0	167.75	168.5	16924.0
2016-10-14	ABEOW-DELISTED	Stock	3.95	3.95	3.95	3.95	100.0
2016-10-14	ABEV	Stock	6.04	6.11	6.03	6.09	14556900.0
2016-10-14	ABG	Stock	55.95	55.95	54.5	55.4	122200.0
2016-10-14	ABM	Stock	38.08	38.47	37.79	37.82	202100.0
2016-10-14	ABMD-DELISTED	Stock	128.01	128.5	126.61	127.06	170222.0
2016-10-14	ABR	Stock	7.42	7.42	7.28	7.36	59900.0

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

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