PREVIEW / stock_daily / 2017-11-08

all stock daily files

  file:    by_date/stock_daily/2017/2017-11-08.parquet
  size:    215 KB
  rows:    6,451
  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-11-08	AAPL	Stock	43.665	44.06	43.5825	44.06	97638000.0
2017-11-08	MSFT	Stock	84.14	84.61	83.83	84.56	18034200.0
2017-11-08	NVDA	Stock	5.2963	5.3	5.181	5.229	522988000.0
2017-11-08	AMZN	Stock	56.141	56.777	55.9555	56.644	51630000.0
2017-11-08	GOOGL	Stock	52.5025	53.1346	52.3525	52.9145	24292000.0
2017-11-08	META	Stock	179.79	180.35	179.11	179.56	10494100.0
2017-11-08	TSLA	Stock	20.3667	20.4593	20.0867	20.2927	70879500.0
2017-11-08	TLT	Stock	126.59	126.8	126.21	126.36	3356399.0
2017-11-08	ES	Stock	64.43	65.01	64.1	64.63	2110800.0
2017-11-08	CL	Stock	73.15	73.62	72.52	73.27	5569100.0
2017-11-08	A	Stock	68.1	68.33	67.77	68.11	977600.0
2017-11-08	AA	Stock	46.73	46.77	45.37	45.89	3348200.0
2017-11-08	AAAP-DELISTED	Stock	80.95	81.1	80.94	80.94	373740.0
2017-11-08	AABA-DELISTED	Stock	72.0	72.2	71.09	71.14	6626204.0
2017-11-08	AAC-DELISTED	Stock	11.0	11.94	10.7636	11.11	940778.0
2017-11-08	AACG	Stock	4.69	4.73	4.21	4.26	5700.0
2017-11-08	AAIC-DELISTED	Stock	11.1	11.19	11.04	11.13	338166.0
2017-11-08	AAL	Stock	46.42	46.98	45.84	46.37	3198800.0
2017-11-08	AAM.A-DELISTED	Stock	26.26	26.45	26.16	26.38	22321.0
2017-11-08	AAME	Stock	3.65	3.65	3.45	3.45	1400.0
2017-11-08	AAMI	Stock	15.38	15.59	15.38	15.58	386000.0
2017-11-08	AAOI	Stock	40.47	44.643	39.1	43.64	7672500.0
2017-11-08	AAON	Stock	23.0	23.5	22.7333	22.9333	156900.0
2017-11-08	AAP	Stock	79.2	80.62	78.81	79.41	3233400.0
2017-11-08	AAT	Stock	38.74	39.16	38.68	38.9	263800.0
2017-11-08	AAU-DELISTED	Stock	0.98	1.01	0.95	0.9668	248020.0
2017-11-08	AAUAF-DELISTED	Stock	0.98	1.01	0.95	0.9668	252808.0
2017-11-08	AAV-DELISTED	Stock	5.7	5.7	5.55	5.6	48755.0
2017-11-08	AAWW-DELISTED	Stock	58.5	59.65	57.1	57.25	360621.0
2017-11-08	AAXJ	Stock	76.37	76.59	76.29	76.57	681128.0
2017-11-08	AAXN-DELISTED	Stock	22.62	22.73	20.57	21.43	2836944.0
2017-11-08	AB	Stock	24.95	25.01	24.05	24.9	404800.0
2017-11-08	ABAC-DELISTED	Stock	3.39	3.5815	3.3	3.4747	15525.0
2017-11-08	ABAX-DELISTED	Stock	45.54	46.19	45.54	45.91	77721.0
2017-11-08	ABB-DELISTED	Stock	26.1	26.28	26.06	26.22	1054136.0
2017-11-08	ABBNY-DELISTED	Stock	26.1	26.28	26.06	26.22	1110684.0
2017-11-08	ABBV	Stock	94.31	96.37	93.84	95.71	6802600.0
2017-11-08	ABC-DELISTED	Stock	74.87	75.41	73.35	75.02	1505215.0
2017-11-08	ABCB	Stock	46.65	47.45	45.95	46.5	149200.0
2017-11-08	ABCD-DELISTED	Stock	6.14	6.14	6.02	6.11	22533.0
2017-11-08	ABCO-DELISTED	Stock	53.4	53.55	53.1	53.45	773296.0
2017-11-08	ABDC-DELISTED	Stock	7.77	7.9508	7.445	7.6501	899898.0
2017-11-08	ABE-DELISTED	Stock	14.34	14.4352	14.34	14.3781	6149.0
2017-11-08	ABEO	Stock	371.25	396.25	365.75	377.5	44004.0
2017-11-08	ABEOW-DELISTED	Stock	9.8422	9.95	9.79	9.95	533.0
2017-11-08	ABEV	Stock	6.2	6.22	6.05	6.18	53627800.0
2017-11-08	ABG	Stock	60.55	61.3	60.0	60.85	118400.0
2017-11-08	ABIL-DELISTED	Stock	0.62	0.63	0.601	0.6031	54102.0
2017-11-08	ABLX-DELISTED	Stock	20.94	21.85	20.86	21.27	291387.0
2017-11-08	ABM	Stock	40.3	40.47	39.98	40.2	199000.0

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

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