PREVIEW / stock_daily / 2016-11-28

all stock daily files

  file:    by_date/stock_daily/2016/2016-11-28.parquet
  size:    214 KB
  rows:    6,519
  symbols: 3,142

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-11-28	AAPL	Stock	27.8575	28.1175	27.8475	27.8925	108776000.0
2016-11-28	MSFT	Stock	60.34	61.02	60.21	60.61	20732600.0
2016-11-28	NVDA	Stock	2.3468	2.3685	2.34	2.3528	278736000.0
2016-11-28	AMZN	Stock	38.8495	38.85	38.212	38.3385	88776000.0
2016-11-28	GOOGL	Stock	38.9175	39.987	38.905	39.2895	51508640.0
2016-11-28	META	Stock	120.12	121.69	119.82	120.41	18101300.0
2016-11-28	TSLA	Stock	13.032	13.29	12.97	13.0747	67938000.0
2016-11-28	TLT	Stock	121.41	121.73	121.09	121.71	8554998.0
2016-11-28	ES	Stock	52.87	53.94	52.77	53.84	2377800.0
2016-11-28	CL	Stock	66.39	66.69	66.04	66.43	3102200.0
2016-11-28	A	Stock	44.52	44.69	43.58	43.6	2241800.0
2016-11-28	AA	Stock	31.48	31.8	30.7	30.86	5121900.0
2016-11-28	AAAP-DELISTED	Stock	33.85	33.85	29.01	30.6	250648.0
2016-11-28	AABA-DELISTED	Stock	40.85	41.7	40.74	41.44	5714840.0
2016-11-28	AAC-DELISTED	Stock	9.43	9.43	8.75	8.81	200558.0
2016-11-28	AACG	Stock	4.2	4.2	4.2	4.2	100.0
2016-11-28	AAIC-DELISTED	Stock	16.54	16.65	16.4033	16.5	220317.0
2016-11-28	AAL	Stock	46.64	46.89	45.66	46.5	7369600.0
2016-11-28	AAMC-DELISTED	Stock	8.5	8.9028	8.5	8.8088	35340.0
2016-11-28	AAME	Stock	4.0	4.0	3.98	4.0	1100.0
2016-11-28	AAMI	Stock	14.67	14.74	14.43	14.52	82400.0
2016-11-28	AAOI	Stock	25.3	25.57	24.92	25.14	218900.0
2016-11-28	AAON	Stock	22.4667	22.52	22.1533	22.3333	175950.0
2016-11-28	AAP	Stock	171.15	174.31	170.55	170.77	1023100.0
2016-11-28	AAT	Stock	40.6	40.95	40.24	40.49	245400.0
2016-11-28	AAU-DELISTED	Stock	1.07	1.11	1.06	1.08	201214.0
2016-11-28	AAUAF-DELISTED	Stock	1.07	1.11	1.06	1.08	203051.0
2016-11-28	AAV-DELISTED	Stock	6.95	7.0	6.85	6.85	66128.0
2016-11-28	AAWW-DELISTED	Stock	50.8	51.2	50.0	50.15	101084.0
2016-11-28	AAXJ	Stock	56.75	56.91	56.65	56.7	754039.0
2016-11-28	AAXN-DELISTED	Stock	28.0	28.1	27.73	27.82	437834.0
2016-11-28	AB	Stock	23.7	23.8	23.15	23.15	213000.0
2016-11-28	ABAC-DELISTED	Stock	3.14	3.47	2.87	3.15	36836.0
2016-11-28	ABAX-DELISTED	Stock	53.11	53.1599	51.65	51.96	77976.0
2016-11-28	ABB-DELISTED	Stock	20.48	20.53	20.39	20.395	975923.0
2016-11-28	ABBNY-DELISTED	Stock	20.48	20.53	20.39	20.4	1053016.0
2016-11-28	ABBV	Stock	59.13	59.94	59.01	59.46	6274600.0
2016-11-28	ABC-DELISTED	Stock	78.61	79.58	77.81	79.04	1866164.0
2016-11-28	ABCB	Stock	44.45	44.5	43.53	43.75	124400.0
2016-11-28	ABCD-DELISTED	Stock	4.91	5.0	4.91	4.9999	29651.0
2016-11-28	ABCO-DELISTED	Stock	37.2	37.2	35.45	36.85	135590.0
2016-11-28	ABDC-DELISTED	Stock	12.32	12.35	11.91	12.21	65024.0
2016-11-28	ABE-DELISTED	Stock	11.23	11.34	11.23	11.27	11458.0
2016-11-28	ABEO	Stock	178.75	179.5	171.25	172.5	7660.0
2016-11-28	ABEOW-DELISTED	Stock	3.3	3.62	3.3	3.55	10645.0
2016-11-28	ABEV	Stock	5.02	5.15	5.0	5.11	22182200.0
2016-11-28	ABG	Stock	60.35	60.55	58.3	59.0	218800.0
2016-11-28	ABIL-DELISTED	Stock	3.49	3.49	3.32	3.389	22065.0
2016-11-28	ABM	Stock	44.51	44.63	44.08	44.31	286600.0
2016-11-28	ABMD-DELISTED	Stock	113.66	114.68	111.805	112.26	197273.0

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

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