PREVIEW / stock_daily / 2016-07-20

all stock daily files

  file:    by_date/stock_daily/2016/2016-07-20.parquet
  size:    219 KB
  rows:    6,547
  symbols: 3,251

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-07-20	AAPL	Stock	25.0	25.115	24.935	24.99	105104000.0
2016-07-20	MSFT	Stock	56.15	56.84	55.53	55.91	89893300.0
2016-07-20	NVDA	Stock	1.3425	1.3628	1.337	1.3555	296460000.0
2016-07-20	AMZN	Stock	37.2	37.3125	37.035	37.286	44280000.0
2016-07-20	GOOGL	Stock	37.7025	38.032	37.7025	37.854	22502340.0
2016-07-20	META	Stock	121.25	122.2	120.56	121.92	20046500.0
2016-07-20	TSLA	Stock	15.098	15.32	15.0	15.224	38527500.0
2016-07-20	TLT	Stock	138.23	138.51	137.91	138.28	6942471.0
2016-07-20	ES	Stock	58.16	58.17	57.77	57.9	811700.0
2016-07-20	CL	Stock	74.27	74.51	74.09	74.12	2961800.0
2016-07-20	A	Stock	46.96	47.18	46.82	47.01	2124600.0
2016-07-20	AA.B-DELISTED	Stock	36.19	36.55	35.8001	36.2	33688.0
2016-07-20	AAAP-DELISTED	Stock	30.5	30.65	30.0	30.59	24053.0
2016-07-20	AABA-DELISTED	Stock	38.36	38.93	38.26	38.89	7823885.0
2016-07-20	AAC-DELISTED	Stock	22.56	22.64	21.79	21.83	93114.0
2016-07-20	AACG	Stock	4.5	4.5	4.5	4.5	1900.0
2016-07-20	AAIC-DELISTED	Stock	13.45	13.49	13.24	13.44	185609.0
2016-07-20	AAL	Stock	36.07	36.73	35.39	35.92	13098400.0
2016-07-20	AAMC-DELISTED	Stock	3.8412	4.1092	3.7647	4.05	124749.0
2016-07-20	AAMI	Stock	14.17	14.17	13.55	13.68	270100.0
2016-07-20	AAOI	Stock	11.94	11.95	11.51	11.86	252400.0
2016-07-20	AAON	Stock	18.36	18.36	18.1133	18.14	285000.0
2016-07-20	AAP	Stock	164.61	164.61	163.42	163.75	444900.0
2016-07-20	AAT	Stock	44.52	44.73	44.39	44.71	130200.0
2016-07-20	AAU-DELISTED	Stock	1.33	1.37	1.3	1.335	578338.0
2016-07-20	AAUAF-DELISTED	Stock	1.33	1.37	1.3	1.335	581340.0
2016-07-20	AAV-DELISTED	Stock	6.2	6.51	6.19	6.49	151429.0
2016-07-20	AAWW-DELISTED	Stock	43.28	43.28	42.23	42.27	123497.0
2016-07-20	AAXJ	Stock	56.91	57.0599	56.7599	57.0	784167.0
2016-07-20	AAXN-DELISTED	Stock	28.17	28.71	27.82	28.26	911336.0
2016-07-20	AB	Stock	23.78	24.21	23.55	24.18	140600.0
2016-07-20	ABAC-DELISTED	Stock	0.8019	0.8019	0.79	0.8	1400.0
2016-07-20	ABAX-DELISTED	Stock	53.49	54.64	53.2	54.32	197500.0
2016-07-20	ABB-DELISTED	Stock	20.2	20.35	20.11	20.23	1791255.0
2016-07-20	ABBNY-DELISTED	Stock	20.2	20.35	20.11	20.24	1843117.0
2016-07-20	ABBV	Stock	63.57	63.9	63.33	63.41	7502800.0
2016-07-20	ABC-DELISTED	Stock	86.39	87.05	86.01	86.65	1108886.0
2016-07-20	ABCB	Stock	30.57	30.71	30.31	30.45	61500.0
2016-07-20	ABCD-DELISTED	Stock	4.94	4.95	4.88	4.9	9437.0
2016-07-20	ABCO-DELISTED	Stock	38.14	38.55	37.72	38.3	146979.0
2016-07-20	ABDC-DELISTED	Stock	12.29	12.34	12.18	12.29	21545.0
2016-07-20	ABE-DELISTED	Stock	12.39	12.4	12.39	12.4	1194.0
2016-07-20	ABEO	Stock	61.0	62.75	60.25	62.0	1916.0
2016-07-20	ABEOW-DELISTED	Stock	1.0	1.0	0.998	0.998	2100.0
2016-07-20	ABEV	Stock	5.85	5.88	5.81	5.86	8601500.0
2016-07-20	ABG	Stock	59.54	60.12	59.0	59.54	210700.0
2016-07-20	ABIL-DELISTED	Stock	4.6	4.62	4.58	4.62	8506.0
2016-07-20	ABM	Stock	36.85	37.33	36.71	37.09	161000.0
2016-07-20	ABMD-DELISTED	Stock	117.28	119.899	117.25	118.22	523495.0
2016-07-20	ABR	Stock	7.2	7.25	7.13	7.17	89500.0

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

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