PREVIEW / stock_daily / 2023-09-05

all stock daily files

  file:    by_date/stock_daily/2023/2023-09-05.parquet
  size:    238 KB
  rows:    7,396
  symbols: 1,432

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-09-05	AAPL	Stock	188.28	189.98	187.61	189.7	45280000.0
2023-09-05	MSFT	Stock	329.0	334.85	328.66	333.55	18553900.0
2023-09-05	NVDA	Stock	48.223	48.851	47.86	48.548	382653000.0
2023-09-05	AMZN	Stock	137.73	137.8	135.82	137.27	40636700.0
2023-09-05	GOOGL	Stock	135.44	136.42	134.5801	135.77	19403112.0
2023-09-05	META	Stock	297.02	301.39	295.51	300.15	14956000.0
2023-09-05	TSLA	Stock	245.0	258.0	244.86	256.49	129469600.0
2023-09-05	TLT	Stock	94.28	94.285	93.49	93.52	29435888.0
2023-09-05	ES	Stock	62.86	62.95	61.14	61.38	2359700.0
2023-09-05	CL	Stock	73.0	73.66	72.73	72.78	2976200.0
2023-09-05	A	Stock	121.64	122.54	118.67	118.73	1270600.0
2023-09-05	AA	Stock	30.78	31.12	30.2	30.29	4304800.0
2023-09-05	AAC-DELISTED	Stock	10.67	10.7	10.67	10.7	56832.0
2023-09-05	AACG	Stock	1.26	1.26	1.2	1.23	2800.0
2023-09-05	AACIW-DELISTED	Stock	0.0692	0.06955	0.0692	0.0692	500.0
2023-09-05	AACT	Stock	10.24	10.24	10.23	10.23	39100.0
2023-09-05	AAIC-DELISTED	Stock	4.58	4.61	4.53	4.58	163498.0
2023-09-05	AAIC.C-DELISTED	Stock	24.2	24.38	24.15	24.3	8452.0
2023-09-05	AAL	Stock	14.53	14.53	14.12	14.3	25690400.0
2023-09-05	AAM.A-DELISTED	Stock	24.96	24.97	24.96	24.97	11861.0
2023-09-05	AAM.B-DELISTED	Stock	24.96	24.9828	24.96	24.975	8570.0
2023-09-05	AAMC-DELISTED	Stock	4.8353	5.2059	4.7059	4.7412	27030.0
2023-09-05	AAME	Stock	1.95	1.95	1.95	1.95	900.0
2023-09-05	AAMI	Stock	20.84	20.845	19.84	20.28	261500.0
2023-09-05	AAN-DELISTED	Stock	11.19	11.24	10.05	10.67	1738700.0
2023-09-05	AAOI	Stock	13.78	13.78	12.81	12.95	1894400.0
2023-09-05	AAON	Stock	66.39	66.39	63.5	64.34	618000.0
2023-09-05	AAP	Stock	67.18	69.31	66.77	67.56	1873400.0
2023-09-05	AAT	Stock	21.26	21.34	20.74	20.79	541500.0
2023-09-05	AATC	Stock	6.08	6.1	6.08	6.09	5433.0
2023-09-05	AAU-DELISTED	Stock	0.121	0.125	0.121	0.1218	109690.0
2023-09-05	AAUAF-DELISTED	Stock	0.121	0.125	0.121	0.1218	112134.0
2023-09-05	AAXJ	Stock	66.0	66.22	65.92	65.99	359695.0
2023-09-05	AB	Stock	32.07	32.69	31.13	32.25	672300.0
2023-09-05	ABBNY-DELISTED	Stock	37.18	37.24	36.95	37.03	215769.0
2023-09-05	ABBV	Stock	148.5	148.96	145.86	146.1	3911100.0
2023-09-05	ABCB	Stock	41.47	41.47	40.35	40.45	400400.0
2023-09-05	ABCL	Stock	5.59	5.79	5.48	5.55	1396600.0
2023-09-05	ABCM-DELISTED	Stock	22.8	22.92	22.78	22.9	4531949.0
2023-09-05	ABEO	Stock	4.18	4.5	4.18	4.2	67600.0
2023-09-05	ABEV	Stock	2.77	2.82	2.75	2.78	9343000.0
2023-09-05	ABG	Stock	231.31	232.13	225.88	227.47	188200.0
2023-09-05	ABLLW	Stock	0.45	0.48	0.45	0.47	20605.0
2023-09-05	ABLV	Stock	4.15	4.15	3.465	3.5	162700.0
2023-09-05	ABM	Stock	45.51	45.61	44.43	44.75	677100.0
2023-09-05	ABNB	Stock	141.15	144.26	139.8	142.29	21052800.0
2023-09-05	ABOS	Stock	6.1	6.3	5.99	6.0	240300.0
2023-09-05	ABR	Stock	16.0	16.16	15.92	15.96	2267400.0
2023-09-05	ABR.D	Stock	19.13	19.14	18.995	19.02	2559.0
2023-09-05	ABR.E	Stock	19.185	19.185	19.0	19.0	728.0

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

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