PREVIEW / stock_daily / 2023-10-31

all stock daily files

  file:    by_date/stock_daily/2023/2023-10-31.parquet
  size:    233 KB
  rows:    7,358
  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-10-31	AAPL	Stock	169.35	170.9	167.9	170.77	44846000.0
2023-10-31	MSFT	Stock	338.85	339.0	334.69	338.11	20265300.0
2023-10-31	NVDA	Stock	40.45	40.879	39.23	40.78	517969000.0
2023-10-31	AMZN	Stock	132.75	133.57	131.71	133.09	51589400.0
2023-10-31	GOOGL	Stock	125.06	125.37	122.685	124.08	26292342.0
2023-10-31	META	Stock	303.31	303.68	296.86	301.27	19434200.0
2023-10-31	TSLA	Stock	196.12	202.8	194.07	200.84	118068300.0
2023-10-31	TLT	Stock	84.365	84.77	83.55	83.58	37269235.0
2023-10-31	ES	Stock	53.66	54.09	53.04	53.79	2919700.0
2023-10-31	CL	Stock	74.22	75.28	73.97	75.12	7591100.0
2023-10-31	A	Stock	103.0	104.2	101.94	103.37	2218800.0
2023-10-31	AA	Stock	25.28	25.89	24.84	25.64	5156500.0
2023-10-31	AAC-DELISTED	Stock	10.78	10.8	10.63	10.77	1400503.0
2023-10-31	AACG	Stock	0.93	1.01	0.93	0.97	2300.0
2023-10-31	AACT	Stock	10.29	10.3	10.29	10.3	104900.0
2023-10-31	AAIC-DELISTED	Stock	4.06	4.2	4.06	4.16	38495.0
2023-10-31	AAIC.C-DELISTED	Stock	23.61	23.65	23.61	23.65	838.0
2023-10-31	AAL	Stock	11.11	11.16	10.86	11.15	42086200.0
2023-10-31	AAMC-DELISTED	Stock	3.6471	3.6471	3.5294	3.6059	36550.0
2023-10-31	AAME	Stock	1.69	1.81	1.69	1.72	12200.0
2023-10-31	AAMI	Stock	15.86	15.875	15.45	15.66	198500.0
2023-10-31	AAN-DELISTED	Stock	7.37	7.49	7.27	7.41	281100.0
2023-10-31	AAOI	Stock	7.13	7.455	6.98	7.43	724600.0
2023-10-31	AAON	Stock	54.4	54.88	54.19	54.48	274000.0
2023-10-31	AAP	Stock	51.47	52.73	50.92	52.03	1292000.0
2023-10-31	AAT	Stock	18.04	18.15	17.65	17.75	694500.0
2023-10-31	AATC	Stock	5.24	5.5	5.24	5.35	5484.0
2023-10-31	AAU-DELISTED	Stock	0.14	0.14	0.135	0.1351	170476.0
2023-10-31	AAUAF-DELISTED	Stock	0.14	0.14	0.135	0.1351	170470.0
2023-10-31	AAXJ	Stock	61.29	61.43	60.9164	61.41	520642.0
2023-10-31	AB	Stock	28.75	29.0	28.44	28.73	476500.0
2023-10-31	ABAT	Stock	5.5	5.5	4.795	4.86	483794.0
2023-10-31	ABBNY-DELISTED	Stock	33.5	33.64	33.42	33.51	779136.0
2023-10-31	ABBV	Stock	142.09	142.22	139.68	141.18	10394000.0
2023-10-31	ABCB	Stock	37.02	37.53	36.81	37.3	483600.0
2023-10-31	ABCL	Stock	4.03	4.23	4.03	4.11	983900.0
2023-10-31	ABCM-DELISTED	Stock	22.92	22.975	22.79	22.925	2264917.0
2023-10-31	ABEO	Stock	3.8	3.99	3.73	3.82	66200.0
2023-10-31	ABEV	Stock	2.52	2.53	2.48	2.53	15994200.0
2023-10-31	ABG	Stock	192.04	193.73	189.25	191.37	167000.0
2023-10-31	ABLLW	Stock	0.28	0.32	0.28	0.31	7368.0
2023-10-31	ABLV	Stock	1.76	2.1	1.76	1.98	6300.0
2023-10-31	ABLVW	Stock	0.0256	0.0256	0.02	0.02	75018.0
2023-10-31	ABM	Stock	39.47	39.47	38.91	39.34	573600.0
2023-10-31	ABNB	Stock	117.13	118.69	114.91	118.29	4647400.0
2023-10-31	ABOS	Stock	2.16	2.215	1.84	1.87	1958500.0
2023-10-31	ABR	Stock	12.5	12.82	12.23	12.61	5740000.0
2023-10-31	ABR.D	Stock	16.23	16.34	16.05	16.05	34802.0
2023-10-31	ABR.E	Stock	16.2	16.3885	16.02	16.12	9863.0
2023-10-31	ABR.F	Stock	17.75	17.75	17.32	17.47	23315.0

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

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