PREVIEW / stock_daily / 2019-11-01

all stock daily files

  file:    by_date/stock_daily/2019/2019-11-01.parquet
  size:    221 KB
  rows:    6,570
  symbols: 2,448

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-01	AAPL	Stock	62.385	63.9825	62.29	63.955	151125200.0
2019-11-01	MSFT	Stock	144.26	144.42	142.97	143.72	33128400.0
2019-11-01	NVDA	Stock	4.99	5.0972	4.9648	5.0648	283640000.0
2019-11-01	AMZN	Stock	89.4005	89.8725	89.2605	89.572	55808000.0
2019-11-01	GOOGL	Stock	63.29	63.65	62.9855	63.6125	28812140.0
2019-11-01	META	Stock	192.85	194.11	189.91	193.62	21711800.0
2019-11-01	TSLA	Stock	21.088	21.0987	20.6533	20.8873	95758500.0
2019-11-01	TLT	Stock	140.73	141.27	139.79	140.56	11425486.0
2019-11-01	ES	Stock	83.84	83.98	82.69	82.79	1556100.0
2019-11-01	CL	Stock	67.44	67.5	65.58	66.81	6128500.0
2019-11-01	A	Stock	76.51	77.35	76.32	76.97	1106300.0
2019-11-01	AA	Stock	21.03	22.06	21.0	21.87	5474100.0
2019-11-01	AACG	Stock	1.81	1.89	1.77	1.77	3800.0
2019-11-01	AAIC-DELISTED	Stock	5.79	5.95	5.79	5.85	346612.0
2019-11-01	AAIC.C-DELISTED	Stock	21.4	21.4	21.32	21.4	8374.0
2019-11-01	AAL	Stock	30.3	30.61	30.02	30.56	8270900.0
2019-11-01	AAM.A-DELISTED	Stock	26.41	26.5375	26.41	26.43	11687.0
2019-11-01	AAM.B-DELISTED	Stock	27.1	27.1	26.9513	27.1	13388.0
2019-11-01	AAME	Stock	2.11	2.29	2.11	2.27	700.0
2019-11-01	AAMI	Stock	9.88	10.17	9.88	10.05	618900.0
2019-11-01	AAOI	Stock	9.07	9.83	9.035	9.57	789200.0
2019-11-01	AAON	Stock	32.7733	33.04	30.86	32.74	343800.0
2019-11-01	AAP	Stock	163.01	166.33	162.46	164.82	677800.0
2019-11-01	AAT	Stock	48.91	48.99	48.53	48.93	259500.0
2019-11-01	AAU-DELISTED	Stock	0.49	0.5257	0.4755	0.5109	338284.0
2019-11-01	AAUAF-DELISTED	Stock	0.49	0.5257	0.4755	0.5109	381118.0
2019-11-01	AAWW-DELISTED	Stock	22.35	23.19	20.93	23.09	749274.0
2019-11-01	AAXJ	Stock	70.03	70.38	70.03	70.27	483836.0
2019-11-01	AAXN-DELISTED	Stock	51.49	53.33	51.0	52.53	897815.0
2019-11-01	AB	Stock	28.86	29.14	28.86	29.06	289000.0
2019-11-01	ABB-DELISTED	Stock	20.97	21.17	20.97	21.165	1183548.0
2019-11-01	ABBNY-DELISTED	Stock	20.97	21.17	20.97	21.17	1242688.0
2019-11-01	ABBV	Stock	80.03	82.18	79.13	81.75	13356300.0
2019-11-01	ABC-DELISTED	Stock	85.92	87.42	85.54	86.9	1035678.0
2019-11-01	ABCB	Stock	43.25	43.51	42.88	43.41	262400.0
2019-11-01	ABDC-DELISTED	Stock	8.98	8.98	8.8	8.82	23108.0
2019-11-01	ABEO	Stock	60.0	64.75	59.0	63.25	14036.0
2019-11-01	ABEV	Stock	4.35	4.37	4.3	4.33	17517300.0
2019-11-01	ABG	Stock	103.92	107.45	103.89	107.4	409300.0
2019-11-01	ABIL-DELISTED	Stock	0.42	0.4505	0.4	0.42	32307.0
2019-11-01	ABM	Stock	36.73	36.85	35.77	36.46	283900.0
2019-11-01	ABMD-DELISTED	Stock	207.5	216.98	203.1794	216.87	742140.0
2019-11-01	ABR	Stock	13.8	14.12	13.67	14.09	2761900.0
2019-11-01	ABR.A-DELISTED	Stock	26.0406	26.0486	26.0	26.0	2999.0
2019-11-01	ABR.B-DELISTED	Stock	26.14	26.14	26.14	26.14	200.0
2019-11-01	ABR.C-DELISTED	Stock	26.05	26.5	26.05	26.1125	13050.0
2019-11-01	ABT	Stock	84.09	84.29	82.61	82.66	5119100.0
2019-11-01	ABTC	Stock	146700.0	151650.0	144000.0	145800.0	0.6666666666666666
2019-11-01	ABTS	Stock	30.0	32.1	28.95	28.95	533.0
2019-11-01	ABTX-DELISTED	Stock	33.21	34.28	33.21	34.18	135751.0

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

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