PREVIEW / stock_daily / 2023-11-09

all stock daily files

  file:    by_date/stock_daily/2023/2023-11-09.parquet
  size:    232 KB
  rows:    7,286
  symbols: 1,270

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-09	AAPL	Stock	182.96	184.12	181.81	182.41	53763500.0
2023-11-09	MSFT	Stock	362.3	364.79	360.36	360.69	24847300.0
2023-11-09	NVDA	Stock	47.467	48.23	46.75	46.95	540496000.0
2023-11-09	AMZN	Stock	142.02	142.65	139.84	140.6	36235400.0
2023-11-09	GOOGL	Stock	131.96	132.55	130.065	130.24	23747773.0
2023-11-09	META	Stock	319.42	324.18	318.8	320.55	16103100.0
2023-11-09	TSLA	Stock	219.75	220.8	206.68	209.98	142110500.0
2023-11-09	TLT	Stock	88.94	89.03	86.74	87.5	88975095.0
2023-11-09	ES	Stock	55.97	56.13	54.21	54.24	2427100.0
2023-11-09	CL	Stock	75.45	75.56	74.8	75.14	2631900.0
2023-11-09	A	Stock	110.12	110.12	107.54	107.74	1481100.0
2023-11-09	AA	Stock	25.81	25.87	24.41	24.58	4078500.0
2023-11-09	AACG	Stock	0.88	0.9	0.85	0.85	10800.0
2023-11-09	AACIW-DELISTED	Stock	0.0633	0.0633	0.0633	0.0633	365.0
2023-11-09	AACT	Stock	10.32	10.322	10.32	10.322	1900.0
2023-11-09	AAIC-DELISTED	Stock	4.47	4.525	4.4	4.43	497119.0
2023-11-09	AAIC.C-DELISTED	Stock	23.73	23.85	23.73	23.85	900.0
2023-11-09	AAL	Stock	12.16	12.24	11.67	11.75	37774500.0
2023-11-09	AAMC-DELISTED	Stock	3.65	3.65	3.17	3.17	32800.0
2023-11-09	AAME	Stock	1.71	1.73	1.51	1.54	16700.0
2023-11-09	AAMI	Stock	16.33	16.4	15.99	16.02	194800.0
2023-11-09	AAN-DELISTED	Stock	7.13	7.151	6.81	6.87	522300.0
2023-11-09	AAOI	Stock	10.07	10.17	9.645	9.76	2102000.0
2023-11-09	AAON	Stock	59.1	59.37	57.2	57.45	386300.0
2023-11-09	AAP	Stock	57.77	57.88	55.88	56.14	1659700.0
2023-11-09	AAT	Stock	19.15	19.15	18.31	18.42	421300.0
2023-11-09	AATC	Stock	5.62	5.74	5.62	5.62	10092.0
2023-11-09	AAU-DELISTED	Stock	0.14	0.14	0.135	0.136	62148.0
2023-11-09	AAUAF-DELISTED	Stock	0.14	0.14	0.135	0.136	64099.0
2023-11-09	AAXJ	Stock	64.08	64.29	63.48	63.53	421912.0
2023-11-09	AB	Stock	27.66	27.7	27.01	27.16	531100.0
2023-11-09	ABAT	Stock	4.48	4.69	4.36	4.39	180699.0
2023-11-09	ABBNY-DELISTED	Stock	36.11	36.28	35.7	35.7	298214.0
2023-11-09	ABBV	Stock	141.0	141.6	135.85	138.04	14970300.0
2023-11-09	ABCB	Stock	40.12	40.19	38.95	39.23	391600.0
2023-11-09	ABCL	Stock	4.21	4.27	4.04	4.04	1313600.0
2023-11-09	ABCM-DELISTED	Stock	23.1	23.3	23.05	23.075	7302976.0
2023-11-09	ABEO	Stock	4.26	4.36	3.93	3.94	76100.0
2023-11-09	ABEV	Stock	2.73	2.76	2.7	2.71	9885900.0
2023-11-09	ABG	Stock	204.78	204.78	198.5	198.56	169900.0
2023-11-09	ABLLW	Stock	0.3195	0.3469	0.2801	0.3301	189921.0
2023-11-09	ABLV	Stock	1.8	1.85	1.72	1.72	13300.0
2023-11-09	ABM	Stock	39.86	39.91	39.27	39.6	431000.0
2023-11-09	ABNB	Stock	118.35	119.53	115.2	115.52	5519600.0
2023-11-09	ABOS	Stock	2.05	2.05	1.83	1.86	641600.0
2023-11-09	ABR	Stock	13.26	13.38	12.72	12.86	5580700.0
2023-11-09	ABR.D	Stock	16.69	16.75	16.5	16.5	19644.0
2023-11-09	ABR.E	Stock	16.55	16.67	16.31	16.34	6805.0
2023-11-09	ABR.F	Stock	17.73	17.7864	17.51	17.68	16008.0
2023-11-09	ABSI	Stock	1.42	1.42	1.24	1.27	230100.0

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

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