PREVIEW / stock_daily / 2023-07-31

all stock daily files

  file:    by_date/stock_daily/2023/2023-07-31.parquet
  size:    242 KB
  rows:    7,542
  symbols: 1,570

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-07-31	AAPL	Stock	196.06	196.49	195.26	196.45	38824100.0
2023-07-31	MSFT	Stock	336.92	337.7	333.36	335.92	25446000.0
2023-07-31	NVDA	Stock	46.754	47.13	46.506	46.729	251055000.0
2023-07-31	AMZN	Stock	133.2	133.87	132.38	133.68	41901500.0
2023-07-31	GOOGL	Stock	132.73	133.525	131.775	132.72	28055531.0
2023-07-31	META	Stock	323.69	325.66	317.59	318.6	25799600.0
2023-07-31	TSLA	Stock	267.48	269.08	263.78	267.43	84582200.0
2023-07-31	TLT	Stock	99.65	100.33	99.62	100.05	28665164.0
2023-07-31	ES	Stock	72.73	72.93	71.93	72.33	7162200.0
2023-07-31	CL	Stock	75.66	76.51	75.42	76.26	8106100.0
2023-07-31	A	Stock	124.38	124.45	121.22	121.77	2376100.0
2023-07-31	AA	Stock	35.45	36.585	35.31	36.19	6037300.0
2023-07-31	AAC-DELISTED	Stock	10.61	10.64	10.6	10.64	34123.0
2023-07-31	AACG	Stock	1.29	1.39	1.29	1.33	17000.0
2023-07-31	AACIW-DELISTED	Stock	0.0682	0.0682	0.064	0.064	1800.0
2023-07-31	AACT	Stock	10.17	10.19	10.17	10.19	3800.0
2023-07-31	AAIC-DELISTED	Stock	4.68	4.69	4.59	4.625	154806.0
2023-07-31	AAL	Stock	16.85	16.87	16.59	16.75	21646200.0
2023-07-31	AAM.A-DELISTED	Stock	23.2	23.97	23.2	23.97	35607.0
2023-07-31	AAM.B-DELISTED	Stock	24.0	24.93	23.5	24.75	61175.0
2023-07-31	AAMC-DELISTED	Stock	27.9412	28.3882	25.3412	25.3412	28730.0
2023-07-31	AAME	Stock	1.88	1.88	1.83	1.83	500.0
2023-07-31	AAMI	Stock	21.54	21.605	21.245	21.28	438700.0
2023-07-31	AAN-DELISTED	Stock	15.5	15.933	15.5	15.82	431500.0
2023-07-31	AAOI	Stock	6.73	6.78	5.86	6.75	2401300.0
2023-07-31	AAON	Stock	68.9067	70.56	68.14	70.1733	715800.0
2023-07-31	AAP	Stock	73.57	74.7	73.55	74.39	1720100.0
2023-07-31	AAT	Stock	22.36	22.61	22.29	22.5	301600.0
2023-07-31	AATC	Stock	4.71	4.71	4.695	4.695	474.0
2023-07-31	AAU-DELISTED	Stock	0.1548	0.1582	0.1505	0.1568	108496.0
2023-07-31	AAUAF-DELISTED	Stock	0.1548	0.1582	0.1505	0.1568	111915.0
2023-07-31	AAXJ	Stock	70.13	70.63	70.13	70.53	1555135.0
2023-07-31	AB	Stock	32.18	33.18	32.08	32.19	304200.0
2023-07-31	ABBNY-DELISTED	Stock	40.16	40.31	39.91	40.0	126175.0
2023-07-31	ABBV	Stock	150.43	150.5	147.62	149.58	9109200.0
2023-07-31	ABC-DELISTED	Stock	187.53	187.53	184.04	186.87	998227.0
2023-07-31	ABCB	Stock	43.37	44.74	43.1	43.65	817800.0
2023-07-31	ABCL	Stock	7.75	7.85	7.59	7.73	1344300.0
2023-07-31	ABCM-DELISTED	Stock	23.53	23.59	23.16	23.45	531608.0
2023-07-31	ABEO	Stock	3.59	3.69	3.34	3.42	302500.0
2023-07-31	ABEV	Stock	3.15	3.16	3.09	3.12	17738100.0
2023-07-31	ABG	Stock	220.61	226.92	219.18	225.6	217900.0
2023-07-31	ABLLW	Stock	0.257	0.2899	0.235	0.235	44140.0
2023-07-31	ABLV	Stock	10.5	13.265	10.2326	12.31	42125.0
2023-07-31	ABM	Stock	45.34	46.54	45.26	46.28	4470700.0
2023-07-31	ABNB	Stock	153.86	154.95	151.55	152.19	4457300.0
2023-07-31	ABOS	Stock	7.45	7.53	7.28	7.4	525600.0
2023-07-31	ABR	Stock	17.16	17.35	16.58	16.91	7638300.0
2023-07-31	ABR.D	Stock	19.17	19.17	18.98	19.05	14824.0
2023-07-31	ABR.E	Stock	19.43	19.43	18.65	19.03	24311.0

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

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