PREVIEW / stock_daily / 2023-12-01

all stock daily files

  file:    by_date/stock_daily/2023/2023-12-01.parquet
  size:    236 KB
  rows:    7,361
  symbols: 1,263

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-12-01	AAPL	Stock	190.33	191.56	189.23	191.24	45679300.0
2023-12-01	MSFT	Stock	376.76	378.16	371.31	374.51	33020400.0
2023-12-01	NVDA	Stock	46.525	47.2	46.187	46.765	369317000.0
2023-12-01	AMZN	Stock	146.0	147.25	145.55	147.03	39924600.0
2023-12-01	GOOGL	Stock	131.86	132.11	130.665	131.86	31442263.0
2023-12-01	META	Stock	325.48	326.86	320.76	324.82	15264700.0
2023-12-01	TSLA	Stock	233.14	240.19	231.9	238.83	121173500.0
2023-12-01	TLT	Stock	91.31	93.0599	91.1316	92.99	64172227.0
2023-12-01	ES	Stock	59.51	60.79	59.2	60.78	2103300.0
2023-12-01	CL	Stock	78.86	78.99	78.35	78.7	3488400.0
2023-12-01	A	Stock	127.34	129.01	126.51	128.79	1729600.0
2023-12-01	AA	Stock	27.0	28.015	26.51	27.74	5455100.0
2023-12-01	AACG	Stock	0.86	0.87	0.8	0.86	7000.0
2023-12-01	AACT	Stock	10.37	10.395	10.37	10.395	700.0
2023-12-01	AAIC-DELISTED	Stock	4.7	4.78	4.66	4.77	153650.0
2023-12-01	AAIC.C-DELISTED	Stock	24.26	24.27	24.26	24.27	892.0
2023-12-01	AAL	Stock	12.46	13.06	12.44	13.02	48841500.0
2023-12-01	AAMC-DELISTED	Stock	3.22	3.28	3.1	3.26	56300.0
2023-12-01	AAME	Stock	1.91	1.91	1.91	1.91	1900.0
2023-12-01	AAMI	Stock	17.36	18.3	17.32	18.19	221900.0
2023-12-01	AAN-DELISTED	Stock	8.78	9.49	8.65	9.49	713200.0
2023-12-01	AAOI	Stock	13.19	16.48	12.98	16.45	5622400.0
2023-12-01	AAON	Stock	62.61	63.6	61.09	62.53	454800.0
2023-12-01	AAP	Stock	50.99	54.09	50.64	54.09	2211600.0
2023-12-01	AAT	Stock	20.0	21.17	20.0	21.1	542700.0
2023-12-01	AATC	Stock	6.41	6.5	6.39	6.5	13934.0
2023-12-01	AAU-DELISTED	Stock	0.1498	0.1498	0.145	0.1466	210876.0
2023-12-01	AAUAF-DELISTED	Stock	0.1498	0.1498	0.145	0.1466	212346.0
2023-12-01	AAXJ	Stock	64.88	65.62	64.77	65.6	544287.0
2023-12-01	AB	Stock	28.95	29.5	28.73	29.09	782000.0
2023-12-01	ABAT	Stock	4.29	4.43	4.17	4.33	244085.0
2023-12-01	ABBNY-DELISTED	Stock	39.97	40.55	39.97	40.5	143765.0
2023-12-01	ABBV	Stock	142.54	144.1	142.28	143.41	4902200.0
2023-12-01	ABCB	Stock	42.29	45.42	42.25	45.22	409400.0
2023-12-01	ABCL	Stock	4.68	4.86	4.52	4.83	2053300.0
2023-12-01	ABCM-DELISTED	Stock	23.98	23.98	23.96	23.97	8397522.0
2023-12-01	ABEO	Stock	4.85	4.85	4.57	4.66	148000.0
2023-12-01	ABEV	Stock	2.81	2.87	2.8	2.85	8473000.0
2023-12-01	ABG	Stock	209.31	218.01	208.32	217.61	118000.0
2023-12-01	ABLLW	Stock	0.3999	0.3999	0.37	0.3899	26642.0
2023-12-01	ABLV	Stock	2.86	2.92	2.86	2.92	2000.0
2023-12-01	ABM	Stock	40.91	42.21	40.91	42.15	344400.0
2023-12-01	ABNB	Stock	125.5	135.42	125.4	135.02	7419200.0
2023-12-01	ABOS	Stock	2.4	2.66	2.37	2.65	548800.0
2023-12-01	ABR	Stock	12.44	13.48	12.36	13.44	8395000.0
2023-12-01	ABR.D	Stock	16.66	17.3	16.66	17.3	26442.0
2023-12-01	ABR.E	Stock	16.57	17.11	16.57	17.1	16223.0
2023-12-01	ABR.F	Stock	19.0	19.22	19.0	19.22	26518.0
2023-12-01	ABSI	Stock	1.69	1.74	1.61	1.74	527200.0
2023-12-01	ABT	Stock	104.22	104.98	103.9	104.88	4682300.0

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

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