PREVIEW / stock_daily / 2023-11-08

all stock daily files

  file:    by_date/stock_daily/2023/2023-11-08.parquet
  size:    233 KB
  rows:    7,337
  symbols: 1,320

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-08	AAPL	Stock	182.35	183.45	181.59	182.89	49340300.0
2023-11-08	MSFT	Stock	361.68	363.87	360.55	363.2	26767800.0
2023-11-08	NVDA	Stock	46.1	46.867	45.968	46.574	346719000.0
2023-11-08	AMZN	Stock	142.97	143.12	141.22	142.08	44521700.0
2023-11-08	GOOGL	Stock	130.97	132.21	130.78	131.84	26425849.0
2023-11-08	META	Stock	318.14	321.33	314.88	319.78	13609700.0
2023-11-08	TSLA	Stock	223.15	224.15	217.64	222.11	106584800.0
2023-11-08	TLT	Stock	88.48	89.62	88.45	89.56	53893384.0
2023-11-08	ES	Stock	56.17	56.34	54.9	55.69	2249200.0
2023-11-08	CL	Stock	75.19	75.68	74.87	75.24	3113100.0
2023-11-08	A	Stock	110.89	111.57	108.46	109.39	1495000.0
2023-11-08	AA	Stock	25.12	25.66	24.965	25.53	3671400.0
2023-11-08	AACG	Stock	0.83	0.95	0.83	0.85	34200.0
2023-11-08	AACT	Stock	10.33	10.33	10.325	10.33	25800.0
2023-11-08	AAIC-DELISTED	Stock	4.42	4.47	4.35	4.46	161480.0
2023-11-08	AAL	Stock	11.86	12.27	11.85	12.01	40867800.0
2023-11-08	AAMC-DELISTED	Stock	3.55	3.73	3.55	3.58	7500.0
2023-11-08	AAME	Stock	1.72	1.72	1.72	1.72	300.0
2023-11-08	AAMI	Stock	16.26	16.45	16.09	16.18	235300.0
2023-11-08	AAN-DELISTED	Stock	7.33	7.39	6.99	7.03	558600.0
2023-11-08	AAOI	Stock	9.96	10.07	9.59	9.85	868700.0
2023-11-08	AAON	Stock	58.8	59.42	57.52	58.58	422400.0
2023-11-08	AAP	Stock	58.19	58.64	57.52	57.64	996300.0
2023-11-08	AAT	Stock	19.21	19.21	18.85	18.98	255900.0
2023-11-08	AATC	Stock	5.61	5.67	5.61	5.62	7730.0
2023-11-08	AAU-DELISTED	Stock	0.1391	0.1399	0.135	0.135	58383.0
2023-11-08	AAUAF-DELISTED	Stock	0.1391	0.1399	0.135	0.135	57444.0
2023-11-08	AAXJ	Stock	64.2	64.4	64.01	64.11	282945.0
2023-11-08	AB	Stock	27.85	27.96	27.51	27.71	387600.0
2023-11-08	ABAT	Stock	4.3	4.64	4.2	4.5	184068.0
2023-11-08	ABBNY-DELISTED	Stock	34.74	34.96	34.67	34.87	342802.0
2023-11-08	ABBV	Stock	143.44	143.89	141.92	142.03	5299100.0
2023-11-08	ABCB	Stock	40.81	40.87	39.94	40.06	473200.0
2023-11-08	ABCL	Stock	4.38	4.38	4.12	4.18	1909900.0
2023-11-08	ABCM-DELISTED	Stock	23.2	23.24	23.08	23.11	4617352.0
2023-11-08	ABEO	Stock	4.49	4.5	4.18	4.26	77800.0
2023-11-08	ABEV	Stock	2.78	2.79	2.74	2.76	10373700.0
2023-11-08	ABG	Stock	201.79	204.36	199.94	201.47	77500.0
2023-11-08	ABLLW	Stock	0.32	0.32	0.29	0.2901	16035.0
2023-11-08	ABLV	Stock	1.79	1.86	1.75	1.76	23700.0
2023-11-08	ABM	Stock	40.1	40.1	39.53	39.63	260400.0
2023-11-08	ABNB	Stock	119.43	121.2	116.179	117.66	7814000.0
2023-11-08	ABOS	Stock	2.12	2.16	1.99	2.04	435800.0
2023-11-08	ABR	Stock	12.66	13.14	12.57	13.1	4781100.0
2023-11-08	ABR.D	Stock	16.515	16.84	16.38	16.56	21515.0
2023-11-08	ABR.E	Stock	16.7585	16.8	16.4	16.4	14402.0
2023-11-08	ABR.F	Stock	17.71	17.93	17.69	17.69	13583.0
2023-11-08	ABSI	Stock	1.4	1.43	1.32	1.36	240900.0
2023-11-08	ABT	Stock	95.22	95.73	93.79	94.74	4416000.0
2023-11-08	ABTC	Stock	382.5	400.5	345.0	390.0	49.333333333333336

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

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