PREVIEW / stock_daily / 2018-10-15

all stock daily files

  file:    by_date/stock_daily/2018/2018-10-15.parquet
  size:    220 KB
  rows:    6,536
  symbols: 2,726

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-15	AAPL	Stock	55.29	55.4575	54.3175	54.34	123164000.0
2018-10-15	MSFT	Stock	108.91	109.48	106.95	107.6	32068100.0
2018-10-15	NVDA	Stock	6.15	6.15	5.8835	5.8845	449760000.0
2018-10-15	AMZN	Stock	89.75	89.7525	86.7115	88.0475	128744000.0
2018-10-15	GOOGL	Stock	55.9	56.0898	54.911	55.122	30079120.0
2018-10-15	META	Stock	153.32	155.57	152.55	153.52	15433500.0
2018-10-15	TSLA	Stock	17.2707	17.552	16.9693	17.306	93000000.0
2018-10-15	TLT	Stock	114.66	114.8168	114.29	114.42	7146281.0
2018-10-15	ES	Stock	61.5	61.96	61.29	61.37	1615900.0
2018-10-15	CL	Stock	62.42	63.06	62.24	62.55	3439100.0
2018-10-15	A	Stock	65.92	66.35	65.36	65.63	1602800.0
2018-10-15	AA	Stock	35.47	35.88	35.31	35.34	2439900.0
2018-10-15	AABA-DELISTED	Stock	61.34	61.5	60.07	60.93	7285192.0
2018-10-15	AAC-DELISTED	Stock	6.88	7.2	6.88	7.03	62189.0
2018-10-15	AACG	Stock	1.01	1.04	1.01	1.01	40900.0
2018-10-15	AAIC-DELISTED	Stock	8.41	8.585	8.4	8.5	484970.0
2018-10-15	AAL	Stock	31.0	32.24	30.82	31.78	11092500.0
2018-10-15	AAM.A-DELISTED	Stock	24.16	24.2384	24.0351	24.05	29332.0
2018-10-15	AAM.B-DELISTED	Stock	24.05	24.15	23.97	23.999	32117.0
2018-10-15	AAMC-DELISTED	Stock	15.4412	16.1764	15.0	15.0	8089.0
2018-10-15	AAME	Stock	2.78	2.95	2.78	2.9	2300.0
2018-10-15	AAMI	Stock	12.1	12.375	12.08	12.28	381900.0
2018-10-15	AAOI	Stock	22.91	24.12	22.32	22.35	938200.0
2018-10-15	AAON	Stock	21.2533	21.5733	21.0333	21.5	227250.0
2018-10-15	AAP	Stock	165.0	168.68	164.76	166.93	644900.0
2018-10-15	AAT	Stock	35.39	36.32	35.39	35.91	138600.0
2018-10-15	AAU-DELISTED	Stock	0.51	0.56	0.5068	0.5524	792421.0
2018-10-15	AAUAF-DELISTED	Stock	0.51	0.56	0.5068	0.55	1115716.0
2018-10-15	AAWW-DELISTED	Stock	53.1	53.43	52.57	52.89	160869.0
2018-10-15	AAXJ	Stock	64.33	64.57	64.11	64.11	964355.0
2018-10-15	AAXN-DELISTED	Stock	57.15	57.5	54.39	57.05	631876.0
2018-10-15	AB	Stock	29.16	30.03	29.11	29.9	406300.0
2018-10-15	ABAC-DELISTED	Stock	1.77	1.9	1.76	1.838	11558.0
2018-10-15	ABB-DELISTED	Stock	21.13	21.215	21.065	21.09	1867737.0
2018-10-15	ABBNY-DELISTED	Stock	21.13	21.215	21.065	21.09	1948822.0
2018-10-15	ABBV	Stock	90.51	90.6	89.18	89.18	4827900.0
2018-10-15	ABC-DELISTED	Stock	88.07	90.54	88.07	89.52	782456.0
2018-10-15	ABCB	Stock	43.25	44.09	43.02	43.75	309900.0
2018-10-15	ABCD-DELISTED	Stock	14.41	14.43	14.38	14.39	3274723.0
2018-10-15	ABDC-DELISTED	Stock	5.96	6.01	5.93	5.955	85990.0
2018-10-15	ABEO	Stock	258.0	259.25	244.25	255.25	28792.0
2018-10-15	ABEOW-DELISTED	Stock	5.32	5.41	5.32	5.41	2943.0
2018-10-15	ABEV	Stock	4.53	4.62	4.5	4.5	25602100.0
2018-10-15	ABG	Stock	59.82	61.22	59.82	60.3	600100.0
2018-10-15	ABIL-DELISTED	Stock	3.04	3.08	2.911	2.96	30769.0
2018-10-15	ABM	Stock	30.39	31.54	30.34	31.3	644500.0
2018-10-15	ABMD-DELISTED	Stock	383.78	387.97	367.24	372.1	487117.0
2018-10-15	ABR	Stock	11.65	11.75	11.57	11.7	715300.0
2018-10-15	ABR.C-DELISTED	Stock	26.09	26.09	25.57	25.58	7815.0
2018-10-15	ABT	Stock	69.34	69.38	68.22	68.7	6674700.0

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

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