PREVIEW / stock_daily / 2017-04-03

all stock daily files

  file:    by_date/stock_daily/2017/2017-04-03.parquet
  size:    215 KB
  rows:    6,471
  symbols: 3,046

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-03	AAPL	Stock	35.9275	36.03	35.7625	35.925	79942800.0
2017-04-03	MSFT	Stock	65.81	65.94	65.19	65.55	20400900.0
2017-04-03	NVDA	Stock	2.7238	2.7413	2.6855	2.7095	445232000.0
2017-04-03	AMZN	Stock	44.4	44.6745	44.271	44.5755	68446000.0
2017-04-03	GOOGL	Stock	42.4375	42.95	42.3765	42.8375	39388040.0
2017-04-03	META	Stock	141.93	142.47	140.82	142.28	13564000.0
2017-04-03	TSLA	Stock	19.1267	19.9333	18.972	19.9013	208329000.0
2017-04-03	TLT	Stock	120.45	121.87	120.4	121.67	12996495.0
2017-04-03	ES	Stock	58.76	58.92	58.27	58.89	1205300.0
2017-04-03	CL	Stock	73.1	73.65	72.99	73.37	3397000.0
2017-04-03	A	Stock	52.9	53.21	52.73	53.2	1550200.0
2017-04-03	AA	Stock	34.62	35.0	33.502	34.22	4204800.0
2017-04-03	AAAP-DELISTED	Stock	39.9	40.03	39.29	39.57	96216.0
2017-04-03	AABA-DELISTED	Stock	46.5	46.85	46.16	46.43	6341586.0
2017-04-03	AAC-DELISTED	Stock	8.55	8.79	8.39	8.51	132612.0
2017-04-03	AACG	Stock	3.76	3.83	3.74	3.82	8000.0
2017-04-03	AAIC-DELISTED	Stock	14.12	14.19	14.01	14.02	353744.0
2017-04-03	AAL	Stock	42.33	42.57	41.63	42.45	5764700.0
2017-04-03	AAM.A-DELISTED	Stock	25.17	25.27	25.17	25.23	192880.0
2017-04-03	AAMC-DELISTED	Stock	22.1176	22.1324	20.8971	21.4118	27319.0
2017-04-03	AAME	Stock	3.85	3.85	3.75	3.75	1400.0
2017-04-03	AAMI	Stock	15.26	15.45	14.84	15.05	261700.0
2017-04-03	AAOI	Stock	56.92	57.9	53.17	53.47	1627400.0
2017-04-03	AAON	Stock	23.5333	23.6333	22.5667	22.9	347100.0
2017-04-03	AAP	Stock	148.4	149.2	143.56	145.5	2029800.0
2017-04-03	AAT	Stock	41.79	41.99	41.52	41.8	240300.0
2017-04-03	AAU-DELISTED	Stock	1.16	1.19	1.13	1.13	128346.0
2017-04-03	AAUAF-DELISTED	Stock	1.16	1.19	1.13	1.13	129866.0
2017-04-03	AAV-DELISTED	Stock	6.65	6.65	6.5	6.6	54603.0
2017-04-03	AAWW-DELISTED	Stock	55.4	55.8917	53.55	53.7	134879.0
2017-04-03	AAXJ	Stock	63.27	63.43	62.99	63.4	1293652.0
2017-04-03	AAXN-DELISTED	Stock	22.78	22.83	22.48	22.495	539108.0
2017-04-03	AB	Stock	22.85	22.95	22.5	22.6	209600.0
2017-04-03	ABAC-DELISTED	Stock	2.31	2.4045	2.31	2.31	6883.0
2017-04-03	ABAX-DELISTED	Stock	48.65	48.87	48.29	48.55	90718.0
2017-04-03	ABB-DELISTED	Stock	23.33	23.37	23.12	23.23	1680304.0
2017-04-03	ABBNY-DELISTED	Stock	23.33	23.37	23.12	23.24	3617230.0
2017-04-03	ABBV	Stock	65.24	65.59	64.88	65.03	5229600.0
2017-04-03	ABC-DELISTED	Stock	88.41	88.63	86.8	87.34	1157751.0
2017-04-03	ABCB	Stock	46.1	46.2	44.45	45.1	209600.0
2017-04-03	ABCD-DELISTED	Stock	4.9	4.9	4.81	4.85	14127.0
2017-04-03	ABCO-DELISTED	Stock	46.8	47.15	46.05	46.8	278073.0
2017-04-03	ABDC-DELISTED	Stock	13.78	13.95	13.28	13.91	73820.0
2017-04-03	ABE-DELISTED	Stock	13.02	13.89	13.02	13.49	29297.0
2017-04-03	ABEO	Stock	123.75	131.25	122.5	127.5	15860.0
2017-04-03	ABEOW-DELISTED	Stock	2.55	2.9	2.55	2.9	405.0
2017-04-03	ABEV	Stock	5.79	5.81	5.74	5.77	11307100.0
2017-04-03	ABG	Stock	60.3	60.3	57.35	57.6	356100.0
2017-04-03	ABIL-DELISTED	Stock	2.0	2.0	1.89	1.9	15319.0
2017-04-03	ABM	Stock	43.59	43.73	42.36	42.44	341400.0

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

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