PREVIEW / stock_daily / 2017-09-18

all stock daily files

  file:    by_date/stock_daily/2017/2017-09-18.parquet
  size:    215 KB
  rows:    6,459
  symbols: 2,935

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-09-18	AAPL	Stock	40.0275	40.125	39.5	39.6675	113077600.0
2017-09-18	MSFT	Stock	75.23	75.97	75.04	75.16	23307000.0
2017-09-18	NVDA	Stock	4.6285	4.78	4.6215	4.6888	1684460000.0
2017-09-18	AMZN	Stock	49.52	49.6395	48.4085	48.7095	68226000.0
2017-09-18	GOOGL	Stock	46.7505	46.843	46.27	46.4875	29473020.0
2017-09-18	META	Stock	171.99	172.07	169.34	170.01	12954000.0
2017-09-18	TSLA	Stock	25.35	25.974	25.1787	25.6667	107820000.0
2017-09-18	TLT	Stock	126.5	126.57	125.84	126.13	6862991.0
2017-09-18	ES	Stock	62.55	62.56	61.21	61.69	1450300.0
2017-09-18	CL	Stock	72.28	72.53	72.0	72.39	1950900.0
2017-09-18	A	Stock	66.09	66.3	65.7	66.08	1562000.0
2017-09-18	AA	Stock	44.8	45.09	44.66	44.91	3224800.0
2017-09-18	AAAP-DELISTED	Stock	56.93	60.99	56.88	57.76	357442.0
2017-09-18	AABA-DELISTED	Stock	66.96	67.2834	66.56	67.11	4637960.0
2017-09-18	AAC-DELISTED	Stock	11.43	11.43	10.7252	10.99	98439.0
2017-09-18	AACG	Stock	4.85	4.85	4.66	4.67	9100.0
2017-09-18	AAIC-DELISTED	Stock	13.18	13.34	13.18	13.23	517116.0
2017-09-18	AAL	Stock	46.02	46.3	45.27	45.31	4601200.0
2017-09-18	AAM.A-DELISTED	Stock	26.27	26.3	26.1997	26.3	15694.0
2017-09-18	AAMC-DELISTED	Stock	28.9559	30.3529	28.9419	29.8529	22800.0
2017-09-18	AAME	Stock	3.25	3.3	3.2	3.3	6800.0
2017-09-18	AAMI	Stock	13.72	13.83	13.65	13.77	386500.0
2017-09-18	AAOI	Stock	58.46	66.7	58.35	66.29	6230900.0
2017-09-18	AAON	Stock	22.0333	22.2333	21.8333	22.1	149100.0
2017-09-18	AAP	Stock	99.66	100.29	98.49	98.58	2072100.0
2017-09-18	AAT	Stock	40.58	40.7	40.2	40.41	277600.0
2017-09-18	AAU-DELISTED	Stock	1.19	1.1985	1.18	1.185	124710.0
2017-09-18	AAUAF-DELISTED	Stock	1.19	1.1985	1.18	1.185	128751.0
2017-09-18	AAV-DELISTED	Stock	6.4	6.45	6.3	6.4	26194.0
2017-09-18	AAWW-DELISTED	Stock	65.9	66.25	65.4	65.85	96550.0
2017-09-18	AAXJ	Stock	73.82	73.92	73.61	73.755	933999.0
2017-09-18	AAXN-DELISTED	Stock	22.34	22.68	22.3	22.4	397723.0
2017-09-18	AB	Stock	24.2	24.5	24.15	24.45	174500.0
2017-09-18	ABAC-DELISTED	Stock	2.3723	2.4	2.31	2.3207	10732.0
2017-09-18	ABAX-DELISTED	Stock	44.37	44.55	43.919	44.08	55503.0
2017-09-18	ABB-DELISTED	Stock	24.47	24.6	24.47	24.6	1743448.0
2017-09-18	ABBNY-DELISTED	Stock	24.47	24.6	24.47	24.6	2334684.0
2017-09-18	ABBV	Stock	87.47	87.81	85.08	85.32	9656700.0
2017-09-18	ABC-DELISTED	Stock	81.8	82.03	80.54	80.67	1122908.0
2017-09-18	ABCB	Stock	43.45	43.9	43.35	43.8	122600.0
2017-09-18	ABCD-DELISTED	Stock	6.14	6.32	6.0753	6.22	95082.0
2017-09-18	ABCO-DELISTED	Stock	53.6	53.65	53.325	53.4	816636.0
2017-09-18	ABDC-DELISTED	Stock	10.86	10.999	10.62	10.78	68324.0
2017-09-18	ABE-DELISTED	Stock	14.22	14.2599	14.12	14.2037	10352.0
2017-09-18	ABEO	Stock	426.25	447.5	403.75	412.5	85716.0
2017-09-18	ABEOW-DELISTED	Stock	12.45	13.1499	11.65	11.65	7800.0
2017-09-18	ABEV	Stock	6.8	6.81	6.7	6.7	18363900.0
2017-09-18	ABG	Stock	58.55	58.85	58.0	58.15	128000.0
2017-09-18	ABIL-DELISTED	Stock	0.779	0.779	0.7349	0.736	59842.0
2017-09-18	ABM	Stock	39.62	39.62	38.9	39.17	319500.0

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

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