PREVIEW / stock_daily / 2015-08-21

all stock daily files

  file:    by_date/stock_daily/2015/2015-08-21.parquet
  size:    225 KB
  rows:    6,688
  symbols: 3,474

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
2015-08-21	AAPL	Stock	27.6075	27.975	26.4125	26.44	513102000.0
2015-08-21	MSFT	Stock	45.3	45.48	43.07	43.07	70053100.0
2015-08-21	NVDA	Stock	0.55	0.5592	0.5362	0.5367	382664000.0
2015-08-21	AMZN	Stock	25.368	25.6165	24.7235	24.7235	134130000.0
2015-08-21	GOOGL	Stock	33.552	33.6445	32.1552	32.2015	91879400.0
2015-08-21	META	Stock	87.52	89.18	85.61	86.06	62778700.0
2015-08-21	TSLA	Stock	15.7333	16.2533	15.3673	15.3847	98853000.0
2015-08-21	TLT	Stock	126.16	126.74	125.59	126.4	10718318.0
2015-08-21	ES	Stock	51.5	51.75	51.01	51.04	1713700.0
2015-08-21	CL	Stock	65.82	66.08	64.86	64.98	5799400.0
2015-08-21	A	Stock	37.13	37.49	36.17	36.23	3827500.0
2015-08-21	AA.B-DELISTED	Stock	33.08	33.6	33.01	33.2	93801.0
2015-08-21	AABA-DELISTED	Stock	33.58	34.02	32.91	32.93	17439896.0
2015-08-21	AAC-DELISTED	Stock	22.47	25.69	22.05	24.38	1056942.0
2015-08-21	AACG	Stock	2.92	2.92	2.7	2.75	40000.0
2015-08-21	AAIC-DELISTED	Stock	17.77	17.8	17.32	17.32	326236.0
2015-08-21	AAL	Stock	41.4	41.6	39.75	39.75	16241600.0
2015-08-21	AAMC-DELISTED	Stock	10.7353	10.7735	9.3382	10.1176	127211.0
2015-08-21	AAME	Stock	3.62	3.64	3.42	3.58	2300.0
2015-08-21	AAMI	Stock	16.86	17.26	16.7	17.03	366600.0
2015-08-21	AAOI	Stock	19.8	20.23	19.58	19.89	458100.0
2015-08-21	AAON	Stock	14.66	14.84	14.3333	14.4467	301800.0
2015-08-21	AAP	Stock	182.13	183.93	177.23	177.54	1392500.0
2015-08-21	AAT	Stock	41.41	41.86	40.92	40.98	246700.0
2015-08-21	AAU-DELISTED	Stock	0.6	0.6483	0.59	0.5901	76075.0
2015-08-21	AAUAF-DELISTED	Stock	0.6	0.6484	0.59	0.5901	76473.0
2015-08-21	AAV-DELISTED	Stock	5.08	5.14	4.98	5.01	183228.0
2015-08-21	AAVL-DELISTED	Stock	9.97	10.94	9.91	10.61	402985.0
2015-08-21	AAWW-DELISTED	Stock	41.17	43.13	40.6	41.78	601628.0
2015-08-21	AAXJ	Stock	53.2	53.475	52.26	52.27	3267864.0
2015-08-21	AAXN-DELISTED	Stock	21.0	22.08	20.26	21.31	3734700.0
2015-08-21	AB	Stock	27.06	27.06	26.02	26.11	326300.0
2015-08-21	ABAC-DELISTED	Stock	0.75	0.75	0.6701	0.738	45157.0
2015-08-21	ABAX-DELISTED	Stock	46.73	47.95	46.64	47.55	174312.0
2015-08-21	ABB-DELISTED	Stock	19.39	19.42	18.97	18.99	2445069.0
2015-08-21	ABBNY-DELISTED	Stock	19.39	19.42	18.97	18.99	2646478.0
2015-08-21	ABBV	Stock	66.74	67.16	65.83	65.9	16277100.0
2015-08-21	ABC-DELISTED	Stock	102.48	103.49	101.34	101.8	2230394.0
2015-08-21	ABCB	Stock	27.21	27.9	27.04	27.64	243100.0
2015-08-21	ABCD-DELISTED	Stock	4.6	4.85	4.56	4.63	141101.0
2015-08-21	ABCO-DELISTED	Stock	50.56	51.46	50.27	50.36	240118.0
2015-08-21	ABCW-DELISTED	Stock	39.17	40.0	39.17	39.9699	16165.0
2015-08-21	ABDC-DELISTED	Stock	12.81	12.85	12.57	12.67	27282.0
2015-08-21	ABE-DELISTED	Stock	11.51	11.51	11.24	11.24	8109.0
2015-08-21	ABEO	Stock	121.25	126.5	117.5	120.75	7564.0
2015-08-21	ABEOW-DELISTED	Stock	1.6901	2.07	1.6901	2.0	4543.0
2015-08-21	ABEV	Stock	5.19	5.21	5.12	5.12	15110700.0
2015-08-21	ABG	Stock	78.02	79.22	76.84	78.9	611500.0
2015-08-21	ABGB-DELISTED	Stock	4.22	4.29	4.01	4.09	65142.0
2015-08-21	ABM	Stock	32.42	33.09	31.92	32.93	353600.0

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

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