PREVIEW / stock_daily / 2019-11-29

all stock daily files

  file:    by_date/stock_daily/2019/2019-11-29.parquet
  size:    215 KB
  rows:    6,516
  symbols: 2,423

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
2019-11-29	AAPL	Stock	66.65	67.0	66.475	66.8125	46617600.0
2019-11-29	MSFT	Stock	152.1	152.3	151.28	151.38	11977300.0
2019-11-29	NVDA	Stock	5.425	5.4535	5.3945	5.4185	141556000.0
2019-11-29	AMZN	Stock	90.889	91.2345	90.0395	90.04	38468000.0
2019-11-29	GOOGL	Stock	65.33	65.4975	65.1615	65.2045	12801380.0
2019-11-29	META	Stock	201.6	203.8	201.21	201.64	7985200.0
2019-11-29	TSLA	Stock	22.074	22.084	21.8333	21.996	36984000.0
2019-11-29	TLT	Stock	140.62	140.68	139.78	140.42	6251071.0
2019-11-29	ES	Stock	83.12	83.49	82.54	82.64	863400.0
2019-11-29	CL	Stock	67.81	67.98	67.49	67.82	1385100.0
2019-11-29	A	Stock	80.96	81.24	80.47	80.77	835800.0
2019-11-29	AA	Stock	20.43	20.47	20.158	20.35	1223300.0
2019-11-29	AACG	Stock	1.81	1.81	1.8	1.8	1000.0
2019-11-29	AAIC-DELISTED	Stock	5.75	5.85	5.75	5.85	161564.0
2019-11-29	AAIC.C-DELISTED	Stock	22.22	22.22	22.22	22.22	199.0
2019-11-29	AAL	Stock	28.92	29.27	28.66	28.74	2970800.0
2019-11-29	AAM.A-DELISTED	Stock	26.34	26.3899	26.12	26.12	41149.0
2019-11-29	AAM.B-DELISTED	Stock	26.7	26.701	26.5	26.5	35738.0
2019-11-29	AAMC-DELISTED	Stock	4.0201	4.0203	4.0	4.0	3352.0
2019-11-29	AAME	Stock	1.63	1.77	1.6	1.77	6200.0
2019-11-29	AAMI	Stock	9.44	9.67	9.41	9.63	655100.0
2019-11-29	AAOI	Stock	10.68	10.82	10.51	10.7	191200.0
2019-11-29	AAON	Stock	32.7867	33.0533	32.4667	32.9133	64650.0
2019-11-29	AAP	Stock	158.46	159.01	156.68	157.08	487100.0
2019-11-29	AAT	Stock	47.0	47.76	47.0	47.53	174300.0
2019-11-29	AAU-DELISTED	Stock	0.48	0.48	0.4649	0.47	124801.0
2019-11-29	AAUAF-DELISTED	Stock	0.48	0.48	0.4649	0.47	128027.0
2019-11-29	AAWW-DELISTED	Stock	26.42	26.51	25.9	26.09	110334.0
2019-11-29	AAXJ	Stock	69.69	69.785	69.565	69.65	372360.0
2019-11-29	AAXN-DELISTED	Stock	75.07	75.85	73.64	74.8	330332.0
2019-11-29	AB	Stock	29.17	29.42	28.93	28.97	178400.0
2019-11-29	ABB-DELISTED	Stock	21.88	21.91	21.82	21.83	618767.0
2019-11-29	ABBNY-DELISTED	Stock	21.88	21.91	21.82	21.83	648730.0
2019-11-29	ABBV	Stock	88.0	88.09	87.22	87.73	3042800.0
2019-11-29	ABC-DELISTED	Stock	87.96	88.75	87.78	87.91	276876.0
2019-11-29	ABCB	Stock	43.46	43.91	43.4	43.65	106200.0
2019-11-29	ABDC-DELISTED	Stock	9.0	9.0	8.9212	9.0	9422.0
2019-11-29	ABEO	Stock	87.75	95.0	83.0	84.25	28264.0
2019-11-29	ABEOW-DELISTED	Stock	0.2	0.2	0.2	0.2	1300.0
2019-11-29	ABEV	Stock	4.26	4.29	4.19	4.21	9806500.0
2019-11-29	ABG	Stock	112.25	112.72	110.84	110.84	38800.0
2019-11-29	ABIL-DELISTED	Stock	0.3999	0.4	0.35	0.39	98444.0
2019-11-29	ABM	Stock	38.72	38.72	37.97	37.99	117800.0
2019-11-29	ABMD-DELISTED	Stock	196.51	200.97	195.17	196.18	253218.0
2019-11-29	ABR	Stock	15.12	15.18	15.11	15.16	318400.0
2019-11-29	ABR.B-DELISTED	Stock	25.66	25.94	25.66	25.94	2700.0
2019-11-29	ABT	Stock	85.3	85.65	84.84	85.45	2410900.0
2019-11-29	ABTC	Stock	234900.0	234900.0	215490.0	223800.0	1.88
2019-11-29	ABTX-DELISTED	Stock	35.7	36.0	35.4	35.88	62282.0
2019-11-29	ABUS	Stock	1.64	1.77	1.63	1.67	279200.0

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

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