PREVIEW / stock_daily / 2016-11-11

all stock daily files

  file:    by_date/stock_daily/2016/2016-11-11.parquet
  size:    214 KB
  rows:    6,521
  symbols: 3,167

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-11	AAPL	Stock	26.78	27.2175	26.6375	27.1075	136575600.0
2016-11-11	MSFT	Stock	58.23	59.12	58.01	59.02	38767800.0
2016-11-11	NVDA	Stock	1.9878	2.2192	1.9625	2.1992	2175344000.0
2016-11-11	AMZN	Stock	36.7865	37.163	36.445	36.9505	132456000.0
2016-11-11	GOOGL	Stock	38.8405	38.8645	38.277	38.5875	71852820.0
2016-11-11	META	Stock	119.53	120.7	118.15	119.02	32840100.0
2016-11-11	TSLA	Stock	12.2827	12.592	12.2	12.5707	59827500.0
2016-11-11	TLT	Stock	122.96	123.05	121.65	122.04	10040165.0
2016-11-11	ES	Stock	52.16	52.9	51.83	51.95	1548700.0
2016-11-11	CL	Stock	67.24	67.77	66.82	67.42	4008400.0
2016-11-11	A	Stock	46.77	46.87	46.21	46.37	2219300.0
2016-11-11	AA	Stock	29.18	29.99	27.63	29.3	5337200.0
2016-11-11	AAAP-DELISTED	Stock	37.2	37.2	36.43	36.46	36231.0
2016-11-11	AABA-DELISTED	Stock	39.84	40.52	39.37	40.42	14251455.0
2016-11-11	AAC-DELISTED	Stock	7.82	8.97	7.63	8.88	551655.0
2016-11-11	AACG	Stock	3.9	4.1	3.9	4.1	2800.0
2016-11-11	AAIC-DELISTED	Stock	14.91	15.39	14.85	15.26	514402.0
2016-11-11	AAL	Stock	42.07	42.95	41.68	42.93	6623500.0
2016-11-11	AAMC-DELISTED	Stock	10.7353	11.1471	10.6618	10.7647	29434.0
2016-11-11	AAME	Stock	3.6	3.65	3.5	3.65	1200.0
2016-11-11	AAMI	Stock	13.32	14.29	13.2	13.9	368100.0
2016-11-11	AAOI	Stock	23.25	25.2	23.25	24.97	704500.0
2016-11-11	AAON	Stock	20.2667	21.4667	20.2667	21.4667	439500.0
2016-11-11	AAP	Stock	145.11	147.23	143.63	145.02	1740100.0
2016-11-11	AAT	Stock	39.28	40.78	39.22	40.03	326600.0
2016-11-11	AAU-DELISTED	Stock	1.23	1.249	1.1	1.16	717087.0
2016-11-11	AAUAF-DELISTED	Stock	1.23	1.249	1.1	1.17	720598.0
2016-11-11	AAV-DELISTED	Stock	6.6	6.625	6.45	6.5	58596.0
2016-11-11	AAWW-DELISTED	Stock	46.05	48.1	46.05	47.85	203460.0
2016-11-11	AAXJ	Stock	55.81	56.05	55.28	55.73	2637472.0
2016-11-11	AAXN-DELISTED	Stock	26.09	27.24	26.04	27.17	1275885.0
2016-11-11	AB	Stock	22.7	23.11	22.5	23.1	342800.0
2016-11-11	ABAC-DELISTED	Stock	2.7	2.9	2.7	2.86	13839.0
2016-11-11	ABAX-DELISTED	Stock	50.1	52.5	46.825	51.23	234922.0
2016-11-11	ABB-DELISTED	Stock	21.4	21.43	21.16	21.37	2007466.0
2016-11-11	ABBNY-DELISTED	Stock	21.4	21.43	21.16	21.38	2081577.0
2016-11-11	ABBV	Stock	63.54	63.85	62.79	63.1	10201600.0
2016-11-11	ABC-DELISTED	Stock	79.41	79.85	77.24	78.96	4461183.0
2016-11-11	ABCB	Stock	41.5	42.7	41.2	42.65	302900.0
2016-11-11	ABCD-DELISTED	Stock	4.9	4.95	4.8	4.95	73147.0
2016-11-11	ABCO-DELISTED	Stock	33.4	34.0	32.7	32.95	716063.0
2016-11-11	ABDC-DELISTED	Stock	12.31	12.65	12.21	12.31	17503.0
2016-11-11	ABE-DELISTED	Stock	11.37	11.466	11.2669	11.37	14004.0
2016-11-11	ABEO	Stock	152.5	173.75	148.75	161.25	35856.0
2016-11-11	ABEOW-DELISTED	Stock	2.7538	3.34	2.7538	3.32	4900.0
2016-11-11	ABEV	Stock	5.15	5.22	5.04	5.12	30426200.0
2016-11-11	ABG	Stock	54.45	54.7	53.25	54.3	289600.0
2016-11-11	ABIL-DELISTED	Stock	2.94	3.0	2.94	2.9601	7398.0
2016-11-11	ABM	Stock	41.41	42.02	41.18	41.94	627400.0
2016-11-11	ABMD-DELISTED	Stock	106.72	110.24	106.55	110.01	539628.0

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

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