PREVIEW / stock_daily / 2016-12-20

all stock daily files

  file:    by_date/stock_daily/2016/2016-12-20.parquet
  size:    216 KB
  rows:    6,519
  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-20	AAPL	Stock	29.185	29.375	29.17	29.2375	85700000.0
2016-12-20	MSFT	Stock	63.69	63.8	63.03	63.54	26028400.0
2016-12-20	NVDA	Stock	2.6145	2.6532	2.603	2.6293	848056000.0
2016-12-20	AMZN	Stock	38.4325	38.7195	38.3855	38.561	54072000.0
2016-12-20	GOOGL	Stock	40.6685	40.8245	40.55	40.76	25437660.0
2016-12-20	META	Stock	119.5	119.77	118.8	119.09	13684400.0
2016-12-20	TSLA	Stock	13.5367	13.9333	13.5	13.9193	70336500.0
2016-12-20	TLT	Stock	117.63	117.9	117.38	117.81	7030613.0
2016-12-20	ES	Stock	55.61	55.61	55.06	55.26	1282500.0
2016-12-20	CL	Stock	66.44	66.45	65.97	66.39	2635800.0
2016-12-20	A	Stock	45.75	46.31	45.54	46.21	1552400.0
2016-12-20	AA	Stock	29.9	30.33	29.77	30.16	3827000.0
2016-12-20	AAAP-DELISTED	Stock	26.34	26.935	25.3901	26.38	101037.0
2016-12-20	AABA-DELISTED	Stock	38.4	39.18	38.24	39.16	14570228.0
2016-12-20	AAC-DELISTED	Stock	7.63	7.8	7.45	7.47	171231.0
2016-12-20	AAIC-DELISTED	Stock	15.64	15.8355	15.33	15.75	545774.0
2016-12-20	AAL	Stock	48.5	49.5	48.5	49.22	4814600.0
2016-12-20	AAMC-DELISTED	Stock	14.0294	14.4118	12.2647	13.3088	57429.0
2016-12-20	AAME	Stock	4.05	4.05	3.99	3.99	2000.0
2016-12-20	AAMI	Stock	14.42	14.55	14.34	14.47	939200.0
2016-12-20	AAOI	Stock	25.17	25.2	24.24	24.42	219700.0
2016-12-20	AAON	Stock	22.0667	22.3333	21.9667	22.3333	299250.0
2016-12-20	AAP	Stock	173.82	176.33	172.22	175.63	1246000.0
2016-12-20	AAT	Stock	43.16	43.5	42.86	43.07	289300.0
2016-12-20	AAU-DELISTED	Stock	0.7901	0.8207	0.7526	0.8065	684538.0
2016-12-20	AAUAF-DELISTED	Stock	0.7901	0.8207	0.7526	0.8065	687149.0
2016-12-20	AAV-DELISTED	Stock	6.75	6.75	6.65	6.7	58997.0
2016-12-20	AAWW-DELISTED	Stock	50.95	52.8	50.15	52.75	171188.0
2016-12-20	AAXJ	Stock	55.56	55.6	55.42	55.56	1137710.0
2016-12-20	AAXN-DELISTED	Stock	24.65	24.76	24.02	24.37	374450.0
2016-12-20	AB	Stock	22.65	23.08	22.65	22.65	405900.0
2016-12-20	ABAC-DELISTED	Stock	3.46	3.49	3.4052	3.49	8300.0
2016-12-20	ABAX-DELISTED	Stock	52.3	52.7	50.93	51.39	151099.0
2016-12-20	ABB-DELISTED	Stock	21.07	21.18	21.06	21.17	2483035.0
2016-12-20	ABBNY-DELISTED	Stock	21.07	21.18	21.06	21.18	4064941.0
2016-12-20	ABBV	Stock	62.34	62.71	61.75	62.16	5751800.0
2016-12-20	ABC-DELISTED	Stock	78.7	80.06	78.56	79.32	2566438.0
2016-12-20	ABCB	Stock	43.05	44.45	42.75	44.05	291200.0
2016-12-20	ABCD-DELISTED	Stock	4.95	5.0	4.95	5.0	24416.0
2016-12-20	ABCO-DELISTED	Stock	32.8	33.025	32.25	32.55	643039.0
2016-12-20	ABDC-DELISTED	Stock	12.58	12.69	12.466	12.59	70328.0
2016-12-20	ABE-DELISTED	Stock	11.17	11.2217	11.15	11.212	2665.0
2016-12-20	ABEO	Stock	113.75	115.0	107.5	111.25	12492.0
2016-12-20	ABEV	Stock	4.81	4.87	4.76	4.83	15256800.0
2016-12-20	ABG	Stock	63.5	65.3	63.5	65.3	143000.0
2016-12-20	ABIL-DELISTED	Stock	2.9	2.9	2.7	2.78	47417.0
2016-12-20	ABM	Stock	40.2	41.14	40.2	40.78	550500.0
2016-12-20	ABMD-DELISTED	Stock	116.5	117.69	112.12	113.08	565770.0
2016-12-20	ABR	Stock	7.31	7.34	7.28	7.28	122100.0
2016-12-20	ABR.A-DELISTED	Stock	24.87	25.4	24.87	25.36	1441.0

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

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