PREVIEW / stock_daily / 2017-10-19

all stock daily files

  file:    by_date/stock_daily/2017/2017-10-19.parquet
  size:    214 KB
  rows:    6,422
  symbols: 2,890

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
2017-10-19	AAPL	Stock	39.1875	39.27	38.755	38.995	170336800.0
2017-10-19	MSFT	Stock	77.57	77.93	77.35	77.91	15092800.0
2017-10-19	NVDA	Stock	4.861	4.95	4.8112	4.945	570772000.0
2017-10-19	AMZN	Stock	49.5	49.5525	49.012	49.3305	62164000.0
2017-10-19	GOOGL	Stock	50.2375	50.3661	49.865	50.092	34284860.0
2017-10-19	META	Stock	174.93	176.03	172.63	174.56	14048400.0
2017-10-19	TSLA	Stock	23.704	23.81	23.2133	23.454	75927000.0
2017-10-19	TLT	Stock	125.74	126.01	125.27	125.31	8966467.0
2017-10-19	ES	Stock	61.56	62.06	61.43	62.06	1630200.0
2017-10-19	CL	Stock	73.84	74.0	72.98	73.14	4369200.0
2017-10-19	A	Stock	66.44	66.97	66.06	66.88	1359100.0
2017-10-19	AA	Stock	46.5	47.74	46.01	46.54	6033100.0
2017-10-19	AAAP-DELISTED	Stock	70.94	73.0	70.01	72.57	245058.0
2017-10-19	AABA-DELISTED	Stock	66.97	67.54	66.65	67.44	2371166.0
2017-10-19	AAC-DELISTED	Stock	8.22	8.35	8.135	8.25	51098.0
2017-10-19	AACG	Stock	4.74	4.74	4.74	4.74	200.0
2017-10-19	AAIC-DELISTED	Stock	12.68	12.72	12.63	12.71	247254.0
2017-10-19	AAL	Stock	51.57	51.83	49.63	51.51	7568200.0
2017-10-19	AAM.A-DELISTED	Stock	26.0824	26.23	26.0623	26.23	33708.0
2017-10-19	AAMC-DELISTED	Stock	25.0735	25.0735	24.6765	25.0735	2156.0
2017-10-19	AAME	Stock	3.25	3.25	3.25	3.25	800.0
2017-10-19	AAMI	Stock	15.21	15.3	15.1	15.3	369300.0
2017-10-19	AAOI	Stock	41.64	42.83	41.05	42.17	1826300.0
2017-10-19	AAON	Stock	22.7	22.8467	22.5333	22.8	145050.0
2017-10-19	AAP	Stock	86.24	87.96	85.34	86.92	2400900.0
2017-10-19	AAT	Stock	40.2	40.31	39.79	39.87	152800.0
2017-10-19	AAU-DELISTED	Stock	1.15	1.15	1.13	1.1367	71569.0
2017-10-19	AAUAF-DELISTED	Stock	1.15	1.15	1.13	1.14	74890.0
2017-10-19	AAV-DELISTED	Stock	5.45	5.55	5.35	5.525	44238.0
2017-10-19	AAWW-DELISTED	Stock	61.95	63.05	60.7	63.0	187279.0
2017-10-19	AAXJ	Stock	74.47	74.52	74.16	74.5	1218964.0
2017-10-19	AAXN-DELISTED	Stock	24.78	24.919	24.42	24.62	535399.0
2017-10-19	AB	Stock	25.15	25.2	24.85	25.1	128200.0
2017-10-19	ABAC-DELISTED	Stock	3.43	3.52	3.43	3.43	1832.0
2017-10-19	ABAX-DELISTED	Stock	46.89	47.0	46.53	46.79	89578.0
2017-10-19	ABB-DELISTED	Stock	25.25	25.428	25.24	25.36	1391842.0
2017-10-19	ABBNY-DELISTED	Stock	25.25	25.428	25.24	25.37	1531772.0
2017-10-19	ABBV	Stock	95.5	96.62	94.51	96.48	9303700.0
2017-10-19	ABC-DELISTED	Stock	80.82	82.55	80.735	82.19	1223773.0
2017-10-19	ABCB	Stock	47.45	48.8	47.45	48.1	257300.0
2017-10-19	ABCD-DELISTED	Stock	6.2	6.22	6.11	6.17	8596.0
2017-10-19	ABCO-DELISTED	Stock	53.75	53.95	53.7	53.95	450113.0
2017-10-19	ABDC-DELISTED	Stock	10.15	10.23	10.02	10.02	46724.0
2017-10-19	ABEO	Stock	433.75	447.5	430.0	443.75	41992.0
2017-10-19	ABEOW-DELISTED	Stock	12.27	12.74	12.25	12.67	26100.0
2017-10-19	ABEV	Stock	6.75	6.84	6.72	6.82	11177400.0
2017-10-19	ABG	Stock	57.0	57.0	54.9	55.05	199000.0
2017-10-19	ABIL-DELISTED	Stock	0.7161	0.7295	0.709	0.72	55568.0
2017-10-19	ABM	Stock	42.47	42.69	42.24	42.52	161200.0
2017-10-19	ABMD-DELISTED	Stock	173.0	173.37	170.57	172.21	176135.0

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

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