PREVIEW / stock_daily / 2016-12-05

all stock daily files

  file:    by_date/stock_daily/2016/2016-12-05.parquet
  size:    216 KB
  rows:    6,536
  symbols: 3,153

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-05	AAPL	Stock	27.5	27.5075	27.0625	27.2775	137298000.0
2016-12-05	MSFT	Stock	59.7	60.59	59.56	60.22	23552700.0
2016-12-05	NVDA	Stock	2.2498	2.3153	2.225	2.297	602284000.0
2016-12-05	AMZN	Stock	37.25	38.0745	37.1	37.968	86294000.0
2016-12-05	GOOGL	Stock	38.5	39.0	38.3484	38.911	33769460.0
2016-12-05	META	Stock	115.95	117.57	115.07	117.43	20201500.0
2016-12-05	TSLA	Stock	12.1673	12.5927	12.1673	12.4533	61083000.0
2016-12-05	TLT	Stock	118.93	120.3975	118.45	119.47	12100125.0
2016-12-05	ES	Stock	51.44	51.97	51.04	51.93	1639700.0
2016-12-05	CL	Stock	64.95	65.2	64.52	64.63	4401800.0
2016-12-05	A	Stock	44.21	44.69	44.21	44.53	2495000.0
2016-12-05	AA	Stock	29.03	31.277	28.89	31.22	7034100.0
2016-12-05	AAAP-DELISTED	Stock	29.6	30.21	29.4	29.47	94567.0
2016-12-05	AABA-DELISTED	Stock	40.02	40.39	39.85	40.2	4047704.0
2016-12-05	AAC-DELISTED	Stock	8.39	8.79	8.27	8.55	268452.0
2016-12-05	AACG	Stock	3.67	4.2	3.6	4.2	14300.0
2016-12-05	AAIC-DELISTED	Stock	16.21	16.59	16.19	16.56	343455.0
2016-12-05	AAL	Stock	46.45	46.54	45.58	45.72	5256400.0
2016-12-05	AAMC-DELISTED	Stock	8.2353	8.7353	8.2279	8.5294	13535.0
2016-12-05	AAME	Stock	3.95	4.0	3.75	4.0	1700.0
2016-12-05	AAMI	Stock	14.65	14.8	14.45	14.55	155600.0
2016-12-05	AAOI	Stock	23.27	24.0	23.14	23.9	424300.0
2016-12-05	AAON	Stock	21.8333	22.2667	21.5667	21.9	230400.0
2016-12-05	AAP	Stock	171.44	171.96	169.96	170.53	740300.0
2016-12-05	AAT	Stock	39.91	40.08	39.64	40.06	198800.0
2016-12-05	AAU-DELISTED	Stock	1.09	1.14	1.03	1.14	326497.0
2016-12-05	AAUAF-DELISTED	Stock	1.09	1.14	1.03	1.14	328163.0
2016-12-05	AAV-DELISTED	Stock	7.3	7.45	7.24	7.3	78368.0
2016-12-05	AAWW-DELISTED	Stock	49.5	50.55	49.5	50.25	210402.0
2016-12-05	AAXJ	Stock	56.65	56.82	56.63	56.75	864555.0
2016-12-05	AAXN-DELISTED	Stock	28.0	28.49	28.0	28.07	886095.0
2016-12-05	AB	Stock	22.8	23.2	22.8	22.9	210600.0
2016-12-05	ABAC-DELISTED	Stock	3.18	3.42	3.18	3.22	24656.0
2016-12-05	ABAX-DELISTED	Stock	51.05	51.71	50.75	51.07	126434.0
2016-12-05	ABB-DELISTED	Stock	21.04	21.09	20.96	21.07	1343505.0
2016-12-05	ABBNY-DELISTED	Stock	21.04	21.09	20.96	21.07	1430504.0
2016-12-05	ABBV	Stock	59.6	61.22	59.57	60.86	10227700.0
2016-12-05	ABC-DELISTED	Stock	78.89	79.98	78.51	79.55	2324010.0
2016-12-05	ABCB	Stock	44.2	45.0	43.8	44.95	270600.0
2016-12-05	ABCD-DELISTED	Stock	4.5711	4.63	4.4	4.47	127029.0
2016-12-05	ABCO-DELISTED	Stock	31.95	32.25	31.55	32.05	612769.0
2016-12-05	ABDC-DELISTED	Stock	11.65	11.85	11.45	11.57	73109.0
2016-12-05	ABE-DELISTED	Stock	11.2	11.2699	11.04	11.2699	32612.0
2016-12-05	ABEO	Stock	153.75	156.25	143.75	147.5	12972.0
2016-12-05	ABEOW-DELISTED	Stock	3.32	3.33	2.85	3.05	2871.0
2016-12-05	ABEV	Stock	4.78	4.84	4.75	4.82	13226000.0
2016-12-05	ABG	Stock	57.5	59.15	57.5	58.9	373500.0
2016-12-05	ABIL-DELISTED	Stock	3.3	3.36	3.28	3.32	7925.0
2016-12-05	ABM	Stock	43.57	44.26	43.15	44.22	275200.0
2016-12-05	ABMD-DELISTED	Stock	109.26	110.82	108.82	109.955	219604.0

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

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