PREVIEW / stock_daily / 2023-08-03

all stock daily files

  file:    by_date/stock_daily/2023/2023-08-03.parquet
  size:    241 KB
  rows:    7,504
  symbols: 1,516

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-03	AAPL	Stock	191.57	192.37	190.69	191.17	61235200.0
2023-08-03	MSFT	Stock	326.0	329.88	325.95	326.66	18253700.0
2023-08-03	NVDA	Stock	43.8	45.118	43.8	44.515	324176000.0
2023-08-03	AMZN	Stock	127.48	129.84	126.41	128.91	88585200.0
2023-08-03	GOOGL	Stock	127.97	129.385	127.42	128.45	20159528.0
2023-08-03	META	Stock	309.93	315.95	309.93	313.19	15180200.0
2023-08-03	TSLA	Stock	252.04	260.49	252.0	259.32	97569100.0
2023-08-03	TLT	Stock	95.19	95.32	94.535	94.85	59449684.0
2023-08-03	ES	Stock	69.47	69.47	68.02	68.12	1818800.0
2023-08-03	CL	Stock	77.32	77.37	76.22	76.58	4935300.0
2023-08-03	A	Stock	127.3	127.36	124.97	125.05	1742600.0
2023-08-03	AA	Stock	34.0	34.69	33.51	34.5	4243300.0
2023-08-03	AAC-DELISTED	Stock	10.63	10.65	10.63	10.65	49531.0
2023-08-03	AACG	Stock	1.33	1.35	1.32	1.32	3300.0
2023-08-03	AACIW-DELISTED	Stock	0.0565	0.0567	0.056	0.056	6184.0
2023-08-03	AACT	Stock	10.18	10.18	10.18	10.18	200000.0
2023-08-03	AAIC-DELISTED	Stock	4.51	4.53	4.44	4.44	260325.0
2023-08-03	AAIC.C-DELISTED	Stock	23.4001	23.4475	23.4	23.4	2092.0
2023-08-03	AAL	Stock	15.77	16.02	15.7	15.98	40463900.0
2023-08-03	AAM.A-DELISTED	Stock	23.65	23.7382	23.5304	23.6555	6194.0
2023-08-03	AAM.B-DELISTED	Stock	24.25	24.64	23.1399	24.2546	10729.0
2023-08-03	AAMC-DELISTED	Stock	25.5294	25.5294	23.8235	23.8824	29920.0
2023-08-03	AAME	Stock	1.79	1.85	1.76	1.81	9600.0
2023-08-03	AAMI	Stock	20.44	20.66	19.52	20.01	256000.0
2023-08-03	AAN-DELISTED	Stock	14.12	14.19	13.04	13.15	294300.0
2023-08-03	AAOI	Stock	7.63	8.12	6.5	6.59	4415400.0
2023-08-03	AAON	Stock	70.08	70.5267	68.02	69.42	1045650.0
2023-08-03	AAP	Stock	70.13	72.05	69.06	72.03	2782400.0
2023-08-03	AAT	Stock	22.16	22.37	21.89	22.31	294900.0
2023-08-03	AATC	Stock	4.64	4.64	4.6	4.6	339.0
2023-08-03	AAU-DELISTED	Stock	0.151	0.151	0.145	0.147	139119.0
2023-08-03	AAUAF-DELISTED	Stock	0.151	0.151	0.145	0.147	140290.0
2023-08-03	AAXJ	Stock	68.11	68.67	68.09	68.43	405567.0
2023-08-03	AB	Stock	32.35	32.61	32.2	32.45	196500.0
2023-08-03	ABBNY-DELISTED	Stock	38.77	39.22	38.75	39.05	173358.0
2023-08-03	ABBV	Stock	148.96	149.36	148.18	149.05	4674300.0
2023-08-03	ABC-DELISTED	Stock	192.5	194.37	190.71	191.18	829414.0
2023-08-03	ABCB	Stock	43.65	44.48	43.33	44.36	418200.0
2023-08-03	ABCL	Stock	6.93	7.1	6.82	6.97	3297500.0
2023-08-03	ABCM-DELISTED	Stock	23.05	23.05	22.54	22.86	1009756.0
2023-08-03	ABEO	Stock	3.17	3.23	3.12	3.17	71800.0
2023-08-03	ABEV	Stock	3.08	3.11	2.94	2.95	23072200.0
2023-08-03	ABG	Stock	225.72	225.72	221.98	224.43	171300.0
2023-08-03	ABLLW	Stock	0.23575	0.2395	0.22	0.22	9550.0
2023-08-03	ABLV	Stock	6.75	8.84	6.215	8.7	61257.0
2023-08-03	ABM	Stock	45.75	45.75	45.07	45.42	268000.0
2023-08-03	ABNB	Stock	140.94	143.103	139.75	140.88	11441200.0
2023-08-03	ABOS	Stock	7.06	7.24	6.93	7.105	270900.0
2023-08-03	ABR	Stock	16.34	16.52	16.17	16.48	2635300.0
2023-08-03	ABR.D	Stock	18.75	19.0	18.75	19.0	4967.0

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

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