PREVIEW / stock_daily / 2019-09-18

all stock daily files

  file:    by_date/stock_daily/2019/2019-09-18.parquet
  size:    221 KB
  rows:    6,599
  symbols: 2,512

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-09-18	AAPL	Stock	55.265	55.7125	54.86	55.6925	101360000.0
2019-09-18	MSFT	Stock	137.36	138.67	136.53	138.52	23982100.0
2019-09-18	NVDA	Stock	4.5198	4.5355	4.4125	4.4995	258152000.0
2019-09-18	AMZN	Stock	90.852	91.103	89.775	90.873	50112000.0
2019-09-18	GOOGL	Stock	61.512	61.812	60.8235	61.6325	17855760.0
2019-09-18	META	Stock	188.09	189.08	186.01	188.14	9681900.0
2019-09-18	TSLA	Stock	16.3333	16.5447	16.158	16.2327	62553000.0
2019-09-18	TLT	Stock	139.93	140.66	139.53	139.62	11106841.0
2019-09-18	ES	Stock	83.41	83.61	82.78	83.37	1557900.0
2019-09-18	CL	Stock	70.18	70.81	69.88	70.75	3532800.0
2019-09-18	A	Stock	76.36	77.57	75.75	77.57	1982600.0
2019-09-18	AA	Stock	21.79	22.0	21.369	21.67	4159200.0
2019-09-18	AABA-DELISTED	Stock	70.11	70.3	70.04	70.29	4916273.0
2019-09-18	AAC-DELISTED	Stock	0.825	0.8396	0.825	0.8313	73556.0
2019-09-18	AACG	Stock	1.81	1.84	1.8	1.8	10100.0
2019-09-18	AAIC-DELISTED	Stock	5.45	5.61	5.45	5.58	276240.0
2019-09-18	AAIC.C-DELISTED	Stock	21.3501	21.3501	21.0	21.291	47417.0
2019-09-18	AAL	Stock	28.55	28.66	28.07	28.6	6129400.0
2019-09-18	AAM.A-DELISTED	Stock	26.27	26.43	26.27	26.3693	15878.0
2019-09-18	AAM.B-DELISTED	Stock	26.4302	26.52	26.42	26.51	23268.0
2019-09-18	AAMC-DELISTED	Stock	3.0882	3.2707	3.0353	3.0353	6977.0
2019-09-18	AAME	Stock	2.74	2.84	2.7	2.84	3100.0
2019-09-18	AAMI	Stock	10.47	10.68	10.41	10.54	935400.0
2019-09-18	AAOI	Stock	11.19	11.38	10.81	11.03	358300.0
2019-09-18	AAON	Stock	34.1067	34.12	33.3333	33.5333	206850.0
2019-09-18	AAP	Stock	155.91	156.37	152.57	153.79	667900.0
2019-09-18	AAT	Stock	47.71	47.83	46.73	47.01	770900.0
2019-09-18	AAU-DELISTED	Stock	0.73	0.7567	0.727	0.727	138698.0
2019-09-18	AAUAF-DELISTED	Stock	0.73	0.7567	0.727	0.727	144973.0
2019-09-18	AAWW-DELISTED	Stock	25.45	25.8	24.73	25.8	590976.0
2019-09-18	AAXJ	Stock	67.98	68.0099	67.33	67.91	754504.0
2019-09-18	AAXN-DELISTED	Stock	66.15	66.48	64.93	65.48	288821.0
2019-09-18	AB	Stock	29.55	29.78	29.35	29.53	107900.0
2019-09-18	ABB-DELISTED	Stock	20.21	20.27	20.09	20.21	973571.0
2019-09-18	ABBNY-DELISTED	Stock	20.21	20.27	20.09	20.22	1026436.0
2019-09-18	ABBV	Stock	71.68	71.82	70.81	71.27	6252600.0
2019-09-18	ABC-DELISTED	Stock	83.28	83.28	81.91	83.0	1096593.0
2019-09-18	ABCB	Stock	38.55	39.63	38.5	39.55	489600.0
2019-09-18	ABDC-DELISTED	Stock	8.77	8.8426	8.77	8.81	22792.0
2019-09-18	ABEO	Stock	73.0	82.25	72.25	80.0	35952.0
2019-09-18	ABEOW-DELISTED	Stock	0.38	0.38	0.38	0.38	100.0
2019-09-18	ABEV	Stock	4.74	4.77	4.66	4.68	53699300.0
2019-09-18	ABG	Stock	101.15	101.45	99.67	100.96	176200.0
2019-09-18	ABIL-DELISTED	Stock	0.6029	0.619	0.5974	0.6179	14064.0
2019-09-18	ABM	Stock	36.4	36.71	35.92	36.22	246100.0
2019-09-18	ABMD-DELISTED	Stock	190.06	191.37	187.23	190.67	194913.0
2019-09-18	ABR	Stock	12.87	12.96	12.86	12.91	859500.0
2019-09-18	ABR.A-DELISTED	Stock	25.96	26.05	25.96	26.05	700.0
2019-09-18	ABR.B-DELISTED	Stock	25.661	25.77	25.661	25.77	6030.0
2019-09-18	ABR.C-DELISTED	Stock	26.6914	26.79	26.6906	26.79	900.0

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

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