PREVIEW / stock_daily / 2018-05-31

all stock daily files

  file:    by_date/stock_daily/2018/2018-05-31.parquet
  size:    218 KB
  rows:    6,505
  symbols: 2,799

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
2018-05-31	AAPL	Stock	46.805	47.0575	46.535	46.7175	109931200.0
2018-05-31	MSFT	Stock	99.29	99.99	98.61	98.84	34140900.0
2018-05-31	NVDA	Stock	6.2925	6.38	6.2818	6.3048	493868000.0
2018-05-31	AMZN	Stock	81.15	81.75	81.0675	81.481	63326000.0
2018-05-31	GOOGL	Stock	54.1	55.5	53.9	55.0	79367240.0
2018-05-31	META	Stock	187.87	192.72	187.48	191.78	30782600.0
2018-05-31	TSLA	Stock	19.1473	19.358	18.862	18.982	88795500.0
2018-05-31	TLT	Stock	121.56	121.98	120.95	121.22	10769941.0
2018-05-31	ES	Stock	57.16	57.43	56.81	57.08	2076500.0
2018-05-31	CL	Stock	64.23	64.26	62.91	63.09	4738000.0
2018-05-31	A	Stock	62.65	62.83	61.85	61.92	2510400.0
2018-05-31	AA	Stock	49.98	50.43	47.81	48.07	4026900.0
2018-05-31	AABA-DELISTED	Stock	76.86	77.49	76.7	77.16	2305002.0
2018-05-31	AAC-DELISTED	Stock	10.77	11.01	10.73	10.76	148073.0
2018-05-31	AACG	Stock	5.11	5.26	5.11	5.26	2500.0
2018-05-31	AAIC-DELISTED	Stock	11.52	11.54	11.41	11.44	488779.0
2018-05-31	AAL	Stock	43.4	44.71	42.97	43.54	8540100.0
2018-05-31	AAM.A-DELISTED	Stock	24.92	25.09	24.85	24.94	60254.0
2018-05-31	AAM.B-DELISTED	Stock	24.5	24.56	24.29	24.4	143726.0
2018-05-31	AAMC-DELISTED	Stock	20.0441	20.5	20.0441	20.2647	3233.0
2018-05-31	AAME	Stock	2.91	2.95	2.75	2.95	3000.0
2018-05-31	AAMI	Stock	15.48	15.625	15.393	15.51	553200.0
2018-05-31	AAOI	Stock	41.01	46.79	41.01	46.77	4887600.0
2018-05-31	AAON	Stock	20.4333	20.5333	20.32	20.3333	531600.0
2018-05-31	AAP	Stock	128.34	129.41	126.0	128.62	1535200.0
2018-05-31	AAT	Stock	36.29	36.45	36.07	36.35	397000.0
2018-05-31	AAU-DELISTED	Stock	0.715	0.7241	0.702	0.7046	81765.0
2018-05-31	AAUAF-DELISTED	Stock	0.715	0.7241	0.702	0.7046	88805.0
2018-05-31	AAV-DELISTED	Stock	2.9	3.04	2.86	3.0	231027.0
2018-05-31	AAWW-DELISTED	Stock	68.95	69.2	67.6	68.1	138635.0
2018-05-31	AAXJ	Stock	75.8	76.2799	75.62	76.0	500281.0
2018-05-31	AAXN-DELISTED	Stock	63.7	64.74	63.165	63.69	846377.0
2018-05-31	AB	Stock	28.45	28.48	28.05	28.35	267900.0
2018-05-31	ABAC-DELISTED	Stock	2.201	2.201	2.2	2.2	1199.0
2018-05-31	ABAX-DELISTED	Stock	83.32	83.4199	82.78	82.78	404840.0
2018-05-31	ABB-DELISTED	Stock	22.91	22.95	22.59	22.735	2497523.0
2018-05-31	ABBNY-DELISTED	Stock	22.91	22.95	22.59	22.74	3411684.0
2018-05-31	ABBV	Stock	100.93	101.1	98.5	98.94	18910900.0
2018-05-31	ABC-DELISTED	Stock	84.43	84.43	81.97	82.14	1187440.0
2018-05-31	ABCB	Stock	55.8	56.55	55.25	55.7	453800.0
2018-05-31	ABCD-DELISTED	Stock	10.06	10.1834	9.96	10.01	146548.0
2018-05-31	ABDC-DELISTED	Stock	6.77	6.825	6.66	6.68	93378.0
2018-05-31	ABEO	Stock	463.75	468.75	435.0	442.5	35276.0
2018-05-31	ABEV	Stock	5.27	5.3	5.22	5.26	11267600.0
2018-05-31	ABG	Stock	70.45	70.45	68.7	69.55	166600.0
2018-05-31	ABIL-DELISTED	Stock	2.31	2.31	2.16	2.26	15367.0
2018-05-31	ABLX-DELISTED	Stock	52.34	52.78	50.631	52.27	3288.0
2018-05-31	ABM	Stock	29.09	29.15	28.26	28.46	1077100.0
2018-05-31	ABMD-DELISTED	Stock	389.21	391.97	379.51	381.17	2713027.0
2018-05-31	ABR	Stock	9.53	9.58	9.46	9.56	987800.0

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

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