PREVIEW / stock_daily / 2017-11-17

all stock daily files

  file:    by_date/stock_daily/2017/2017-11-17.parquet
  size:    216 KB
  rows:    6,482
  symbols: 2,909

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-11-17	AAPL	Stock	42.76	42.8475	42.41	42.5375	87598000.0
2017-11-17	MSFT	Stock	83.12	83.12	82.24	82.4	22079000.0
2017-11-17	NVDA	Stock	5.348	5.3838	5.2688	5.284	515664000.0
2017-11-17	AMZN	Stock	56.914	56.94	56.2905	56.494	48268000.0
2017-11-17	GOOGL	Stock	52.49	52.55	51.6865	51.7945	26712200.0
2017-11-17	META	Stock	179.3	179.98	178.9	179.0	13018000.0
2017-11-17	TSLA	Stock	21.7113	21.778	20.8767	21.0033	206026500.0
2017-11-17	TLT	Stock	126.07	126.44	125.96	126.39	6938792.0
2017-11-17	ES	Stock	64.62	64.89	64.06	64.21	1602400.0
2017-11-17	CL	Stock	72.31	72.62	71.78	71.89	4627400.0
2017-11-17	A	Stock	68.53	69.09	68.29	68.79	1823100.0
2017-11-17	AA	Stock	42.0	43.6	42.0	43.4	3569000.0
2017-11-17	AAAP-DELISTED	Stock	81.02	81.37	81.02	81.18	315204.0
2017-11-17	AABA-DELISTED	Stock	70.81	71.37	70.74	70.97	11118395.0
2017-11-17	AAC-DELISTED	Stock	9.97	10.1	9.79	9.8	122778.0
2017-11-17	AACG	Stock	4.37	4.41	4.37	4.39	1000.0
2017-11-17	AAIC-DELISTED	Stock	11.41	11.5348	11.395	11.47	375573.0
2017-11-17	AAL	Stock	47.6	47.75	47.19	47.39	2324800.0
2017-11-17	AAM.A-DELISTED	Stock	26.32	26.43	26.28	26.39	19743.0
2017-11-17	AAMC-DELISTED	Stock	22.5735	22.5735	22.2794	22.5368	2941.0
2017-11-17	AAME	Stock	3.8	3.8	3.6	3.6	1500.0
2017-11-17	AAMI	Stock	15.74	16.07	15.74	15.92	945900.0
2017-11-17	AAOI	Stock	44.54	45.27	44.28	45.04	1026200.0
2017-11-17	AAON	Stock	22.7	23.2	22.4	22.9667	184200.0
2017-11-17	AAP	Stock	91.02	91.44	89.13	89.27	1549200.0
2017-11-17	AAT	Stock	39.45	39.78	39.38	39.46	240200.0
2017-11-17	AAU-DELISTED	Stock	0.86	0.9249	0.86	0.92	204174.0
2017-11-17	AAUAF-DELISTED	Stock	0.86	0.9249	0.86	0.92	217359.0
2017-11-17	AAV-DELISTED	Stock	5.15	5.2	5.1	5.175	77700.0
2017-11-17	AAWW-DELISTED	Stock	53.65	53.95	53.15	53.6	95982.0
2017-11-17	AAXJ	Stock	76.67	76.9162	76.66	76.7	781547.0
2017-11-17	AAXN-DELISTED	Stock	22.5	23.45	22.49	23.13	1047290.0
2017-11-17	AB	Stock	25.6	25.7	25.4	25.4	136300.0
2017-11-17	ABAC-DELISTED	Stock	2.9439	3.18	2.9101	2.99	6500.0
2017-11-17	ABAX-DELISTED	Stock	48.29	49.68	47.135	49.37	140152.0
2017-11-17	ABB-DELISTED	Stock	25.1	25.29	25.02	25.23	1550912.0
2017-11-17	ABBNY-DELISTED	Stock	25.1	25.29	25.02	25.23	1617757.0
2017-11-17	ABBV	Stock	93.8	94.49	93.57	93.61	3386400.0
2017-11-17	ABC-DELISTED	Stock	79.65	80.03	77.58	78.83	1907383.0
2017-11-17	ABCB	Stock	46.85	47.1	46.25	46.8	397300.0
2017-11-17	ABCD-DELISTED	Stock	5.76	5.76	5.45	5.54	68750.0
2017-11-17	ABCO-DELISTED	Stock	53.75	53.85	53.75	53.825	886047.0
2017-11-17	ABDC-DELISTED	Stock	7.5	8.07	7.5	7.81	300674.0
2017-11-17	ABE-DELISTED	Stock	14.22	14.4099	14.19	14.2548	16880.0
2017-11-17	ABEO	Stock	400.0	400.0	383.75	385.0	15996.0
2017-11-17	ABEOW-DELISTED	Stock	10.95	10.95	10.95	10.95	400.0
2017-11-17	ABEV	Stock	6.2	6.28	6.15	6.24	17121300.0
2017-11-17	ABG	Stock	61.8	62.45	61.15	61.75	243700.0
2017-11-17	ABIL-DELISTED	Stock	0.57	0.57	0.5001	0.5301	296887.0
2017-11-17	ABLX-DELISTED	Stock	20.62	21.63	20.59	21.15	201080.0

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

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