PREVIEW / stock_daily / 2019-11-06

all stock daily files

  file:    by_date/stock_daily/2019/2019-11-06.parquet
  size:    221 KB
  rows:    6,608
  symbols: 2,477

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-06	AAPL	Stock	64.1925	64.3725	63.8425	64.31	75864400.0
2019-11-06	MSFT	Stock	144.37	144.52	143.2	144.06	16575800.0
2019-11-06	NVDA	Stock	5.216	5.2418	5.1028	5.1908	269012000.0
2019-11-06	AMZN	Stock	90.05	90.125	89.429	89.7885	40596000.0
2019-11-06	GOOGL	Stock	64.5045	64.6495	64.1135	64.5505	24625300.0
2019-11-06	META	Stock	194.03	194.37	191.35	191.55	10973000.0
2019-11-06	TSLA	Stock	21.2	21.7813	20.9667	21.772	119113500.0
2019-11-06	TLT	Stock	138.02	138.41	137.34	137.98	9353012.0
2019-11-06	ES	Stock	81.09	81.62	80.68	81.39	1906100.0
2019-11-06	CL	Stock	66.31	66.89	66.19	66.52	4412600.0
2019-11-06	A	Stock	75.7	75.94	74.94	75.79	1355700.0
2019-11-06	AA	Stock	22.41	22.62	21.89	21.9	2274000.0
2019-11-06	AACG	Stock	1.75	1.75	1.7	1.72	3100.0
2019-11-06	AAIC-DELISTED	Stock	5.82	5.8453	5.76	5.79	183108.0
2019-11-06	AAIC.C-DELISTED	Stock	21.37	21.45	21.37	21.4	3038.0
2019-11-06	AAL	Stock	31.17	31.19	30.65	30.96	4270300.0
2019-11-06	AAM.A-DELISTED	Stock	26.5775	26.63	26.56	26.57	6257.0
2019-11-06	AAM.B-DELISTED	Stock	27.0924	27.2	27.0901	27.1	8125.0
2019-11-06	AAMC-DELISTED	Stock	3.7794	3.9706	3.7794	3.9706	9024.0
2019-11-06	AAME	Stock	2.2	2.2	1.95	1.96	9300.0
2019-11-06	AAMI	Stock	9.97	10.16	9.88	10.01	533200.0
2019-11-06	AAOI	Stock	11.45	12.13	11.37	11.71	2131800.0
2019-11-06	AAON	Stock	33.18	33.34	32.6667	33.0533	153300.0
2019-11-06	AAP	Stock	168.14	169.95	166.43	169.7	866300.0
2019-11-06	AAT	Stock	47.9	48.12	47.42	47.48	226900.0
2019-11-06	AAU-DELISTED	Stock	0.49	0.4996	0.48	0.485	239532.0
2019-11-06	AAUAF-DELISTED	Stock	0.49	0.4996	0.48	0.485	255125.0
2019-11-06	AAWW-DELISTED	Stock	26.14	26.39	25.6	26.02	342973.0
2019-11-06	AAXJ	Stock	71.72	71.75	71.34	71.55	895452.0
2019-11-06	AAXN-DELISTED	Stock	53.14	53.69	51.94	52.25	596948.0
2019-11-06	AB	Stock	29.52	29.78	29.44	29.62	267500.0
2019-11-06	ABB-DELISTED	Stock	21.61	21.655	21.535	21.65	1869499.0
2019-11-06	ABBNY-DELISTED	Stock	21.61	21.655	21.535	21.65	2258136.0
2019-11-06	ABBV	Stock	81.77	82.25	80.35	82.08	9303600.0
2019-11-06	ABC-DELISTED	Stock	86.64	86.95	84.58	84.7	1056964.0
2019-11-06	ABCB	Stock	43.77	43.98	43.42	43.83	244400.0
2019-11-06	ABDC-DELISTED	Stock	8.8	8.84	8.7139	8.82	23533.0
2019-11-06	ABEO	Stock	67.25	68.0	64.5	65.25	4188.0
2019-11-06	ABEOW-DELISTED	Stock	0.1606	0.17	0.15	0.15	6294.0
2019-11-06	ABEV	Stock	4.28	4.32	4.24	4.26	11601000.0
2019-11-06	ABG	Stock	109.26	109.26	107.68	107.77	114000.0
2019-11-06	ABIL-DELISTED	Stock	0.4311	0.45	0.4203	0.4447	32705.0
2019-11-06	ABM	Stock	37.26	37.35	36.89	37.15	253300.0
2019-11-06	ABMD-DELISTED	Stock	217.49	217.89	213.25	214.54	366726.0
2019-11-06	ABR	Stock	14.49	15.03	14.39	14.88	5776300.0
2019-11-06	ABR.A-DELISTED	Stock	26.1	26.1	25.98	26.04	5542.0
2019-11-06	ABR.B-DELISTED	Stock	26.01	26.1172	26.01	26.0798	1300.0
2019-11-06	ABR.C-DELISTED	Stock	26.3096	26.3096	26.05	26.1701	10402.0
2019-11-06	ABT	Stock	82.5	83.44	82.38	83.12	4489000.0
2019-11-06	ABTC	Stock	134700.0	135000.0	124500.0	124500.0	2.6666666666666665

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

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