PREVIEW / stock_daily / 2016-11-22

all stock daily files

  file:    by_date/stock_daily/2016/2016-11-22.parquet
  size:    217 KB
  rows:    6,536
  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-11-22	AAPL	Stock	27.9875	28.105	27.85	27.95	103862000.0
2016-11-22	MSFT	Stock	60.98	61.26	60.81	61.12	23206700.0
2016-11-22	NVDA	Stock	2.3325	2.3435	2.3095	2.3412	330368000.0
2016-11-22	AMZN	Stock	39.4085	39.62	39.05	39.2665	106226000.0
2016-11-22	GOOGL	Stock	39.4495	39.6885	39.187	39.25	27883480.0
2016-11-22	META	Stock	122.4	122.98	120.9	121.47	26089200.0
2016-11-22	TSLA	Stock	12.3893	12.7647	12.2473	12.7447	84051000.0
2016-11-22	TLT	Stock	121.66	121.76	120.88	121.11	9989917.0
2016-11-22	ES	Stock	52.3	52.7	52.08	52.45	2331800.0
2016-11-22	CL	Stock	66.43	66.73	66.24	66.33	3556100.0
2016-11-22	A	Stock	44.94	45.16	43.77	44.46	2831200.0
2016-11-22	AA	Stock	31.1	31.91	30.54	31.34	4182800.0
2016-11-22	AAAP-DELISTED	Stock	35.57	35.59	34.735	35.27	29760.0
2016-11-22	AABA-DELISTED	Stock	41.2	41.395	40.83	41.0	8533247.0
2016-11-22	AAC-DELISTED	Stock	9.26	9.575	9.21	9.42	210589.0
2016-11-22	AACG	Stock	4.11	4.15	4.11	4.13	500.0
2016-11-22	AAIC-DELISTED	Stock	15.98	16.3565	15.9471	16.25	266872.0
2016-11-22	AAL	Stock	46.03	46.95	45.95	46.08	5780600.0
2016-11-22	AAMC-DELISTED	Stock	8.1471	8.4559	7.9412	8.3824	67925.0
2016-11-22	AAME	Stock	4.0	4.0	3.75	3.85	1000.0
2016-11-22	AAMI	Stock	14.81	14.868	14.61	14.75	147500.0
2016-11-22	AAOI	Stock	26.2	26.43	24.85	26.0	1509400.0
2016-11-22	AAON	Stock	21.9667	22.0667	21.7533	22.0333	254850.0
2016-11-22	AAP	Stock	167.63	170.98	167.07	170.29	1387900.0
2016-11-22	AAT	Stock	40.02	40.68	39.92	40.63	274100.0
2016-11-22	AAU-DELISTED	Stock	1.12	1.15	1.1	1.15	208051.0
2016-11-22	AAUAF-DELISTED	Stock	1.12	1.15	1.1	1.15	209306.0
2016-11-22	AAV-DELISTED	Stock	7.0	7.05	6.875	7.05	66319.0
2016-11-22	AAWW-DELISTED	Stock	50.85	51.2	50.21	50.9	161927.0
2016-11-22	AAXJ	Stock	56.52	56.59	56.285	56.53	1004277.0
2016-11-22	AAXN-DELISTED	Stock	27.37	28.0294	27.33	28.0	591601.0
2016-11-22	AB	Stock	23.35	23.95	23.1	23.7	359600.0
2016-11-22	ABAC-DELISTED	Stock	2.682	2.69	2.59	2.59	4978.0
2016-11-22	ABAX-DELISTED	Stock	52.3	52.3	50.13	51.37	140169.0
2016-11-22	ABB-DELISTED	Stock	20.76	20.78	20.635	20.75	1860642.0
2016-11-22	ABBNY-DELISTED	Stock	20.77	20.78	20.635	20.75	1904282.0
2016-11-22	ABBV	Stock	60.49	60.56	58.61	58.93	8518600.0
2016-11-22	ABC-DELISTED	Stock	78.77	78.77	77.77	78.42	1636281.0
2016-11-22	ABCB	Stock	43.3	44.2	43.1	44.1	201800.0
2016-11-22	ABCD-DELISTED	Stock	5.09	5.13	4.91	4.99	37990.0
2016-11-22	ABCO-DELISTED	Stock	37.2	37.35	36.65	36.95	324042.0
2016-11-22	ABDC-DELISTED	Stock	12.05	12.3	11.9	12.13	76428.0
2016-11-22	ABE-DELISTED	Stock	11.39	11.44	11.1968	11.1968	4710.0
2016-11-22	ABEO	Stock	180.0	181.0	172.5	173.75	9596.0
2016-11-22	ABEOW-DELISTED	Stock	3.7	3.7	3.61	3.7	20800.0
2016-11-22	ABEV	Stock	5.25	5.26	5.06	5.06	23481400.0
2016-11-22	ABG	Stock	59.35	59.65	58.35	58.9	290200.0
2016-11-22	ABIL-DELISTED	Stock	3.45	3.4899	3.362	3.4	17047.0
2016-11-22	ABM	Stock	44.53	44.93	43.91	44.42	307600.0
2016-11-22	ABMD-DELISTED	Stock	116.04	116.8265	110.51	111.01	426185.0

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

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