PREVIEW / stock_daily / 2016-08-31

all stock daily files

  file:    by_date/stock_daily/2016/2016-08-31.parquet
  size:    220 KB
  rows:    6,577
  symbols: 3,253

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-08-31	AAPL	Stock	26.415	26.6425	26.41	26.525	118649600.0
2016-08-31	MSFT	Stock	57.65	57.8	57.3	57.46	20860300.0
2016-08-31	NVDA	Stock	1.5438	1.548	1.529	1.5335	388544000.0
2016-08-31	AMZN	Stock	38.33	38.482	38.2	38.458	32676000.0
2016-08-31	GOOGL	Stock	39.48	39.5785	39.36	39.4925	21428400.0
2016-08-31	META	Stock	125.6	126.22	125.1	126.12	14200600.0
2016-08-31	TSLA	Stock	14.0287	14.1733	13.91	14.134	49147500.0
2016-08-31	TLT	Stock	139.66	140.17	139.34	139.87	7349658.0
2016-08-31	ES	Stock	53.71	53.98	53.58	53.97	1503100.0
2016-08-31	CL	Stock	74.47	74.58	74.0	74.34	2597400.0
2016-08-31	A	Stock	47.12	47.19	46.81	46.98	1676600.0
2016-08-31	AA.B-DELISTED	Stock	34.6	35.1299	34.4	34.41	30902.0
2016-08-31	AAAP-DELISTED	Stock	34.08	34.9299	33.85	34.685	27435.0
2016-08-31	AABA-DELISTED	Stock	42.51	42.8	42.46	42.74	6916667.0
2016-08-31	AAC-DELISTED	Stock	19.4931	19.59	18.87	19.55	161562.0
2016-08-31	AACG	Stock	4.6	4.63	4.24	4.24	1300.0
2016-08-31	AAIC-DELISTED	Stock	14.84	14.91	14.69	14.88	156898.0
2016-08-31	AAL	Stock	36.97	36.98	35.63	36.3	13111700.0
2016-08-31	AAMC-DELISTED	Stock	3.9706	4.2059	3.9559	4.1559	38991.0
2016-08-31	AAME	Stock	3.42	3.62	3.42	3.62	8800.0
2016-08-31	AAMI	Stock	13.57	13.74	13.42	13.5	177400.0
2016-08-31	AAOI	Stock	17.06	17.25	16.67	16.85	367900.0
2016-08-31	AAON	Stock	18.7533	19.04	18.4733	18.8667	325650.0
2016-08-31	AAP	Stock	156.79	157.86	155.89	157.38	699500.0
2016-08-31	AAT	Stock	44.42	44.65	43.94	44.3	247100.0
2016-08-31	AAU-DELISTED	Stock	1.3	1.34	1.3	1.32	374862.0
2016-08-31	AAUAF-DELISTED	Stock	1.3	1.34	1.3	1.32	376896.0
2016-08-31	AAV-DELISTED	Stock	6.86	6.88	6.68	6.83	96667.0
2016-08-31	AAWW-DELISTED	Stock	37.04	37.26	36.25	37.14	379089.0
2016-08-31	AAXJ	Stock	58.94	58.94	58.53	58.68	641404.0
2016-08-31	AAXN-DELISTED	Stock	29.37	29.38	26.6101	27.075	2664759.0
2016-08-31	AB	Stock	21.94	22.09	21.75	21.89	221400.0
2016-08-31	ABAC-DELISTED	Stock	0.77	0.78	0.7302	0.78	10583.0
2016-08-31	ABAX-DELISTED	Stock	50.67	50.94	49.9311	50.14	69402.0
2016-08-31	ABB-DELISTED	Stock	21.72	21.765	21.6001	21.67	912031.0
2016-08-31	ABBNY-DELISTED	Stock	21.72	21.765	21.6001	21.67	940767.0
2016-08-31	ABBV	Stock	64.21	64.45	63.5	64.1	6750000.0
2016-08-31	ABC-DELISTED	Stock	86.13	87.075	85.73	86.94	2420424.0
2016-08-31	ABCB	Stock	34.6	34.9	34.32	34.82	243400.0
2016-08-31	ABCD-DELISTED	Stock	4.76	4.84	4.75	4.81	6871.0
2016-08-31	ABCO-DELISTED	Stock	42.0	42.4	41.7	42.15	153899.0
2016-08-31	ABDC-DELISTED	Stock	12.59	12.68	12.5	12.59	37973.0
2016-08-31	ABE-DELISTED	Stock	12.55	12.56	12.5	12.5172	3600.0
2016-08-31	ABEO	Stock	101.0	103.25	98.75	101.5	4980.0
2016-08-31	ABEOW-DELISTED	Stock	1.87	1.87	1.87	1.87	400.0
2016-08-31	ABEV	Stock	5.92	5.95	5.85	5.93	20065400.0
2016-08-31	ABG	Stock	53.68	54.58	53.23	53.72	143500.0
2016-08-31	ABIL-DELISTED	Stock	4.31	4.5	4.3099	4.39	40697.0
2016-08-31	ABM	Stock	38.41	38.49	37.99	38.43	200400.0
2016-08-31	ABMD-DELISTED	Stock	119.5	119.5	117.6	117.94	262765.0

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

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