PREVIEW / stock_daily / 2016-12-29

all stock daily files

  file:    by_date/stock_daily/2016/2016-12-29.parquet
  size:    216 KB
  rows:    6,521
  symbols: 3,132

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-12-29	AAPL	Stock	29.1125	29.2775	29.1	29.1825	60158000.0
2016-12-29	MSFT	Stock	62.86	63.2	62.73	62.9	10250600.0
2016-12-29	NVDA	Stock	2.6225	2.7873	2.57	2.7858	2175368000.0
2016-12-29	AMZN	Stock	38.62	38.67	38.0425	38.2575	63166000.0
2016-12-29	GOOGL	Stock	40.1165	40.2875	39.9072	40.144	21147840.0
2016-12-29	META	Stock	117.0	117.53	116.06	116.35	9934900.0
2016-12-29	TSLA	Stock	14.5707	14.6133	14.2747	14.312	60675000.0
2016-12-29	TLT	Stock	118.8	119.2747	118.66	118.95	8581375.0
2016-12-29	ES	Stock	54.85	55.62	54.73	55.57	1187300.0
2016-12-29	CL	Stock	65.73	66.0	65.64	65.89	2108800.0
2016-12-29	A	Stock	45.68	46.0	45.57	45.64	891000.0
2016-12-29	AA	Stock	29.43	29.44	28.6	28.89	3224400.0
2016-12-29	AAAP-DELISTED	Stock	26.25	26.9697	26.17	26.59	46442.0
2016-12-29	AABA-DELISTED	Stock	38.73	38.93	38.48	38.63	3792203.0
2016-12-29	AAC-DELISTED	Stock	6.99	7.08	6.57	6.87	174326.0
2016-12-29	AACG	Stock	3.85	4.1	3.74	3.83	6800.0
2016-12-29	AAIC-DELISTED	Stock	14.82	15.18	14.8	15.04	303006.0
2016-12-29	AAL	Stock	47.8	48.0	46.96	47.25	3709300.0
2016-12-29	AAMC-DELISTED	Stock	15.1471	15.8529	13.9559	14.4412	120363.0
2016-12-29	AAME	Stock	3.95	3.95	3.93	3.93	700.0
2016-12-29	AAMI	Stock	14.53	14.72	14.49	14.56	393900.0
2016-12-29	AAOI	Stock	24.41	24.944	23.86	24.27	112400.0
2016-12-29	AAON	Stock	22.3333	22.5	22.2	22.3667	89850.0
2016-12-29	AAP	Stock	170.08	171.08	169.46	170.28	431400.0
2016-12-29	AAT	Stock	42.23	42.79	42.17	42.49	255800.0
2016-12-29	AAU-DELISTED	Stock	1.0	1.06	0.9993	1.05	477935.0
2016-12-29	AAUAF-DELISTED	Stock	1.0	1.06	0.9993	1.05	479215.0
2016-12-29	AAV-DELISTED	Stock	6.75	6.825	6.7	6.775	66797.0
2016-12-29	AAWW-DELISTED	Stock	52.3	52.65	51.5	52.2	98690.0
2016-12-29	AAXJ	Stock	54.79	55.2	54.79	55.11	1102661.0
2016-12-29	AAXN-DELISTED	Stock	24.56	25.01	24.56	24.8	403138.0
2016-12-29	AB	Stock	23.45	23.93	23.45	23.7	266500.0
2016-12-29	ABAC-DELISTED	Stock	3.733	3.7584	3.68	3.68	4743.0
2016-12-29	ABAX-DELISTED	Stock	51.73	52.87	51.73	52.84	63294.0
2016-12-29	ABB-DELISTED	Stock	21.14	21.17	21.065	21.07	1396912.0
2016-12-29	ABBNY-DELISTED	Stock	21.14	21.17	21.065	21.08	1474539.0
2016-12-29	ABBV	Stock	62.39	63.06	62.39	62.73	4990000.0
2016-12-29	ABC-DELISTED	Stock	78.61	80.24	78.59	79.34	814121.0
2016-12-29	ABCB	Stock	44.5	45.05	44.1	44.45	133800.0
2016-12-29	ABCD-DELISTED	Stock	5.0	5.0	4.8985	5.0	5503.0
2016-12-29	ABCO-DELISTED	Stock	32.6	33.0358	32.525	32.8	227643.0
2016-12-29	ABDC-DELISTED	Stock	11.88	12.33	11.87	12.15	76537.0
2016-12-29	ABE-DELISTED	Stock	11.14	11.28	11.14	11.28	17682.0
2016-12-29	ABEO	Stock	126.25	128.75	120.0	122.5	8664.0
2016-12-29	ABEV	Stock	4.95	4.97	4.92	4.95	11418400.0
2016-12-29	ABG	Stock	62.15	63.15	61.1	61.9	116000.0
2016-12-29	ABIL-DELISTED	Stock	2.8	2.84	2.71	2.72	50481.0
2016-12-29	ABM	Stock	40.48	40.8	40.25	40.78	468800.0
2016-12-29	ABMD-DELISTED	Stock	112.74	114.36	110.82	113.66	149662.0
2016-12-29	ABR	Stock	7.45	7.51	7.45	7.48	57200.0

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

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