PREVIEW / stock_daily / 2018-11-28

all stock daily files

  file:    by_date/stock_daily/2018/2018-11-28.parquet
  size:    222 KB
  rows:    6,596
  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-11-28	AAPL	Stock	44.1825	45.3225	43.7325	45.235	184250000.0
2018-11-28	MSFT	Stock	107.89	111.33	107.86	111.12	46788500.0
2018-11-28	NVDA	Stock	3.962	4.007	3.8282	4.0018	804524000.0
2018-11-28	AMZN	Stock	80.696	84.0725	80.061	83.8875	169174000.0
2018-11-28	GOOGL	Stock	52.873	54.6429	52.1475	54.5895	46042420.0
2018-11-28	META	Stock	136.28	136.79	131.85	136.76	29847500.0
2018-11-28	TSLA	Stock	23.066	23.2187	22.814	23.1913	61914000.0
2018-11-28	TLT	Stock	114.85	115.02	114.36	114.45	7814288.0
2018-11-28	ES	Stock	67.55	67.73	67.02	67.43	1859400.0
2018-11-28	CL	Stock	63.03	63.5	62.59	62.83	4940700.0
2018-11-28	A	Stock	69.82	71.49	69.43	71.48	2661300.0
2018-11-28	AA	Stock	31.35	34.17	30.96	33.6	5636700.0
2018-11-28	AABA-DELISTED	Stock	64.75	65.49	64.03	65.41	7891320.0
2018-11-28	AAC-DELISTED	Stock	2.0	2.07	1.9332	2.05	395070.0
2018-11-28	AACG	Stock	1.14	1.14	1.03	1.11	102800.0
2018-11-28	AAIC-DELISTED	Stock	8.37	8.47	8.29	8.4	330953.0
2018-11-28	AAL	Stock	38.59	38.97	37.78	38.94	6673800.0
2018-11-28	AAM.A-DELISTED	Stock	23.94	24.12	23.94	24.07	23082.0
2018-11-28	AAM.B-DELISTED	Stock	24.07	24.09	23.865	23.93	31953.0
2018-11-28	AAMC-DELISTED	Stock	13.7618	14.1029	13.7059	14.1029	5253.0
2018-11-28	AAME	Stock	2.81	2.85	2.81	2.85	2400.0
2018-11-28	AAMI	Stock	12.73	13.06	12.61	13.05	670800.0
2018-11-28	AAOI	Stock	20.16	20.73	19.81	20.66	337300.0
2018-11-28	AAON	Stock	25.0067	25.8333	24.6533	25.5533	248250.0
2018-11-28	AAP	Stock	178.85	180.79	177.95	178.95	1086600.0
2018-11-28	AAT	Stock	40.02	40.95	39.92	40.89	253500.0
2018-11-28	AAU-DELISTED	Stock	0.53	0.53	0.5	0.5226	121644.0
2018-11-28	AAUAF-DELISTED	Stock	0.53	0.53	0.5	0.5226	131315.0
2018-11-28	AAWW-DELISTED	Stock	51.38	53.69	50.75	53.5	168836.0
2018-11-28	AAXJ	Stock	66.39	67.42	66.01	67.41	1624528.0
2018-11-28	AAXN-DELISTED	Stock	46.66	47.1573	45.26	45.38	792982.0
2018-11-28	AB	Stock	29.93	30.14	29.57	30.09	286200.0
2018-11-28	ABAC-DELISTED	Stock	1.51	1.56	1.51	1.56	4472.0
2018-11-28	ABB-DELISTED	Stock	20.21	20.44	20.01	20.435	2331205.0
2018-11-28	ABBNY-DELISTED	Stock	20.2	20.44	20.01	20.44	2462721.0
2018-11-28	ABBV	Stock	88.04	88.96	86.56	88.94	3953600.0
2018-11-28	ABC-DELISTED	Stock	89.7	91.27	89.05	91.24	821527.0
2018-11-28	ABCB	Stock	42.65	43.0	41.5	42.9	157900.0
2018-11-28	ABCD-DELISTED	Stock	14.45	14.49	14.44	14.47	406660.0
2018-11-28	ABDC-DELISTED	Stock	6.44	6.6	6.3501	6.58	129838.0
2018-11-28	ABEO	Stock	197.25	201.5	186.5	201.5	24996.0
2018-11-28	ABEOW-DELISTED	Stock	3.95	3.95	3.65	3.9	7782.0
2018-11-28	ABEV	Stock	4.24	4.31	4.14	4.31	27241100.0
2018-11-28	ABG	Stock	70.46	71.44	68.58	70.84	556100.0
2018-11-28	ABIL-DELISTED	Stock	2.88	2.91	2.7	2.82	879719.0
2018-11-28	ABM	Stock	30.33	30.99	29.89	30.66	1371200.0
2018-11-28	ABMD-DELISTED	Stock	316.64	335.99	316.455	335.3	512014.0
2018-11-28	ABR	Stock	12.29	12.32	12.16	12.28	836200.0
2018-11-28	ABR.A-DELISTED	Stock	25.48	25.48	25.34	25.4	1361.0
2018-11-28	ABR.C-DELISTED	Stock	25.4475	25.53	25.36	25.3614	5514.0

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

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