PREVIEW / stock_daily / 2023-03-01

all stock daily files

  file:    by_date/stock_daily/2023/2023-03-01.parquet
  size:    247 KB
  rows:    7,629
  symbols: 1,800

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-01	AAPL	Stock	146.83	147.23	145.01	145.31	55479000.0
2023-03-01	MSFT	Stock	250.76	250.93	245.79	246.27	27565300.0
2023-03-01	NVDA	Stock	23.192	23.256	22.508	22.698	460026000.0
2023-03-01	AMZN	Stock	93.87	94.68	91.59	92.17	52299500.0
2023-03-01	GOOGL	Stock	89.98	91.03	89.67	90.36	31111225.0
2023-03-01	META	Stock	174.59	177.85	173.05	173.42	30998400.0
2023-03-01	TSLA	Stock	206.21	207.2	198.52	202.77	156852800.0
2023-03-01	TLT	Stock	100.82	101.03	99.96	100.37	19000033.0
2023-03-01	ES	Stock	74.02	74.68	72.93	73.17	2107600.0
2023-03-01	CL	Stock	73.35	73.35	71.82	72.55	2880800.0
2023-03-01	A	Stock	138.58	139.99	136.25	137.51	3132800.0
2023-03-01	AA	Stock	51.29	52.96	50.53	51.65	7599600.0
2023-03-01	AAC-DELISTED	Stock	10.23	10.25	10.23	10.25	174627.0
2023-03-01	AACG	Stock	1.95	1.95	1.9	1.93	8100.0
2023-03-01	AACIW-DELISTED	Stock	0.1148	0.1148	0.106	0.1148	383.0
2023-03-01	AAIC-DELISTED	Stock	3.03	3.06	2.99	3.03	144582.0
2023-03-01	AAIC.C-DELISTED	Stock	22.62	22.6201	20.88	22.0	12437.0
2023-03-01	AAL	Stock	15.93	16.05	15.75	16.03	11730500.0
2023-03-01	AAM.A-DELISTED	Stock	24.65	24.65	24.0301	24.05	10663.0
2023-03-01	AAM.B-DELISTED	Stock	24.19	24.47	23.93	23.95	5411.0
2023-03-01	AAMC-DELISTED	Stock	15.3794	16.2118	15.3794	15.9029	29679.0
2023-03-01	AAME	Stock	2.54	2.54	2.46	2.46	1000.0
2023-03-01	AAMI	Stock	25.0	25.5	24.81	25.18	175000.0
2023-03-01	AAN-DELISTED	Stock	14.23	14.535	14.15	14.4	250700.0
2023-03-01	AAOI	Stock	2.77	2.9	2.73	2.73	143600.0
2023-03-01	AAON	Stock	60.4667	61.0667	59.8933	60.38	566400.0
2023-03-01	AAP	Stock	143.3	143.96	137.0	138.82	2601600.0
2023-03-01	AAT	Stock	25.05	25.09	24.61	25.09	242100.0
2023-03-01	AATC	Stock	4.3	4.325	4.3	4.315	4542.0
2023-03-01	AAU-DELISTED	Stock	0.2062	0.21	0.1995	0.206	145276.0
2023-03-01	AAUAF-DELISTED	Stock	0.2062	0.21	0.1995	0.206	147753.0
2023-03-01	AAWW-DELISTED	Stock	100.61	100.91	99.525	100.69	849591.0
2023-03-01	AAXJ	Stock	67.25	67.28	66.785	66.87	1608319.0
2023-03-01	AB	Stock	38.7	39.25	38.34	38.94	221900.0
2023-03-01	ABB-DELISTED	Stock	33.68	33.85	33.41	33.56	1075138.0
2023-03-01	ABBNY-DELISTED	Stock	33.68	33.85	33.41	33.56	1199238.0
2023-03-01	ABBV	Stock	152.76	155.58	152.37	155.27	5485800.0
2023-03-01	ABC-DELISTED	Stock	155.07	156.865	154.52	156.62	715737.0
2023-03-01	ABCB	Stock	47.6	48.13	47.43	47.74	265000.0
2023-03-01	ABCL	Stock	8.4	8.48	8.1	8.15	1339200.0
2023-03-01	ABCM-DELISTED	Stock	14.16	14.57	14.05	14.55	543650.0
2023-03-01	ABEO	Stock	2.26	2.34	2.21	2.28	49500.0
2023-03-01	ABEV	Stock	2.58	2.59	2.54	2.58	15423700.0
2023-03-01	ABG	Stock	225.54	233.12	225.5	232.85	205700.0
2023-03-01	ABM	Stock	48.22	48.57	47.86	48.33	316000.0
2023-03-01	ABNB	Stock	122.375	123.3	120.39	120.83	4645000.0
2023-03-01	ABOS	Stock	5.29	5.325	5.08	5.24	37500.0
2023-03-01	ABR	Stock	15.07	15.1	14.79	14.99	3320400.0
2023-03-01	ABR.D	Stock	19.64	19.6408	19.01	19.16	17986.0
2023-03-01	ABR.E	Stock	18.81	19.11	18.8	19.0	11150.0

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

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