PREVIEW / stock_daily / 2016-10-24

all stock daily files

  file:    by_date/stock_daily/2016/2016-10-24.parquet
  size:    215 KB
  rows:    6,522
  symbols: 3,190

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-24	AAPL	Stock	29.275	29.435	29.25	29.4125	94154800.0
2016-10-24	MSFT	Stock	59.94	61.0	59.93	61.0	54067000.0
2016-10-24	NVDA	Stock	1.7	1.7698	1.6998	1.7678	339836000.0
2016-10-24	AMZN	Stock	41.2475	41.915	41.1105	41.9045	81218000.0
2016-10-24	GOOGL	Stock	41.5045	41.897	41.452	41.787	28952320.0
2016-10-24	META	Stock	132.72	133.41	132.15	133.28	17470200.0
2016-10-24	TSLA	Stock	13.4	13.5967	13.35	13.5173	41274000.0
2016-10-24	TLT	Stock	133.41	133.45	132.29	132.73	6507489.0
2016-10-24	ES	Stock	54.19	54.41	53.74	54.13	1008700.0
2016-10-24	CL	Stock	71.0	71.36	70.86	71.03	2408600.0
2016-10-24	A	Stock	45.88	45.95	45.64	45.85	1666400.0
2016-10-24	AA	Stock	21.635	21.6671	21.4348	21.5149	7109988.0
2016-10-24	AA.B-DELISTED	Stock	29.8	29.8	29.41	29.57	31304.0
2016-10-24	AAAP-DELISTED	Stock	38.35	38.71	38.08	38.6	65958.0
2016-10-24	AABA-DELISTED	Stock	42.5	42.68	42.38	42.59	4103823.0
2016-10-24	AAC-DELISTED	Stock	19.76	19.98	16.78	17.48	664387.0
2016-10-24	AACG	Stock	3.9	3.9	3.66	3.66	8600.0
2016-10-24	AAIC-DELISTED	Stock	14.71	14.89	14.62	14.87	186237.0
2016-10-24	AAL	Stock	40.25	40.55	39.77	39.83	6466300.0
2016-10-24	AAMC-DELISTED	Stock	11.1765	11.5221	10.7353	11.0441	65559.0
2016-10-24	AAME	Stock	4.15	4.15	3.91	4.15	6800.0
2016-10-24	AAMI	Stock	14.54	14.584	14.37	14.44	89700.0
2016-10-24	AAOI	Stock	20.72	21.61	20.662	21.59	216200.0
2016-10-24	AAON	Stock	19.8333	20.0667	19.5	19.8667	183150.0
2016-10-24	AAP	Stock	142.92	143.54	140.64	141.1	1012800.0
2016-10-24	AAT	Stock	40.33	40.82	40.16	40.43	137400.0
2016-10-24	AAU-DELISTED	Stock	1.2347	1.28	1.21	1.2299	115912.0
2016-10-24	AAUAF-DELISTED	Stock	1.2347	1.28	1.21	1.21	116576.0
2016-10-24	AAV-DELISTED	Stock	7.45	7.58	7.2	7.32	108256.0
2016-10-24	AAWW-DELISTED	Stock	43.05	43.05	42.55	42.9	90723.0
2016-10-24	AAXJ	Stock	60.24	60.385	60.06	60.23	678738.0
2016-10-24	AAXN-DELISTED	Stock	23.28	23.62	23.27	23.54	346401.0
2016-10-24	AB	Stock	22.0	22.25	21.7	21.9	174500.0
2016-10-24	ABAC-DELISTED	Stock	2.3	2.3	2.27	2.27	8948.0
2016-10-24	ABAX-DELISTED	Stock	52.95	53.09	52.21	52.96	176488.0
2016-10-24	ABB-DELISTED	Stock	22.32	22.39	22.21	22.29	1230553.0
2016-10-24	ABBNY-DELISTED	Stock	22.32	22.39	22.21	22.29	1274787.0
2016-10-24	ABBV	Stock	61.13	61.68	61.02	61.12	3934800.0
2016-10-24	ABC-DELISTED	Stock	80.34	80.88	79.94	80.02	1146142.0
2016-10-24	ABCB	Stock	36.15	36.65	36.0	36.2	206700.0
2016-10-24	ABCD-DELISTED	Stock	5.15	5.17	5.02	5.09	18743.0
2016-10-24	ABCO-DELISTED	Stock	42.72	43.21	42.32	42.52	109481.0
2016-10-24	ABDC-DELISTED	Stock	12.94	13.0	12.81	12.96	31948.0
2016-10-24	ABE-DELISTED	Stock	12.46	12.5007	12.46	12.5	1430.0
2016-10-24	ABEO	Stock	207.5	220.0	201.25	205.0	12024.0
2016-10-24	ABEOW-DELISTED	Stock	4.5	4.72	4.36	4.38	49808.0
2016-10-24	ABEV	Stock	6.32	6.34	6.26	6.26	8965200.0
2016-10-24	ABG	Stock	53.4	54.6	53.05	53.9	165100.0
2016-10-24	ABIL-DELISTED	Stock	3.6238	3.6299	3.59	3.59	2100.0
2016-10-24	ABM	Stock	38.24	38.74	38.24	38.74	198500.0

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

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