PREVIEW / stock_daily / 2017-11-07

all stock daily files

  file:    by_date/stock_daily/2017/2017-11-07.parquet
  size:    215 KB
  rows:    6,476
  symbols: 2,917

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-07	AAPL	Stock	43.4775	43.8125	43.4	43.7025	97446000.0
2017-11-07	MSFT	Stock	84.77	84.9	83.93	84.27	17939700.0
2017-11-07	NVDA	Stock	5.2638	5.3225	5.2515	5.3008	427700000.0
2017-11-07	AMZN	Stock	56.237	56.53	55.875	56.1585	53780000.0
2017-11-07	GOOGL	Stock	52.4825	52.6705	52.15	52.6195	26104580.0
2017-11-07	META	Stock	180.5	180.75	178.96	180.25	12928200.0
2017-11-07	TSLA	Stock	20.068	20.4333	20.002	20.4033	79414500.0
2017-11-07	TLT	Stock	126.23	126.78	126.13	126.64	6422666.0
2017-11-07	ES	Stock	64.0	64.61	63.58	64.52	1990200.0
2017-11-07	CL	Stock	70.28	71.1	69.86	70.9	3351200.0
2017-11-07	A	Stock	68.32	68.64	68.04	68.25	956500.0
2017-11-07	AA	Stock	47.11	47.204	46.54	46.97	2168900.0
2017-11-07	AAAP-DELISTED	Stock	80.95	81.08	80.95	81.0	788251.0
2017-11-07	AABA-DELISTED	Stock	72.2	72.47	71.62	72.22	8355882.0
2017-11-07	AAC-DELISTED	Stock	11.14	11.14	10.41	11.08	157569.0
2017-11-07	AACG	Stock	4.17	4.69	4.17	4.66	1500.0
2017-11-07	AAIC-DELISTED	Stock	11.15	11.23	11.07	11.1	492327.0
2017-11-07	AAL	Stock	47.51	47.54	46.4	46.46	3756400.0
2017-11-07	AAM.A-DELISTED	Stock	26.44	26.44	26.32	26.44	37294.0
2017-11-07	AAMC-DELISTED	Stock	23.7059	23.8235	23.5588	23.8235	4423.0
2017-11-07	AAME	Stock	3.4	3.4	3.4	3.4	200.0
2017-11-07	AAMI	Stock	15.88	15.99	15.42	15.46	349200.0
2017-11-07	AAOI	Stock	37.98	38.6	36.97	37.89	3508200.0
2017-11-07	AAON	Stock	23.1	23.1667	22.9333	23.0667	270450.0
2017-11-07	AAP	Stock	80.66	80.83	78.9	79.38	1261600.0
2017-11-07	AAT	Stock	38.64	39.12	38.56	38.98	454600.0
2017-11-07	AAU-DELISTED	Stock	0.96	0.99	0.92	0.9595	236391.0
2017-11-07	AAUAF-DELISTED	Stock	0.96	0.99	0.92	0.9595	252667.0
2017-11-07	AAV-DELISTED	Stock	5.75	5.75	5.575	5.65	104010.0
2017-11-07	AAWW-DELISTED	Stock	56.05	57.85	55.65	56.05	887906.0
2017-11-07	AAXJ	Stock	76.49	76.58	76.09	76.18	1627277.0
2017-11-07	AAXN-DELISTED	Stock	23.2	23.35	22.84	22.86	794719.0
2017-11-07	AB	Stock	25.4	25.45	24.85	25.0	230500.0
2017-11-07	ABAC-DELISTED	Stock	3.3941	3.44	3.26	3.354	30350.0
2017-11-07	ABAX-DELISTED	Stock	47.16	47.16	45.0	45.74	99359.0
2017-11-07	ABB-DELISTED	Stock	26.24	26.2868	26.09	26.26	1503769.0
2017-11-07	ABBNY-DELISTED	Stock	26.24	26.2868	26.09	26.26	1737900.0
2017-11-07	ABBV	Stock	92.98	95.68	92.96	93.96	7014000.0
2017-11-07	ABC-DELISTED	Stock	74.92	75.73	74.56	74.92	1564111.0
2017-11-07	ABCB	Stock	47.8	48.05	46.3	46.65	160700.0
2017-11-07	ABCD-DELISTED	Stock	6.27	6.27	6.01	6.15	27484.0
2017-11-07	ABCO-DELISTED	Stock	53.15	53.525	53.15	53.4	962117.0
2017-11-07	ABDC-DELISTED	Stock	8.18	8.78	8.0	8.3	278881.0
2017-11-07	ABE-DELISTED	Stock	14.44	14.44	14.4	14.4	6589.0
2017-11-07	ABEO	Stock	408.75	415.0	356.25	358.25	66228.0
2017-11-07	ABEOW-DELISTED	Stock	11.5086	11.5086	9.5	9.5	7717.0
2017-11-07	ABEV	Stock	6.23	6.23	6.07	6.12	30408900.0
2017-11-07	ABG	Stock	61.55	62.0	60.15	60.85	150600.0
2017-11-07	ABIL-DELISTED	Stock	0.67	0.67	0.61	0.62	67799.0
2017-11-07	ABLX-DELISTED	Stock	20.79	21.0402	20.68	20.925	287349.0

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

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