PREVIEW / stock_daily / 2023-08-07

all stock daily files

  file:    by_date/stock_daily/2023/2023-08-07.parquet
  size:    239 KB
  rows:    7,427
  symbols: 1,504

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-07	AAPL	Stock	182.13	183.13	177.35	178.85	97576100.0
2023-08-07	MSFT	Stock	328.37	331.11	327.52	330.11	17741500.0
2023-08-07	NVDA	Stock	45.111	45.54	44.563	45.417	322154000.0
2023-08-07	AMZN	Stock	140.99	142.54	138.95	142.22	71213100.0
2023-08-07	GOOGL	Stock	129.16	131.61	129.02	131.53	22746290.0
2023-08-07	META	Stock	313.23	317.07	310.46	316.56	16236500.0
2023-08-07	TSLA	Stock	251.45	253.65	242.76	251.45	111097900.0
2023-08-07	TLT	Stock	96.11	96.2	95.5	95.58	35862880.0
2023-08-07	ES	Stock	67.33	67.79	67.01	67.08	1536900.0
2023-08-07	CL	Stock	76.46	77.19	76.46	76.9	2469400.0
2023-08-07	A	Stock	126.73	127.89	125.7	126.51	1487000.0
2023-08-07	AA	Stock	33.9	34.06	33.22	34.06	3520600.0
2023-08-07	AAC-DELISTED	Stock	10.65	10.65	10.63	10.64	22328.0
2023-08-07	AACG	Stock	1.31	1.32	1.28	1.29	4700.0
2023-08-07	AACIU	Stock	10.5	10.5	10.5	10.5	200.0
2023-08-07	AAIC-DELISTED	Stock	4.47	4.57	4.47	4.545	167509.0
2023-08-07	AAIC.C-DELISTED	Stock	23.44	23.5	23.44	23.4998	1805.0
2023-08-07	AAL	Stock	15.73	16.01	15.69	15.99	22485700.0
2023-08-07	AAM.A-DELISTED	Stock	23.715	23.76	23.715	23.75	6384.0
2023-08-07	AAM.B-DELISTED	Stock	23.85	24.32	23.57	24.09	13820.0
2023-08-07	AAMC-DELISTED	Stock	24.3529	25.2235	24.1412	25.1471	17510.0
2023-08-07	AAME	Stock	1.92	1.92	1.86	1.86	400.0
2023-08-07	AAMI	Stock	20.58	20.69	20.32	20.48	165300.0
2023-08-07	AAN-DELISTED	Stock	13.63	13.79	13.39	13.69	240300.0
2023-08-07	AAOI	Stock	11.07	13.17	10.929	12.38	16940800.0
2023-08-07	AAON	Stock	65.4	65.96	62.7333	62.9667	758550.0
2023-08-07	AAP	Stock	71.1	71.8	70.28	71.3	1634300.0
2023-08-07	AAT	Stock	22.5	22.97	22.38	22.96	321000.0
2023-08-07	AATC	Stock	4.78	4.78	4.78	4.78	142.0
2023-08-07	AAU-DELISTED	Stock	0.15	0.15	0.145	0.1454	154257.0
2023-08-07	AAUAF-DELISTED	Stock	0.15	0.15	0.145	0.1454	156647.0
2023-08-07	AAXJ	Stock	68.41	68.41	67.86	68.12	421145.0
2023-08-07	AB	Stock	31.65	31.75	30.86	31.04	353300.0
2023-08-07	ABBNY-DELISTED	Stock	39.21	39.5725	39.165	39.51	134737.0
2023-08-07	ABBV	Stock	148.0	150.88	147.8	150.33	3800600.0
2023-08-07	ABC-DELISTED	Stock	186.25	187.59	185.22	186.51	2334998.0
2023-08-07	ABCB	Stock	44.52	45.34	44.34	45.31	242000.0
2023-08-07	ABCL	Stock	6.16	6.66	5.8	5.85	3461900.0
2023-08-07	ABCM-DELISTED	Stock	22.9	22.96	22.31	22.445	758328.0
2023-08-07	ABEO	Stock	3.12	3.12	2.97	2.98	115200.0
2023-08-07	ABEV	Stock	2.97	2.98	2.94	2.96	8171500.0
2023-08-07	ABG	Stock	220.56	226.16	220.24	225.69	116400.0
2023-08-07	ABLLW	Stock	0.229	0.229	0.205	0.2267	3841.0
2023-08-07	ABLV	Stock	8.24	9.49	8.05	9.01	67887.0
2023-08-07	ABM	Stock	45.48	45.75	45.38	45.6	308400.0
2023-08-07	ABNB	Stock	142.0	144.0	138.79	143.2	4079100.0
2023-08-07	ABOS	Stock	7.48	7.52	6.84	7.0	1025200.0
2023-08-07	ABR	Stock	16.76	16.95	16.55	16.74	2602600.0
2023-08-07	ABR.D	Stock	19.07	19.1	18.75	18.76	19459.0
2023-08-07	ABR.E	Stock	18.83	19.08	18.83	19.04	7393.0

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

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