PREVIEW / stock_daily / 2023-11-01

all stock daily files

  file:    by_date/stock_daily/2023/2023-11-01.parquet
  size:    233 KB
  rows:    7,342
  symbols: 1,333

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-01	AAPL	Stock	171.0	174.23	170.12	173.97	56934900.0
2023-11-01	MSFT	Stock	339.79	347.42	339.65	346.07	28158800.0
2023-11-01	NVDA	Stock	40.884	42.381	40.869	42.325	437593000.0
2023-11-01	AMZN	Stock	133.96	137.35	133.71	137.0	61529400.0
2023-11-01	GOOGL	Stock	124.07	126.49	123.715	126.45	30082438.0
2023-11-01	META	Stock	301.85	312.74	301.85	311.85	20434600.0
2023-11-01	TSLA	Stock	204.04	205.99	197.85	205.66	121661700.0
2023-11-01	TLT	Stock	84.04	85.12	84.02	85.1	72308463.0
2023-11-01	ES	Stock	53.07	53.8	52.03	53.09	3497500.0
2023-11-01	CL	Stock	75.15	75.3	74.4	74.93	4757700.0
2023-11-01	A	Stock	102.5	103.21	100.26	102.86	2284600.0
2023-11-01	AA	Stock	25.67	25.78	24.275	25.03	6202100.0
2023-11-01	AAC-DELISTED	Stock	10.77	10.78	10.76	10.78	63136.0
2023-11-01	AACG	Stock	0.98	0.98	0.89	0.96	6200.0
2023-11-01	AACIW-DELISTED	Stock	0.0623	0.0695	0.0601	0.0694	1926.0
2023-11-01	AACT	Stock	10.29	10.33	10.29	10.3	370700.0
2023-11-01	AAIC-DELISTED	Stock	4.14	4.2501	4.14	4.25	27008.0
2023-11-01	AAIC.C-DELISTED	Stock	23.6045	23.73	23.57	23.7	5192.0
2023-11-01	AAL	Stock	11.11	11.22	10.98	11.14	30449500.0
2023-11-01	AAMC-DELISTED	Stock	3.55	3.77	3.51	3.72	40800.0
2023-11-01	AAME	Stock	1.72	1.79	1.72	1.79	700.0
2023-11-01	AAMI	Stock	15.69	16.0	15.52	15.72	380200.0
2023-11-01	AAN-DELISTED	Stock	7.35	7.376	7.13	7.14	355600.0
2023-11-01	AAOI	Stock	7.41	7.75	7.126	7.72	967400.0
2023-11-01	AAON	Stock	54.67	56.66	54.67	56.52	354500.0
2023-11-01	AAP	Stock	52.23	52.23	50.95	51.55	1235000.0
2023-11-01	AAT	Stock	17.73	18.01	17.57	17.97	512000.0
2023-11-01	AATC	Stock	5.44	5.55	5.44	5.5	7617.0
2023-11-01	AAU-DELISTED	Stock	0.135	0.1374	0.135	0.1351	79117.0
2023-11-01	AAUAF-DELISTED	Stock	0.135	0.1374	0.135	0.1351	72989.0
2023-11-01	AAXJ	Stock	61.28	61.83	61.1997	61.83	660142.0
2023-11-01	AB	Stock	28.78	28.96	28.22	28.39	419800.0
2023-11-01	ABAT	Stock	4.84	4.91	4.0	4.18	660121.0
2023-11-01	ABBNY-DELISTED	Stock	33.6	33.77	33.455	33.675	226949.0
2023-11-01	ABBV	Stock	141.86	143.71	141.75	142.47	4207800.0
2023-11-01	ABCB	Stock	37.23	38.15	37.01	38.13	543200.0
2023-11-01	ABCL	Stock	4.12	4.145	4.01	4.12	705200.0
2023-11-01	ABCM-DELISTED	Stock	23.02	23.23	23.0	23.19	8187977.0
2023-11-01	ABEO	Stock	3.83	3.88	3.72	3.83	38500.0
2023-11-01	ABEV	Stock	2.53	2.59	2.52	2.58	17322100.0
2023-11-01	ABG	Stock	189.32	196.88	186.29	196.34	193200.0
2023-11-01	ABLLW	Stock	0.3215	0.3215	0.301	0.3145	3221.0
2023-11-01	ABLV	Stock	2.01	2.22	1.968	2.12	18500.0
2023-11-01	ABM	Stock	39.38	39.56	38.48	39.36	469800.0
2023-11-01	ABNB	Stock	118.25	119.89	116.66	119.47	9336500.0
2023-11-01	ABOS	Stock	1.87	2.0	1.83	1.9	829700.0
2023-11-01	ABR	Stock	12.65	12.68	12.14	12.4	6291600.0
2023-11-01	ABR.D	Stock	16.07	16.3999	15.9	15.92	68267.0
2023-11-01	ABR.E	Stock	16.12	16.442	16.0	16.0	15393.0
2023-11-01	ABR.F	Stock	17.47	17.71	17.3	17.3	10585.0

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

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