PREVIEW / stock_daily / 2017-10-23

all stock daily files

  file:    by_date/stock_daily/2017/2017-10-23.parquet
  size:    214 KB
  rows:    6,441
  symbols: 2,901

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-23	AAPL	Stock	39.2225	39.4225	38.875	39.0425	87937200.0
2017-10-23	MSFT	Stock	78.99	79.34	78.76	78.83	20627200.0
2017-10-23	NVDA	Stock	4.9445	4.9713	4.895	4.9155	428696000.0
2017-10-23	AMZN	Stock	49.3365	49.339	48.125	48.315	69882000.0
2017-10-23	GOOGL	Stock	50.259	50.2897	49.155	49.277	32785880.0
2017-10-23	META	Stock	175.2	175.34	171.25	171.27	13852700.0
2017-10-23	TSLA	Stock	23.3253	23.33	22.4167	22.468	86209500.0
2017-10-23	TLT	Stock	124.16	124.49	124.02	124.2	6871125.0
2017-10-23	ES	Stock	62.26	62.42	61.89	62.37	1401200.0
2017-10-23	CL	Stock	72.04	72.5	71.78	72.19	4308200.0
2017-10-23	A	Stock	67.45	67.68	66.93	67.02	1267600.0
2017-10-23	AA	Stock	48.04	48.56	47.83	47.93	4019500.0
2017-10-23	AAAP-DELISTED	Stock	73.0	73.54	71.03	71.75	307829.0
2017-10-23	AABA-DELISTED	Stock	67.63	68.0	66.4	66.48	3667037.0
2017-10-23	AAC-DELISTED	Stock	8.64	8.645	8.23	8.45	104472.0
2017-10-23	AACG	Stock	4.69	4.75	4.69	4.73	9500.0
2017-10-23	AAIC-DELISTED	Stock	12.77	12.79	12.65	12.66	256904.0
2017-10-23	AAL	Stock	51.92	51.95	50.87	50.98	3456500.0
2017-10-23	AAM.A-DELISTED	Stock	26.29	26.35	26.2501	26.2501	18125.0
2017-10-23	AAMC-DELISTED	Stock	24.7206	24.7206	24.7206	24.7206	1231.0
2017-10-23	AAME	Stock	3.2	3.45	3.2	3.25	9000.0
2017-10-23	AAMI	Stock	15.6	15.71	15.53	15.59	254300.0
2017-10-23	AAOI	Stock	41.41	42.24	40.8	41.81	1316700.0
2017-10-23	AAON	Stock	23.0333	23.8	22.9	23.1	181200.0
2017-10-23	AAP	Stock	86.55	87.44	85.58	85.91	1344900.0
2017-10-23	AAT	Stock	38.99	39.43	38.95	39.29	142000.0
2017-10-23	AAU-DELISTED	Stock	1.12	1.14	1.1	1.14	146872.0
2017-10-23	AAUAF-DELISTED	Stock	1.12	1.14	1.1	1.14	154598.0
2017-10-23	AAV-DELISTED	Stock	5.45	5.495	5.44	5.45	35526.0
2017-10-23	AAWW-DELISTED	Stock	64.55	64.575	63.4	64.5	168317.0
2017-10-23	AAXJ	Stock	74.82	74.94	74.39	74.46	774849.0
2017-10-23	AAXN-DELISTED	Stock	22.8	22.9699	22.3275	22.59	730703.0
2017-10-23	AB	Stock	25.35	25.45	25.1	25.2	160000.0
2017-10-23	ABAC-DELISTED	Stock	3.61	3.61	3.3509	3.445	5621.0
2017-10-23	ABAX-DELISTED	Stock	47.08	47.39	46.5	47.08	104701.0
2017-10-23	ABB-DELISTED	Stock	25.41	25.42	25.24	25.27	2398444.0
2017-10-23	ABBNY-DELISTED	Stock	25.41	25.42	25.24	25.28	2443529.0
2017-10-23	ABBV	Stock	95.93	96.0	94.45	94.51	4483900.0
2017-10-23	ABC-DELISTED	Stock	83.17	83.4299	81.7658	82.52	931770.0
2017-10-23	ABCB	Stock	48.3	48.6	47.85	48.0	126600.0
2017-10-23	ABCD-DELISTED	Stock	6.21	6.25	6.14	6.14	15360.0
2017-10-23	ABCO-DELISTED	Stock	53.9	54.0	53.85	53.85	306230.0
2017-10-23	ABDC-DELISTED	Stock	10.31	10.31	10.04	10.07	37820.0
2017-10-23	ABE-DELISTED	Stock	14.64	14.64	14.55	14.57	6996.0
2017-10-23	ABEO	Stock	477.5	510.0	459.25	465.0	63688.0
2017-10-23	ABEOW-DELISTED	Stock	14.45	15.3477	13.63	13.7902	10250.0
2017-10-23	ABEV	Stock	6.67	6.68	6.49	6.52	28834000.0
2017-10-23	ABG	Stock	56.2	56.5	55.55	56.05	319400.0
2017-10-23	ABIL-DELISTED	Stock	0.72	0.72	0.69	0.695	30507.0
2017-10-23	ABM	Stock	42.63	42.88	42.31	42.39	168100.0

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

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