PREVIEW / stock_daily / 2017-04-13

all stock daily files

  file:    by_date/stock_daily/2017/2017-04-13.parquet
  size:    214 KB
  rows:    6,435
  symbols: 3,021

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
2017-04-13	AAPL	Stock	35.4775	35.595	35.2625	35.2625	71291600.0
2017-04-13	MSFT	Stock	65.29	65.86	64.95	64.95	17896500.0
2017-04-13	NVDA	Stock	2.4083	2.4302	2.3872	2.3872	506892000.0
2017-04-13	AMZN	Stock	44.5725	44.7485	44.2245	44.2335	63492000.0
2017-04-13	GOOGL	Stock	42.052	42.1865	41.8925	42.009	21473000.0
2017-04-13	META	Stock	139.62	140.58	139.33	139.39	10965600.0
2017-04-13	TSLA	Stock	19.78	20.4927	19.6867	20.2667	139269000.0
2017-04-13	TLT	Stock	123.45	123.74	122.91	123.47	8396661.0
2017-04-13	ES	Stock	59.71	59.92	59.3	59.62	1058000.0
2017-04-13	CL	Stock	73.71	73.91	73.58	73.66	2334200.0
2017-04-13	A	Stock	52.43	52.74	52.31	52.33	864000.0
2017-04-13	AA	Stock	32.11	32.47	30.99	30.99	6143300.0
2017-04-13	AAAP-DELISTED	Stock	37.75	37.9113	37.18	37.34	28312.0
2017-04-13	AABA-DELISTED	Stock	46.85	47.11	46.6072	46.9	3489319.0
2017-04-13	AAC-DELISTED	Stock	8.19	8.19	8.025	8.08	72047.0
2017-04-13	AACG	Stock	3.74	3.74	3.67	3.67	400.0
2017-04-13	AAIC-DELISTED	Stock	14.03	14.145	14.01	14.02	180823.0
2017-04-13	AAL	Stock	43.95	44.02	43.34	43.35	5504900.0
2017-04-13	AAM.A-DELISTED	Stock	25.39	25.39	25.26	25.29	155423.0
2017-04-13	AAMC-DELISTED	Stock	21.3529	21.3529	20.8529	21.1765	8085.0
2017-04-13	AAME	Stock	3.8	3.8	3.8	3.8	600.0
2017-04-13	AAMI	Stock	14.88	14.95	14.62	14.63	198200.0
2017-04-13	AAOI	Stock	49.85	50.0	44.64	45.3	13208400.0
2017-04-13	AAON	Stock	22.7667	22.9667	22.6	22.6333	147750.0
2017-04-13	AAP	Stock	141.92	142.84	140.89	140.89	476100.0
2017-04-13	AAT	Stock	44.23	44.39	43.84	43.84	348400.0
2017-04-13	AAU-DELISTED	Stock	1.66	1.75	1.56	1.72	1221124.0
2017-04-13	AAUAF-DELISTED	Stock	1.66	1.75	1.56	1.72	1239536.0
2017-04-13	AAV-DELISTED	Stock	6.75	6.75	6.525	6.55	57057.0
2017-04-13	AAWW-DELISTED	Stock	55.15	55.15	53.85	53.9	77517.0
2017-04-13	AAXJ	Stock	62.99	63.165	62.76	62.79	909506.0
2017-04-13	AAXN-DELISTED	Stock	22.22	22.5	22.02	22.05	819658.0
2017-04-13	AB	Stock	23.0	23.0	22.75	22.95	321200.0
2017-04-13	ABAC-DELISTED	Stock	2.59	2.7357	2.4	2.46	16247.0
2017-04-13	ABAX-DELISTED	Stock	47.0	47.12	46.285	46.55	49883.0
2017-04-13	ABB-DELISTED	Stock	22.91	22.94	22.62	22.62	2225777.0
2017-04-13	ABBNY-DELISTED	Stock	22.91	22.94	22.62	22.63	2289581.0
2017-04-13	ABBV	Stock	64.24	64.72	64.08	64.13	3896700.0
2017-04-13	ABC-DELISTED	Stock	86.64	87.29	86.36	86.66	651053.0
2017-04-13	ABCB	Stock	43.7	44.4	43.15	43.2	184500.0
2017-04-13	ABCD-DELISTED	Stock	4.88	4.89	4.76	4.77	10682.0
2017-04-13	ABCO-DELISTED	Stock	47.05	47.6	46.8	46.9	192951.0
2017-04-13	ABDC-DELISTED	Stock	14.02	14.73	14.02	14.44	100163.0
2017-04-13	ABE-DELISTED	Stock	13.5	13.556	13.36	13.36	12609.0
2017-04-13	ABEO	Stock	122.5	126.25	120.0	121.25	5132.0
2017-04-13	ABEOW-DELISTED	Stock	2.63	2.7	2.63	2.6999	559.0
2017-04-13	ABEV	Stock	5.6	5.66	5.59	5.62	14517100.0
2017-04-13	ABG	Stock	58.85	59.15	57.5	57.55	183500.0
2017-04-13	ABIL-DELISTED	Stock	1.23	1.2424	1.2	1.2	37786.0
2017-04-13	ABM	Stock	42.37	42.46	41.97	41.97	468300.0

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

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