PREVIEW / stock_daily / 2016-12-21

all stock daily files

  file:    by_date/stock_daily/2016/2016-12-21.parquet
  size:    217 KB
  rows:    6,542
  symbols: 3,148

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-21	AAPL	Stock	29.2	29.35	29.195	29.265	95132800.0
2016-12-21	MSFT	Stock	63.43	63.7	63.12	63.54	17096300.0
2016-12-21	NVDA	Stock	2.641	2.6488	2.5928	2.6458	576136000.0
2016-12-21	AMZN	Stock	38.5	38.561	38.285	38.53	40892000.0
2016-12-21	GOOGL	Stock	40.786	40.786	40.255	40.61	29192560.0
2016-12-21	META	Stock	118.92	119.2	118.48	119.04	10767600.0
2016-12-21	TSLA	Stock	13.8967	14.1487	13.8273	13.8467	78114000.0
2016-12-21	TLT	Stock	117.92	118.4	117.7338	118.33	4624709.0
2016-12-21	ES	Stock	55.18	55.55	54.91	54.95	938700.0
2016-12-21	CL	Stock	66.19	66.73	66.03	66.05	2007100.0
2016-12-21	A	Stock	46.21	46.36	45.86	46.04	1652300.0
2016-12-21	AA	Stock	30.19	30.43	30.02	30.43	1811200.0
2016-12-21	AAAP-DELISTED	Stock	25.11	25.5375	23.98	24.68	183340.0
2016-12-21	AABA-DELISTED	Stock	39.08	39.32	38.97	39.15	7707801.0
2016-12-21	AAC-DELISTED	Stock	7.5	7.68	7.47	7.49	147551.0
2016-12-21	AACG	Stock	3.7	3.7	3.66	3.66	1000.0
2016-12-21	AAIC-DELISTED	Stock	15.63	15.73	15.4	15.66	446420.0
2016-12-21	AAL	Stock	49.34	49.9	49.23	49.47	3827900.0
2016-12-21	AAMC-DELISTED	Stock	13.3676	15.5588	13.1618	15.1471	77704.0
2016-12-21	AAME	Stock	4.05	4.05	3.8	3.8	1400.0
2016-12-21	AAMI	Stock	14.5	14.511	14.31	14.31	377800.0
2016-12-21	AAOI	Stock	24.49	24.96	24.23	24.74	148600.0
2016-12-21	AAON	Stock	22.2333	22.4333	22.0333	22.0667	145200.0
2016-12-21	AAP	Stock	174.76	175.47	173.31	173.51	454700.0
2016-12-21	AAT	Stock	42.96	43.43	42.71	42.71	240300.0
2016-12-21	AAU-DELISTED	Stock	0.8065	0.85	0.7998	0.8101	365588.0
2016-12-21	AAUAF-DELISTED	Stock	0.8065	0.85	0.7998	0.8101	368217.0
2016-12-21	AAV-DELISTED	Stock	6.65	6.975	6.65	6.8	91811.0
2016-12-21	AAWW-DELISTED	Stock	52.5	53.95	52.3	53.45	228616.0
2016-12-21	AAXJ	Stock	54.87	54.9	54.63	54.63	2053086.0
2016-12-21	AAXN-DELISTED	Stock	24.44	25.59	24.15	25.03	1798045.0
2016-12-21	AB	Stock	22.55	23.15	22.55	22.95	387000.0
2016-12-21	ABAC-DELISTED	Stock	3.49	3.4949	3.4157	3.4949	6396.0
2016-12-21	ABAX-DELISTED	Stock	51.26	51.82	50.7201	51.67	73943.0
2016-12-21	ABB-DELISTED	Stock	21.02	21.165	20.995	21.05	1901660.0
2016-12-21	ABBNY-DELISTED	Stock	21.02	21.165	20.995	21.05	3108181.0
2016-12-21	ABBV	Stock	62.23	62.41	61.43	61.45	5498700.0
2016-12-21	ABC-DELISTED	Stock	78.96	79.575	78.61	78.86	1162862.0
2016-12-21	ABCB	Stock	43.85	44.28	43.8	43.95	246900.0
2016-12-21	ABCD-DELISTED	Stock	4.96	4.98	4.8801	4.93	12506.0
2016-12-21	ABCO-DELISTED	Stock	32.4	33.0	31.35	32.3	700501.0
2016-12-21	ABDC-DELISTED	Stock	12.68	12.7	12.4	12.47	40698.0
2016-12-21	ABE-DELISTED	Stock	11.25	11.25	11.14	11.16	5052.0
2016-12-21	ABEO	Stock	110.0	110.75	101.25	106.25	15020.0
2016-12-21	ABEOW-DELISTED	Stock	2.54	2.54	2.47	2.5	1700.0
2016-12-21	ABEV	Stock	4.91	4.91	4.84	4.84	10775200.0
2016-12-21	ABG	Stock	65.4	66.0	64.55	65.05	172900.0
2016-12-21	ABIL-DELISTED	Stock	2.76	2.835	2.62	2.74	43418.0
2016-12-21	ABM	Stock	40.94	41.18	40.47	40.47	327900.0
2016-12-21	ABMD-DELISTED	Stock	112.77	114.73	112.77	113.56	302531.0

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

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