PREVIEW / stock_daily / 2023-11-02

all stock daily files

  file:    by_date/stock_daily/2023/2023-11-02.parquet
  size:    234 KB
  rows:    7,378
  symbols: 1,340

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-02	AAPL	Stock	175.52	177.78	175.46	177.57	77334800.0
2023-11-02	MSFT	Stock	347.24	348.83	344.77	348.32	24348100.0
2023-11-02	NVDA	Stock	43.328	43.884	42.894	43.506	409172000.0
2023-11-02	AMZN	Stock	138.73	138.81	136.47	138.07	52236700.0
2023-11-02	GOOGL	Stock	128.42	128.98	126.93	127.49	27124647.0
2023-11-02	META	Stock	317.3	318.82	308.33	310.87	21631800.0
2023-11-02	TSLA	Stock	212.97	219.2	211.45	218.51	125987600.0
2023-11-02	TLT	Stock	86.675	87.31	86.22	87.04	69739356.0
2023-11-02	ES	Stock	53.51	54.64	53.45	54.28	2797400.0
2023-11-02	CL	Stock	74.71	75.05	74.22	74.8	5624700.0
2023-11-02	A	Stock	103.97	104.64	102.7	104.47	1489000.0
2023-11-02	AA	Stock	25.5	26.142	25.295	26.07	5825300.0
2023-11-02	AAC-DELISTED	Stock	10.78	10.78	10.77	10.77	58875.0
2023-11-02	AACG	Stock	1.05	1.06	0.88	0.95	5100.0
2023-11-02	AACT	Stock	10.31	10.32	10.3	10.32	204300.0
2023-11-02	AAIC-DELISTED	Stock	4.26	4.38	4.26	4.37	67018.0
2023-11-02	AAIC.C-DELISTED	Stock	23.8	23.9	23.8	23.8	1414.0
2023-11-02	AAL	Stock	11.35	11.47	11.28	11.4	29763600.0
2023-11-02	AAMC-DELISTED	Stock	3.58	3.6	3.5	3.51	26300.0
2023-11-02	AAME	Stock	1.78	1.82	1.77	1.82	1100.0
2023-11-02	AAMI	Stock	16.79	16.79	15.225	15.68	450900.0
2023-11-02	AAN-DELISTED	Stock	7.2	7.43	7.1	7.28	332200.0
2023-11-02	AAOI	Stock	8.0	8.62	7.9	8.57	1802300.0
2023-11-02	AAON	Stock	57.41	58.18	56.17	56.82	368300.0
2023-11-02	AAP	Stock	52.09	53.2	51.76	52.94	1236200.0
2023-11-02	AAT	Stock	18.31	19.08	18.23	19.05	444700.0
2023-11-02	AATC	Stock	5.5375	5.5375	5.31	5.45	4589.0
2023-11-02	AAU-DELISTED	Stock	0.1372	0.1381	0.135	0.1351	121021.0
2023-11-02	AAUAF-DELISTED	Stock	0.1372	0.1381	0.135	0.1351	127227.0
2023-11-02	AAXJ	Stock	62.67	62.84	62.52	62.79	723186.0
2023-11-02	AB	Stock	28.74	29.14	28.56	28.89	521000.0
2023-11-02	ABAT	Stock	4.27	4.61	4.0563	4.59	342243.0
2023-11-02	ABBNY-DELISTED	Stock	34.35	34.475	34.05	34.27	243059.0
2023-11-02	ABBV	Stock	141.31	143.77	140.51	143.26	4066800.0
2023-11-02	ABCB	Stock	38.75	40.69	38.75	40.48	449600.0
2023-11-02	ABCL	Stock	4.18	4.45	4.16	4.43	1956500.0
2023-11-02	ABCM-DELISTED	Stock	23.15	23.2	23.12	23.14	1229354.0
2023-11-02	ABEO	Stock	3.88	3.97	3.77	3.96	28900.0
2023-11-02	ABEV	Stock	2.6	2.63	2.59	2.61	7193900.0
2023-11-02	ABG	Stock	199.67	201.79	198.7	201.77	159800.0
2023-11-02	ABLLW	Stock	0.301	0.33	0.2747	0.3299	2925.0
2023-11-02	ABLV	Stock	2.09	2.2	2.0	2.0	30200.0
2023-11-02	ABM	Stock	39.79	40.11	39.46	40.1	387300.0
2023-11-02	ABNB	Stock	122.51	122.74	114.1	115.5	14053500.0
2023-11-02	ABOS	Stock	1.94	2.05	1.875	1.96	1103200.0
2023-11-02	ABR	Stock	12.79	13.33	12.66	13.32	6546300.0
2023-11-02	ABR.D	Stock	16.29	16.3	16.01	16.17	108360.0
2023-11-02	ABR.E	Stock	16.36	16.6	16.2	16.37	21658.0
2023-11-02	ABR.F	Stock	17.9453	17.95	17.72	17.73	16188.0
2023-11-02	ABSI	Stock	1.26	1.32	1.25	1.32	269800.0

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

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