PREVIEW / stock_daily / 2016-05-18

all stock daily files

  file:    by_date/stock_daily/2016/2016-05-18.parquet
  size:    218 KB
  rows:    6,553
  symbols: 3,288

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-05-18	AAPL	Stock	23.54	23.8025	23.4725	23.64	168249600.0
2016-05-18	MSFT	Stock	50.48	51.14	50.3	50.81	24907500.0
2016-05-18	NVDA	Stock	1.05	1.0963	1.05	1.084	541072000.0
2016-05-18	AMZN	Stock	34.478	35.127	34.438	34.8725	85664000.0
2016-05-18	GOOGL	Stock	35.925	36.2785	35.751	36.089	32536000.0
2016-05-18	META	Stock	116.8	118.27	116.73	117.65	21642300.0
2016-05-18	TSLA	Stock	13.9433	14.354	13.85	14.078	84262500.0
2016-05-18	TLT	Stock	130.81	130.85	128.91	129.49	12680973.0
2016-05-18	ES	Stock	55.48	56.04	54.57	54.79	2530900.0
2016-05-18	CL	Stock	70.69	70.69	69.73	70.13	3433400.0
2016-05-18	A	Stock	44.45	44.74	43.99	44.32	3476500.0
2016-05-18	AA.B-DELISTED	Stock	32.17	32.4799	31.55	31.72	49499.0
2016-05-18	AAAP-DELISTED	Stock	28.03	28.49	27.5	27.84	33683.0
2016-05-18	AABA-DELISTED	Stock	37.09	37.4999	36.89	37.24	7962672.0
2016-05-18	AAC-DELISTED	Stock	19.7	20.14	19.58	19.845	89644.0
2016-05-18	AACG	Stock	5.36	5.36	4.98	5.16	1600.0
2016-05-18	AAIC-DELISTED	Stock	12.37	12.57	12.27	12.35	162458.0
2016-05-18	AAL	Stock	32.61	33.36	32.34	32.61	9136300.0
2016-05-18	AAMC-DELISTED	Stock	3.7618	4.0353	3.6853	3.6882	91205.0
2016-05-18	AAME	Stock	3.42	3.42	3.42	3.42	500.0
2016-05-18	AAMI	Stock	13.67	14.015	13.67	13.93	183500.0
2016-05-18	AAOI	Stock	9.12	9.6	9.12	9.37	368000.0
2016-05-18	AAON	Stock	18.04	18.3667	17.9067	18.2	276300.0
2016-05-18	AAP	Stock	144.01	145.49	141.88	143.81	1604600.0
2016-05-18	AAT	Stock	40.09	40.58	39.04	39.31	162900.0
2016-05-18	AAU-DELISTED	Stock	1.19	1.28	1.1	1.12	470558.0
2016-05-18	AAUAF-DELISTED	Stock	1.19	1.28	1.1	1.15	472932.0
2016-05-18	AAV-DELISTED	Stock	5.83	5.85	5.62	5.63	40911.0
2016-05-18	AAWW-DELISTED	Stock	42.53	43.05	42.09	42.43	356540.0
2016-05-18	AAXJ	Stock	51.49	51.92	51.09	51.36	661477.0
2016-05-18	AAXN-DELISTED	Stock	20.64	21.27	20.48	20.78	1767057.0
2016-05-18	AB	Stock	22.25	23.08	22.14	22.8	264200.0
2016-05-18	ABAC-DELISTED	Stock	0.62	0.62	0.599	0.599	2200.0
2016-05-18	ABAX-DELISTED	Stock	43.6	45.15	42.465	44.94	169147.0
2016-05-18	ABB-DELISTED	Stock	20.35	20.55	20.24	20.34	2220901.0
2016-05-18	ABBNY-DELISTED	Stock	20.35	20.55	20.24	20.36	2298511.0
2016-05-18	ABBV	Stock	59.87	60.8	59.56	60.46	10622000.0
2016-05-18	ABC-DELISTED	Stock	74.2	75.27	74.08	75.13	2978638.0
2016-05-18	ABCB	Stock	30.16	31.16	30.16	31.0	242200.0
2016-05-18	ABCD-DELISTED	Stock	4.25	4.41	4.19	4.33	64276.0
2016-05-18	ABCO-DELISTED	Stock	32.66	33.03	31.9775	32.1	462585.0
2016-05-18	ABDC-DELISTED	Stock	12.0	12.06	11.551	11.84	10152.0
2016-05-18	ABE-DELISTED	Stock	11.56	11.779	11.5401	11.69	3147.0
2016-05-18	ABEO	Stock	60.75	63.0	60.25	62.75	1540.0
2016-05-18	ABEV	Stock	5.18	5.25	5.1	5.14	12369200.0
2016-05-18	ABG	Stock	53.55	53.96	52.96	53.22	291500.0
2016-05-18	ABIL-DELISTED	Stock	2.95	2.95	2.832	2.84	20194.0
2016-05-18	ABM	Stock	32.83	32.83	32.39	32.58	269300.0
2016-05-18	ABMD-DELISTED	Stock	93.75	95.35	92.03	95.11	477635.0
2016-05-18	ABR	Stock	6.7	6.82	6.64	6.7	103100.0

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

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