PREVIEW / stock_daily / 2018-05-29

all stock daily files

  file:    by_date/stock_daily/2018/2018-05-29.parquet
  size:    217 KB
  rows:    6,504
  symbols: 2,800

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-29	AAPL	Stock	46.9	47.1875	46.7175	46.975	90056400.0
2018-05-29	MSFT	Stock	97.84	98.88	97.23	98.01	28671000.0
2018-05-29	NVDA	Stock	6.2138	6.2835	6.1675	6.2148	352684000.0
2018-05-29	AMZN	Stock	80.0355	81.0895	80.0075	80.6435	76930000.0
2018-05-29	GOOGL	Stock	53.8	54.067	53.154	53.4035	36076100.0
2018-05-29	META	Stock	184.34	186.81	183.71	185.74	16398900.0
2018-05-29	TSLA	Stock	18.5673	19.1	18.41	18.9173	84999000.0
2018-05-29	TLT	Stock	120.79	122.52	120.4261	122.24	21668143.0
2018-05-29	ES	Stock	56.45	57.28	56.36	56.81	3023600.0
2018-05-29	CL	Stock	63.67	64.08	63.36	63.56	5033600.0
2018-05-29	A	Stock	62.63	62.67	61.3	61.85	3559200.0
2018-05-29	AA	Stock	47.57	47.95	46.82	47.3	1973400.0
2018-05-29	AABA-DELISTED	Stock	76.96	78.29	76.45	76.77	1364983.0
2018-05-29	AAC-DELISTED	Stock	11.38	11.63	10.73	11.06	260932.0
2018-05-29	AACG	Stock	5.0	5.12	5.0	5.1	2500.0
2018-05-29	AAIC-DELISTED	Stock	11.21	11.3501	11.18	11.27	487128.0
2018-05-29	AAL	Stock	44.6	45.15	43.22	43.59	4531800.0
2018-05-29	AAM.A-DELISTED	Stock	25.45	25.5	25.45	25.5	23176.0
2018-05-29	AAM.B-DELISTED	Stock	25.02	25.02	24.97	24.99	45020.0
2018-05-29	AAMC-DELISTED	Stock	19.2794	19.2794	19.2794	19.2794	1401.0
2018-05-29	AAME	Stock	2.7	2.7	2.67	2.7	1500.0
2018-05-29	AAMI	Stock	15.39	15.45	14.93	15.22	383600.0
2018-05-29	AAOI	Stock	34.32	35.86	34.32	35.72	1039300.0
2018-05-29	AAON	Stock	20.0	20.3733	19.8533	20.2333	1473300.0
2018-05-29	AAP	Stock	124.36	124.99	123.06	123.96	1163300.0
2018-05-29	AAT	Stock	35.35	35.84	35.22	35.74	211600.0
2018-05-29	AAU-DELISTED	Stock	0.74	0.74	0.705	0.7199	49263.0
2018-05-29	AAUAF-DELISTED	Stock	0.74	0.74	0.705	0.7199	52060.0
2018-05-29	AAV-DELISTED	Stock	2.9	2.95	2.824	2.9	171842.0
2018-05-29	AAWW-DELISTED	Stock	68.15	70.845	67.4	68.45	246429.0
2018-05-29	AAXJ	Stock	76.28	76.28	75.11	75.44	1739858.0
2018-05-29	AAXN-DELISTED	Stock	63.71	64.94	63.15	63.97	965481.0
2018-05-29	AB	Stock	28.25	28.35	27.79	27.95	364600.0
2018-05-29	ABAX-DELISTED	Stock	83.0	83.1	82.5	82.59	385651.0
2018-05-29	ABB-DELISTED	Stock	23.1	23.165	22.835	22.93	1614791.0
2018-05-29	ABBNY-DELISTED	Stock	23.1	23.165	22.835	22.92	1871541.0
2018-05-29	ABBV	Stock	100.27	101.59	98.93	99.47	25494700.0
2018-05-29	ABC-DELISTED	Stock	84.57	84.845	82.0975	82.57	1168548.0
2018-05-29	ABCB	Stock	55.95	55.95	54.45	55.0	777800.0
2018-05-29	ABCD-DELISTED	Stock	10.01	10.21	9.5534	10.11	87232.0
2018-05-29	ABDC-DELISTED	Stock	6.6	6.66	6.49	6.61	73111.0
2018-05-29	ABEO	Stock	415.0	450.0	406.25	447.5	35192.0
2018-05-29	ABEV	Stock	5.28	5.33	5.16	5.2	28892600.0
2018-05-29	ABG	Stock	69.6	70.15	68.9	69.2	161200.0
2018-05-29	ABIL-DELISTED	Stock	2.54	2.55	2.35	2.44	19584.0
2018-05-29	ABLX-DELISTED	Stock	52.38	52.38	51.12	51.84	8546.0
2018-05-29	ABM	Stock	29.05	29.42	28.54	28.82	1326100.0
2018-05-29	ABMD-DELISTED	Stock	388.65	394.39	375.0	387.53	967255.0
2018-05-29	ABR	Stock	9.44	9.56	9.44	9.53	1151700.0
2018-05-29	ABR.A-DELISTED	Stock	25.75	25.75	25.5801	25.6519	1508.0

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

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