PREVIEW / stock_daily / 2023-08-10

all stock daily files

  file:    by_date/stock_daily/2023/2023-08-10.parquet
  size:    240 KB
  rows:    7,437
  symbols: 1,499

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-08-10	AAPL	Stock	179.48	180.75	177.6	177.97	54686900.0
2023-08-10	MSFT	Stock	326.02	328.26	321.18	322.93	20113700.0
2023-08-10	NVDA	Stock	42.16	43.574	41.835	42.388	492705000.0
2023-08-10	AMZN	Stock	139.07	140.41	137.49	138.56	58928400.0
2023-08-10	GOOGL	Stock	131.32	132.05	129.45	129.69	20857754.0
2023-08-10	META	Stock	307.94	312.34	303.87	305.74	14358900.0
2023-08-10	TSLA	Stock	245.4	251.8	243.0	245.34	109498600.0
2023-08-10	TLT	Stock	97.04	97.355	95.59	95.59	37253246.0
2023-08-10	ES	Stock	67.58	68.11	66.24	66.34	2635600.0
2023-08-10	CL	Stock	76.66	77.19	76.12	76.28	2552400.0
2023-08-10	A	Stock	128.0	129.99	127.31	127.65	1515900.0
2023-08-10	AA	Stock	33.97	34.0	32.55	32.88	4810900.0
2023-08-10	AAC-DELISTED	Stock	10.65	10.65	10.63	10.63	17411.0
2023-08-10	AACG	Stock	1.26	1.31	1.25	1.25	7700.0
2023-08-10	AACIW-DELISTED	Stock	0.07	0.1	0.069	0.1	3549.0
2023-08-10	AACT	Stock	10.21	10.21	10.19	10.2	33300.0
2023-08-10	AAIC-DELISTED	Stock	4.52	4.55	4.48	4.51	35859.0
2023-08-10	AAIC.C-DELISTED	Stock	23.5	23.5	23.4	23.5	1299.0
2023-08-10	AAL	Stock	15.93	16.02	15.65	15.76	19104200.0
2023-08-10	AAM.A-DELISTED	Stock	24.05	24.4603	24.05	24.21	6491.0
2023-08-10	AAM.B-DELISTED	Stock	24.2	24.945	24.2	24.505	5699.0
2023-08-10	AAMC-DELISTED	Stock	22.3529	22.5265	21.0412	21.1765	45220.0
2023-08-10	AAME	Stock	1.78	1.78	1.72	1.77	2200.0
2023-08-10	AAMI	Stock	20.21	20.355	20.01	20.04	201000.0
2023-08-10	AAN-DELISTED	Stock	13.66	13.93	13.1	13.21	261100.0
2023-08-10	AAOI	Stock	12.04	14.77	11.35	14.44	8934200.0
2023-08-10	AAON	Stock	63.3333	63.6267	62.1133	62.9	248550.0
2023-08-10	AAP	Stock	71.56	73.06	71.06	71.53	1750700.0
2023-08-10	AAT	Stock	22.41	22.67	22.07	22.19	302600.0
2023-08-10	AATC	Stock	4.55	4.55	4.46	4.46	1583.0
2023-08-10	AAU-DELISTED	Stock	0.13	0.138	0.125	0.133	235241.0
2023-08-10	AAUAF-DELISTED	Stock	0.13	0.138	0.125	0.133	233949.0
2023-08-10	AAXJ	Stock	67.71	68.365	67.35	67.49	814280.0
2023-08-10	AB	Stock	29.85	30.11	29.4	29.41	394900.0
2023-08-10	ABBNY-DELISTED	Stock	38.6	38.8	38.18	38.25	197186.0
2023-08-10	ABBV	Stock	151.2	152.84	150.57	151.44	3275800.0
2023-08-10	ABC-DELISTED	Stock	185.41	188.83	185.015	187.02	2163106.0
2023-08-10	ABCB	Stock	43.94	44.52	43.31	43.58	278700.0
2023-08-10	ABCL	Stock	6.05	6.14	5.855	5.88	1689000.0
2023-08-10	ABCM-DELISTED	Stock	22.24	22.52	22.1	22.5	741295.0
2023-08-10	ABEO	Stock	3.0	3.05	2.93	2.99	57900.0
2023-08-10	ABEV	Stock	2.95	2.98	2.91	2.92	6822300.0
2023-08-10	ABG	Stock	224.4	226.63	219.89	221.45	138400.0
2023-08-10	ABLLW	Stock	0.2	0.222	0.2	0.222	16506.0
2023-08-10	ABLV	Stock	9.0	9.25	8.62	8.84	15071.0
2023-08-10	ABM	Stock	46.66	46.95	45.68	46.1	310500.0
2023-08-10	ABNB	Stock	139.87	140.97	135.65	135.97	3437600.0
2023-08-10	ABOS	Stock	6.8	7.19	6.66	7.04	437900.0
2023-08-10	ABR	Stock	16.67	16.77	16.36	16.59	2095900.0
2023-08-10	ABR.D	Stock	18.7	19.15	18.7	18.8	6147.0

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

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