PREVIEW / stock_daily / 2023-08-24

all stock daily files

  file:    by_date/stock_daily/2023/2023-08-24.parquet
  size:    236 KB
  rows:    7,364
  symbols: 1,442

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-08-24	AAPL	Stock	180.67	181.1	176.01	176.38	54945800.0
2023-08-24	MSFT	Stock	332.85	332.98	319.96	319.97	23281400.0
2023-08-24	NVDA	Stock	50.216	50.266	47.159	47.163	1156044000.0
2023-08-24	AMZN	Stock	136.4	136.78	131.83	131.84	43646300.0
2023-08-24	GOOGL	Stock	133.95	134.25	129.57	129.78	28500694.0
2023-08-24	META	Stock	298.5	299.46	286.64	286.75	18360900.0
2023-08-24	TSLA	Stock	238.66	238.92	228.18	230.04	99777400.0
2023-08-24	TLT	Stock	95.13	95.55	94.885	94.91	22300818.0
2023-08-24	ES	Stock	64.06	64.81	63.6	63.97	1976100.0
2023-08-24	CL	Stock	73.55	74.31	73.3	73.32	3692900.0
2023-08-24	A	Stock	119.36	120.78	118.58	119.49	2045900.0
2023-08-24	AA	Stock	28.36	29.11	28.31	28.75	4329500.0
2023-08-24	AAC-DELISTED	Stock	10.68	10.69	10.67	10.685	53568.0
2023-08-24	AACG	Stock	1.27	1.28	1.21	1.21	7800.0
2023-08-24	AACIW-DELISTED	Stock	0.0875	0.0894	0.0871	0.0894	800.0
2023-08-24	AAIC-DELISTED	Stock	4.41	4.48	4.41	4.44	43947.0
2023-08-24	AAIC.C-DELISTED	Stock	23.9	24.02	23.9	24.0	3936.0
2023-08-24	AAL	Stock	14.66	14.76	14.46	14.57	23360500.0
2023-08-24	AAM.A-DELISTED	Stock	25.29	25.3138	25.2701	25.31	184773.0
2023-08-24	AAM.B-DELISTED	Stock	25.28	25.34	25.28	25.33	24403.0
2023-08-24	AAMC-DELISTED	Stock	5.2235	5.6941	5.0824	5.0824	90270.0
2023-08-24	AAME	Stock	1.92	2.0	1.92	1.98	2800.0
2023-08-24	AAMI	Stock	21.4	21.58	20.97	21.06	159200.0
2023-08-24	AAN-DELISTED	Stock	12.0	12.15	11.85	11.89	204100.0
2023-08-24	AAOI	Stock	15.6	16.26	13.8	14.09	2771000.0
2023-08-24	AAON	Stock	61.14	61.45	59.61	60.0	342000.0
2023-08-24	AAP	Stock	69.55	71.39	67.85	67.91	17981700.0
2023-08-24	AAT	Stock	20.88	21.37	20.88	20.92	199300.0
2023-08-24	AATC	Stock	6.1	6.14	5.94	6.025	26789.0
2023-08-24	AAU-DELISTED	Stock	0.122	0.122	0.12	0.1209	88970.0
2023-08-24	AAUAF-DELISTED	Stock	0.122	0.122	0.12	0.1209	91432.0
2023-08-24	AAXJ	Stock	65.31	65.42	64.7	64.7	567599.0
2023-08-24	AB	Stock	30.29	31.07	30.01	30.04	244200.0
2023-08-24	ABBNY-DELISTED	Stock	37.4	37.456	36.84	36.85	184625.0
2023-08-24	ABBV	Stock	146.92	147.82	146.35	146.63	3986300.0
2023-08-24	ABC-DELISTED	Stock	177.8	179.666	177.8	178.77	771873.0
2023-08-24	ABCB	Stock	39.6	40.32	39.37	39.69	375300.0
2023-08-24	ABCL	Stock	5.56	5.56	5.42	5.5	1182800.0
2023-08-24	ABCM-DELISTED	Stock	22.78	22.9	22.4591	22.5	754704.0
2023-08-24	ABEO	Stock	4.16	4.19	3.82	3.94	85900.0
2023-08-24	ABEV	Stock	2.93	2.94	2.87	2.87	7073100.0
2023-08-24	ABG	Stock	220.59	220.59	216.94	217.57	113000.0
2023-08-24	ABLLW	Stock	0.36	0.38	0.303	0.3611	106805.0
2023-08-24	ABLV	Stock	4.5	5.44	4.2004	4.99	326311.0
2023-08-24	ABLVW	Stock	0.052	0.0578	0.0375	0.0552	57888.0
2023-08-24	ABM	Stock	44.95	45.56	44.89	45.36	335500.0
2023-08-24	ABNB	Stock	128.23	128.84	124.64	124.72	2980800.0
2023-08-24	ABOS	Stock	6.5	6.5	5.9	6.12	575300.0
2023-08-24	ABR	Stock	15.29	15.72	15.28	15.44	2072800.0
2023-08-24	ABR.D	Stock	18.75	18.75	18.45	18.68	4392.0

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

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