PREVIEW / stock_daily / 2016-12-22

all stock daily files

  file:    by_date/stock_daily/2016/2016-12-22.parquet
  size:    216 KB
  rows:    6,530
  symbols: 3,139

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-22	AAPL	Stock	29.0875	29.1275	28.91	29.0725	104343600.0
2016-12-22	MSFT	Stock	63.84	64.1	63.41	63.55	22176600.0
2016-12-22	NVDA	Stock	2.6705	2.7218	2.6632	2.6778	718612000.0
2016-12-22	AMZN	Stock	38.406	38.5605	38.151	38.317	50872000.0
2016-12-22	GOOGL	Stock	40.455	40.5535	40.3015	40.484	22642380.0
2016-12-22	META	Stock	118.86	118.99	116.93	117.4	16258600.0
2016-12-22	TSLA	Stock	13.8813	13.9993	13.7667	13.8967	46666500.0
2016-12-22	TLT	Stock	117.53	118.0	117.5	117.81	5177794.0
2016-12-22	ES	Stock	54.89	55.52	54.71	55.44	1296200.0
2016-12-22	CL	Stock	65.97	66.43	65.84	66.37	1673600.0
2016-12-22	A	Stock	45.93	46.13	45.8	45.97	968300.0
2016-12-22	AA	Stock	30.21	30.35	29.54	29.75	3767400.0
2016-12-22	AAAP-DELISTED	Stock	24.12	24.92	23.5	23.72	367730.0
2016-12-22	AABA-DELISTED	Stock	38.69	38.79	38.26	38.5	11178540.0
2016-12-22	AAC-DELISTED	Stock	7.51	7.61	7.23	7.35	231049.0
2016-12-22	AACG	Stock	3.64	3.7	3.64	3.7	1600.0
2016-12-22	AAIC-DELISTED	Stock	15.65	15.89	15.5	15.66	428364.0
2016-12-22	AAL	Stock	49.35	49.45	48.46	48.69	3618700.0
2016-12-22	AAMC-DELISTED	Stock	15.1618	16.0294	15.0	15.4853	69068.0
2016-12-22	AAME	Stock	3.95	3.95	3.67	3.67	1200.0
2016-12-22	AAMI	Stock	14.27	14.4	13.94	14.33	398600.0
2016-12-22	AAOI	Stock	24.78	25.45	24.33	24.84	193300.0
2016-12-22	AAON	Stock	22.0667	22.42	21.8667	21.8667	164850.0
2016-12-22	AAP	Stock	172.7	173.41	169.69	170.39	946100.0
2016-12-22	AAT	Stock	42.57	42.73	42.27	42.53	230200.0
2016-12-22	AAU-DELISTED	Stock	0.81	0.8496	0.81	0.835	185994.0
2016-12-22	AAUAF-DELISTED	Stock	0.81	0.8496	0.81	0.835	187074.0
2016-12-22	AAV-DELISTED	Stock	6.8	6.845	6.7	6.75	35353.0
2016-12-22	AAWW-DELISTED	Stock	53.5	53.65	52.5	52.65	117817.0
2016-12-22	AAXJ	Stock	54.18	54.18	53.9	54.13	1211455.0
2016-12-22	AAXN-DELISTED	Stock	25.18	25.34	24.24	24.3	551564.0
2016-12-22	AB	Stock	23.0	23.85	22.9	23.4	628400.0
2016-12-22	ABAC-DELISTED	Stock	3.47	3.7258	3.47	3.56	4534.0
2016-12-22	ABAX-DELISTED	Stock	51.6	51.98	50.9	51.21	80621.0
2016-12-22	ABB-DELISTED	Stock	21.12	21.225	21.08	21.19	2209374.0
2016-12-22	ABBNY-DELISTED	Stock	21.12	21.225	21.08	21.19	3475243.0
2016-12-22	ABBV	Stock	61.58	61.92	61.35	61.66	5626000.0
2016-12-22	ABC-DELISTED	Stock	78.96	78.96	77.325	77.8	1702824.0
2016-12-22	ABCB	Stock	43.9	44.35	43.75	43.95	181600.0
2016-12-22	ABCD-DELISTED	Stock	4.92	4.96	4.81	4.88	11509.0
2016-12-22	ABCO-DELISTED	Stock	32.15	32.35	31.8	32.3	370009.0
2016-12-22	ABDC-DELISTED	Stock	12.59	12.59	12.43	12.52	46661.0
2016-12-22	ABE-DELISTED	Stock	11.12	11.18	10.9	10.9	10440.0
2016-12-22	ABEO	Stock	107.5	123.75	106.25	116.25	16988.0
2016-12-22	ABEOW-DELISTED	Stock	2.6	3.25	2.6	3.0795	1500.0
2016-12-22	ABEV	Stock	4.78	4.81	4.73	4.77	12306800.0
2016-12-22	ABG	Stock	65.0	65.08	62.45	62.5	133700.0
2016-12-22	ABIL-DELISTED	Stock	2.68	2.7296	2.6	2.6	34427.0
2016-12-22	ABM	Stock	40.24	40.49	40.09	40.41	368200.0
2016-12-22	ABMD-DELISTED	Stock	113.3	113.3	110.37	111.55	287647.0

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

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