PREVIEW / stock_daily / 2016-12-30

all stock daily files

  file:    by_date/stock_daily/2016/2016-12-30.parquet
  size:    216 KB
  rows:    6,541
  symbols: 3,146

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-30	AAPL	Stock	29.1625	29.3	28.8575	28.955	122345200.0
2016-12-30	MSFT	Stock	62.96	62.99	62.03	62.14	25579900.0
2016-12-30	NVDA	Stock	2.7838	2.798	2.6575	2.6685	1212932000.0
2016-12-30	AMZN	Stock	38.3235	38.37	37.414	37.4935	82788000.0
2016-12-30	GOOGL	Stock	40.1605	40.1642	39.481	39.6225	34717580.0
2016-12-30	META	Stock	116.6	116.83	114.77	115.05	18684100.0
2016-12-30	TSLA	Stock	14.42	14.5	14.112	14.246	69639000.0
2016-12-30	TLT	Stock	118.78	119.65	118.72	119.13	10613914.0
2016-12-30	ES	Stock	55.6	55.74	55.07	55.23	1446800.0
2016-12-30	CL	Stock	65.84	66.07	65.28	65.44	3491300.0
2016-12-30	A	Stock	45.76	45.82	45.38	45.56	1216100.0
2016-12-30	AA	Stock	28.97	29.378	28.01	28.08	2686000.0
2016-12-30	AAAP-DELISTED	Stock	26.73	26.92	26.6	26.81	38997.0
2016-12-30	AABA-DELISTED	Stock	38.72	39.0	38.43	38.69	5631052.0
2016-12-30	AAC-DELISTED	Stock	6.88	7.5077	6.8301	7.25	186099.0
2016-12-30	AACG	Stock	3.85	3.85	3.6	3.72	2400.0
2016-12-30	AAIC-DELISTED	Stock	15.05	15.1	14.8	14.82	292479.0
2016-12-30	AAL	Stock	47.42	47.66	46.47	46.69	4495000.0
2016-12-30	AAMC-DELISTED	Stock	14.4412	15.7353	13.4184	15.7353	61581.0
2016-12-30	AAME	Stock	3.95	4.2	3.95	4.1	50400.0
2016-12-30	AAMI	Stock	14.65	14.675	14.37	14.5	249700.0
2016-12-30	AAOI	Stock	24.25	24.25	23.21	23.44	197100.0
2016-12-30	AAON	Stock	22.5	22.5	21.9333	22.0333	149700.0
2016-12-30	AAP	Stock	171.32	172.0	168.6	169.12	513000.0
2016-12-30	AAT	Stock	42.41	43.34	42.41	43.08	232400.0
2016-12-30	AAU-DELISTED	Stock	1.08	1.08	0.966	0.9688	450391.0
2016-12-30	AAUAF-DELISTED	Stock	1.08	1.08	0.966	0.9688	452576.0
2016-12-30	AAV-DELISTED	Stock	6.7	6.85	6.7	6.75	63910.0
2016-12-30	AAWW-DELISTED	Stock	52.3	52.85	51.3	52.25	120806.0
2016-12-30	AAXJ	Stock	55.28	55.33	54.835	54.93	891647.0
2016-12-30	AAXN-DELISTED	Stock	24.8	24.8	24.21	24.25	301671.0
2016-12-30	AB	Stock	23.8	23.85	23.42	23.45	218300.0
2016-12-30	ABAC-DELISTED	Stock	3.6528	3.6528	3.6001	3.6177	7399.0
2016-12-30	ABAX-DELISTED	Stock	53.0	53.31	52.15	52.74	93893.0
2016-12-30	ABB-DELISTED	Stock	21.26	21.27	21.04	21.07	1327872.0
2016-12-30	ABBNY-DELISTED	Stock	21.26	21.27	21.04	21.07	1387970.0
2016-12-30	ABBV	Stock	62.73	62.93	62.41	62.62	5999200.0
2016-12-30	ABC-DELISTED	Stock	79.35	79.49	77.96	78.21	1211496.0
2016-12-30	ABCB	Stock	44.45	44.5	43.43	43.6	202500.0
2016-12-30	ABCD-DELISTED	Stock	4.98	5.0	4.89	5.0	29935.0
2016-12-30	ABCO-DELISTED	Stock	32.85	33.25	32.15	33.25	319662.0
2016-12-30	ABDC-DELISTED	Stock	12.14	12.5	11.88	11.96	35483.0
2016-12-30	ABE-DELISTED	Stock	11.27	11.27	11.22	11.25	11709.0
2016-12-30	ABEO	Stock	121.25	123.75	118.75	121.25	6116.0
2016-12-30	ABEV	Stock	4.96	4.97	4.89	4.91	8423400.0
2016-12-30	ABG	Stock	62.1	63.05	60.85	61.7	151600.0
2016-12-30	ABIL-DELISTED	Stock	2.7	2.83	2.7	2.77	50256.0
2016-12-30	ABM	Stock	40.79	40.94	40.62	40.84	355700.0
2016-12-30	ABMD-DELISTED	Stock	113.6	113.99	112.26	112.7	134523.0
2016-12-30	ABR	Stock	7.5	7.53	7.44	7.46	59600.0

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

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