PREVIEW / stock_daily / 2023-05-23

all stock daily files

  file:    by_date/stock_daily/2023/2023-05-23.parquet
  size:    242 KB
  rows:    7,526
  symbols: 1,638

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-05-23	AAPL	Stock	173.13	173.38	171.28	171.56	50747300.0
2023-05-23	MSFT	Stock	320.03	322.72	315.25	315.26	30797200.0
2023-05-23	NVDA	Stock	31.0	31.288	30.631	30.688	356253000.0
2023-05-23	AMZN	Stock	114.27	117.14	113.78	114.99	67576300.0
2023-05-23	GOOGL	Stock	124.16	124.625	122.2104	122.56	34046251.0
2023-05-23	META	Stock	246.81	251.61	246.65	246.74	17748100.0
2023-05-23	TSLA	Stock	186.2	192.96	185.26	185.77	156952100.0
2023-05-23	TLT	Stock	100.43	101.25	100.275	101.03	21749470.0
2023-05-23	ES	Stock	72.68	73.56	72.43	72.75	1502500.0
2023-05-23	CL	Stock	78.29	78.32	77.04	77.04	5299300.0
2023-05-23	A	Stock	129.03	130.54	127.91	128.64	2784400.0
2023-05-23	AA	Stock	36.0	36.17	35.45	35.67	3542500.0
2023-05-23	AAC-DELISTED	Stock	10.49	10.5	10.485	10.485	117082.0
2023-05-23	AACG	Stock	1.53	1.55	1.5	1.55	9100.0
2023-05-23	AACIW-DELISTED	Stock	0.08	0.08	0.0711	0.0711	552.0
2023-05-23	AAIC-DELISTED	Stock	2.64	2.76	2.64	2.73	160758.0
2023-05-23	AAL	Stock	14.35	14.64	14.07	14.07	28899400.0
2023-05-23	AAM.A-DELISTED	Stock	23.55	24.19	23.55	23.84	10547.0
2023-05-23	AAM.B-DELISTED	Stock	24.1	24.69	23.77	23.77	8742.0
2023-05-23	AAMC-DELISTED	Stock	28.7941	29.1871	28.4765	28.8235	26129.0
2023-05-23	AAME	Stock	2.18	2.2	2.12	2.15	6000.0
2023-05-23	AAMI	Stock	22.84	23.18	22.49	22.49	92600.0
2023-05-23	AAN-DELISTED	Stock	12.66	13.135	12.66	12.78	167800.0
2023-05-23	AAOI	Stock	1.75	1.779	1.7	1.72	138200.0
2023-05-23	AAON	Stock	60.3067	61.2533	59.6933	59.94	318600.0
2023-05-23	AAP	Stock	117.61	118.99	115.77	116.78	1390500.0
2023-05-23	AAT	Stock	19.37	20.13	19.31	19.59	361300.0
2023-05-23	AATC	Stock	4.44	4.46	4.37	4.46	6005.0
2023-05-23	AAU-DELISTED	Stock	0.115	0.125	0.115	0.124	341341.0
2023-05-23	AAUAF-DELISTED	Stock	0.115	0.125	0.115	0.124	341226.0
2023-05-23	AAXJ	Stock	66.19	66.205	65.59	65.59	752212.0
2023-05-23	AB	Stock	34.51	35.59	34.09	34.14	217300.0
2023-05-23	ABBNY-DELISTED	Stock	36.93	37.1	36.52	36.63	2161211.0
2023-05-23	ABBV	Stock	144.45	144.82	142.34	142.52	5121900.0
2023-05-23	ABC-DELISTED	Stock	171.71	172.21	169.66	171.26	752518.0
2023-05-23	ABCB	Stock	32.03	33.69	31.72	32.78	406800.0
2023-05-23	ABCL	Stock	6.58	7.49	6.574	7.08	9600800.0
2023-05-23	ABCM-DELISTED	Stock	16.37	17.32	16.1	16.5	630174.0
2023-05-23	ABEO	Stock	3.2	3.33	3.08	3.16	114200.0
2023-05-23	ABEV	Stock	2.89	2.93	2.87	2.88	10658100.0
2023-05-23	ABG	Stock	203.45	210.66	202.21	206.4	202800.0
2023-05-23	ABM	Stock	43.31	43.96	43.31	43.6	321200.0
2023-05-23	ABNB	Stock	109.0	109.706	105.67	106.25	6498200.0
2023-05-23	ABOS	Stock	5.31	5.7	5.19	5.2	228800.0
2023-05-23	ABR	Stock	12.5	12.92	12.48	12.55	2936600.0
2023-05-23	ABR.D	Stock	16.86	17.45	16.86	17.4	15749.0
2023-05-23	ABR.E	Stock	16.85	16.91	16.72	16.8	6788.0
2023-05-23	ABR.F	Stock	18.0657	18.1	17.95	18.0	7521.0
2023-05-23	ABSI	Stock	1.82	1.9	1.67	1.67	978000.0
2023-05-23	ABST-DELISTED	Stock	11.48	11.51	11.46	11.5	556848.0

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

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