PREVIEW / stock_daily / 2016-02-17

all stock daily files

  file:    by_date/stock_daily/2016/2016-02-17.parquet
  size:    218 KB
  rows:    6,567
  symbols: 3,341

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-02-17	AAPL	Stock	24.1675	24.5525	24.0375	24.53	179452800.0
2016-02-17	MSFT	Stock	51.49	52.77	51.45	52.42	40789000.0
2016-02-17	NVDA	Stock	0.6832	0.698	0.6805	0.6915	771468000.0
2016-02-17	AMZN	Stock	26.437	26.874	25.9695	26.705	96480000.0
2016-02-17	GOOGL	Stock	36.35	36.688	35.8305	36.5985	49154300.0
2016-02-17	META	Stock	102.02	105.72	100.4	105.2	44073400.0
2016-02-17	TSLA	Stock	10.6	11.2893	10.4453	11.2453	87378000.0
2016-02-17	TLT	Stock	129.64	129.83	128.71	129.31	13157299.0
2016-02-17	ES	Stock	53.81	53.9	53.29	53.54	1368000.0
2016-02-17	CL	Stock	66.12	67.2	65.96	67.06	3112400.0
2016-02-17	A	Stock	35.22	38.13	34.75	37.87	5382300.0
2016-02-17	AA.B-DELISTED	Stock	29.25	29.9	28.9	29.78	63719.0
2016-02-17	AAAP-DELISTED	Stock	26.0	27.0	23.21	26.49	113107.0
2016-02-17	AABA-DELISTED	Stock	29.5	29.66	29.06	29.36	12228672.0
2016-02-17	AAC-DELISTED	Stock	21.0	22.61	20.91	22.24	295211.0
2016-02-17	AACG	Stock	5.39	5.4	5.02	5.03	3900.0
2016-02-17	AAIC-DELISTED	Stock	11.52	11.99	11.52	11.88	233824.0
2016-02-17	AAL	Stock	38.95	39.83	38.87	39.34	8432500.0
2016-02-17	AAMC-DELISTED	Stock	4.9441	5.5676	4.9441	5.4206	88125.0
2016-02-17	AAME	Stock	4.38	4.38	4.38	4.38	100.0
2016-02-17	AAMI	Stock	11.51	11.95	11.51	11.6	230100.0
2016-02-17	AAOI	Stock	16.17	17.11	16.17	16.43	365700.0
2016-02-17	AAON	Stock	14.0667	14.2733	13.7933	13.9733	270300.0
2016-02-17	AAP	Stock	147.17	149.01	142.99	143.41	1471100.0
2016-02-17	AAT	Stock	35.95	36.27	35.66	36.01	299000.0
2016-02-17	AAU-DELISTED	Stock	0.699	0.72	0.661	0.72	54396.0
2016-02-17	AAUAF-DELISTED	Stock	0.699	0.72	0.661	0.72	54883.0
2016-02-17	AAV-DELISTED	Stock	5.53	5.82	5.52	5.67	208523.0
2016-02-17	AAVL-DELISTED	Stock	5.02	5.32	4.88	5.19	464697.0
2016-02-17	AAWW-DELISTED	Stock	37.33	38.82	36.56	38.1	282416.0
2016-02-17	AAXJ	Stock	49.13	49.63	49.05	49.59	632261.0
2016-02-17	AAXN-DELISTED	Stock	16.4	17.23	16.2	17.13	1375979.0
2016-02-17	AB	Stock	18.8	19.28	18.73	19.0	399700.0
2016-02-17	ABAC-DELISTED	Stock	0.659	0.6687	0.614	0.637	2550.0
2016-02-17	ABAX-DELISTED	Stock	39.32	40.51	38.9901	39.87	277216.0
2016-02-17	ABB-DELISTED	Stock	17.72	17.9285	17.68	17.86	2570468.0
2016-02-17	ABBNY-DELISTED	Stock	17.72	17.9285	17.68	17.86	2620216.0
2016-02-17	ABBV	Stock	54.34	55.15	53.35	55.01	10005600.0
2016-02-17	ABC-DELISTED	Stock	86.06	87.83	85.72	87.5	3297105.0
2016-02-17	ABCB	Stock	26.51	26.68	25.37	26.0	382700.0
2016-02-17	ABCD-DELISTED	Stock	3.91	4.06	3.872	4.04	56232.0
2016-02-17	ABCO-DELISTED	Stock	40.35	40.59	39.11	39.27	239945.0
2016-02-17	ABCW-DELISTED	Stock	41.77	42.08	41.38	41.56	60716.0
2016-02-17	ABDC-DELISTED	Stock	9.2	9.48	9.035	9.29	31818.0
2016-02-17	ABE-DELISTED	Stock	10.5	10.552	10.5	10.552	572.0
2016-02-17	ABEO	Stock	64.0	68.25	63.5	65.25	2524.0
2016-02-17	ABEV	Stock	4.49	4.65	4.48	4.58	16910300.0
2016-02-17	ABG	Stock	51.31	54.07	51.31	52.65	531600.0
2016-02-17	ABGB-DELISTED	Stock	0.898	0.91	0.88	0.91	10231.0
2016-02-17	ABIL-DELISTED	Stock	6.75	7.19	6.75	7.07	35270.0

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

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