PREVIEW / stock_daily / 2023-08-15

all stock daily files

  file:    by_date/stock_daily/2023/2023-08-15.parquet
  size:    238 KB
  rows:    7,421
  symbols: 1,478

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-15	AAPL	Stock	178.88	179.48	177.05	177.45	43622600.0
2023-08-15	MSFT	Stock	323.0	325.09	320.9	321.86	16966300.0
2023-08-15	NVDA	Stock	44.56	45.268	43.71	43.94	676512000.0
2023-08-15	AMZN	Stock	140.05	141.28	137.23	137.67	42781500.0
2023-08-15	GOOGL	Stock	131.1	131.42	129.28	129.78	19770732.0
2023-08-15	META	Stock	306.14	307.23	300.03	301.95	11623600.0
2023-08-15	TSLA	Stock	238.73	240.5	232.61	232.96	88197600.0
2023-08-15	TLT	Stock	94.798	95.195	94.56	94.58	24125027.0
2023-08-15	ES	Stock	65.71	65.88	64.26	64.26	3118400.0
2023-08-15	CL	Stock	75.47	75.58	74.43	74.64	4476300.0
2023-08-15	A	Stock	126.31	127.18	125.25	125.65	2274800.0
2023-08-15	AA	Stock	31.475	31.475	30.305	30.34	5807900.0
2023-08-15	AAC-DELISTED	Stock	10.64	10.655	10.6267	10.65	54817.0
2023-08-15	AACG	Stock	1.23	1.24	1.18	1.18	14700.0
2023-08-15	AACIW-DELISTED	Stock	0.0678	0.0678	0.06	0.06	1000.0
2023-08-15	AAIC-DELISTED	Stock	4.48	4.48	4.44	4.47	55429.0
2023-08-15	AAIC.C-DELISTED	Stock	23.99	24.25	23.95	24.0475	9490.0
2023-08-15	AAL	Stock	15.71	15.78	15.51	15.55	20041500.0
2023-08-15	AAM.A-DELISTED	Stock	24.8	24.88	24.51	24.53	17957.0
2023-08-15	AAM.B-DELISTED	Stock	24.4211	24.7751	24.4211	24.54	3346.0
2023-08-15	AAMC-DELISTED	Stock	6.3059	8.0559	5.7947	6.0471	1372580.0
2023-08-15	AAME	Stock	1.95	1.95	1.76	1.85	9300.0
2023-08-15	AAMI	Stock	19.81	19.89	19.6	19.64	62000.0
2023-08-15	AAN-DELISTED	Stock	12.4	12.65	12.3	12.61	161100.0
2023-08-15	AAOI	Stock	14.895	15.9	14.11	14.79	6348500.0
2023-08-15	AAON	Stock	64.0467	64.0467	62.8733	63.0	304350.0
2023-08-15	AAP	Stock	70.81	71.17	69.4	69.73	1282000.0
2023-08-15	AAT	Stock	21.61	21.61	21.2	21.26	264700.0
2023-08-15	AATC	Stock	5.44	5.505	5.36	5.46	6979.0
2023-08-15	AAU-DELISTED	Stock	0.132	0.1336	0.1212	0.128	294847.0
2023-08-15	AAUAF-DELISTED	Stock	0.132	0.1336	0.1212	0.128	298563.0
2023-08-15	AAXJ	Stock	65.54	65.54	65.05	65.14	325578.0
2023-08-15	AB	Stock	29.95	29.95	29.05	29.23	342400.0
2023-08-15	ABBNY-DELISTED	Stock	38.3001	38.38	37.98	38.03	123595.0
2023-08-15	ABBV	Stock	151.57	152.9	150.79	152.12	3636300.0
2023-08-15	ABC-DELISTED	Stock	188.07	188.4	185.3	185.44	808208.0
2023-08-15	ABCB	Stock	42.52	42.62	41.75	41.82	294400.0
2023-08-15	ABCL	Stock	5.6	5.65	5.5	5.52	1848200.0
2023-08-15	ABCM-DELISTED	Stock	22.71	23.06	22.56	22.62	1325810.0
2023-08-15	ABEO	Stock	3.12	3.64	3.07	3.45	145000.0
2023-08-15	ABEV	Stock	2.86	2.86	2.82	2.82	7848800.0
2023-08-15	ABG	Stock	227.88	228.25	222.33	223.19	120900.0
2023-08-15	ABLLW	Stock	0.2601	0.305	0.2601	0.2901	50340.0
2023-08-15	ABLV	Stock	8.2	9.1	8.2	8.8	10503.0
2023-08-15	ABM	Stock	45.59	45.74	45.44	45.5	193200.0
2023-08-15	ABNB	Stock	132.5	132.81	129.73	129.85	3970500.0
2023-08-15	ABOS	Stock	7.15	7.25	6.96	7.12	539300.0
2023-08-15	ABR	Stock	15.89	16.02	15.55	15.69	2648100.0
2023-08-15	ABR.D	Stock	18.7154	18.7154	18.51	18.66	7128.0
2023-08-15	ABR.E	Stock	18.4	18.54	18.38	18.54	1774.0

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

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