PREVIEW / stock_daily / 2016-04-08

all stock daily files

  file:    by_date/stock_daily/2016/2016-04-08.parquet
  size:    218 KB
  rows:    6,561
  symbols: 3,317

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-04-08	AAPL	Stock	27.2275	27.4425	27.0425	27.165	94326800.0
2016-04-08	MSFT	Stock	54.67	55.28	54.32	54.42	22167200.0
2016-04-08	NVDA	Stock	0.893	0.8988	0.8828	0.8915	255936000.0
2016-04-08	AMZN	Stock	29.716	29.893	29.45	29.73	51838000.0
2016-04-08	GOOGL	Stock	38.2935	38.3565	37.7885	37.9735	23437340.0
2016-04-08	META	Stock	114.25	114.33	109.9	110.63	48497800.0
2016-04-08	TSLA	Stock	17.3667	17.388	16.5347	16.6713	110458500.0
2016-04-08	TLT	Stock	132.17	132.4	131.635	132.01	5585183.0
2016-04-08	ES	Stock	57.06	57.6	56.95	57.05	1788200.0
2016-04-08	CL	Stock	71.09	71.15	70.5	71.07	2816000.0
2016-04-08	A	Stock	39.69	39.97	39.4	39.54	1106300.0
2016-04-08	AA.B-DELISTED	Stock	33.1	33.1966	32.3	32.55	11961.0
2016-04-08	AAAP-DELISTED	Stock	36.28	38.06	35.52	35.71	25031.0
2016-04-08	AABA-DELISTED	Stock	36.85	36.92	35.62	36.08	19369523.0
2016-04-08	AAC-DELISTED	Stock	19.11	19.37	18.5	18.68	290221.0
2016-04-08	AACG	Stock	5.48	5.5	5.15	5.21	3900.0
2016-04-08	AAIC-DELISTED	Stock	12.25	12.49	12.18	12.19	137945.0
2016-04-08	AAL	Stock	38.7	38.72	38.12	38.5	6087400.0
2016-04-08	AAMC-DELISTED	Stock	4.9059	5.4206	4.7794	5.3	76548.0
2016-04-08	AAME	Stock	4.77	4.9	4.57	4.63	2900.0
2016-04-08	AAMI	Stock	12.97	13.045	12.7	12.76	119100.0
2016-04-08	AAOI	Stock	15.05	15.86	14.82	15.73	383100.0
2016-04-08	AAON	Stock	17.6467	18.1733	17.5867	17.84	490500.0
2016-04-08	AAP	Stock	157.0	157.29	155.0	156.11	504100.0
2016-04-08	AAT	Stock	38.55	38.8	38.38	38.65	122500.0
2016-04-08	AAU-DELISTED	Stock	1.0	1.24	1.0	1.119	2929089.0
2016-04-08	AAUAF-DELISTED	Stock	1.0	1.24	1.0	1.119	2947526.0
2016-04-08	AAV-DELISTED	Stock	5.33	5.33	5.16	5.22	52920.0
2016-04-08	AAVL-DELISTED	Stock	5.39	5.39	5.18	5.2	304613.0
2016-04-08	AAWW-DELISTED	Stock	38.75	39.835	38.36	39.0	115605.0
2016-04-08	AAXJ	Stock	53.6	53.73	53.22	53.35	1186347.0
2016-04-08	AAXN-DELISTED	Stock	18.86	18.93	18.24	18.305	609051.0
2016-04-08	AB	Stock	23.65	24.18	23.37	23.56	169100.0
2016-04-08	ABAC-DELISTED	Stock	0.63	0.63	0.61	0.61	31373.0
2016-04-08	ABAX-DELISTED	Stock	44.36	44.74	43.4	44.2	121285.0
2016-04-08	ABB-DELISTED	Stock	19.24	19.46	19.23	19.35	1129917.0
2016-04-08	ABBNY-DELISTED	Stock	19.24	19.46	19.23	19.37	1218557.0
2016-04-08	ABBV	Stock	59.49	59.8	58.17	58.47	5750000.0
2016-04-08	ABC-DELISTED	Stock	86.75	86.89	85.12	85.29	2231773.0
2016-04-08	ABCB	Stock	28.05	28.5	27.9	28.17	96000.0
2016-04-08	ABCD-DELISTED	Stock	4.06	4.14	4.01	4.05	31302.0
2016-04-08	ABCO-DELISTED	Stock	32.35	32.94	31.62	31.815	653284.0
2016-04-08	ABCW-DELISTED	Stock	44.33	44.63	44.12	44.19	19463.0
2016-04-08	ABDC-DELISTED	Stock	11.6	11.73	11.33	11.71	36941.0
2016-04-08	ABE-DELISTED	Stock	11.7	11.7045	11.626	11.626	4644.0
2016-04-08	ABEO	Stock	69.5	70.25	65.25	66.0	2388.0
2016-04-08	ABEOW-DELISTED	Stock	1.15	1.15	0.78	0.85	11754.0
2016-04-08	ABEV	Stock	5.13	5.14	5.04	5.1	14180900.0
2016-04-08	ABG	Stock	54.5	55.22	53.82	53.93	532000.0
2016-04-08	ABGB-DELISTED	Stock	1.4601	1.49	1.45	1.48	19478.0

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

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