PREVIEW / stock_daily / 2018-05-15

all stock daily files

  file:    by_date/stock_daily/2018/2018-05-15.parquet
  size:    217 KB
  rows:    6,510
  symbols: 2,824

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-15	AAPL	Stock	46.695	46.7675	46.275	46.61	94780800.0
2018-05-15	MSFT	Stock	97.24	97.85	96.34	97.32	24594000.0
2018-05-15	NVDA	Stock	6.3198	6.3225	6.0375	6.139	963528000.0
2018-05-15	AMZN	Stock	79.39	79.39	78.261	78.806	101550000.0
2018-05-15	GOOGL	Stock	54.845	54.956	53.939	54.2435	35738520.0
2018-05-15	META	Stock	184.88	185.29	183.2	184.32	15429400.0
2018-05-15	TSLA	Stock	19.0007	19.1307	18.7	18.9453	142788000.0
2018-05-15	TLT	Stock	117.56	117.58	116.7	117.25	12901003.0
2018-05-15	ES	Stock	57.34	57.52	56.8	57.39	1494300.0
2018-05-15	CL	Stock	61.79	61.9	61.28	61.65	6573100.0
2018-05-15	A	Stock	61.84	64.1	60.7	62.5	14451200.0
2018-05-15	AA	Stock	51.79	51.95	50.4	50.54	6216300.0
2018-05-15	AABA-DELISTED	Stock	75.92	76.46	75.4	76.44	1634306.0
2018-05-15	AAC-DELISTED	Stock	11.29	11.52	11.19	11.41	35745.0
2018-05-15	AACG	Stock	5.27	5.3	5.27	5.3	5800.0
2018-05-15	AAIC-DELISTED	Stock	10.92	11.03	10.91	10.97	485976.0
2018-05-15	AAL	Stock	42.02	43.4	41.6	43.19	6909600.0
2018-05-15	AAM.A-DELISTED	Stock	25.02	25.0225	24.9	24.99	40288.0
2018-05-15	AAM.B-DELISTED	Stock	24.79	24.79	24.52	24.603	94319.0
2018-05-15	AAMC-DELISTED	Stock	19.0735	19.1176	18.4265	19.1176	3288.0
2018-05-15	AAME	Stock	2.75	2.95	2.75	2.85	23300.0
2018-05-15	AAMI	Stock	15.38	15.54	15.35	15.48	325700.0
2018-05-15	AAOI	Stock	31.91	32.5	31.4	32.4	434000.0
2018-05-15	AAON	Stock	19.5	19.8	19.3667	19.6667	309900.0
2018-05-15	AAP	Stock	121.29	121.44	118.78	119.92	878100.0
2018-05-15	AAT	Stock	34.99	34.99	34.35	34.51	399500.0
2018-05-15	AAU-DELISTED	Stock	0.76	0.76	0.7499	0.7501	229569.0
2018-05-15	AAUAF-DELISTED	Stock	0.76	0.76	0.7499	0.7541	259974.0
2018-05-15	AAV-DELISTED	Stock	2.95	3.14	2.9	3.1	201647.0
2018-05-15	AAWW-DELISTED	Stock	67.2	68.6	67.1	68.5	184394.0
2018-05-15	AAXJ	Stock	76.62	76.62	75.99	76.25	872721.0
2018-05-15	AAXN-DELISTED	Stock	53.87	54.67	52.22	54.54	1884455.0
2018-05-15	AB	Stock	26.95	27.25	26.9	26.9	673900.0
2018-05-15	ABAC-DELISTED	Stock	2.25	2.25	2.25	2.25	100.0
2018-05-15	ABAX-DELISTED	Stock	71.96	72.06	71.045	71.755	128536.0
2018-05-15	ABB-DELISTED	Stock	23.7	23.87	23.62	23.82	1165573.0
2018-05-15	ABBNY-DELISTED	Stock	23.7	23.87	23.62	23.82	1309359.0
2018-05-15	ABBV	Stock	105.38	105.56	103.59	104.18	8387600.0
2018-05-15	ABC-DELISTED	Stock	86.6	87.48	85.43	85.68	901928.0
2018-05-15	ABCB	Stock	54.8	55.75	54.8	55.35	196000.0
2018-05-15	ABCD-DELISTED	Stock	10.6	10.84	10.22	10.38	232938.0
2018-05-15	ABDC-DELISTED	Stock	6.57	6.75	6.45	6.75	62856.0
2018-05-15	ABEO	Stock	521.25	528.75	505.0	512.5	22860.0
2018-05-15	ABEOW-DELISTED	Stock	16.0	16.0	16.0	16.0	200.0
2018-05-15	ABEV	Stock	5.84	5.85	5.76	5.82	17556300.0
2018-05-15	ABG	Stock	70.15	70.55	69.5	70.0	213400.0
2018-05-15	ABIL-DELISTED	Stock	2.69	2.76	2.6101	2.6101	25783.0
2018-05-15	ABLX-DELISTED	Stock	53.37	53.65	53.12	53.12	3548.0
2018-05-15	ABM	Stock	30.12	30.47	30.08	30.24	725700.0
2018-05-15	ABMD-DELISTED	Stock	373.01	381.225	368.14	380.35	405904.0

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

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