PREVIEW / stock_daily / 2023-11-15

all stock daily files

  file:    by_date/stock_daily/2023/2023-11-15.parquet
  size:    235 KB
  rows:    7,358
  symbols: 1,308

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-15	AAPL	Stock	187.85	189.5	187.78	188.01	53790500.0
2023-11-15	MSFT	Stock	371.28	373.13	367.11	369.67	26860100.0
2023-11-15	NVDA	Stock	49.935	49.96	48.2	48.888	475497000.0
2023-11-15	AMZN	Stock	147.06	147.29	142.59	143.2	63875700.0
2023-11-15	GOOGL	Stock	134.87	135.03	133.57	134.62	23861515.0
2023-11-15	META	Stock	337.93	338.4	330.02	332.71	14531200.0
2023-11-15	TSLA	Stock	239.29	246.7	236.45	242.84	150354000.0
2023-11-15	TLT	Stock	89.01	89.14	88.31	88.52	56205295.0
2023-11-15	ES	Stock	56.21	57.62	56.04	57.25	3170600.0
2023-11-15	CL	Stock	76.55	77.05	75.37	75.47	4810900.0
2023-11-15	A	Stock	111.85	114.52	111.33	113.6	2021400.0
2023-11-15	AA	Stock	26.52	27.34	26.36	26.95	5857200.0
2023-11-15	AACG	Stock	0.85	0.94	0.85	0.86	5100.0
2023-11-15	AACIW-DELISTED	Stock	0.0521	0.0596	0.0521	0.0596	7600.0
2023-11-15	AACT	Stock	10.34	10.35	10.34	10.34	2600.0
2023-11-15	AAIC-DELISTED	Stock	4.63	4.72	4.63	4.69	94345.0
2023-11-15	AAIC.C-DELISTED	Stock	23.9501	24.14	23.75	23.87	26979.0
2023-11-15	AAL	Stock	12.35	12.72	12.35	12.42	37557800.0
2023-11-15	AAMC-DELISTED	Stock	3.15	3.15	2.95	3.0	19200.0
2023-11-15	AAME	Stock	1.83	1.87	1.75	1.85	2100.0
2023-11-15	AAMI	Stock	17.2	17.63	17.2	17.49	236900.0
2023-11-15	AAN-DELISTED	Stock	8.4	8.83	8.4	8.8	481600.0
2023-11-15	AAOI	Stock	12.22	13.27	12.117	12.71	3727100.0
2023-11-15	AAON	Stock	64.25	65.3	63.68	63.76	468200.0
2023-11-15	AAP	Stock	54.8	60.79	52.77	55.67	8466300.0
2023-11-15	AAT	Stock	19.98	20.35	19.88	19.91	332900.0
2023-11-15	AATC	Stock	6.45	6.54	6.37	6.455	24513.0
2023-11-15	AAU-DELISTED	Stock	0.1418	0.1418	0.14	0.1401	69525.0
2023-11-15	AAUAF-DELISTED	Stock	0.1418	0.1418	0.14	0.1401	71212.0
2023-11-15	AAXJ	Stock	65.86	66.51	65.86	66.13	754844.0
2023-11-15	AB	Stock	27.3	27.7	27.16	27.4	497400.0
2023-11-15	ABAT	Stock	4.32	4.3799	3.96	4.2	452294.0
2023-11-15	ABBNY-DELISTED	Stock	37.75	37.93	37.71	37.85	237493.0
2023-11-15	ABBV	Stock	138.25	138.25	136.3	137.6	6473200.0
2023-11-15	ABCB	Stock	42.85	44.01	42.33	43.53	675800.0
2023-11-15	ABCL	Stock	4.4	4.66	4.3	4.53	1470000.0
2023-11-15	ABCM-DELISTED	Stock	23.14	23.28	23.12	23.28	4880312.0
2023-11-15	ABEO	Stock	4.15	4.39	4.14	4.15	124700.0
2023-11-15	ABEV	Stock	2.78	2.83	2.78	2.8	6045900.0
2023-11-15	ABG	Stock	218.98	225.96	218.98	222.74	142100.0
2023-11-15	ABLLW	Stock	0.33	0.33	0.28	0.303	5223.0
2023-11-15	ABLV	Stock	1.716	1.85	1.716	1.78	38400.0
2023-11-15	ABM	Stock	41.65	42.06	41.24	41.41	380100.0
2023-11-15	ABNB	Stock	128.0	131.62	127.061	128.35	6851400.0
2023-11-15	ABOS	Stock	2.15	2.53	2.145	2.37	1289800.0
2023-11-15	ABR	Stock	13.73	13.85	13.43	13.84	4219400.0
2023-11-15	ABR.D	Stock	16.75	17.15	16.75	17.0	38738.0
2023-11-15	ABR.E	Stock	16.75	17.0	16.66	16.8	16103.0
2023-11-15	ABR.F	Stock	17.85	18.05	17.7101	18.0	14630.0
2023-11-15	ABSI	Stock	1.3	1.46	1.29	1.4	713500.0

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

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