PREVIEW / stock_daily / 2023-08-23

all stock daily files

  file:    by_date/stock_daily/2023/2023-08-23.parquet
  size:    237 KB
  rows:    7,409
  symbols: 1,458

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-23	AAPL	Stock	178.52	181.55	178.33	181.12	52722800.0
2023-08-23	MSFT	Stock	323.82	329.2	323.46	327.0	21166400.0
2023-08-23	NVDA	Stock	45.866	47.2	45.208	47.116	779046000.0
2023-08-23	AMZN	Stock	134.5	135.95	133.22	135.52	42801000.0
2023-08-23	GOOGL	Stock	130.18	133.41	129.87	132.37	27819713.0
2023-08-23	META	Stock	288.5	297.4	287.67	294.24	18287000.0
2023-08-23	TSLA	Stock	229.34	238.98	229.29	236.86	101077600.0
2023-08-23	TLT	Stock	94.3	95.55	94.23	95.54	38294655.0
2023-08-23	ES	Stock	64.12	64.43	63.6	64.13	1913700.0
2023-08-23	CL	Stock	73.86	74.17	73.13	73.51	2615300.0
2023-08-23	A	Stock	118.51	119.15	117.71	119.13	1289300.0
2023-08-23	AA	Stock	28.78	29.03	28.56	28.81	5915200.0
2023-08-23	AAC-DELISTED	Stock	10.6629	10.6795	10.6629	10.67	11933.0
2023-08-23	AACG	Stock	1.26	1.26	1.18	1.21	9400.0
2023-08-23	AACT	Stock	10.24	10.24	10.2	10.2	54200.0
2023-08-23	AAIC-DELISTED	Stock	4.39	4.47	4.38	4.47	116973.0
2023-08-23	AAIC.C-DELISTED	Stock	23.95	23.95	23.94	23.94	3300.0
2023-08-23	AAL	Stock	14.78	14.92	14.57	14.78	18599700.0
2023-08-23	AAM.A-DELISTED	Stock	25.2201	25.25	25.22	25.235	21198.0
2023-08-23	AAM.B-DELISTED	Stock	25.24	25.3	25.24	25.27	3151.0
2023-08-23	AAMC-DELISTED	Stock	4.7529	5.2941	4.7529	5.2353	177480.0
2023-08-23	AAME	Stock	1.92	2.03	1.86	1.99	2700.0
2023-08-23	AAMI	Stock	20.8	21.56	20.7	21.52	151100.0
2023-08-23	AAN-DELISTED	Stock	11.93	12.106	11.9	12.08	126100.0
2023-08-23	AAOI	Stock	15.14	15.73	14.35	15.33	2518700.0
2023-08-23	AAON	Stock	60.26	62.65	60.21	61.59	522600.0
2023-08-23	AAP	Stock	67.49	71.49	66.33	69.44	6086400.0
2023-08-23	AAT	Stock	20.65	20.97	20.42	20.93	140800.0
2023-08-23	AATC	Stock	5.875	6.09	5.85	6.06	24897.0
2023-08-23	AAU-DELISTED	Stock	0.1231	0.1231	0.1201	0.1206	74669.0
2023-08-23	AAUAF-DELISTED	Stock	0.1231	0.1231	0.1201	0.1206	75764.0
2023-08-23	AAXJ	Stock	64.54	65.03	64.45	64.92	417009.0
2023-08-23	AB	Stock	29.55	30.58	29.55	30.33	234800.0
2023-08-23	ABBNY-DELISTED	Stock	37.28	37.4499	37.26	37.35	330758.0
2023-08-23	ABBV	Stock	148.67	149.0	145.94	147.08	5414800.0
2023-08-23	ABC-DELISTED	Stock	178.54	178.8025	177.15	177.77	721797.0
2023-08-23	ABCB	Stock	39.38	39.81	38.9	39.75	177100.0
2023-08-23	ABCL	Stock	5.52	5.59	5.495	5.56	748000.0
2023-08-23	ABCM-DELISTED	Stock	22.19	22.71	22.18	22.55	2140455.0
2023-08-23	ABEO	Stock	3.83	4.13	3.77	4.13	95000.0
2023-08-23	ABEV	Stock	2.92	2.95	2.9	2.93	8892900.0
2023-08-23	ABG	Stock	217.63	222.48	216.17	222.27	125500.0
2023-08-23	ABLLW	Stock	0.3465	0.36	0.2801	0.303	600630.0
2023-08-23	ABLV	Stock	4.79	5.2	4.54	4.75	99051.0
2023-08-23	ABLVW	Stock	0.04	0.0595	0.04	0.0595	2298.0
2023-08-23	ABM	Stock	44.82	45.1	44.6	45.09	170200.0
2023-08-23	ABNB	Stock	126.9	129.185	126.4	128.13	4605400.0
2023-08-23	ABOS	Stock	6.47	6.6	6.42	6.5	711700.0
2023-08-23	ABR	Stock	15.15	15.37	15.09	15.34	2376100.0
2023-08-23	ABR.D	Stock	18.09	18.8255	18.09	18.4453	4016.0

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

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