PREVIEW / stock_daily / 2023-11-16

all stock daily files

  file:    by_date/stock_daily/2023/2023-11-16.parquet
  size:    233 KB
  rows:    7,324
  symbols: 1,289

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
2023-11-16	AAPL	Stock	189.57	190.96	188.65	189.71	54412900.0
2023-11-16	MSFT	Stock	370.96	376.35	370.18	376.17	27182300.0
2023-11-16	NVDA	Stock	48.679	49.525	48.33	49.48	339756000.0
2023-11-16	AMZN	Stock	140.91	143.32	139.52	142.83	49653500.0
2023-11-16	GOOGL	Stock	135.19	137.2199	134.32	136.93	28013179.0
2023-11-16	META	Stock	329.37	334.58	326.38	334.19	18932600.0
2023-11-16	TSLA	Stock	239.49	240.88	230.96	233.59	136816800.0
2023-11-16	TLT	Stock	89.3	89.96	89.25	89.62	49473882.0
2023-11-16	ES	Stock	57.72	58.28	56.86	57.48	2821600.0
2023-11-16	CL	Stock	75.57	76.45	75.56	75.98	4432800.0
2023-11-16	A	Stock	113.94	114.5	113.56	114.19	1728100.0
2023-11-16	AA	Stock	26.6	26.99	25.94	26.0	4080300.0
2023-11-16	AACG	Stock	0.84	0.86	0.84	0.86	4000.0
2023-11-16	AACT	Stock	10.34	10.375	10.34	10.375	105400.0
2023-11-16	AAIC-DELISTED	Stock	4.68	4.7	4.59	4.61	87028.0
2023-11-16	AAIC.C-DELISTED	Stock	23.99	23.99	23.99	23.99	500.0
2023-11-16	AAL	Stock	12.42	12.6	12.16	12.19	34506600.0
2023-11-16	AAMC-DELISTED	Stock	3.01	3.1	2.76	2.86	34200.0
2023-11-16	AAME	Stock	1.87	1.92	1.86	1.92	7300.0
2023-11-16	AAMI	Stock	17.46	17.48	17.045	17.2	132100.0
2023-11-16	AAN-DELISTED	Stock	8.76	8.87	8.38	8.58	555100.0
2023-11-16	AAOI	Stock	12.36	12.99	12.35	12.83	1737600.0
2023-11-16	AAON	Stock	63.53	63.72	62.45	62.49	180300.0
2023-11-16	AAP	Stock	53.61	54.42	50.53	53.42	5115500.0
2023-11-16	AAT	Stock	19.91	20.01	19.25	19.26	279800.0
2023-11-16	AATC	Stock	6.4725	6.565	6.4725	6.565	9685.0
2023-11-16	AAU-DELISTED	Stock	0.1385	0.1431	0.135	0.14	128611.0
2023-11-16	AAUAF-DELISTED	Stock	0.1385	0.1431	0.135	0.14	131459.0
2023-11-16	AAXJ	Stock	65.26	65.74	65.158	65.39	550998.0
2023-11-16	AB	Stock	27.4	28.16	27.4	28.09	486200.0
2023-11-16	ABAT	Stock	4.2	4.42	4.0	4.04	281506.0
2023-11-16	ABBNY-DELISTED	Stock	37.95	38.17	37.801	37.93	185103.0
2023-11-16	ABBV	Stock	138.28	138.82	137.05	138.28	5257000.0
2023-11-16	ABCB	Stock	43.46	43.75	42.58	42.96	403800.0
2023-11-16	ABCL	Stock	4.52	4.52	4.24	4.38	931500.0
2023-11-16	ABCM-DELISTED	Stock	23.2	23.25	23.04	23.07	6977948.0
2023-11-16	ABEO	Stock	4.27	4.33	4.09	4.22	128900.0
2023-11-16	ABEV	Stock	2.79	2.82	2.78	2.79	14480500.0
2023-11-16	ABG	Stock	220.29	221.36	202.46	204.99	224600.0
2023-11-16	ABLLW	Stock	0.328	0.33	0.2851	0.2851	23989.0
2023-11-16	ABLV	Stock	2.0	2.0	1.81	1.9	11100.0
2023-11-16	ABM	Stock	41.42	41.55	40.87	41.04	312300.0
2023-11-16	ABNB	Stock	127.12	128.4	125.31	126.28	4177300.0
2023-11-16	ABOS	Stock	2.36	2.385	2.195	2.24	496700.0
2023-11-16	ABR	Stock	13.14	13.31	12.05	12.24	14861300.0
2023-11-16	ABR.D	Stock	17.15	17.15	16.28	16.46	157373.0
2023-11-16	ABR.E	Stock	16.8	16.88	16.3	16.75	37478.0
2023-11-16	ABR.F	Stock	18.06	18.2	17.37	17.48	38030.0
2023-11-16	ABSI	Stock	1.39	1.4	1.34	1.39	236200.0
2023-11-16	ABT	Stock	97.72	100.35	97.64	100.26	7603200.0

> showing 50 of 7,324 rows — these rows as CSV

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