PREVIEW / stock_daily / 2018-11-29

all stock daily files

  file:    by_date/stock_daily/2018/2018-11-29.parquet
  size:    221 KB
  rows:    6,575
  symbols: 2,715

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-29	AAPL	Stock	45.665	45.7	44.425	44.8875	167080000.0
2018-11-29	MSFT	Stock	110.33	111.12	109.03	110.19	28123200.0
2018-11-29	NVDA	Stock	4.0	4.0375	3.9035	3.934	549172000.0
2018-11-29	AMZN	Stock	83.7495	84.4995	82.6165	83.6785	132264000.0
2018-11-29	GOOGL	Stock	54.1765	55.0075	54.1	54.729	31010460.0
2018-11-29	META	Stock	135.92	139.99	135.66	138.68	24238700.0
2018-11-29	TSLA	Stock	23.1333	23.1667	22.6367	22.7447	46210500.0
2018-11-29	TLT	Stock	114.92	115.25	114.59	114.9	7295627.0
2018-11-29	ES	Stock	67.43	67.47	66.46	67.07	2004700.0
2018-11-29	CL	Stock	62.72	63.34	62.61	63.04	3239700.0
2018-11-29	A	Stock	71.23	72.18	71.23	71.57	2625800.0
2018-11-29	AA	Stock	33.45	33.48	30.979	30.99	8105500.0
2018-11-29	AABA-DELISTED	Stock	65.0	65.26	63.52	64.38	6722481.0
2018-11-29	AAC-DELISTED	Stock	2.24	2.27	1.99	2.0	468200.0
2018-11-29	AACG	Stock	1.03	1.1	1.03	1.06	28100.0
2018-11-29	AAIC-DELISTED	Stock	8.36	8.56	8.35	8.49	268685.0
2018-11-29	AAL	Stock	38.8	39.34	38.4	38.42	5178100.0
2018-11-29	AAM.A-DELISTED	Stock	23.52	23.5707	23.11	23.24	68789.0
2018-11-29	AAM.B-DELISTED	Stock	23.47	23.6699	23.181	23.2601	58771.0
2018-11-29	AAMC-DELISTED	Stock	13.6647	14.1353	13.6647	13.7559	11397.0
2018-11-29	AAME	Stock	2.76	2.86	2.76	2.86	1500.0
2018-11-29	AAMI	Stock	12.95	13.15	12.93	13.06	252000.0
2018-11-29	AAOI	Stock	20.59	20.8	20.068	20.28	300500.0
2018-11-29	AAON	Stock	25.44	25.8133	25.1533	25.3733	388200.0
2018-11-29	AAP	Stock	177.91	179.18	177.34	177.67	747800.0
2018-11-29	AAT	Stock	41.08	41.08	40.39	40.76	222500.0
2018-11-29	AAU-DELISTED	Stock	0.52	0.53	0.5074	0.52	108233.0
2018-11-29	AAUAF-DELISTED	Stock	0.52	0.53	0.5074	0.5083	116361.0
2018-11-29	AAWW-DELISTED	Stock	53.25	53.44	52.1301	52.65	277805.0
2018-11-29	AAXJ	Stock	66.73	67.02	66.26	66.65	699747.0
2018-11-29	AAXN-DELISTED	Stock	45.3	45.93	43.33	44.07	829599.0
2018-11-29	AB	Stock	30.0	30.48	30.0	30.03	296700.0
2018-11-29	ABAC-DELISTED	Stock	1.53	1.6451	1.5	1.5	34035.0
2018-11-29	ABB-DELISTED	Stock	20.41	20.455	20.285	20.35	1418910.0
2018-11-29	ABBNY-DELISTED	Stock	20.41	20.455	20.285	20.35	1477416.0
2018-11-29	ABBV	Stock	89.01	90.33	88.36	89.91	3838000.0
2018-11-29	ABC-DELISTED	Stock	90.89	91.21	89.88	90.5	604576.0
2018-11-29	ABCB	Stock	42.49	43.09	42.22	42.67	149600.0
2018-11-29	ABCD-DELISTED	Stock	14.45	14.48	14.45	14.47	153116.0
2018-11-29	ABDC-DELISTED	Stock	6.57	6.63	6.47	6.58	48857.0
2018-11-29	ABEO	Stock	201.75	208.0	194.0	195.25	18528.0
2018-11-29	ABEOW-DELISTED	Stock	4.0	4.0	4.0	4.0	3800.0
2018-11-29	ABEV	Stock	4.27	4.34	4.24	4.3	36131600.0
2018-11-29	ABG	Stock	70.8	71.74	68.94	69.07	297400.0
2018-11-29	ABIL-DELISTED	Stock	2.8	2.82	2.7	2.7438	658823.0
2018-11-29	ABM	Stock	30.66	31.91	30.66	31.32	680600.0
2018-11-29	ABMD-DELISTED	Stock	331.65	335.4245	327.0008	332.0	388375.0
2018-11-29	ABR	Stock	12.25	12.31	12.19	12.24	707400.0
2018-11-29	ABR.A-DELISTED	Stock	25.41	25.4242	25.34	25.4242	1078.0
2018-11-29	ABR.B-DELISTED	Stock	25.01	25.011	25.01	25.011	400.0

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

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