PREVIEW / stock_daily / 2023-08-02

all stock daily files

  file:    by_date/stock_daily/2023/2023-08-02.parquet
  size:    240 KB
  rows:    7,455
  symbols: 1,511

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-02	AAPL	Stock	195.04	195.18	191.85	192.58	50389300.0
2023-08-02	MSFT	Stock	333.63	333.63	326.36	327.5	27761300.0
2023-08-02	NVDA	Stock	45.831	45.84	43.387	44.269	530142000.0
2023-08-02	AMZN	Stock	130.15	130.23	126.82	128.21	51027600.0
2023-08-02	GOOGL	Stock	129.45	130.09	127.56	128.38	26273258.0
2023-08-02	META	Stock	318.0	318.39	310.65	314.31	20461100.0
2023-08-02	TSLA	Stock	255.57	259.52	250.49	254.11	101752900.0
2023-08-02	TLT	Stock	97.04	97.235	96.41	97.09	38121255.0
2023-08-02	ES	Stock	70.36	70.49	69.53	69.8	2130600.0
2023-08-02	CL	Stock	76.64	77.85	76.51	77.54	4275700.0
2023-08-02	A	Stock	122.0	128.73	121.51	127.71	2654700.0
2023-08-02	AA	Stock	34.425	34.685	33.66	33.93	5290200.0
2023-08-02	AAC-DELISTED	Stock	10.64	10.645	10.62	10.63	25027.0
2023-08-02	AACG	Stock	1.34	1.36	1.31	1.36	8500.0
2023-08-02	AACIW-DELISTED	Stock	0.0693	0.0694	0.06	0.06	9119.0
2023-08-02	AACT	Stock	10.18	10.18	10.18	10.18	29300.0
2023-08-02	AAIC-DELISTED	Stock	4.56	4.58	4.53	4.55	121978.0
2023-08-02	AAL	Stock	16.01	16.11	15.78	15.95	29884600.0
2023-08-02	AAM.A-DELISTED	Stock	23.51	23.9	23.4	23.83	18423.0
2023-08-02	AAM.B-DELISTED	Stock	24.5	24.8	24.0601	24.53	13183.0
2023-08-02	AAMC-DELISTED	Stock	24.1176	25.8176	22.9412	25.2947	42670.0
2023-08-02	AAME	Stock	1.8	1.84	1.67	1.76	12400.0
2023-08-02	AAMI	Stock	21.17	21.36	20.94	21.11	166400.0
2023-08-02	AAN-DELISTED	Stock	14.12	14.56	13.82	14.23	391800.0
2023-08-02	AAOI	Stock	6.81	7.5	6.62	7.39	2222100.0
2023-08-02	AAON	Stock	69.94	71.3933	69.7067	71.0267	428700.0
2023-08-02	AAP	Stock	72.88	73.06	69.58	69.64	2757700.0
2023-08-02	AAT	Stock	21.91	22.33	21.91	22.27	169300.0
2023-08-02	AATC	Stock	4.675	4.7	4.67	4.68	4547.0
2023-08-02	AAU-DELISTED	Stock	0.15	0.1518	0.1451	0.1462	179440.0
2023-08-02	AAUAF-DELISTED	Stock	0.15	0.1518	0.1451	0.1453	170967.0
2023-08-02	AAXJ	Stock	68.42	68.925	67.8	67.9	780120.0
2023-08-02	AB	Stock	32.86	33.1	32.18	32.6	298900.0
2023-08-02	ABBNY-DELISTED	Stock	39.3	39.6425	39.28	39.49	266183.0
2023-08-02	ABBV	Stock	148.11	150.57	148.11	149.38	5756400.0
2023-08-02	ABC-DELISTED	Stock	187.88	192.685	186.97	191.45	1190233.0
2023-08-02	ABCB	Stock	43.09	43.92	42.81	43.78	262200.0
2023-08-02	ABCL	Stock	7.13	7.197	6.83	6.94	2236500.0
2023-08-02	ABCM-DELISTED	Stock	23.07	23.47	22.7	23.0	1393152.0
2023-08-02	ABEO	Stock	3.35	3.42	3.17	3.2	108400.0
2023-08-02	ABEV	Stock	3.11	3.13	3.09	3.09	9949500.0
2023-08-02	ABG	Stock	222.5	226.75	222.5	225.17	112800.0
2023-08-02	ABLLW	Stock	0.249	0.249	0.2225	0.24	2061.0
2023-08-02	ABLV	Stock	10.02	10.21	6.13	6.96	143140.0
2023-08-02	ABM	Stock	45.14	46.1	45.0	45.55	355400.0
2023-08-02	ABNB	Stock	146.45	147.115	143.19	144.56	7026100.0
2023-08-02	ABOS	Stock	7.2	7.29	6.96	7.1	758800.0
2023-08-02	ABR	Stock	16.1	16.49	16.03	16.27	2772800.0
2023-08-02	ABR.D	Stock	18.88	18.96	18.75	18.96	11658.0
2023-08-02	ABR.E	Stock	18.71	19.18	18.64	19.0	11021.0

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

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