PREVIEW / stock_daily / 2016-12-06

all stock daily files

  file:    by_date/stock_daily/2016/2016-12-06.parquet
  size:    216 KB
  rows:    6,514
  symbols: 3,139

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-06	AAPL	Stock	27.375	27.59	27.2975	27.4875	104782000.0
2016-12-06	MSFT	Stock	60.43	60.46	59.8	59.95	19907000.0
2016-12-06	NVDA	Stock	2.3052	2.3433	2.2892	2.3348	498796000.0
2016-12-06	AMZN	Stock	38.1995	38.412	37.8625	38.236	75894000.0
2016-12-06	GOOGL	Stock	39.0095	39.264	38.666	38.809	34681980.0
2016-12-06	META	Stock	117.69	117.8	116.33	117.31	19131200.0
2016-12-06	TSLA	Stock	12.368	12.4387	12.1787	12.39	50874000.0
2016-12-06	TLT	Stock	119.7	119.94	119.12	119.38	11526642.0
2016-12-06	ES	Stock	52.1	52.17	51.53	52.01	1436700.0
2016-12-06	CL	Stock	64.78	65.13	64.51	65.03	4540800.0
2016-12-06	A	Stock	44.58	44.9	44.2	44.84	1136700.0
2016-12-06	AA	Stock	30.71	31.19	30.21	31.15	3248600.0
2016-12-06	AAAP-DELISTED	Stock	29.63	29.86	29.51	29.68	62848.0
2016-12-06	AABA-DELISTED	Stock	40.31	40.42	39.88	39.97	4746354.0
2016-12-06	AAC-DELISTED	Stock	8.47	8.67	8.36	8.5	173224.0
2016-12-06	AACG	Stock	4.1	4.1	3.83	3.83	700.0
2016-12-06	AAIC-DELISTED	Stock	16.65	16.7	16.42	16.59	331751.0
2016-12-06	AAL	Stock	46.16	46.55	45.92	46.43	5334500.0
2016-12-06	AAMC-DELISTED	Stock	8.6176	9.7647	8.2241	9.7059	45438.0
2016-12-06	AAME	Stock	3.95	3.95	3.85	3.85	800.0
2016-12-06	AAMI	Stock	14.69	14.875	14.32	14.5	234900.0
2016-12-06	AAOI	Stock	23.93	23.93	22.92	23.4	280400.0
2016-12-06	AAON	Stock	21.8667	21.9667	21.6	21.8333	254100.0
2016-12-06	AAP	Stock	170.18	173.76	169.85	173.31	753400.0
2016-12-06	AAT	Stock	39.75	40.17	39.56	40.15	207500.0
2016-12-06	AAU-DELISTED	Stock	1.12	1.15	1.11	1.12	139640.0
2016-12-06	AAUAF-DELISTED	Stock	1.12	1.15	1.11	1.11	140429.0
2016-12-06	AAV-DELISTED	Stock	7.3	7.425	7.275	7.3	252861.0
2016-12-06	AAWW-DELISTED	Stock	50.25	51.0	50.025	50.45	181298.0
2016-12-06	AAXJ	Stock	56.91	57.02	56.805	56.94	1305952.0
2016-12-06	AAXN-DELISTED	Stock	28.3	28.37	27.886	28.2	465403.0
2016-12-06	AB	Stock	22.8	23.15	22.6	23.0	252400.0
2016-12-06	ABAC-DELISTED	Stock	3.26	3.37	3.2249	3.26	4000.0
2016-12-06	ABAX-DELISTED	Stock	51.31	52.98	51.275	52.67	236436.0
2016-12-06	ABB-DELISTED	Stock	20.89	21.07	20.88	21.04	1293375.0
2016-12-06	ABBNY-DELISTED	Stock	20.89	21.07	20.88	21.04	1335253.0
2016-12-06	ABBV	Stock	60.76	61.72	60.33	61.62	7610400.0
2016-12-06	ABC-DELISTED	Stock	79.9	80.1	78.54	78.88	2127420.0
2016-12-06	ABCB	Stock	45.25	46.55	44.95	46.5	222800.0
2016-12-06	ABCD-DELISTED	Stock	4.43	4.47	4.25	4.39	74194.0
2016-12-06	ABCO-DELISTED	Stock	32.15	32.8	31.9	32.7	392834.0
2016-12-06	ABDC-DELISTED	Stock	11.71	11.99	11.65	11.74	44185.0
2016-12-06	ABE-DELISTED	Stock	11.27	11.32	11.23	11.27	14199.0
2016-12-06	ABEO	Stock	148.75	160.0	138.75	147.5	15228.0
2016-12-06	ABEOW-DELISTED	Stock	3.0	3.18	3.0	3.16	750.0
2016-12-06	ABEV	Stock	4.79	4.89	4.74	4.85	21386200.0
2016-12-06	ABG	Stock	59.4	61.35	58.7	61.25	219600.0
2016-12-06	ABIL-DELISTED	Stock	3.39	3.39	3.3	3.3672	4570.0
2016-12-06	ABM	Stock	43.16	43.48	42.63	42.86	520300.0
2016-12-06	ABMD-DELISTED	Stock	109.62	114.68	109.53	112.91	563673.0

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

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