PREVIEW / stock_daily / 2017-02-02

all stock daily files

  file:    by_date/stock_daily/2017/2017-02-02.parquet
  size:    216 KB
  rows:    6,486
  symbols: 3,083

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-02	AAPL	Stock	31.995	32.3475	31.945	32.1325	134841600.0
2017-02-02	MSFT	Stock	63.25	63.41	62.75	63.17	45827000.0
2017-02-02	NVDA	Stock	2.8325	2.8935	2.8015	2.8848	483240000.0
2017-02-02	AMZN	Stock	41.8295	42.1245	41.413	41.9975	147010000.0
2017-02-02	GOOGL	Stock	40.75	41.228	40.6026	40.913	33783580.0
2017-02-02	META	Stock	133.22	135.49	130.4	130.84	54366400.0
2017-02-02	TSLA	Stock	16.556	16.828	16.514	16.77	37497000.0
2017-02-02	TLT	Stock	119.93	120.135	119.0	119.05	6978567.0
2017-02-02	ES	Stock	54.77	55.41	54.55	55.35	1099900.0
2017-02-02	CL	Stock	65.09	66.02	64.82	65.68	7063600.0
2017-02-02	A	Stock	48.88	49.0	48.47	48.9	1352200.0
2017-02-02	AA	Stock	36.7	38.37	36.63	37.68	5049700.0
2017-02-02	AAAP-DELISTED	Stock	33.0	33.96	33.0	33.6	64057.0
2017-02-02	AABA-DELISTED	Stock	43.63	43.995	43.58	43.69	4679945.0
2017-02-02	AAC-DELISTED	Stock	7.95	8.18	7.8543	8.03	109019.0
2017-02-02	AACG	Stock	3.25	3.75	3.25	3.52	33000.0
2017-02-02	AAIC-DELISTED	Stock	14.96	15.085	14.91	15.08	299254.0
2017-02-02	AAL	Stock	43.61	44.52	43.57	44.01	7607700.0
2017-02-02	AAMC-DELISTED	Stock	19.0294	24.6471	18.7353	23.6733	47488.0
2017-02-02	AAME	Stock	3.85	3.85	3.85	3.85	500.0
2017-02-02	AAMI	Stock	14.37	14.94	14.25	14.89	748000.0
2017-02-02	AAOI	Stock	30.95	31.7	30.444	31.31	384500.0
2017-02-02	AAON	Stock	22.6	22.6	22.2667	22.3333	151650.0
2017-02-02	AAP	Stock	160.09	163.05	160.0	162.34	1485400.0
2017-02-02	AAT	Stock	42.29	42.9	42.23	42.5	478500.0
2017-02-02	AAU-DELISTED	Stock	1.1	1.18	1.0882	1.16	735742.0
2017-02-02	AAUAF-DELISTED	Stock	1.1	1.18	1.0882	1.16	748593.0
2017-02-02	AAV-DELISTED	Stock	6.45	6.55	6.4	6.45	61878.0
2017-02-02	AAWW-DELISTED	Stock	52.7	52.7	51.7	52.35	127984.0
2017-02-02	AAXJ	Stock	59.12	59.29	59.09	59.24	582896.0
2017-02-02	AAXN-DELISTED	Stock	25.18	25.99	25.13	25.72	687072.0
2017-02-02	AB	Stock	23.3	23.7	23.3	23.6	306900.0
2017-02-02	ABAC-DELISTED	Stock	3.5424	3.5424	3.33	3.52	8300.0
2017-02-02	ABAX-DELISTED	Stock	50.67	51.22	50.606	50.95	76013.0
2017-02-02	ABB-DELISTED	Stock	23.69	23.7261	23.632	23.66	1400202.0
2017-02-02	ABBNY-DELISTED	Stock	23.69	23.7261	23.632	23.67	1530060.0
2017-02-02	ABBV	Stock	60.65	61.12	60.48	60.89	5365300.0
2017-02-02	ABC-DELISTED	Stock	88.05	88.78	86.57	88.09	3426508.0
2017-02-02	ABCB	Stock	44.65	45.1	44.25	44.85	172200.0
2017-02-02	ABCD-DELISTED	Stock	5.05	5.26	4.88	5.1	86901.0
2017-02-02	ABCO-DELISTED	Stock	46.0	51.225	45.825	47.05	1742487.0
2017-02-02	ABDC-DELISTED	Stock	11.88	12.02	11.71	12.0	30262.0
2017-02-02	ABE-DELISTED	Stock	11.8	11.885	11.73	11.82	27288.0
2017-02-02	ABEO	Stock	117.5	125.75	117.5	122.5	10972.0
2017-02-02	ABEOW-DELISTED	Stock	2.9	3.0	2.8	3.0	2936.0
2017-02-02	ABEV	Stock	5.49	5.5	5.42	5.45	8520600.0
2017-02-02	ABG	Stock	65.0	66.2	64.0	64.7	236900.0
2017-02-02	ABIL-DELISTED	Stock	3.23	3.23	3.2	3.2	11600.0
2017-02-02	ABM	Stock	40.17	40.2	39.68	40.03	293900.0
2017-02-02	ABMD-DELISTED	Stock	104.55	105.08	103.53	104.07	582654.0

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

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