PREVIEW / stock_daily / 2019-09-11

all stock daily files

  file:    by_date/stock_daily/2019/2019-09-11.parquet
  size:    220 KB
  rows:    6,593
  symbols: 2,527

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-11	AAPL	Stock	54.5175	55.9275	54.4325	55.8975	177158400.0
2019-09-11	MSFT	Stock	135.91	136.27	135.09	136.12	24726100.0
2019-09-11	NVDA	Stock	4.5943	4.6568	4.565	4.6083	361512000.0
2019-09-11	AMZN	Stock	90.607	91.671	90.454	91.1495	48656000.0
2019-09-11	GOOGL	Stock	60.1945	61.1235	60.1138	61.0	23521320.0
2019-09-11	META	Stock	186.46	189.44	186.08	188.49	11761700.0
2019-09-11	TSLA	Stock	15.8253	16.5447	15.7333	16.4733	150642000.0
2019-09-11	TLT	Stock	140.4	141.15	140.39	140.44	10941748.0
2019-09-11	ES	Stock	81.43	82.44	81.12	82.17	1692300.0
2019-09-11	CL	Stock	71.95	72.86	71.4	72.85	2305700.0
2019-09-11	A	Stock	75.07	77.01	75.07	76.99	2805500.0
2019-09-11	AA	Stock	21.35	22.28	20.7	22.18	6270100.0
2019-09-11	AABA-DELISTED	Stock	70.01	70.035	69.91	70.0	18452357.0
2019-09-11	AAC-DELISTED	Stock	0.69	0.8487	0.6301	0.8079	445420.0
2019-09-11	AACG	Stock	1.86	1.88	1.84	1.84	8600.0
2019-09-11	AAIC-DELISTED	Stock	5.45	5.62	5.4067	5.62	380864.0
2019-09-11	AAIC.C-DELISTED	Stock	21.9875	22.01	21.9548	22.0	8510.0
2019-09-11	AAL	Stock	29.16	29.93	28.73	29.76	10842600.0
2019-09-11	AAM.A-DELISTED	Stock	26.31	26.4	26.31	26.4	49340.0
2019-09-11	AAM.B-DELISTED	Stock	26.28	26.47	26.2	26.47	29055.0
2019-09-11	AAMC-DELISTED	Stock	3.0588	3.0588	3.0529	3.0529	1700.0
2019-09-11	AAME	Stock	2.55	2.55	2.55	2.55	100.0
2019-09-11	AAMI	Stock	10.4	10.42	10.0	10.23	801600.0
2019-09-11	AAOI	Stock	11.5	11.68	11.02	11.54	887200.0
2019-09-11	AAON	Stock	32.04	33.1733	32.0067	33.1067	233400.0
2019-09-11	AAP	Stock	154.96	158.89	154.68	158.86	1180100.0
2019-09-11	AAT	Stock	47.08	47.28	46.48	46.81	917700.0
2019-09-11	AAU-DELISTED	Stock	0.7	0.738	0.69	0.73	386216.0
2019-09-11	AAUAF-DELISTED	Stock	0.7	0.738	0.69	0.73	392186.0
2019-09-11	AAWW-DELISTED	Stock	29.39	29.5299	28.3714	29.46	309523.0
2019-09-11	AAXJ	Stock	67.76	68.04	67.63	67.97	1003343.0
2019-09-11	AAXN-DELISTED	Stock	60.78	62.99	60.32	62.93	347717.0
2019-09-11	AB	Stock	28.99	29.83	28.91	29.75	225300.0
2019-09-11	ABB-DELISTED	Stock	20.13	20.295	20.09	20.28	1269344.0
2019-09-11	ABBNY-DELISTED	Stock	20.13	20.295	20.09	20.28	1329278.0
2019-09-11	ABBV	Stock	68.38	69.74	68.06	69.49	8369100.0
2019-09-11	ABC-DELISTED	Stock	86.05	88.46	85.33	87.79	748128.0
2019-09-11	ABCB	Stock	36.85	37.76	36.39	37.72	518600.0
2019-09-11	ABDC-DELISTED	Stock	8.99	9.0	8.93	8.94	38881.0
2019-09-11	ABEO	Stock	80.25	83.25	76.0	78.0	36180.0
2019-09-11	ABEOW-DELISTED	Stock	0.3	0.3	0.3	0.3	100.0
2019-09-11	ABEV	Stock	4.66	4.76	4.61	4.65	21383900.0
2019-09-11	ABG	Stock	101.49	103.92	99.99	102.56	332400.0
2019-09-11	ABIL-DELISTED	Stock	0.61	0.67	0.6075	0.6102	55735.0
2019-09-11	ABM	Stock	36.13	36.58	35.81	36.55	283700.0
2019-09-11	ABMD-DELISTED	Stock	191.96	192.98	187.59	190.995	331670.0
2019-09-11	ABR	Stock	12.63	12.77	12.6	12.77	911100.0
2019-09-11	ABR.A-DELISTED	Stock	26.03	26.13	25.95	26.1111	800.0
2019-09-11	ABR.B-DELISTED	Stock	25.845	26.05	25.7576	26.05	1985.0
2019-09-11	ABR.C-DELISTED	Stock	26.34	26.35	26.2613	26.2613	800.0

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

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