PREVIEW / stock_daily / 2023-11-03

all stock daily files

  file:    by_date/stock_daily/2023/2023-11-03.parquet
  size:    235 KB
  rows:    7,387
  symbols: 1,336

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-11-03	AAPL	Stock	174.24	176.82	173.35	176.65	79763700.0
2023-11-03	MSFT	Stock	349.63	354.39	347.33	352.8	23624000.0
2023-11-03	NVDA	Stock	44.02	45.309	43.723	45.005	424610000.0
2023-11-03	AMZN	Stock	138.99	139.49	137.45	138.6	44007200.0
2023-11-03	GOOGL	Stock	128.02	129.525	127.86	129.1	26393109.0
2023-11-03	META	Stock	312.55	315.55	311.02	314.6	16754100.0
2023-11-03	TSLA	Stock	221.15	226.37	218.4	219.96	119281000.0
2023-11-03	TLT	Stock	88.81	89.05	87.575	87.63	77692250.0
2023-11-03	ES	Stock	55.39	56.31	54.93	55.43	4049300.0
2023-11-03	CL	Stock	74.88	75.35	74.57	74.82	4362500.0
2023-11-03	A	Stock	106.5	109.59	106.12	109.02	2511300.0
2023-11-03	AA	Stock	26.5	27.005	26.14	26.53	5478000.0
2023-11-03	AAC-DELISTED	Stock	10.77	10.78	10.77	10.77	279314.0
2023-11-03	AACG	Stock	1.06	1.06	0.9	0.99	9600.0
2023-11-03	AACIW-DELISTED	Stock	0.087	0.087	0.087	0.087	100.0
2023-11-03	AACT	Stock	10.31	10.33	10.31	10.32	707900.0
2023-11-03	AAIC-DELISTED	Stock	4.42	4.54	4.42	4.51	146176.0
2023-11-03	AAIC.C-DELISTED	Stock	23.883	23.95	23.883	23.95	3301.0
2023-11-03	AAL	Stock	11.63	12.08	11.62	11.98	52897300.0
2023-11-03	AAMC-DELISTED	Stock	3.61	4.0	3.545	3.68	22200.0
2023-11-03	AAME	Stock	1.86	1.9	1.75	1.88	2400.0
2023-11-03	AAMI	Stock	15.88	17.09	15.34	16.73	468900.0
2023-11-03	AAN-DELISTED	Stock	7.44	7.63	7.4	7.47	239600.0
2023-11-03	AAOI	Stock	8.7	9.64	8.49	9.47	2519300.0
2023-11-03	AAON	Stock	58.19	59.1	57.83	57.87	264900.0
2023-11-03	AAP	Stock	54.01	57.25	53.5	57.14	2593000.0
2023-11-03	AAT	Stock	19.54	19.96	19.38	19.95	320600.0
2023-11-03	AATC	Stock	5.41	5.69	5.4	5.69	11657.0
2023-11-03	AAU-DELISTED	Stock	0.1354	0.1374	0.135	0.137	165667.0
2023-11-03	AAUAF-DELISTED	Stock	0.1354	0.1374	0.135	0.137	168298.0
2023-11-03	AAXJ	Stock	63.78	64.305	63.7	64.24	1722730.0
2023-11-03	AB	Stock	29.0	29.08	28.34	28.4	392500.0
2023-11-03	ABAT	Stock	4.59	4.7836	4.3	4.59	280240.0
2023-11-03	ABBNY-DELISTED	Stock	34.74	34.89	34.57	34.61	190307.0
2023-11-03	ABBV	Stock	143.95	143.95	140.89	141.42	5414500.0
2023-11-03	ABCB	Stock	41.8	42.59	41.75	41.84	353300.0
2023-11-03	ABCL	Stock	3.97	4.78	3.9	4.7	3552200.0
2023-11-03	ABCM-DELISTED	Stock	23.15	23.25	23.1	23.22	1349635.0
2023-11-03	ABEO	Stock	3.96	4.49	3.94	4.49	130900.0
2023-11-03	ABEV	Stock	2.67	2.72	2.65	2.7	23938400.0
2023-11-03	ABG	Stock	205.53	213.83	205.53	210.02	163400.0
2023-11-03	ABLLW	Stock	0.3299	0.33	0.2825	0.3299	2972.0
2023-11-03	ABLV	Stock	1.86	2.05	1.86	1.97	9000.0
2023-11-03	ABM	Stock	40.61	41.12	40.52	40.86	404300.0
2023-11-03	ABNB	Stock	117.98	123.45	117.38	122.64	9015200.0
2023-11-03	ABOS	Stock	2.01	2.3	2.0	2.19	769000.0
2023-11-03	ABR	Stock	13.62	14.11	12.86	12.89	7264600.0
2023-11-03	ABR.D	Stock	16.32	16.49	16.1101	16.23	39835.0
2023-11-03	ABR.E	Stock	16.46	16.633	16.22	16.28	11059.0
2023-11-03	ABR.F	Stock	17.92	18.03	17.62	17.62	13266.0

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

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