PREVIEW / stock_daily / 2017-10-11

all stock daily files

  file:    by_date/stock_daily/2017/2017-10-11.parquet
  size:    215 KB
  rows:    6,448
  symbols: 2,920

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-10-11	AAPL	Stock	38.9925	39.245	38.9375	39.1375	67622400.0
2017-10-11	MSFT	Stock	76.36	76.46	75.95	76.42	15388900.0
2017-10-11	NVDA	Stock	4.74	4.775	4.6935	4.7735	529508000.0
2017-10-11	AMZN	Stock	49.5635	49.775	49.335	49.75	46742000.0
2017-10-11	GOOGL	Stock	49.452	50.3783	49.397	50.2825	36299980.0
2017-10-11	META	Stock	171.95	172.78	171.4	172.74	11283700.0
2017-10-11	TSLA	Stock	23.5927	23.84	23.41	23.64	67512000.0
2017-10-11	TLT	Stock	124.57	124.66	124.26	124.42	4385859.0
2017-10-11	ES	Stock	60.66	61.42	60.54	61.3	1832900.0
2017-10-11	CL	Stock	74.44	75.15	74.14	74.73	6491400.0
2017-10-11	A	Stock	66.68	66.97	66.34	66.62	1794800.0
2017-10-11	AA	Stock	46.72	47.0	46.21	46.94	2728000.0
2017-10-11	AAAP-DELISTED	Stock	66.2	68.0	66.04	67.15	62920.0
2017-10-11	AABA-DELISTED	Stock	68.75	69.38	68.75	69.23	3781452.0
2017-10-11	AAC-DELISTED	Stock	8.26	8.37	7.68	7.79	342590.0
2017-10-11	AACG	Stock	4.64	4.7	4.64	4.7	1100.0
2017-10-11	AAIC-DELISTED	Stock	12.67	12.7	12.59	12.7	464159.0
2017-10-11	AAL	Stock	53.1	53.74	52.33	52.83	5396800.0
2017-10-11	AAM.A-DELISTED	Stock	25.86	25.97	25.786	25.94	21302.0
2017-10-11	AAMC-DELISTED	Stock	24.8676	24.8676	24.8529	24.8529	2421.0
2017-10-11	AAME	Stock	3.4	3.4	3.25	3.3	2200.0
2017-10-11	AAMI	Stock	15.31	15.36	15.18	15.26	458800.0
2017-10-11	AAOI	Stock	60.45	62.3	60.38	61.44	1639900.0
2017-10-11	AAON	Stock	23.1667	23.3333	22.7333	22.8333	246450.0
2017-10-11	AAP	Stock	91.7	92.16	89.18	89.4	1527600.0
2017-10-11	AAT	Stock	40.83	41.43	40.83	41.37	180200.0
2017-10-11	AAU-DELISTED	Stock	1.2	1.22	1.16	1.171	116976.0
2017-10-11	AAUAF-DELISTED	Stock	1.2	1.22	1.16	1.171	135460.0
2017-10-11	AAV-DELISTED	Stock	5.65	5.725	5.6	5.7	114054.0
2017-10-11	AAWW-DELISTED	Stock	65.2	66.0	65.05	65.7	188801.0
2017-10-11	AAXJ	Stock	74.29	74.645	74.21	74.61	1174411.0
2017-10-11	AAXN-DELISTED	Stock	23.77	24.0	23.77	23.92	390425.0
2017-10-11	AB	Stock	24.85	25.45	24.85	25.25	198300.0
2017-10-11	ABAC-DELISTED	Stock	3.56	3.56	3.3055	3.42	12285.0
2017-10-11	ABAX-DELISTED	Stock	45.7	46.24	45.7	45.97	50566.0
2017-10-11	ABB-DELISTED	Stock	25.17	25.2	25.1	25.17	693324.0
2017-10-11	ABBNY-DELISTED	Stock	25.17	25.2	25.1	25.17	734420.0
2017-10-11	ABBV	Stock	91.47	92.61	90.97	92.38	6298500.0
2017-10-11	ABC-DELISTED	Stock	79.45	80.5	79.25	80.31	855582.0
2017-10-11	ABCB	Stock	50.8	51.15	50.7	50.7	227900.0
2017-10-11	ABCD-DELISTED	Stock	6.51	6.585	6.42	6.48	21876.0
2017-10-11	ABCO-DELISTED	Stock	53.65	54.05	53.65	53.9	1273230.0
2017-10-11	ABDC-DELISTED	Stock	10.55	10.61	10.41	10.52	29499.0
2017-10-11	ABE-DELISTED	Stock	14.65	14.7015	14.62	14.68	13937.0
2017-10-11	ABEO	Stock	511.25	568.75	455.0	483.75	128596.0
2017-10-11	ABEOW-DELISTED	Stock	15.85	17.56	13.95	14.22	79360.0
2017-10-11	ABEV	Stock	6.8	6.81	6.72	6.79	26318000.0
2017-10-11	ABG	Stock	60.5	60.8	58.35	58.55	132300.0
2017-10-11	ABIL-DELISTED	Stock	0.765	0.79	0.75	0.7582	66508.0
2017-10-11	ABM	Stock	42.98	43.2	42.87	43.07	194800.0

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

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