PREVIEW / stock_daily / 2017-08-28

all stock daily files

  file:    by_date/stock_daily/2017/2017-08-28.parquet
  size:    214 KB
  rows:    6,470
  symbols: 2,959

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-28	AAPL	Stock	40.035	40.5	39.9825	40.3675	103864000.0
2017-08-28	MSFT	Stock	73.06	73.09	72.55	72.83	14569700.0
2017-08-28	NVDA	Stock	4.1145	4.1275	4.0582	4.1242	389496000.0
2017-08-28	AMZN	Stock	47.327	47.65	47.1125	47.301	51934000.0
2017-08-28	GOOGL	Stock	46.594	46.7425	46.3055	46.4065	20987940.0
2017-08-28	META	Stock	166.91	167.7	166.33	167.24	8553700.0
2017-08-28	TSLA	Stock	23.152	23.1567	22.648	23.044	56460000.0
2017-08-28	TLT	Stock	126.92	127.39	126.73	127.24	4448548.0
2017-08-28	ES	Stock	63.11	63.35	62.99	63.27	1147000.0
2017-08-28	CL	Stock	71.28	71.33	70.66	70.9	3106100.0
2017-08-28	A	Stock	63.1	63.58	62.97	63.46	1290400.0
2017-08-28	AA	Stock	41.43	42.26	41.05	42.17	2696000.0
2017-08-28	AAAP-DELISTED	Stock	48.36	49.1	48.36	48.82	49382.0
2017-08-28	AABA-DELISTED	Stock	64.43	64.43	63.13	63.52	4462917.0
2017-08-28	AAC-DELISTED	Stock	9.07	9.3299	8.9578	9.12	37703.0
2017-08-28	AACG	Stock	4.66	4.73	4.66	4.7	13800.0
2017-08-28	AAIC-DELISTED	Stock	12.98	13.03	12.91	12.96	179482.0
2017-08-28	AAL	Stock	45.23	45.37	44.78	44.95	6969300.0
2017-08-28	AAM.A-DELISTED	Stock	26.33	26.33	26.2001	26.29	21127.0
2017-08-28	AAMC-DELISTED	Stock	22.7206	23.9706	22.7206	23.8235	4886.0
2017-08-28	AAME	Stock	3.4	3.4	3.25	3.25	2700.0
2017-08-28	AAMI	Stock	13.62	13.66	13.48	13.52	187300.0
2017-08-28	AAOI	Stock	61.84	62.3	60.5	61.25	1468300.0
2017-08-28	AAON	Stock	21.2333	21.3333	21.0	21.2667	186750.0
2017-08-28	AAP	Stock	95.94	96.31	93.95	94.66	1108300.0
2017-08-28	AAT	Stock	40.86	41.23	40.19	40.35	225600.0
2017-08-28	AAU-DELISTED	Stock	1.13	1.17	1.1134	1.15	378918.0
2017-08-28	AAUAF-DELISTED	Stock	1.13	1.17	1.1134	1.16	394025.0
2017-08-28	AAV-DELISTED	Stock	6.45	6.5	6.3	6.35	57766.0
2017-08-28	AAWW-DELISTED	Stock	63.95	64.8	63.45	64.5	234126.0
2017-08-28	AAXJ	Stock	72.05	72.07	71.697	71.79	1874756.0
2017-08-28	AAXN-DELISTED	Stock	21.63	21.95	21.61	21.9	559431.0
2017-08-28	AB	Stock	23.35	23.5	23.2	23.3	153200.0
2017-08-28	ABAC-DELISTED	Stock	2.2256	2.2256	2.2256	2.2256	125.0
2017-08-28	ABAX-DELISTED	Stock	45.47	46.6	45.17	45.5	116463.0
2017-08-28	ABB-DELISTED	Stock	23.24	23.25	23.06	23.075	1112202.0
2017-08-28	ABBNY-DELISTED	Stock	23.24	23.25	23.06	23.07	1152622.0
2017-08-28	ABBV	Stock	72.67	73.57	72.56	73.32	4574400.0
2017-08-28	ABC-DELISTED	Stock	78.38	78.88	77.69	78.66	1020298.0
2017-08-28	ABCB	Stock	44.55	44.55	44.05	44.25	99600.0
2017-08-28	ABCD-DELISTED	Stock	5.25	5.44	5.25	5.38	30109.0
2017-08-28	ABCO-DELISTED	Stock	50.8	50.8	49.6	49.85	480894.0
2017-08-28	ABDC-DELISTED	Stock	10.5	10.82	10.495	10.73	150359.0
2017-08-28	ABEO	Stock	226.25	247.0	225.0	237.5	27500.0
2017-08-28	ABEOW-DELISTED	Stock	5.3	5.3	5.185	5.2	650.0
2017-08-28	ABEV	Stock	6.26	6.26	6.21	6.23	8938700.0
2017-08-28	ABG	Stock	51.3	51.5	50.3	51.0	167200.0
2017-08-28	ABIL-DELISTED	Stock	0.97	1.0	0.812	0.85	558146.0
2017-08-28	ABM	Stock	44.16	44.46	43.94	44.08	124500.0
2017-08-28	ABMD-DELISTED	Stock	147.8	149.12	147.67	147.9	229951.0

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

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