PREVIEW / stock_daily / 2016-07-21

all stock daily files

  file:    by_date/stock_daily/2016/2016-07-21.parquet
  size:    219 KB
  rows:    6,527
  symbols: 3,235

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-07-21	AAPL	Stock	24.9575	25.25	24.7825	24.8575	130808000.0
2016-07-21	MSFT	Stock	55.98	56.23	55.76	55.8	32776700.0
2016-07-21	NVDA	Stock	1.3525	1.3568	1.326	1.3305	361308000.0
2016-07-21	AMZN	Stock	37.375	37.468	37.1395	37.2215	46342000.0
2016-07-21	GOOGL	Stock	37.85	37.9075	37.576	37.7205	19061060.0
2016-07-21	META	Stock	121.92	122.1	120.25	120.61	17801700.0
2016-07-21	TSLA	Stock	15.0667	15.19	14.6067	14.7	66430500.0
2016-07-21	TLT	Stock	137.04	138.62	136.985	138.56	10398437.0
2016-07-21	ES	Stock	57.84	58.12	57.51	58.01	1688800.0
2016-07-21	CL	Stock	73.88	74.09	73.61	73.87	2618300.0
2016-07-21	A	Stock	46.98	47.14	46.47	46.67	1218400.0
2016-07-21	AA.B-DELISTED	Stock	36.5	37.18	36.1	36.48	13001.0
2016-07-21	AAAP-DELISTED	Stock	30.32	30.69	30.32	30.69	15485.0
2016-07-21	AABA-DELISTED	Stock	39.01	39.25	38.72	38.86	7162692.0
2016-07-21	AAC-DELISTED	Stock	21.71	22.21	21.61	21.85	57875.0
2016-07-21	AACG	Stock	4.5	4.5	4.23	4.23	1300.0
2016-07-21	AAIC-DELISTED	Stock	13.43	13.5	13.37	13.45	175039.0
2016-07-21	AAL	Stock	35.1	35.56	34.44	34.96	16429900.0
2016-07-21	AAMC-DELISTED	Stock	4.1147	4.4082	4.05	4.2059	72920.0
2016-07-21	AAMI	Stock	13.68	13.89	13.58	13.87	113400.0
2016-07-21	AAOI	Stock	11.86	12.21	11.751	12.06	243600.0
2016-07-21	AAON	Stock	18.0733	18.1133	17.5667	17.68	208200.0
2016-07-21	AAP	Stock	163.49	164.36	162.99	164.09	418700.0
2016-07-21	AAT	Stock	44.46	45.21	44.42	45.11	159100.0
2016-07-21	AAU-DELISTED	Stock	1.35	1.389	1.32	1.3575	335153.0
2016-07-21	AAUAF-DELISTED	Stock	1.35	1.389	1.32	1.3575	335985.0
2016-07-21	AAV-DELISTED	Stock	6.44	6.59	6.35	6.43	95242.0
2016-07-21	AAWW-DELISTED	Stock	42.22	42.595	41.235	41.6	170097.0
2016-07-21	AAXJ	Stock	56.96	57.135	56.815	56.92	1433369.0
2016-07-21	AAXN-DELISTED	Stock	28.2	28.442	28.005	28.2	756195.0
2016-07-21	AB	Stock	23.98	24.31	23.93	24.04	124800.0
2016-07-21	ABAC-DELISTED	Stock	0.77	0.82	0.77	0.775	103049.0
2016-07-21	ABAX-DELISTED	Stock	54.25	54.98	54.02	54.74	286156.0
2016-07-21	ABB-DELISTED	Stock	20.65	20.86	20.61	20.69	2782078.0
2016-07-21	ABBNY-DELISTED	Stock	20.65	20.86	20.61	20.7	3017933.0
2016-07-21	ABBV	Stock	63.23	64.0	63.17	63.89	6145500.0
2016-07-21	ABC-DELISTED	Stock	86.38	86.895	85.53	85.79	1489030.0
2016-07-21	ABCB	Stock	30.42	30.77	30.31	30.48	97500.0
2016-07-21	ABCD-DELISTED	Stock	4.89	4.89	4.83	4.83	8559.0
2016-07-21	ABCO-DELISTED	Stock	38.33	39.019	36.51	38.11	141658.0
2016-07-21	ABDC-DELISTED	Stock	12.34	12.4	12.24	12.34	31125.0
2016-07-21	ABE-DELISTED	Stock	12.43	12.48	12.43	12.48	600.0
2016-07-21	ABEO	Stock	62.75	65.25	61.25	62.0	1684.0
2016-07-21	ABEOW-DELISTED	Stock	1.0	1.0	1.0	1.0	5000.0
2016-07-21	ABEV	Stock	5.84	5.87	5.79	5.84	6899000.0
2016-07-21	ABG	Stock	59.64	62.21	59.64	61.31	364000.0
2016-07-21	ABIL-DELISTED	Stock	4.541	4.59	4.54	4.59	3000.0
2016-07-21	ABM	Stock	37.11	37.28	36.94	37.15	167300.0
2016-07-21	ABMD-DELISTED	Stock	118.45	118.89	115.31	116.0	402231.0
2016-07-21	ABR	Stock	7.17	7.22	7.11	7.12	93100.0

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

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