PREVIEW / stock_daily / 2016-10-25

all stock daily files

  file:    by_date/stock_daily/2016/2016-10-25.parquet
  size:    216 KB
  rows:    6,519
  symbols: 3,189

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-10-25	AAPL	Stock	29.4875	29.59	29.3275	29.5625	192516000.0
2016-10-25	MSFT	Stock	60.85	61.37	60.8	60.99	35137200.0
2016-10-25	NVDA	Stock	1.7648	1.8075	1.7562	1.7968	397460000.0
2016-10-25	AMZN	Stock	41.965	42.1545	41.661	41.759	64968000.0
2016-10-25	GOOGL	Stock	41.925	41.925	41.265	41.4275	37814240.0
2016-10-25	META	Stock	133.5	133.5	132.22	132.29	13336800.0
2016-10-25	TSLA	Stock	13.5267	13.646	13.4133	13.4893	36675000.0
2016-10-25	TLT	Stock	132.53	133.555	132.49	133.08	5134728.0
2016-10-25	ES	Stock	53.95	54.52	53.87	54.3	1260600.0
2016-10-25	CL	Stock	71.37	71.72	71.18	71.31	2535600.0
2016-10-25	A	Stock	45.26	45.59	43.17	43.51	3949500.0
2016-10-25	AA	Stock	21.8353	22.2278	21.619	21.8593	12088514.0
2016-10-25	AA.B-DELISTED	Stock	30.02	30.35	29.6715	29.97	56836.0
2016-10-25	AAAP-DELISTED	Stock	38.53	38.62	37.93	38.1	445709.0
2016-10-25	AABA-DELISTED	Stock	42.72	42.75	42.43	42.55	5014357.0
2016-10-25	AAC-DELISTED	Stock	17.25	17.39	16.72	16.97	189990.0
2016-10-25	AACG	Stock	3.97	3.97	3.55	3.55	1000.0
2016-10-25	AAIC-DELISTED	Stock	14.85	15.1	14.75	15.09	300373.0
2016-10-25	AAL	Stock	39.66	40.43	39.36	39.69	6019900.0
2016-10-25	AAMC-DELISTED	Stock	11.1618	11.1618	9.5441	9.6618	100283.0
2016-10-25	AAME	Stock	4.15	4.3	4.15	4.25	4600.0
2016-10-25	AAMI	Stock	14.39	14.48	14.15	14.22	73600.0
2016-10-25	AAOI	Stock	21.52	21.613	20.83	21.15	142700.0
2016-10-25	AAON	Stock	19.8667	19.8667	19.4333	19.7	202050.0
2016-10-25	AAP	Stock	140.43	144.26	140.09	143.81	1117800.0
2016-10-25	AAT	Stock	40.34	40.34	39.9	40.02	125300.0
2016-10-25	AAU-DELISTED	Stock	1.24	1.31	1.22	1.31	263388.0
2016-10-25	AAUAF-DELISTED	Stock	1.24	1.31	1.22	1.31	267326.0
2016-10-25	AAV-DELISTED	Stock	7.33	7.39	7.21	7.22	55948.0
2016-10-25	AAWW-DELISTED	Stock	42.85	43.725	42.025	42.1	114776.0
2016-10-25	AAXJ	Stock	60.24	60.31	60.07	60.18	315024.0
2016-10-25	AAXN-DELISTED	Stock	23.64	23.73	23.05	23.19	459195.0
2016-10-25	AB	Stock	21.9	22.0	21.6	21.75	301100.0
2016-10-25	ABAC-DELISTED	Stock	2.24	2.41	2.1799	2.35	32348.0
2016-10-25	ABAX-DELISTED	Stock	53.07	53.92	50.4	50.69	228472.0
2016-10-25	ABB-DELISTED	Stock	22.13	22.17	22.06	22.12	1306249.0
2016-10-25	ABBNY-DELISTED	Stock	22.13	22.17	22.06	22.12	1714931.0
2016-10-25	ABBV	Stock	61.06	61.66	60.95	61.55	6432800.0
2016-10-25	ABC-DELISTED	Stock	79.6	80.56	79.45	80.4	1484185.0
2016-10-25	ABCB	Stock	36.25	36.48	36.0	36.45	145600.0
2016-10-25	ABCD-DELISTED	Stock	5.16	5.16	5.07	5.13	5719.0
2016-10-25	ABCO-DELISTED	Stock	42.36	42.54	41.54	41.72	110977.0
2016-10-25	ABDC-DELISTED	Stock	13.0	13.07	12.86	13.07	52092.0
2016-10-25	ABE-DELISTED	Stock	12.406	12.51	11.85	12.47	16587.0
2016-10-25	ABEO	Stock	213.75	216.25	197.5	200.0	26676.0
2016-10-25	ABEOW-DELISTED	Stock	4.59	4.59	4.2921	4.5	9050.0
2016-10-25	ABEV	Stock	6.26	6.27	6.22	6.23	10132000.0
2016-10-25	ABG	Stock	51.05	52.5	48.9	50.25	1083700.0
2016-10-25	ABIL-DELISTED	Stock	3.58	3.5889	3.58	3.5889	2300.0
2016-10-25	ABM	Stock	38.62	38.62	38.32	38.47	112700.0

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

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