PREVIEW / stock_daily / 2019-10-29

all stock daily files

  file:    by_date/stock_daily/2019/2019-10-29.parquet
  size:    221 KB
  rows:    6,598
  symbols: 2,471

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-10-29	AAPL	Stock	62.2425	62.4375	60.6425	60.8225	142839600.0
2019-10-29	MSFT	Stock	144.08	144.5	142.65	142.83	20589500.0
2019-10-29	NVDA	Stock	5.1558	5.1622	5.0535	5.073	211236000.0
2019-10-29	AMZN	Stock	88.7405	88.85	87.7905	88.1355	45538000.0
2019-10-29	GOOGL	Stock	63.8	64.04	62.7805	63.033	52654300.0
2019-10-29	META	Stock	191.69	192.53	188.47	189.31	13574900.0
2019-10-29	TSLA	Stock	21.3327	21.62	20.9833	21.0813	190264500.0
2019-10-29	TLT	Stock	137.62	137.74	137.17	137.35	5296576.0
2019-10-29	ES	Stock	82.72	83.12	82.21	82.9	2104300.0
2019-10-29	CL	Stock	67.17	67.96	67.01	67.92	3018800.0
2019-10-29	A	Stock	75.05	76.68	74.94	76.17	1113300.0
2019-10-29	AA	Stock	21.45	21.73	21.05	21.6	2443600.0
2019-10-29	AACG	Stock	1.78	1.8	1.68	1.75	18700.0
2019-10-29	AAIC-DELISTED	Stock	5.68	5.8293	5.66	5.8	325483.0
2019-10-29	AAIC.C-DELISTED	Stock	21.3574	21.41	21.26	21.4	4691.0
2019-10-29	AAL	Stock	31.42	31.49	30.68	30.92	6843200.0
2019-10-29	AAM.A-DELISTED	Stock	26.79	26.79	26.5401	26.56	24233.0
2019-10-29	AAM.B-DELISTED	Stock	27.09	27.09	26.9845	26.9845	12761.0
2019-10-29	AAMC-DELISTED	Stock	4.4118	4.4118	3.8971	3.9853	28111.0
2019-10-29	AAME	Stock	2.25	2.25	2.12	2.25	1600.0
2019-10-29	AAMI	Stock	9.72	9.84	9.64	9.8	471800.0
2019-10-29	AAOI	Stock	10.13	10.13	9.74	9.84	481000.0
2019-10-29	AAON	Stock	32.88	33.5533	32.8333	33.1267	240150.0
2019-10-29	AAP	Stock	166.27	166.92	163.99	164.35	657500.0
2019-10-29	AAT	Stock	46.97	47.44	46.9	47.2	267000.0
2019-10-29	AAU-DELISTED	Stock	0.61	0.6378	0.61	0.63	177006.0
2019-10-29	AAUAF-DELISTED	Stock	0.61	0.6378	0.61	0.63	196603.0
2019-10-29	AAWW-DELISTED	Stock	25.42	25.68	23.89	23.95	638059.0
2019-10-29	AAXJ	Stock	69.29	69.47	69.245	69.31	389218.0
2019-10-29	AAXN-DELISTED	Stock	54.56	55.21	52.81	52.98	428057.0
2019-10-29	AB	Stock	29.2	29.81	29.11	29.65	413100.0
2019-10-29	ABB-DELISTED	Stock	21.12	21.1793	21.07	21.11	1372964.0
2019-10-29	ABBNY-DELISTED	Stock	21.12	21.1793	21.07	21.11	1501974.0
2019-10-29	ABBV	Stock	78.11	78.74	77.59	78.47	6391500.0
2019-10-29	ABC-DELISTED	Stock	87.42	88.88	87.13	88.83	728546.0
2019-10-29	ABCB	Stock	43.94	44.44	43.81	44.04	700700.0
2019-10-29	ABDC-DELISTED	Stock	8.89	8.97	8.89	8.97	12218.0
2019-10-29	ABEO	Stock	63.0	65.25	61.75	62.5	6128.0
2019-10-29	ABEV	Stock	4.37	4.43	4.35	4.36	16745900.0
2019-10-29	ABG	Stock	104.59	105.47	103.54	104.5	116100.0
2019-10-29	ABIL-DELISTED	Stock	0.4799	0.4899	0.45	0.4608	75538.0
2019-10-29	ABM	Stock	37.56	38.16	37.33	37.37	374200.0
2019-10-29	ABMD-DELISTED	Stock	181.32	186.6	180.5087	184.96	837728.0
2019-10-29	ABR	Stock	13.53	13.61	13.52	13.58	666700.0
2019-10-29	ABR.A-DELISTED	Stock	26.2417	26.2417	26.2417	26.2417	172.0
2019-10-29	ABR.C-DELISTED	Stock	26.1716	26.231	26.04	26.1701	1394.0
2019-10-29	ABT	Stock	82.45	83.87	82.29	83.45	4614900.0
2019-10-29	ABTC	Stock	156000.0	156000.0	144000.0	151800.0	1.4
2019-10-29	ABTS	Stock	28.08	28.95	24.9	28.95	233.0
2019-10-29	ABTX-DELISTED	Stock	33.71	33.95	33.18	33.23	143198.0

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

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