PREVIEW / stock_daily / 2016-08-30

all stock daily files

  file:    by_date/stock_daily/2016/2016-08-30.parquet
  size:    219 KB
  rows:    6,558
  symbols: 3,239

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-30	AAPL	Stock	26.45	26.625	26.375	26.5	99455600.0
2016-08-30	MSFT	Stock	57.98	58.19	57.61	57.89	16930200.0
2016-08-30	NVDA	Stock	1.5478	1.556	1.5365	1.5408	285544000.0
2016-08-30	AMZN	Stock	38.5525	38.592	38.278	38.379	34184000.0
2016-08-30	GOOGL	Stock	39.644	39.9	39.4735	39.596	23348260.0
2016-08-30	META	Stock	126.6	126.6	125.15	125.84	17804300.0
2016-08-30	TSLA	Stock	14.4073	14.4073	14.0347	14.0893	47533500.0
2016-08-30	TLT	Stock	140.17	140.26	139.67	139.67	5161769.0
2016-08-30	ES	Stock	54.34	54.64	53.69	53.74	1202800.0
2016-08-30	CL	Stock	74.71	74.8	74.34	74.5	2057400.0
2016-08-30	A	Stock	47.66	47.81	47.08	47.14	2231200.0
2016-08-30	AA.B-DELISTED	Stock	35.05	35.05	34.53	34.7342	172965.0
2016-08-30	AAAP-DELISTED	Stock	34.0	35.14	33.4029	34.44	35682.0
2016-08-30	AABA-DELISTED	Stock	42.28	42.74	42.28	42.58	5370321.0
2016-08-30	AAC-DELISTED	Stock	18.73	19.34	18.71	19.3308	285137.0
2016-08-30	AACG	Stock	4.56	4.6	4.56	4.6	2900.0
2016-08-30	AAIC-DELISTED	Stock	14.69	14.86	14.63	14.84	191677.0
2016-08-30	AAL	Stock	35.45	37.35	35.35	37.05	14509300.0
2016-08-30	AAMC-DELISTED	Stock	3.8559	3.9941	3.8265	3.9765	23120.0
2016-08-30	AAME	Stock	3.65	3.65	3.35	3.54	9000.0
2016-08-30	AAMI	Stock	13.48	13.56	13.43	13.51	69300.0
2016-08-30	AAOI	Stock	15.93	17.08	15.93	16.99	274800.0
2016-08-30	AAON	Stock	18.6733	18.78	18.56	18.78	87300.0
2016-08-30	AAP	Stock	157.98	157.98	156.08	156.66	722800.0
2016-08-30	AAT	Stock	44.72	44.72	43.97	44.31	218100.0
2016-08-30	AAU-DELISTED	Stock	1.42	1.42	1.3	1.3	465969.0
2016-08-30	AAUAF-DELISTED	Stock	1.42	1.42	1.3	1.3	477738.0
2016-08-30	AAV-DELISTED	Stock	7.05	7.1	6.85	6.88	38355.0
2016-08-30	AAWW-DELISTED	Stock	35.73	36.94	35.64	36.83	294814.0
2016-08-30	AAXJ	Stock	59.23	59.44	59.03	59.12	425701.0
2016-08-30	AAXN-DELISTED	Stock	28.66	29.68	28.66	29.41	1550300.0
2016-08-30	AB	Stock	22.04	22.19	21.9	21.98	180600.0
2016-08-30	ABAC-DELISTED	Stock	0.798	0.798	0.73	0.77	27835.0
2016-08-30	ABAX-DELISTED	Stock	50.63	51.29	50.63	50.84	73056.0
2016-08-30	ABB-DELISTED	Stock	21.87	21.91	21.71	21.765	929562.0
2016-08-30	ABBNY-DELISTED	Stock	21.88	21.91	21.71	21.76	987189.0
2016-08-30	ABBV	Stock	64.54	64.71	64.11	64.16	5531800.0
2016-08-30	ABC-DELISTED	Stock	86.45	86.87	85.68	86.06	1517453.0
2016-08-30	ABCB	Stock	34.13	34.42	34.02	34.41	79900.0
2016-08-30	ABCD-DELISTED	Stock	4.87	4.87	4.79	4.8	8414.0
2016-08-30	ABCO-DELISTED	Stock	42.09	42.35	40.65	42.19	137575.0
2016-08-30	ABDC-DELISTED	Stock	12.58	12.71	12.5001	12.54	26455.0
2016-08-30	ABE-DELISTED	Stock	12.61	12.61	12.56	12.566	800.0
2016-08-30	ABEO	Stock	101.75	105.0	97.5	102.5	7896.0
2016-08-30	ABEV	Stock	5.91	5.94	5.86	5.93	10872000.0
2016-08-30	ABG	Stock	53.46	54.28	53.45	53.9	172900.0
2016-08-30	ABIL-DELISTED	Stock	4.38	4.47	4.33	4.38	21916.0
2016-08-30	ABM	Stock	38.14	38.57	38.12	38.4	196000.0
2016-08-30	ABMD-DELISTED	Stock	120.57	120.96	119.03	119.34	183421.0
2016-08-30	ABR	Stock	7.75	7.86	7.75	7.8	135500.0

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

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