PREVIEW / stock_daily / 2016-06-15

all stock daily files

  file:    by_date/stock_daily/2016/2016-06-15.parquet
  size:    218 KB
  rows:    6,562
  symbols: 3,281

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-06-15	AAPL	Stock	24.455	24.6025	24.2575	24.285	117780800.0
2016-06-15	MSFT	Stock	49.78	50.12	49.69	49.69	33757600.0
2016-06-15	NVDA	Stock	1.1818	1.1942	1.1688	1.184	301036000.0
2016-06-15	AMZN	Stock	36.1	36.128	35.6675	35.713	54188000.0
2016-06-15	GOOGL	Stock	36.746	36.8575	36.5655	36.6095	23234020.0
2016-06-15	META	Stock	115.3	115.44	114.07	114.6	19819400.0
2016-06-15	TSLA	Stock	14.4633	14.7933	14.342	14.5133	43627500.0
2016-06-15	TLT	Stock	135.52	136.23	135.31	135.8	7953205.0
2016-06-15	ES	Stock	57.3	57.36	56.39	56.52	1448000.0
2016-06-15	CL	Stock	72.19	72.29	71.62	71.72	2152900.0
2016-06-15	A	Stock	45.11	45.38	44.9	44.94	2029200.0
2016-06-15	AA.B-DELISTED	Stock	32.22	33.49	32.22	33.15	36844.0
2016-06-15	AAAP-DELISTED	Stock	30.0	30.38	29.2	29.5699	72291.0
2016-06-15	AABA-DELISTED	Stock	37.43	37.605	37.1	37.32	9768365.0
2016-06-15	AAC-DELISTED	Stock	20.42	20.53	19.6965	19.87	102976.0
2016-06-15	AACG	Stock	5.1	5.26	5.1	5.11	1800.0
2016-06-15	AAIC-DELISTED	Stock	13.27	13.46	13.21	13.26	141991.0
2016-06-15	AAL	Stock	30.65	31.1	30.45	30.49	8152300.0
2016-06-15	AAMC-DELISTED	Stock	4.9529	5.0735	4.7706	4.9765	61744.0
2016-06-15	AAME	Stock	3.53	3.73	3.51	3.64	3500.0
2016-06-15	AAMI	Stock	14.4	14.77	14.01	14.17	431100.0
2016-06-15	AAOI	Stock	9.9	10.54	9.86	10.19	292700.0
2016-06-15	AAON	Stock	17.66	17.7133	17.3333	17.3467	180000.0
2016-06-15	AAP	Stock	152.88	155.18	152.68	153.64	866300.0
2016-06-15	AAT	Stock	40.84	41.08	40.65	40.88	137400.0
2016-06-15	AAU-DELISTED	Stock	1.07	1.17	1.06	1.1213	433615.0
2016-06-15	AAUAF-DELISTED	Stock	1.07	1.17	1.06	1.1213	436001.0
2016-06-15	AAV-DELISTED	Stock	5.62	5.73	5.53	5.53	65884.0
2016-06-15	AAWW-DELISTED	Stock	44.49	45.2	43.66	43.79	226839.0
2016-06-15	AAXJ	Stock	53.35	53.78	53.26	53.32	739899.0
2016-06-15	AAXN-DELISTED	Stock	22.82	22.9586	22.56	22.76	374989.0
2016-06-15	AB	Stock	22.46	23.0	22.37	22.5	194700.0
2016-06-15	ABAC-DELISTED	Stock	0.7957	0.798	0.77	0.798	1700.0
2016-06-15	ABAX-DELISTED	Stock	45.72	45.997	45.16	45.47	61982.0
2016-06-15	ABB-DELISTED	Stock	20.4	20.55	20.3	20.33	1922711.0
2016-06-15	ABBNY-DELISTED	Stock	20.4	20.55	20.3	20.33	2056677.0
2016-06-15	ABBV	Stock	60.29	61.27	60.01	60.4	7739300.0
2016-06-15	ABC-DELISTED	Stock	75.95	76.73	75.87	76.14	2159151.0
2016-06-15	ABCB	Stock	30.23	30.62	30.0	30.12	105700.0
2016-06-15	ABCD-DELISTED	Stock	4.62	4.62	4.5301	4.62	26785.0
2016-06-15	ABCO-DELISTED	Stock	33.87	34.08	33.57	33.64	248178.0
2016-06-15	ABDC-DELISTED	Stock	12.08	12.24	12.01	12.06	16043.0
2016-06-15	ABE-DELISTED	Stock	11.78	11.92	11.78	11.91	18620.0
2016-06-15	ABEO	Stock	73.75	76.25	72.25	72.5	3916.0
2016-06-15	ABEOW-DELISTED	Stock	0.95	1.05	0.95	1.05	1186.0
2016-06-15	ABEV	Stock	5.33	5.37	5.25	5.3	10480200.0
2016-06-15	ABG	Stock	54.07	55.77	53.81	54.67	203200.0
2016-06-15	ABIL-DELISTED	Stock	3.96	4.14	3.62	3.95	72766.0
2016-06-15	ABM	Stock	36.89	36.95	36.43	36.49	200300.0
2016-06-15	ABMD-DELISTED	Stock	102.34	103.418	101.6201	103.11	402090.0

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

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