PREVIEW / stock_daily / 2018-10-16

all stock daily files

  file:    by_date/stock_daily/2018/2018-10-16.parquet
  size:    221 KB
  rows:    6,542
  symbols: 2,725

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-10-16	AAPL	Stock	54.7325	55.7475	54.19	55.5375	116736000.0
2018-10-16	MSFT	Stock	109.54	111.41	108.95	111.0	31610200.0
2018-10-16	NVDA	Stock	5.9983	6.157	5.9485	6.1458	408712000.0
2018-10-16	AMZN	Stock	89.175	91.194	88.0775	90.998	117198000.0
2018-10-16	GOOGL	Stock	55.674	56.8185	55.5875	56.654	38377580.0
2018-10-16	META	Stock	155.4	159.46	155.01	158.78	19180100.0
2018-10-16	TSLA	Stock	17.7133	18.492	17.4827	18.4393	142896000.0
2018-10-16	TLT	Stock	114.39	114.72	114.16	114.68	4762322.0
2018-10-16	ES	Stock	61.41	62.4	61.09	61.96	1769900.0
2018-10-16	CL	Stock	62.71	62.93	62.42	62.61	3226000.0
2018-10-16	A	Stock	66.25	67.57	65.99	67.46	1868300.0
2018-10-16	AA	Stock	35.48	36.295	35.3	36.19	2686800.0
2018-10-16	AABA-DELISTED	Stock	61.63	62.905	61.23	62.83	5773313.0
2018-10-16	AAC-DELISTED	Stock	6.9	6.95	6.5	6.89	313484.0
2018-10-16	AACG	Stock	1.01	1.11	1.01	1.08	120300.0
2018-10-16	AAIC-DELISTED	Stock	8.47	8.717	8.45	8.67	332493.0
2018-10-16	AAL	Stock	32.06	33.44	31.98	33.28	11339200.0
2018-10-16	AAM.A-DELISTED	Stock	24.075	24.1352	24.04	24.045	29424.0
2018-10-16	AAM.B-DELISTED	Stock	24.08	24.1	23.94	23.95	25708.0
2018-10-16	AAMC-DELISTED	Stock	16.1735	16.1735	15.2618	15.3618	10577.0
2018-10-16	AAME	Stock	2.9	2.95	2.67	2.88	7700.0
2018-10-16	AAMI	Stock	12.32	12.44	12.07	12.39	372400.0
2018-10-16	AAOI	Stock	22.53	23.57	22.246	23.37	642000.0
2018-10-16	AAON	Stock	21.5933	21.88	21.2267	21.8533	232050.0
2018-10-16	AAP	Stock	170.7	170.7	163.78	168.37	1067700.0
2018-10-16	AAT	Stock	36.01	36.99	35.61	36.89	139200.0
2018-10-16	AAU-DELISTED	Stock	0.57	0.57	0.55	0.5549	235959.0
2018-10-16	AAUAF-DELISTED	Stock	0.57	0.57	0.55	0.5549	239211.0
2018-10-16	AAWW-DELISTED	Stock	53.25	54.14	51.875	53.77	202134.0
2018-10-16	AAXJ	Stock	64.72	65.57	64.71	65.53	701697.0
2018-10-16	AAXN-DELISTED	Stock	57.6	61.37	57.35	61.24	325614.0
2018-10-16	AB	Stock	30.01	30.64	29.78	30.5	701000.0
2018-10-16	ABAC-DELISTED	Stock	1.8874	1.8874	1.77	1.83	5877.0
2018-10-16	ABB-DELISTED	Stock	21.45	21.5	21.35	21.47	1401511.0
2018-10-16	ABBNY-DELISTED	Stock	21.45	21.5	21.35	21.47	1468143.0
2018-10-16	ABBV	Stock	89.78	91.98	89.53	91.91	3787100.0
2018-10-16	ABC-DELISTED	Stock	90.03	93.22	89.49	92.54	1782727.0
2018-10-16	ABCB	Stock	43.95	43.95	43.1	43.79	488400.0
2018-10-16	ABCD-DELISTED	Stock	14.39	14.42	14.36	14.37	1256486.0
2018-10-16	ABDC-DELISTED	Stock	5.96	5.99	5.93	5.97	36684.0
2018-10-16	ABEO	Stock	258.5	265.5	257.75	261.25	31960.0
2018-10-16	ABEOW-DELISTED	Stock	5.87	6.045	5.86	6.045	3149.0
2018-10-16	ABEV	Stock	4.6	4.7	4.59	4.65	33885500.0
2018-10-16	ABG	Stock	60.75	61.5	59.31	61.2	386300.0
2018-10-16	ABIL-DELISTED	Stock	3.04	3.25	2.9201	3.22	70543.0
2018-10-16	ABM	Stock	31.51	32.51	31.02	32.45	399400.0
2018-10-16	ABMD-DELISTED	Stock	376.28	388.11	374.74	386.7	303100.0
2018-10-16	ABR	Stock	11.74	11.89	11.65	11.89	906000.0
2018-10-16	ABR.A-DELISTED	Stock	25.52	25.52	25.4017	25.5	3376.0
2018-10-16	ABR.C-DELISTED	Stock	25.8067	25.9023	25.64	25.6458	1900.0

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

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