PREVIEW / stock_daily / 2017-08-17

all stock daily files

  file:    by_date/stock_daily/2017/2017-08-17.parquet
  size:    213 KB
  rows:    6,421
  symbols: 2,930

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-08-17	AAPL	Stock	40.13	40.1775	39.46	39.465	111762400.0
2017-08-17	MSFT	Stock	73.58	73.87	72.4	72.4	22977500.0
2017-08-17	NVDA	Stock	4.1203	4.1375	4.0345	4.0368	525444000.0
2017-08-17	AMZN	Stock	48.892	48.892	48.016	48.0285	70248000.0
2017-08-17	GOOGL	Stock	47.1475	47.1905	46.382	46.383	33913880.0
2017-08-17	META	Stock	169.34	169.86	166.85	166.91	17216000.0
2017-08-17	TSLA	Stock	24.0807	24.22	23.4393	23.4613	75415500.0
2017-08-17	TLT	Stock	125.7	126.675	125.51	126.65	9364681.0
2017-08-17	ES	Stock	62.85	62.97	62.39	62.46	1114000.0
2017-08-17	CL	Stock	71.99	72.35	71.27	71.3	3250900.0
2017-08-17	A	Stock	62.0	62.07	60.78	60.86	3501600.0
2017-08-17	AA	Stock	39.0	39.0	37.75	37.8	3298900.0
2017-08-17	AAAP-DELISTED	Stock	49.24	49.635	48.45	48.99	24108.0
2017-08-17	AABA-DELISTED	Stock	62.92	63.46	62.09	62.21	10521039.0
2017-08-17	AAC-DELISTED	Stock	8.67	9.0	8.51	8.79	105090.0
2017-08-17	AACG	Stock	4.61	4.62	4.61	4.62	400.0
2017-08-17	AAIC-DELISTED	Stock	13.15	13.1759	12.99	13.0	365966.0
2017-08-17	AAL	Stock	48.25	48.34	45.8	46.03	10304200.0
2017-08-17	AAM.A-DELISTED	Stock	25.95	26.06	25.92	26.05	25280.0
2017-08-17	AAMC-DELISTED	Stock	22.0441	22.5	22.0441	22.2794	12821.0
2017-08-17	AAME	Stock	3.45	3.45	3.45	3.45	100.0
2017-08-17	AAMI	Stock	13.66	13.74	13.26	13.26	548800.0
2017-08-17	AAOI	Stock	65.0	66.57	64.26	64.51	2047500.0
2017-08-17	AAON	Stock	21.5	21.6333	21.02	21.1	270750.0
2017-08-17	AAP	Stock	90.75	95.49	90.18	92.85	4675100.0
2017-08-17	AAT	Stock	40.5	40.72	40.21	40.27	206000.0
2017-08-17	AAU-DELISTED	Stock	1.14	1.14	1.0838	1.095	125187.0
2017-08-17	AAUAF-DELISTED	Stock	1.14	1.14	1.0838	1.095	128907.0
2017-08-17	AAV-DELISTED	Stock	6.3	6.4	6.3	6.35	83622.0
2017-08-17	AAWW-DELISTED	Stock	62.4	62.75	60.425	60.475	181132.0
2017-08-17	AAXJ	Stock	70.42	70.555	69.75	69.81	1320082.0
2017-08-17	AAXN-DELISTED	Stock	21.55	21.86	21.445	21.48	402867.0
2017-08-17	AB	Stock	23.45	23.55	23.1	23.15	149400.0
2017-08-17	ABAC-DELISTED	Stock	2.08	2.0905	1.99	2.07	16917.0
2017-08-17	ABAX-DELISTED	Stock	47.07	48.0	47.07	47.78	78975.0
2017-08-17	ABB-DELISTED	Stock	23.1	23.1299	22.905	22.91	1478590.0
2017-08-17	ABBNY-DELISTED	Stock	23.1	23.1299	22.905	22.91	1532503.0
2017-08-17	ABBV	Stock	70.6	70.68	69.83	69.85	5086000.0
2017-08-17	ABC-DELISTED	Stock	79.68	81.34	79.68	79.94	1444082.0
2017-08-17	ABCB	Stock	44.85	45.0	43.45	43.6	187700.0
2017-08-17	ABCD-DELISTED	Stock	5.14	5.21	5.0	5.15	69261.0
2017-08-17	ABCO-DELISTED	Stock	51.6	51.9	51.05	51.05	249396.0
2017-08-17	ABDC-DELISTED	Stock	10.79	10.8513	10.38	10.62	78798.0
2017-08-17	ABE-DELISTED	Stock	13.83	13.83	13.73	13.75	8513.0
2017-08-17	ABEO	Stock	210.0	225.25	201.25	203.75	24432.0
2017-08-17	ABEOW-DELISTED	Stock	4.49	4.5	4.35	4.35	2400.0
2017-08-17	ABEV	Stock	6.2	6.24	6.18	6.19	14546100.0
2017-08-17	ABG	Stock	51.1	51.45	49.9	50.15	204200.0
2017-08-17	ABIL-DELISTED	Stock	0.68	0.72	0.6326	0.6581	23698.0
2017-08-17	ABM	Stock	43.94	44.16	43.17	43.18	195100.0

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

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