PREVIEW / stock_daily / 2016-11-25

all stock daily files

  file:    by_date/stock_daily/2016/2016-11-25.parquet
  size:    208 KB
  rows:    6,377
  symbols: 3,064

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-25	AAPL	Stock	27.7825	27.9675	27.7375	27.9475	45903600.0
2016-11-25	MSFT	Stock	60.3	60.53	60.13	60.53	8409600.0
2016-11-25	NVDA	Stock	2.3605	2.3775	2.3352	2.354	195564000.0
2016-11-25	AMZN	Stock	39.325	39.3375	38.895	39.0185	36742000.0
2016-11-25	GOOGL	Stock	39.1305	39.145	38.9095	39.0115	12270980.0
2016-11-25	META	Stock	121.01	121.14	120.07	120.38	8658600.0
2016-11-25	TSLA	Stock	12.9093	13.1493	12.9093	13.11	35491500.0
2016-11-25	TLT	Stock	121.19	121.29	120.4	120.82	3126273.0
2016-11-25	ES	Stock	51.97	52.7	51.96	52.59	829600.0
2016-11-25	CL	Stock	66.33	66.7	66.3	66.53	1302300.0
2016-11-25	A	Stock	44.74	45.01	44.62	44.89	877100.0
2016-11-25	AA	Stock	31.24	32.19	31.11	31.7	3109500.0
2016-11-25	AAAP-DELISTED	Stock	35.0	35.87	33.855	33.91	109158.0
2016-11-25	AABA-DELISTED	Stock	41.08	41.08	40.71	40.86	2481047.0
2016-11-25	AAC-DELISTED	Stock	9.27	9.6	9.27	9.56	28939.0
2016-11-25	AACG	Stock	4.03	4.2	4.01	4.2	3600.0
2016-11-25	AAIC-DELISTED	Stock	16.49	16.56	16.42	16.52	182462.0
2016-11-25	AAL	Stock	46.34	46.86	46.3	46.82	2426600.0
2016-11-25	AAMC-DELISTED	Stock	8.3971	8.6029	8.3971	8.5	8582.0
2016-11-25	AAMI	Stock	14.9	14.9	14.71	14.81	45700.0
2016-11-25	AAOI	Stock	25.14	25.5	25.06	25.47	153500.0
2016-11-25	AAON	Stock	22.3	22.6	22.1	22.6	76050.0
2016-11-25	AAP	Stock	171.69	172.02	170.13	170.86	405600.0
2016-11-25	AAT	Stock	40.46	40.88	40.42	40.55	63800.0
2016-11-25	AAU-DELISTED	Stock	1.05	1.09	1.05	1.05	121118.0
2016-11-25	AAUAF-DELISTED	Stock	1.05	1.09	1.05	1.05	122404.0
2016-11-25	AAV-DELISTED	Stock	7.1	7.1	6.81	6.85	38338.0
2016-11-25	AAWW-DELISTED	Stock	51.2	51.3	50.65	51.25	59219.0
2016-11-25	AAXJ	Stock	56.63	56.72	56.53	56.56	290746.0
2016-11-25	AAXN-DELISTED	Stock	28.1	28.22	27.87	28.06	158294.0
2016-11-25	AB	Stock	23.3	24.0	23.3	23.95	166500.0
2016-11-25	ABAC-DELISTED	Stock	3.08	3.4999	3.08	3.23	67791.0
2016-11-25	ABAX-DELISTED	Stock	52.87	53.9	52.4101	53.37	51308.0
2016-11-25	ABB-DELISTED	Stock	20.61	20.71	20.6	20.7	600370.0
2016-11-25	ABBNY-DELISTED	Stock	20.61	20.71	20.6	20.7	678490.0
2016-11-25	ABBV	Stock	60.04	60.67	59.67	60.51	2941600.0
2016-11-25	ABC-DELISTED	Stock	79.07	80.48	78.35	78.55	1022975.0
2016-11-25	ABCB	Stock	44.5	44.65	44.35	44.6	56900.0
2016-11-25	ABCD-DELISTED	Stock	4.8	5.0	4.74	4.97	17319.0
2016-11-25	ABCO-DELISTED	Stock	37.05	37.3	37.025	37.2	60354.0
2016-11-25	ABDC-DELISTED	Stock	12.31	12.4019	12.21	12.25	20407.0
2016-11-25	ABE-DELISTED	Stock	11.16	11.3747	11.16	11.29	13515.0
2016-11-25	ABEO	Stock	177.5	180.0	173.75	176.25	3064.0
2016-11-25	ABEOW-DELISTED	Stock	3.62	3.7	3.55	3.55	11500.0
2016-11-25	ABEV	Stock	5.0	5.05	4.94	4.96	7318600.0
2016-11-25	ABG	Stock	60.0	60.55	59.85	60.35	146200.0
2016-11-25	ABIL-DELISTED	Stock	3.34	3.48	3.34	3.48	3045.0
2016-11-25	ABM	Stock	43.9	44.53	43.9	44.34	164700.0
2016-11-25	ABMD-DELISTED	Stock	113.36	113.98	111.4227	113.65	73489.0
2016-11-25	ABR	Stock	7.31	7.5	7.31	7.46	44300.0

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

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