PREVIEW / stock_daily / 2018-05-17

all stock daily files

  file:    by_date/stock_daily/2018/2018-05-17.parquet
  size:    218 KB
  rows:    6,491
  symbols: 2,803

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-17	AAPL	Stock	47.0	47.2275	46.59	46.7475	69176000.0
2018-05-17	MSFT	Stock	96.76	97.54	95.83	96.18	17246700.0
2018-05-17	NVDA	Stock	6.152	6.2875	6.1358	6.1928	519784000.0
2018-05-17	AMZN	Stock	79.028	79.702	78.65	79.088	42952000.0
2018-05-17	GOOGL	Stock	54.073	54.55	53.821	54.063	25738140.0
2018-05-17	META	Stock	182.68	184.06	182.22	183.76	14840700.0
2018-05-17	TSLA	Stock	19.06	19.2793	18.9313	18.9693	66309000.0
2018-05-17	TLT	Stock	116.63	116.82	116.09	116.21	7330707.0
2018-05-17	ES	Stock	57.5	57.71	56.96	57.1	1888000.0
2018-05-17	CL	Stock	62.21	62.38	61.82	62.29	4080900.0
2018-05-17	A	Stock	61.98	63.91	61.76	63.59	5211300.0
2018-05-17	AA	Stock	49.83	51.09	49.83	50.71	2887600.0
2018-05-17	AABA-DELISTED	Stock	76.77	77.34	76.37	76.48	1512638.0
2018-05-17	AAC-DELISTED	Stock	11.53	11.81	11.43	11.74	68472.0
2018-05-17	AACG	Stock	5.3	5.3	5.1	5.1	400.0
2018-05-17	AAIC-DELISTED	Stock	10.95	11.04	10.895	10.94	545927.0
2018-05-17	AAL	Stock	43.9	44.51	43.49	43.63	5334100.0
2018-05-17	AAM.A-DELISTED	Stock	25.18	25.18	25.08	25.12	14326.0
2018-05-17	AAM.B-DELISTED	Stock	24.8	24.8	24.73	24.7672	24220.0
2018-05-17	AAMC-DELISTED	Stock	18.9265	18.9265	18.5588	18.5588	2084.0
2018-05-17	AAME	Stock	2.85	2.85	2.75	2.75	1900.0
2018-05-17	AAMI	Stock	15.49	15.685	15.43	15.66	357800.0
2018-05-17	AAOI	Stock	33.04	34.1	32.92	33.74	607400.0
2018-05-17	AAON	Stock	20.0333	20.8667	20.0	20.7	422550.0
2018-05-17	AAP	Stock	119.14	120.58	118.08	119.79	1054900.0
2018-05-17	AAT	Stock	34.53	34.73	34.3	34.56	301200.0
2018-05-17	AAU-DELISTED	Stock	0.745	0.7751	0.7301	0.755	202454.0
2018-05-17	AAUAF-DELISTED	Stock	0.745	0.7751	0.7301	0.755	210477.0
2018-05-17	AAV-DELISTED	Stock	3.15	3.2	3.1	3.125	214834.0
2018-05-17	AAWW-DELISTED	Stock	69.25	69.8	68.7	69.2	114712.0
2018-05-17	AAXJ	Stock	76.61	76.8	76.18	76.4	791641.0
2018-05-17	AAXN-DELISTED	Stock	55.27	57.89	54.28	57.12	5123938.0
2018-05-17	AB	Stock	27.45	27.75	27.2	27.7	354500.0
2018-05-17	ABAC-DELISTED	Stock	2.25	2.25	2.2	2.2475	17066.0
2018-05-17	ABAX-DELISTED	Stock	83.26	83.77	83.0	83.71	984959.0
2018-05-17	ABB-DELISTED	Stock	23.91	24.12	23.91	24.08	1822504.0
2018-05-17	ABBNY-DELISTED	Stock	23.91	24.12	23.91	24.09	2265785.0
2018-05-17	ABBV	Stock	105.1	105.41	104.21	105.32	6702900.0
2018-05-17	ABC-DELISTED	Stock	85.94	87.86	85.33	87.1	1336265.0
2018-05-17	ABCB	Stock	55.55	55.95	55.24	55.9	218600.0
2018-05-17	ABCD-DELISTED	Stock	10.19	10.3574	9.87	9.95	217198.0
2018-05-17	ABDC-DELISTED	Stock	6.8	6.92	6.65	6.7	42295.0
2018-05-17	ABEO	Stock	525.0	536.25	500.0	536.25	35324.0
2018-05-17	ABEOW-DELISTED	Stock	15.87	15.87	15.85	15.85	1500.0
2018-05-17	ABEV	Stock	5.77	5.77	5.64	5.66	27218000.0
2018-05-17	ABG	Stock	70.5	71.5	69.7	70.6	316600.0
2018-05-17	ABIL-DELISTED	Stock	2.49	2.58	2.49	2.5425	13440.0
2018-05-17	ABLX-DELISTED	Stock	53.13	53.17	52.85	52.9	34768.0
2018-05-17	ABM	Stock	30.29	30.4	30.0	30.1	692600.0
2018-05-17	ABMD-DELISTED	Stock	380.35	384.4	377.75	379.79	405691.0

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

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