PREVIEW / stock_daily / 2023-08-01

all stock daily files

  file:    by_date/stock_daily/2023/2023-08-01.parquet
  size:    242 KB
  rows:    7,502
  symbols: 1,534

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-01	AAPL	Stock	196.24	196.73	195.28	195.61	35175100.0
2023-08-01	MSFT	Stock	335.19	338.54	333.7	336.34	18311900.0
2023-08-01	NVDA	Stock	46.46	46.9	46.027	46.507	237858000.0
2023-08-01	AMZN	Stock	133.55	133.69	131.62	131.69	42098500.0
2023-08-01	GOOGL	Stock	130.775	132.63	130.68	131.55	23276440.0
2023-08-01	META	Stock	317.54	324.14	314.66	322.71	22817900.0
2023-08-01	TSLA	Stock	266.26	266.47	260.25	261.07	83166000.0
2023-08-01	TLT	Stock	98.84	98.915	97.9	98.14	34985340.0
2023-08-01	ES	Stock	71.96	72.33	70.15	70.35	4156000.0
2023-08-01	CL	Stock	76.12	77.1	76.12	76.64	4721400.0
2023-08-01	A	Stock	121.78	123.58	120.46	122.48	1655000.0
2023-08-01	AA	Stock	35.48	35.66	35.1	35.18	5217800.0
2023-08-01	AAC-DELISTED	Stock	10.65	10.65	10.62	10.65	33238.0
2023-08-01	AACG	Stock	1.36	1.39	1.3	1.39	3000.0
2023-08-01	AACIW-DELISTED	Stock	0.0641	0.0641	0.0612	0.0612	469.0
2023-08-01	AACT	Stock	10.2	10.22	10.17	10.18	21900.0
2023-08-01	AAIC-DELISTED	Stock	4.6	4.65	4.545	4.57	389887.0
2023-08-01	AAL	Stock	16.54	16.54	15.94	16.23	31342400.0
2023-08-01	AAM.A-DELISTED	Stock	23.89	23.97	23.84	23.943	8163.0
2023-08-01	AAM.B-DELISTED	Stock	24.59	24.85	24.1901	24.6774	12434.0
2023-08-01	AAMC-DELISTED	Stock	26.1524	26.1524	23.6176	24.3176	23290.0
2023-08-01	AAME	Stock	1.83	1.83	1.77	1.77	13000.0
2023-08-01	AAMI	Stock	21.24	21.54	21.12	21.52	173500.0
2023-08-01	AAN-DELISTED	Stock	14.29	14.9	13.22	14.38	702300.0
2023-08-01	AAOI	Stock	6.76	7.1	6.48	7.03	1742000.0
2023-08-01	AAON	Stock	69.8733	71.38	69.32	70.9867	649500.0
2023-08-01	AAP	Stock	73.92	74.25	72.93	73.72	1583400.0
2023-08-01	AAT	Stock	22.52	22.52	21.82	22.2	471900.0
2023-08-01	AATC	Stock	4.71	4.71	4.69	4.69	3801.0
2023-08-01	AAU-DELISTED	Stock	0.1616	0.1616	0.15	0.15	161628.0
2023-08-01	AAUAF-DELISTED	Stock	0.1616	0.1616	0.15	0.15	161417.0
2023-08-01	AAXJ	Stock	69.95	69.97	69.55	69.7	614293.0
2023-08-01	AB	Stock	32.4	33.11	32.35	33.08	254000.0
2023-08-01	ABBNY-DELISTED	Stock	39.57	39.77	38.8077	39.67	346358.0
2023-08-01	ABBV	Stock	150.0	150.87	147.84	148.54	4409600.0
2023-08-01	ABC-DELISTED	Stock	187.51	189.325	186.88	188.95	967654.0
2023-08-01	ABCB	Stock	43.42	44.01	42.74	43.65	386000.0
2023-08-01	ABCL	Stock	7.73	7.73	7.25	7.27	1735300.0
2023-08-01	ABCM-DELISTED	Stock	23.5	23.51	22.94	23.19	987085.0
2023-08-01	ABEO	Stock	3.43	3.45	3.26	3.31	105200.0
2023-08-01	ABEV	Stock	3.06	3.11	3.05	3.1	16885500.0
2023-08-01	ABG	Stock	221.85	226.97	218.41	225.46	139800.0
2023-08-01	ABLLW	Stock	0.22	0.2625	0.22	0.2411	8630.0
2023-08-01	ABLV	Stock	11.83	11.83	10.0901	10.1501	25983.0
2023-08-01	ABM	Stock	46.33	46.43	44.84	45.37	480000.0
2023-08-01	ABNB	Stock	149.62	150.42	148.03	148.91	4519600.0
2023-08-01	ABOS	Stock	7.28	7.47	7.1	7.26	440800.0
2023-08-01	ABR	Stock	16.95	16.96	16.33	16.36	4055700.0
2023-08-01	ABR.D	Stock	18.99	19.1	18.8	18.96	13650.0
2023-08-01	ABR.E	Stock	18.78	19.5299	18.75	18.92	10978.0

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

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