PREVIEW / stock_daily / 2016-05-23

all stock daily files

  file:    by_date/stock_daily/2016/2016-05-23.parquet
  size:    217 KB
  rows:    6,544
  symbols: 3,280

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-23	AAPL	Stock	23.9675	24.2975	23.9175	24.1075	152074400.0
2016-05-23	MSFT	Stock	50.6	50.68	49.98	50.03	26118700.0
2016-05-23	NVDA	Stock	1.113	1.1172	1.1032	1.11	413636000.0
2016-05-23	AMZN	Stock	35.2125	35.3	34.821	34.8375	51902000.0
2016-05-23	GOOGL	Stock	35.999	36.175	35.847	35.8625	24816520.0
2016-05-23	META	Stock	117.42	117.6	115.94	115.97	20441000.0
2016-05-23	TSLA	Stock	14.658	14.84	14.3907	14.4147	76537500.0
2016-05-23	TLT	Stock	130.36	130.73	129.92	130.44	6979730.0
2016-05-23	ES	Stock	54.91	55.0	54.13	54.16	1795800.0
2016-05-23	CL	Stock	70.05	70.24	69.83	70.08	2068000.0
2016-05-23	A	Stock	44.89	44.96	44.53	44.57	1689700.0
2016-05-23	AA.B-DELISTED	Stock	32.1	32.65	32.1	32.45	34545.0
2016-05-23	AAAP-DELISTED	Stock	28.19	28.97	28.14	28.74	45315.0
2016-05-23	AABA-DELISTED	Stock	36.46	36.945	36.43	36.67	7121915.0
2016-05-23	AAC-DELISTED	Stock	19.81	20.23	19.42	19.98	53155.0
2016-05-23	AACG	Stock	5.31	5.31	4.41	4.97	18700.0
2016-05-23	AAIC-DELISTED	Stock	12.6	12.68	12.52	12.55	166212.0
2016-05-23	AAL	Stock	32.03	32.29	31.7	31.73	6498400.0
2016-05-23	AAMC-DELISTED	Stock	3.8441	4.3235	3.8029	4.0618	106447.0
2016-05-23	AAME	Stock	3.39	3.44	3.29	3.35	3100.0
2016-05-23	AAMI	Stock	13.88	14.05	13.86	13.88	99600.0
2016-05-23	AAOI	Stock	9.19	10.117	9.16	9.97	480700.0
2016-05-23	AAON	Stock	18.24	18.3867	18.0	18.18	143850.0
2016-05-23	AAP	Stock	145.58	147.5	145.1	145.87	1069800.0
2016-05-23	AAT	Stock	39.53	39.53	39.07	39.09	77700.0
2016-05-23	AAU-DELISTED	Stock	1.05	1.15	1.05	1.1	408717.0
2016-05-23	AAUAF-DELISTED	Stock	1.05	1.15	1.05	1.1	410491.0
2016-05-23	AAV-DELISTED	Stock	5.77	5.77	5.63	5.69	24271.0
2016-05-23	AAWW-DELISTED	Stock	43.61	44.13	43.0	43.02	406807.0
2016-05-23	AAXJ	Stock	51.38	51.68	51.37	51.39	775655.0
2016-05-23	AAXN-DELISTED	Stock	21.74	21.77	21.38	21.45	578417.0
2016-05-23	AB	Stock	23.2	23.46	22.91	22.95	154500.0
2016-05-23	ABAC-DELISTED	Stock	0.689	0.76	0.689	0.72	21216.0
2016-05-23	ABAX-DELISTED	Stock	44.75	45.19	43.75	44.07	79953.0
2016-05-23	ABB-DELISTED	Stock	20.47	20.5671	20.42	20.5	1752818.0
2016-05-23	ABBNY-DELISTED	Stock	20.46	20.5671	20.42	20.5	1802508.0
2016-05-23	ABBV	Stock	59.75	59.84	59.13	59.3	6468900.0
2016-05-23	ABC-DELISTED	Stock	75.0	75.05	73.91	73.96	1532539.0
2016-05-23	ABCB	Stock	30.96	31.01	30.55	30.86	208200.0
2016-05-23	ABCD-DELISTED	Stock	4.52	4.59	4.51	4.53	9501.0
2016-05-23	ABCO-DELISTED	Stock	32.34	32.45	31.15	31.3	369897.0
2016-05-23	ABDC-DELISTED	Stock	11.84	12.14	11.84	12.03	19102.0
2016-05-23	ABE-DELISTED	Stock	11.65	11.684	11.53	11.53	8264.0
2016-05-23	ABEO	Stock	62.75	64.0	62.5	63.0	1764.0
2016-05-23	ABEOW-DELISTED	Stock	0.7	0.7	0.7	0.7	9798.0
2016-05-23	ABEV	Stock	5.12	5.16	5.09	5.1	12478300.0
2016-05-23	ABG	Stock	54.64	54.64	52.45	52.52	234200.0
2016-05-23	ABIL-DELISTED	Stock	2.71	2.785	2.65	2.71	35743.0
2016-05-23	ABM	Stock	33.1	33.22	32.99	33.0	164400.0
2016-05-23	ABMD-DELISTED	Stock	96.88	97.53	95.815	97.05	268310.0

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

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