PREVIEW / stock_daily / 2023-09-08

all stock daily files

  file:    by_date/stock_daily/2023/2023-09-08.parquet
  size:    236 KB
  rows:    7,377
  symbols: 1,438

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-09-08	AAPL	Stock	178.35	180.24	177.79	178.18	65551300.0
2023-09-08	MSFT	Stock	330.09	336.16	329.46	334.27	19530100.0
2023-09-08	NVDA	Stock	45.942	46.606	45.271	45.572	473069000.0
2023-09-08	AMZN	Stock	136.86	138.85	136.75	138.23	38348200.0
2023-09-08	GOOGL	Stock	134.91	136.66	134.85	136.38	23584188.0
2023-09-08	META	Stock	299.22	305.25	296.78	297.89	17548000.0
2023-09-08	TSLA	Stock	251.22	256.52	246.67	248.5	118367700.0
2023-09-08	TLT	Stock	94.38	94.9	94.17	94.37	17054175.0
2023-09-08	ES	Stock	61.62	62.11	61.15	62.08	2381100.0
2023-09-08	CL	Stock	73.57	73.8	73.09	73.2	3804500.0
2023-09-08	A	Stock	116.01	116.21	113.71	113.99	1789800.0
2023-09-08	AA	Stock	28.3	28.467	27.96	28.1	4520900.0
2023-09-08	AAC-DELISTED	Stock	10.7	10.71	10.69	10.69	18974.0
2023-09-08	AACG	Stock	1.18	1.2	1.18	1.18	10700.0
2023-09-08	AACT	Stock	10.23	10.24	10.23	10.23	32000.0
2023-09-08	AAIC-DELISTED	Stock	4.57	4.75	4.517	4.72	86699.0
2023-09-08	AAIC.C-DELISTED	Stock	24.31	24.4	24.3	24.4	4500.0
2023-09-08	AAL	Stock	14.0	14.13	13.91	13.98	17141500.0
2023-09-08	AAM.A-DELISTED	Stock	24.97	25.0	24.97	25.0	7131.0
2023-09-08	AAM.B-DELISTED	Stock	24.93	24.93	24.93	24.93	425.0
2023-09-08	AAMC-DELISTED	Stock	4.2824	4.3918	3.6882	3.7118	53040.0
2023-09-08	AAME	Stock	2.03	2.03	1.85	1.9	3000.0
2023-09-08	AAMI	Stock	20.28	20.5	20.03	20.35	106000.0
2023-09-08	AAN-DELISTED	Stock	10.31	10.64	10.1	10.41	729300.0
2023-09-08	AAOI	Stock	12.54	12.98	11.55	11.8	2273200.0
2023-09-08	AAON	Stock	66.23	66.75	65.39	65.57	347900.0
2023-09-08	AAP	Stock	63.07	65.04	62.82	64.61	1755200.0
2023-09-08	AAT	Stock	20.55	20.78	20.33	20.48	359500.0
2023-09-08	AATC	Stock	6.04	6.04	6.02	6.02	4803.0
2023-09-08	AAU-DELISTED	Stock	0.121	0.1277	0.121	0.123	123150.0
2023-09-08	AAUAF-DELISTED	Stock	0.121	0.1277	0.121	0.123	128815.0
2023-09-08	AAXJ	Stock	64.96	65.09	64.81	64.92	286345.0
2023-09-08	AB	Stock	32.68	32.68	31.85	31.97	351600.0
2023-09-08	ABBNY-DELISTED	Stock	36.83	36.915	36.68	36.71	134598.0
2023-09-08	ABBV	Stock	149.0	149.76	148.2	149.02	4339800.0
2023-09-08	ABCB	Stock	39.23	39.38	38.6	39.21	253700.0
2023-09-08	ABCL	Stock	5.57	5.58	5.38	5.41	1796200.0
2023-09-08	ABCM-DELISTED	Stock	22.86	22.88	22.815	22.855	2465301.0
2023-09-08	ABEO	Stock	3.96	4.11	3.86	4.07	128100.0
2023-09-08	ABEV	Stock	2.75	2.76	2.72	2.72	9417800.0
2023-09-08	ABG	Stock	218.79	226.27	218.3	222.27	133800.0
2023-09-08	ABLLW	Stock	0.3899	0.4174	0.38	0.4038	13203.0
2023-09-08	ABLV	Stock	2.82	2.88	2.71	2.82	35500.0
2023-09-08	ABM	Stock	37.61	39.54	37.61	39.28	1154500.0
2023-09-08	ABNB	Stock	143.94	146.85	143.18	145.82	9326600.0
2023-09-08	ABOS	Stock	5.61	5.66	5.52	5.615	163100.0
2023-09-08	ABR	Stock	15.79	16.01	15.71	15.91	1589700.0
2023-09-08	ABR.D	Stock	18.7	19.0	18.7	19.0	7428.0
2023-09-08	ABR.E	Stock	18.71	18.75	18.63	18.67	1388.0
2023-09-08	ABR.F	Stock	20.43	20.58	20.2876	20.58	2110.0

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

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