PREVIEW / stock_daily / 2016-09-30

all stock daily files

  file:    by_date/stock_daily/2016/2016-09-30.parquet
  size:    219 KB
  rows:    6,510
  symbols: 3,190

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
2016-09-30	AAPL	Stock	28.115	28.3425	27.95	28.2625	145516400.0
2016-09-30	MSFT	Stock	57.57	57.77	57.34	57.6	29910800.0
2016-09-30	NVDA	Stock	1.6942	1.7298	1.6843	1.713	429932000.0
2016-09-30	AMZN	Stock	41.6305	41.9975	41.62	41.8655	88612000.0
2016-09-30	GOOGL	Stock	40.18	40.4045	40.075	40.203	33204020.0
2016-09-30	META	Stock	128.03	128.59	127.45	128.27	18402900.0
2016-09-30	TSLA	Stock	13.4807	13.6653	13.3033	13.602	38794500.0
2016-09-30	TLT	Stock	138.55	138.64	136.87	137.51	11747119.0
2016-09-30	ES	Stock	54.91	55.22	53.81	54.18	2550600.0
2016-09-30	CL	Stock	73.55	74.5	73.51	74.14	4652300.0
2016-09-30	A	Stock	46.5	47.32	46.3	47.09	1754300.0
2016-09-30	AA.B-DELISTED	Stock	32.59	32.98	32.4201	32.84	40341.0
2016-09-30	AAAP-DELISTED	Stock	38.4	38.4899	37.68	37.81	60540.0
2016-09-30	AABA-DELISTED	Stock	42.74	43.25	42.72	43.09	9622113.0
2016-09-30	AAC-DELISTED	Stock	17.05	17.55	16.9508	17.39	100126.0
2016-09-30	AACG	Stock	4.07	4.31	4.06	4.08	35600.0
2016-09-30	AAIC-DELISTED	Stock	14.65	14.85	14.52	14.79	262749.0
2016-09-30	AAL	Stock	35.98	36.99	35.86	36.61	7429300.0
2016-09-30	AAMC-DELISTED	Stock	4.8618	5.6617	4.7824	5.4412	118759.0
2016-09-30	AAME	Stock	3.32	3.32	3.24	3.24	3400.0
2016-09-30	AAMI	Stock	13.57	13.98	13.55	13.91	126900.0
2016-09-30	AAOI	Stock	20.77	22.4	20.77	22.21	636400.0
2016-09-30	AAON	Stock	18.94	19.3467	18.86	19.2133	258750.0
2016-09-30	AAP	Stock	147.11	149.51	146.26	149.12	1065500.0
2016-09-30	AAT	Stock	44.0	44.0	43.33	43.38	238500.0
2016-09-30	AAU-DELISTED	Stock	1.43	1.44	1.4	1.4	190071.0
2016-09-30	AAUAF-DELISTED	Stock	1.43	1.44	1.4	1.4	192805.0
2016-09-30	AAV-DELISTED	Stock	6.97	7.07	6.96	7.02	55519.0
2016-09-30	AAWW-DELISTED	Stock	42.34	43.14	41.81	42.78	280714.0
2016-09-30	AAXJ	Stock	60.32	60.67	60.19	60.52	936745.0
2016-09-30	AAXN-DELISTED	Stock	28.93	28.99	28.57	28.61	1832280.0
2016-09-30	AB	Stock	22.22	22.98	22.22	22.8	201500.0
2016-09-30	ABAC-DELISTED	Stock	2.03	2.17	1.88	1.94	32070.0
2016-09-30	ABAX-DELISTED	Stock	50.88	51.94	50.48	51.58	83406.0
2016-09-30	ABB-DELISTED	Stock	22.28	22.545	22.27	22.51	2410019.0
2016-09-30	ABBNY-DELISTED	Stock	22.28	22.545	22.27	22.51	2473389.0
2016-09-30	ABBV	Stock	62.67	63.26	62.45	63.07	7325400.0
2016-09-30	ABC-DELISTED	Stock	81.24	81.64	79.34	80.77	2651468.0
2016-09-30	ABCB	Stock	34.4	35.12	34.12	34.95	202300.0
2016-09-30	ABCD-DELISTED	Stock	5.3222	5.45	5.3104	5.43	29835.0
2016-09-30	ABCO-DELISTED	Stock	44.1	45.0	43.72	44.74	146342.0
2016-09-30	ABDC-DELISTED	Stock	13.19	13.2	12.92	13.04	45966.0
2016-09-30	ABE-DELISTED	Stock	12.58	12.64	12.57	12.64	4235.0
2016-09-30	ABEO	Stock	149.25	150.0	145.5	150.0	6608.0
2016-09-30	ABEOW-DELISTED	Stock	3.35	3.36	3.25	3.25	600.0
2016-09-30	ABEV	Stock	6.1	6.15	6.05	6.09	8651000.0
2016-09-30	ABG	Stock	54.58	56.05	54.04	55.67	171300.0
2016-09-30	ABIL-DELISTED	Stock	3.76	3.85	3.725	3.8401	1220.0
2016-09-30	ABM	Stock	39.29	39.9	39.19	39.7	267400.0
2016-09-30	ABMD-DELISTED	Stock	128.63	129.84	127.81	128.58	288400.0

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

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