PREVIEW / stock_daily / 2017-02-17

all stock daily files

  file:    by_date/stock_daily/2017/2017-02-17.parquet
  size:    215 KB
  rows:    6,475
  symbols: 3,075

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
2017-02-17	AAPL	Stock	33.775	33.9575	33.775	33.93	88792800.0
2017-02-17	MSFT	Stock	64.47	64.69	64.3	64.62	21248800.0
2017-02-17	NVDA	Stock	2.6675	2.6852	2.6198	2.6808	563740000.0
2017-02-17	AMZN	Stock	42.1	42.3635	42.0365	42.2535	62246000.0
2017-02-17	GOOGL	Stock	42.0655	42.347	41.989	42.3275	29224200.0
2017-02-17	META	Stock	133.5	134.09	133.17	133.53	12276500.0
2017-02-17	TSLA	Stock	17.72	18.1927	17.61	18.1487	93856500.0
2017-02-17	TLT	Stock	120.61	120.7	120.13	120.32	7886448.0
2017-02-17	ES	Stock	56.3	56.46	55.87	56.15	1529500.0
2017-02-17	CL	Stock	70.95	72.87	70.58	71.98	15036900.0
2017-02-17	A	Stock	50.65	51.64	50.58	51.63	2195500.0
2017-02-17	AA	Stock	36.24	36.61	35.79	36.21	4516800.0
2017-02-17	AAAP-DELISTED	Stock	35.91	36.23	35.59	36.2	143250.0
2017-02-17	AABA-DELISTED	Stock	44.95	45.34	44.79	45.09	7735012.0
2017-02-17	AAC-DELISTED	Stock	8.01	8.13	7.78	8.12	73693.0
2017-02-17	AACG	Stock	3.7	3.71	3.7	3.71	6200.0
2017-02-17	AAIC-DELISTED	Stock	14.89	14.94	14.73	14.94	284703.0
2017-02-17	AAL	Stock	46.83	47.1	46.43	46.91	4581600.0
2017-02-17	AAMC-DELISTED	Stock	21.8529	22.6471	21.8529	22.6029	25194.0
2017-02-17	AAME	Stock	3.75	3.9	3.75	3.9	900.0
2017-02-17	AAMI	Stock	14.99	15.15	14.8	15.08	207900.0
2017-02-17	AAOI	Stock	35.43	37.73	35.057	37.27	628900.0
2017-02-17	AAON	Stock	23.3333	23.3333	22.8333	22.9	250350.0
2017-02-17	AAP	Stock	160.61	161.88	159.75	161.58	1561300.0
2017-02-17	AAT	Stock	43.6	43.65	42.92	43.2	186800.0
2017-02-17	AAU-DELISTED	Stock	1.23	1.24	1.2	1.21	190982.0
2017-02-17	AAUAF-DELISTED	Stock	1.23	1.24	1.2	1.21	193469.0
2017-02-17	AAV-DELISTED	Stock	6.55	6.595	6.4	6.4	64625.0
2017-02-17	AAWW-DELISTED	Stock	53.95	54.55	53.45	53.65	116155.0
2017-02-17	AAXJ	Stock	60.41	60.59	60.34	60.59	721524.0
2017-02-17	AAXN-DELISTED	Stock	26.5	26.6889	26.29	26.49	656781.0
2017-02-17	AB	Stock	23.85	24.3	23.5	24.2	419000.0
2017-02-17	ABAC-DELISTED	Stock	3.17	3.46	2.57	2.7	128928.0
2017-02-17	ABAX-DELISTED	Stock	49.11	49.69	48.92	49.66	69636.0
2017-02-17	ABB-DELISTED	Stock	22.74	22.83	22.692	22.825	1801512.0
2017-02-17	ABBNY-DELISTED	Stock	22.74	22.83	22.692	22.82	1859657.0
2017-02-17	ABBV	Stock	61.54	62.08	61.17	61.77	8124400.0
2017-02-17	ABC-DELISTED	Stock	90.24	90.88	89.72	90.75	1237899.0
2017-02-17	ABCB	Stock	48.4	49.0	47.95	48.75	205500.0
2017-02-17	ABCD-DELISTED	Stock	4.69	4.83	4.69	4.8	57180.0
2017-02-17	ABCO-DELISTED	Stock	46.9	47.2	45.95	46.1	670091.0
2017-02-17	ABDC-DELISTED	Stock	12.88	12.88	12.51	12.7	44970.0
2017-02-17	ABE-DELISTED	Stock	11.91	12.01	11.9	11.99	30075.0
2017-02-17	ABEO	Stock	156.25	156.25	137.0	150.0	24440.0
2017-02-17	ABEOW-DELISTED	Stock	3.2775	3.28	3.2	3.2	1900.0
2017-02-17	ABEV	Stock	5.72	5.78	5.71	5.72	13799000.0
2017-02-17	ABG	Stock	65.9	67.55	65.5	67.55	160600.0
2017-02-17	ABIL-DELISTED	Stock	2.88	2.88	2.8345	2.8489	4200.0
2017-02-17	ABM	Stock	40.74	40.74	40.27	40.39	226200.0
2017-02-17	ABMD-DELISTED	Stock	114.01	116.92	112.2	116.6	464766.0

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

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