PREVIEW / stock_daily / 2016-08-23

all stock daily files

  file:    by_date/stock_daily/2016/2016-08-23.parquet
  size:    220 KB
  rows:    6,559
  symbols: 3,237

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-23	AAPL	Stock	27.1475	27.33	27.1325	27.2125	85030800.0
2016-08-23	MSFT	Stock	57.9	58.18	57.85	57.89	18732400.0
2016-08-23	NVDA	Stock	1.576	1.583	1.5682	1.5728	339764000.0
2016-08-23	AMZN	Stock	38.1655	38.235	38.05	38.1225	30482000.0
2016-08-23	GOOGL	Stock	40.024	40.05	39.7995	39.8295	18350260.0
2016-08-23	META	Stock	124.51	125.09	124.25	124.37	13309500.0
2016-08-23	TSLA	Stock	14.9547	15.2327	14.8533	14.9893	71766000.0
2016-08-23	TLT	Stock	140.27	140.59	139.67	140.03	6841393.0
2016-08-23	ES	Stock	55.67	56.18	55.25	55.28	959400.0
2016-08-23	CL	Stock	74.48	74.84	74.42	74.54	1460600.0
2016-08-23	A	Stock	47.73	48.09	47.68	47.82	1645100.0
2016-08-23	AA.B-DELISTED	Stock	35.4401	35.8	35.39	35.75	22824.0
2016-08-23	AAAP-DELISTED	Stock	32.6	33.5	32.39	33.22	41465.0
2016-08-23	AABA-DELISTED	Stock	42.61	42.91	42.45	42.59	8515764.0
2016-08-23	AAC-DELISTED	Stock	17.9	19.03	17.9	18.75	256567.0
2016-08-23	AACG	Stock	4.5	4.5	4.09	4.5	1400.0
2016-08-23	AAIC-DELISTED	Stock	14.5	14.79	14.48	14.75	219518.0
2016-08-23	AAL	Stock	36.32	36.65	36.18	36.4	5401700.0
2016-08-23	AAMC-DELISTED	Stock	4.0324	4.0324	3.9971	3.9972	3546.0
2016-08-23	AAME	Stock	3.5	3.72	3.26	3.48	74700.0
2016-08-23	AAMI	Stock	13.58	13.72	13.5	13.69	76700.0
2016-08-23	AAOI	Stock	13.82	14.19	13.74	14.02	176000.0
2016-08-23	AAON	Stock	18.4667	18.6667	18.0733	18.58	90000.0
2016-08-23	AAP	Stock	159.37	159.91	157.76	157.94	996100.0
2016-08-23	AAT	Stock	44.91	44.95	44.55	44.57	75200.0
2016-08-23	AAU-DELISTED	Stock	1.54	1.58	1.44	1.4664	548560.0
2016-08-23	AAUAF-DELISTED	Stock	1.54	1.58	1.44	1.4664	551492.0
2016-08-23	AAV-DELISTED	Stock	7.02	7.21	7.02	7.15	66022.0
2016-08-23	AAWW-DELISTED	Stock	34.96	35.4	34.905	35.01	155348.0
2016-08-23	AAXJ	Stock	59.38	59.48	58.99	58.99	529240.0
2016-08-23	AAXN-DELISTED	Stock	29.1	29.285	28.85	28.92	699201.0
2016-08-23	AB	Stock	22.01	22.25	22.0	22.01	132200.0
2016-08-23	ABAC-DELISTED	Stock	0.8	0.89	0.7894	0.81	112520.0
2016-08-23	ABAX-DELISTED	Stock	50.15	50.69	50.15	50.25	53075.0
2016-08-23	ABB-DELISTED	Stock	22.13	22.19	22.06	22.08	818127.0
2016-08-23	ABBNY-DELISTED	Stock	22.13	22.19	22.06	22.07	846147.0
2016-08-23	ABBV	Stock	67.26	67.49	65.99	66.17	10227800.0
2016-08-23	ABC-DELISTED	Stock	89.14	89.23	88.83	88.96	536272.0
2016-08-23	ABCB	Stock	33.93	34.03	33.73	33.81	130600.0
2016-08-23	ABCD-DELISTED	Stock	4.82	4.83	4.72	4.74	28158.0
2016-08-23	ABCO-DELISTED	Stock	41.65	42.42	41.65	42.03	342479.0
2016-08-23	ABDC-DELISTED	Stock	12.48	12.5	12.45	12.47	31823.0
2016-08-23	ABE-DELISTED	Stock	12.796	12.796	12.7177	12.7177	1700.0
2016-08-23	ABEO	Stock	102.5	108.5	102.5	107.0	1624.0
2016-08-23	ABEOW-DELISTED	Stock	2.08	2.08	1.9	2.0499	2600.0
2016-08-23	ABEV	Stock	6.15	6.18	6.06	6.07	11356300.0
2016-08-23	ABG	Stock	53.08	53.64	53.0	53.55	181700.0
2016-08-23	ABIL-DELISTED	Stock	4.19	4.3272	4.19	4.26	18315.0
2016-08-23	ABM	Stock	38.27	38.59	38.24	38.35	168000.0
2016-08-23	ABMD-DELISTED	Stock	121.01	121.48	120.57	121.03	302409.0

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

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