PREVIEW / stock_daily / 2023-09-07

all stock daily files

  file:    by_date/stock_daily/2023/2023-09-07.parquet
  size:    236 KB
  rows:    7,346
  symbols: 1,410

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-07	AAPL	Stock	175.18	178.21	173.54	177.56	112488800.0
2023-09-07	MSFT	Stock	331.29	333.08	329.03	329.91	18381000.0
2023-09-07	NVDA	Stock	45.525	46.344	45.152	46.241	433330000.0
2023-09-07	AMZN	Stock	133.9	138.03	133.16	137.85	48498900.0
2023-09-07	GOOGL	Stock	133.59	135.58	132.95	135.26	18844342.0
2023-09-07	META	Stock	298.0	307.05	292.22	298.67	33748700.0
2023-09-07	TSLA	Stock	245.07	252.81	243.27	251.49	115312900.0
2023-09-07	TLT	Stock	94.0	94.07	93.68	94.01	18091459.0
2023-09-07	ES	Stock	61.48	61.98	60.98	61.35	2331700.0
2023-09-07	CL	Stock	72.65	74.18	72.64	73.56	5704300.0
2023-09-07	A	Stock	117.97	118.01	116.09	116.26	1317000.0
2023-09-07	AA	Stock	29.45	29.45	28.06	28.45	9406100.0
2023-09-07	AAC-DELISTED	Stock	10.7	10.7	10.69	10.7	33317.0
2023-09-07	AACG	Stock	1.18	1.2	1.18	1.19	2400.0
2023-09-07	AACT	Stock	10.23	10.23	10.23	10.23	281200.0
2023-09-07	AAIC-DELISTED	Stock	4.59	4.59	4.53	4.56	24873.0
2023-09-07	AAIC.C-DELISTED	Stock	24.29	24.3	24.24	24.3	1900.0
2023-09-07	AAL	Stock	14.25	14.26	13.92	14.0	24678300.0
2023-09-07	AAM.A-DELISTED	Stock	24.96	24.97	24.96	24.97	19382.0
2023-09-07	AAM.B-DELISTED	Stock	24.9868	24.9868	24.96	24.96	13949.0
2023-09-07	AAMC-DELISTED	Stock	4.7059	4.7059	4.2059	4.2412	44200.0
2023-09-07	AAME	Stock	2.01	2.01	1.86	1.86	2500.0
2023-09-07	AAMI	Stock	20.13	20.24	19.89	20.15	247400.0
2023-09-07	AAN-DELISTED	Stock	10.4	10.61	10.0	10.15	1089100.0
2023-09-07	AAOI	Stock	12.25	12.66	11.85	12.32	1759600.0
2023-09-07	AAON	Stock	65.2	65.97	64.5	65.7	329000.0
2023-09-07	AAP	Stock	66.45	66.62	63.26	63.39	2933500.0
2023-09-07	AAT	Stock	20.69	20.86	20.61	20.66	255500.0
2023-09-07	AATC	Stock	6.04	6.04	6.0	6.023	4989.0
2023-09-07	AAU-DELISTED	Stock	0.124	0.124	0.12	0.1231	81779.0
2023-09-07	AAUAF-DELISTED	Stock	0.124	0.124	0.12	0.1231	83569.0
2023-09-07	AAXJ	Stock	65.0	65.01	64.68	64.9	588904.0
2023-09-07	AB	Stock	32.22	32.7	32.17	32.6	379400.0
2023-09-07	ABBNY-DELISTED	Stock	37.2501	37.38	37.04	37.28	213099.0
2023-09-07	ABBV	Stock	146.15	149.0	145.87	148.91	5142100.0
2023-09-07	ABCB	Stock	39.55	39.89	39.03	39.15	380900.0
2023-09-07	ABCL	Stock	5.46	5.61	5.41	5.56	1789500.0
2023-09-07	ABCM-DELISTED	Stock	22.88	22.94	22.811	22.83	4966013.0
2023-09-07	ABEO	Stock	3.99	4.04	3.86	4.01	100300.0
2023-09-07	ABEV	Stock	2.77	2.77	2.73	2.74	4661000.0
2023-09-07	ABG	Stock	224.32	226.17	218.81	219.2	147100.0
2023-09-07	ABLLW	Stock	0.47	0.48	0.39	0.39	55470.0
2023-09-07	ABLV	Stock	2.91	3.0	2.82	2.89	45300.0
2023-09-07	ABLVW	Stock	0.0351	0.06	0.0351	0.06	11559.0
2023-09-07	ABM	Stock	40.46	41.22	38.08	38.7	1962200.0
2023-09-07	ABNB	Stock	139.25	144.25	139.01	143.27	7928200.0
2023-09-07	ABOS	Stock	5.86	5.86	5.61	5.61	209100.0
2023-09-07	ABR	Stock	15.85	15.93	15.77	15.81	1978500.0
2023-09-07	ABR.D	Stock	18.7501	19.0	18.71	18.71	6949.0
2023-09-07	ABR.E	Stock	18.39	18.84	18.39	18.75	2455.0

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

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