PREVIEW / stock_daily / 2016-12-12

all stock daily files

  file:    by_date/stock_daily/2016/2016-12-12.parquet
  size:    217 KB
  rows:    6,528
  symbols: 3,140

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-12-12	AAPL	Stock	28.3225	28.75	28.1225	28.325	105497600.0
2016-12-12	MSFT	Stock	61.82	62.3	61.72	62.17	20198100.0
2016-12-12	NVDA	Stock	2.2462	2.2488	2.1885	2.2398	601332000.0
2016-12-12	AMZN	Stock	38.32	38.3445	37.86	38.006	59278000.0
2016-12-12	GOOGL	Stock	40.241	40.5675	40.2266	40.395	32572040.0
2016-12-12	META	Stock	119.22	119.24	117.65	117.77	17805500.0
2016-12-12	TSLA	Stock	12.8533	12.9613	12.7453	12.8287	36583500.0
2016-12-12	TLT	Stock	117.27	117.8	116.88	117.72	9496347.0
2016-12-12	ES	Stock	53.54	54.37	53.54	54.29	1683700.0
2016-12-12	CL	Stock	66.28	66.95	66.28	66.75	3126500.0
2016-12-12	A	Stock	46.18	46.75	46.11	46.14	1851500.0
2016-12-12	AA	Stock	32.16	32.35	30.85	31.24	3416400.0
2016-12-12	AAAP-DELISTED	Stock	30.14	30.14	29.27	29.46	79615.0
2016-12-12	AABA-DELISTED	Stock	41.45	41.53	41.125	41.3	4120057.0
2016-12-12	AAC-DELISTED	Stock	8.4	8.515	8.19	8.21	141396.0
2016-12-12	AACG	Stock	3.98	3.98	3.85	3.85	4400.0
2016-12-12	AAIC-DELISTED	Stock	17.08	17.08	16.61	16.75	369865.0
2016-12-12	AAL	Stock	49.16	49.34	47.44	47.59	8643500.0
2016-12-12	AAMC-DELISTED	Stock	12.3676	12.6985	11.8275	12.3529	51704.0
2016-12-12	AAME	Stock	3.95	3.95	3.72	3.72	2900.0
2016-12-12	AAMI	Stock	15.4	15.51	15.24	15.27	202500.0
2016-12-12	AAOI	Stock	24.7	24.94	23.73	24.13	261000.0
2016-12-12	AAON	Stock	22.0667	22.2667	21.8667	22.0333	353250.0
2016-12-12	AAP	Stock	174.21	175.65	171.76	173.0	1088800.0
2016-12-12	AAT	Stock	42.46	43.01	42.26	42.98	198200.0
2016-12-12	AAU-DELISTED	Stock	1.1	1.15	1.08	1.15	244380.0
2016-12-12	AAUAF-DELISTED	Stock	1.1	1.15	1.08	1.11	247423.0
2016-12-12	AAV-DELISTED	Stock	7.5	7.55	7.0	7.05	299707.0
2016-12-12	AAWW-DELISTED	Stock	52.5	52.95	51.25	51.75	217012.0
2016-12-12	AAXJ	Stock	57.0	57.09	56.75	56.92	2778390.0
2016-12-12	AAXN-DELISTED	Stock	23.65	23.92	23.32	23.52	1104982.0
2016-12-12	AB	Stock	23.05	23.3	22.35	22.85	597000.0
2016-12-12	ABAC-DELISTED	Stock	3.39	3.79	3.2633	3.79	32606.0
2016-12-12	ABAX-DELISTED	Stock	53.94	55.31	53.94	54.85	179616.0
2016-12-12	ABB-DELISTED	Stock	21.2	21.35	21.17	21.255	4398799.0
2016-12-12	ABBNY-DELISTED	Stock	21.2	21.35	21.17	21.26	4925193.0
2016-12-12	ABBV	Stock	61.53	62.45	61.51	62.04	5984500.0
2016-12-12	ABC-DELISTED	Stock	78.37	78.97	77.28	78.08	1467863.0
2016-12-12	ABCB	Stock	47.25	47.4	45.15	45.4	210200.0
2016-12-12	ABCD-DELISTED	Stock	4.9	5.0	4.8	5.0	33547.0
2016-12-12	ABCO-DELISTED	Stock	34.05	34.2	33.4	33.5	617583.0
2016-12-12	ABDC-DELISTED	Stock	12.16	12.39	12.13	12.3	51835.0
2016-12-12	ABE-DELISTED	Stock	11.2822	11.33	11.2649	11.33	9335.0
2016-12-12	ABEO	Stock	126.25	126.25	106.25	111.25	89308.0
2016-12-12	ABEOW-DELISTED	Stock	2.5	2.55	2.15	2.4899	9750.0
2016-12-12	ABEV	Stock	4.9	4.91	4.76	4.82	24803700.0
2016-12-12	ABG	Stock	63.25	63.45	61.15	62.0	188200.0
2016-12-12	ABIL-DELISTED	Stock	3.26	3.301	3.05	3.259	37213.0
2016-12-12	ABM	Stock	43.03	43.46	42.68	42.88	566900.0
2016-12-12	ABMD-DELISTED	Stock	116.4	119.15	115.6	119.12	347380.0

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

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