PREVIEW / stock_daily / 2016-10-27

all stock daily files

  file:    by_date/stock_daily/2016/2016-10-27.parquet
  size:    214 KB
  rows:    6,490
  symbols: 3,169

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-10-27	AAPL	Stock	28.8475	28.965	28.525	28.62	138248000.0
2016-10-27	MSFT	Stock	60.61	60.83	60.09	60.1	28479900.0
2016-10-27	NVDA	Stock	1.8178	1.8212	1.7598	1.767	388664000.0
2016-10-27	AMZN	Stock	41.562	41.586	40.7715	40.918	148128000.0
2016-10-27	GOOGL	Stock	41.1505	41.329	40.7305	40.8675	59469720.0
2016-10-27	META	Stock	131.74	131.8	129.27	129.69	16741400.0
2016-10-27	TSLA	Stock	14.0893	14.2467	13.4433	13.6007	196405500.0
2016-10-27	TLT	Stock	131.07	131.07	130.0649	130.74	10044665.0
2016-10-27	ES	Stock	54.0	54.18	53.55	53.91	1534800.0
2016-10-27	CL	Stock	71.72	71.87	70.25	70.57	4366800.0
2016-10-27	A	Stock	43.97	44.19	43.35	43.38	2392800.0
2016-10-27	AA	Stock	22.3079	22.6202	22.2758	22.6042	11574782.0
2016-10-27	AA.B-DELISTED	Stock	30.4324	30.8003	30.41	30.6499	30192.0
2016-10-27	AAAP-DELISTED	Stock	38.26	38.49	37.405	38.01	45948.0
2016-10-27	AABA-DELISTED	Stock	42.31	42.49	41.81	41.87	6691463.0
2016-10-27	AAC-DELISTED	Stock	17.62	17.77	17.0	17.05	75824.0
2016-10-27	AACG	Stock	3.55	3.59	3.55	3.58	1700.0
2016-10-27	AAIC-DELISTED	Stock	14.87	14.9	14.37	14.4	239035.0
2016-10-27	AAL	Stock	39.45	40.18	39.26	39.91	6542100.0
2016-10-27	AAMC-DELISTED	Stock	9.6768	9.7059	9.3235	9.5588	58286.0
2016-10-27	AAMI	Stock	14.22	14.27	13.97	13.99	152700.0
2016-10-27	AAOI	Stock	21.63	21.89	19.91	19.99	347000.0
2016-10-27	AAON	Stock	19.5	19.7	19.3667	19.6667	169500.0
2016-10-27	AAP	Stock	143.44	144.54	138.98	139.22	1362900.0
2016-10-27	AAT	Stock	39.35	39.35	38.38	38.46	141200.0
2016-10-27	AAU-DELISTED	Stock	1.29	1.29	1.26	1.29	92610.0
2016-10-27	AAUAF-DELISTED	Stock	1.29	1.29	1.26	1.29	93621.0
2016-10-27	AAV-DELISTED	Stock	7.09	7.19	7.02	7.02	116254.0
2016-10-27	AAWW-DELISTED	Stock	42.55	42.6	41.75	42.0	101899.0
2016-10-27	AAXJ	Stock	59.51	59.555	59.08	59.12	1381326.0
2016-10-27	AAXN-DELISTED	Stock	22.96	23.13	22.32	22.52	741403.0
2016-10-27	AB	Stock	22.55	22.55	21.7	21.75	212900.0
2016-10-27	ABAC-DELISTED	Stock	2.83	2.84	2.56	2.7233	12414.0
2016-10-27	ABAX-DELISTED	Stock	47.23	48.575	46.71	47.13	174811.0
2016-10-27	ABB-DELISTED	Stock	20.7	20.745	20.4907	20.53	5183576.0
2016-10-27	ABBNY-DELISTED	Stock	20.7	20.745	20.4907	20.53	5638944.0
2016-10-27	ABBV	Stock	61.45	61.72	60.6	61.46	6612500.0
2016-10-27	ABC-DELISTED	Stock	79.56	79.84	79.11	79.51	1328496.0
2016-10-27	ABCB	Stock	36.6	36.6	36.15	36.2	106500.0
2016-10-27	ABCD-DELISTED	Stock	4.96	5.07	4.96	5.03	12081.0
2016-10-27	ABCO-DELISTED	Stock	40.37	40.84	39.68	40.37	121698.0
2016-10-27	ABDC-DELISTED	Stock	13.31	13.33	13.12	13.2	57580.0
2016-10-27	ABE-DELISTED	Stock	12.3699	12.3699	12.3699	12.3699	340.0
2016-10-27	ABEO	Stock	185.0	186.25	178.25	181.25	54312.0
2016-10-27	ABEOW-DELISTED	Stock	3.6321	3.98	3.6321	3.7405	2998.0
2016-10-27	ABEV	Stock	6.22	6.24	6.13	6.16	12778000.0
2016-10-27	ABG	Stock	50.4	51.35	50.05	50.35	202800.0
2016-10-27	ABIL-DELISTED	Stock	3.4	3.4	3.14	3.15	41277.0
2016-10-27	ABM	Stock	38.45	38.46	38.17	38.29	121200.0
2016-10-27	ABMD-DELISTED	Stock	101.51	104.4	95.1364	103.32	3572234.0

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

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