PREVIEW / stock_daily / 2023-03-03

all stock daily files

  file:    by_date/stock_daily/2023/2023-03-03.parquet
  size:    247 KB
  rows:    7,612
  symbols: 1,784

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-03-03	AAPL	Stock	148.04	151.11	147.33	151.03	70732300.0
2023-03-03	MSFT	Stock	252.19	255.62	251.39	255.29	30760100.0
2023-03-03	NVDA	Stock	23.32	23.9	23.13	23.89	412393000.0
2023-03-03	AMZN	Stock	92.74	94.94	92.66	94.9	55759600.0
2023-03-03	GOOGL	Stock	92.48	93.73	92.45	93.65	35160105.0
2023-03-03	META	Stock	178.92	186.62	177.05	185.25	45877700.0
2023-03-03	TSLA	Stock	194.8	200.48	192.88	197.79	154193300.0
2023-03-03	TLT	Stock	100.93	101.9	100.57	101.89	30877342.0
2023-03-03	ES	Stock	74.49	75.47	73.41	75.44	2863600.0
2023-03-03	CL	Stock	74.0	74.09	73.25	73.95	2532600.0
2023-03-03	A	Stock	142.54	144.44	141.98	143.93	1147800.0
2023-03-03	AA	Stock	54.33	55.74	53.7	55.52	6162700.0
2023-03-03	AAC-DELISTED	Stock	10.24	10.28	10.24	10.28	958779.0
2023-03-03	AACG	Stock	1.98	1.98	1.9	1.91	5800.0
2023-03-03	AACIU	Stock	9.71	10.05	9.71	10.05	701.0
2023-03-03	AACIW-DELISTED	Stock	0.111	0.111	0.11	0.11	490.0
2023-03-03	AAIC-DELISTED	Stock	3.01	3.0338	3.01	3.03	23982.0
2023-03-03	AAIC.C-DELISTED	Stock	22.27	22.27	22.0	22.0	1500.0
2023-03-03	AAL	Stock	16.37	16.55	16.14	16.36	14389500.0
2023-03-03	AAM.A-DELISTED	Stock	23.76	23.8	23.51	23.61	9407.0
2023-03-03	AAM.B-DELISTED	Stock	23.5	24.08	23.27	23.94	14787.0
2023-03-03	AAMC-DELISTED	Stock	15.9588	16.3334	15.5882	15.6471	12607.0
2023-03-03	AAME	Stock	2.55	2.56	2.33	2.39	8800.0
2023-03-03	AAMI	Stock	25.21	25.52	25.03	25.46	124900.0
2023-03-03	AAN-DELISTED	Stock	12.36	12.93	12.36	12.78	854800.0
2023-03-03	AAOI	Stock	2.73	2.75	2.68	2.73	97400.0
2023-03-03	AAON	Stock	60.9867	62.7	60.4467	62.6133	385650.0
2023-03-03	AAP	Stock	139.66	140.26	137.37	138.48	1907500.0
2023-03-03	AAT	Stock	25.0	25.12	24.78	24.83	335900.0
2023-03-03	AATC	Stock	4.33	4.347	4.33	4.347	1440.0
2023-03-03	AAU-DELISTED	Stock	0.2	0.2139	0.2	0.2051	165043.0
2023-03-03	AAUAF-DELISTED	Stock	0.2	0.2139	0.2	0.2041	169719.0
2023-03-03	AAWW-DELISTED	Stock	100.34	100.4007	99.585	99.9	764327.0
2023-03-03	AAXJ	Stock	67.4	67.925	67.35	67.84	578292.0
2023-03-03	AB	Stock	38.25	39.15	38.22	39.11	309300.0
2023-03-03	ABB-DELISTED	Stock	33.71	34.17	33.52	34.165	1684830.0
2023-03-03	ABBNY-DELISTED	Stock	33.71	34.17	33.52	34.16	2852244.0
2023-03-03	ABBV	Stock	154.33	156.17	154.01	156.06	4851200.0
2023-03-03	ABC-DELISTED	Stock	155.54	156.43	153.645	156.08	640005.0
2023-03-03	ABCB	Stock	47.05	47.34	46.26	47.11	263200.0
2023-03-03	ABCL	Stock	8.26	8.485	8.18	8.38	1139400.0
2023-03-03	ABCM-DELISTED	Stock	15.14	15.5	15.025	15.39	348689.0
2023-03-03	ABEO	Stock	2.45	2.53	2.38	2.53	80500.0
2023-03-03	ABEV	Stock	2.52	2.53	2.48	2.52	63051700.0
2023-03-03	ABG	Stock	234.55	241.3	233.81	238.02	381200.0
2023-03-03	ABM	Stock	48.6	48.98	48.11	48.82	228500.0
2023-03-03	ABNB	Stock	123.18	125.87	122.7	125.73	5499400.0
2023-03-03	ABOS	Stock	5.12	5.34	5.03	5.23	29300.0
2023-03-03	ABR	Stock	15.0	15.19	14.97	15.07	3478200.0
2023-03-03	ABR.D	Stock	18.7805	19.1974	18.61	18.87	9870.0

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

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