PREVIEW / stock_daily / 2023-12-22

all stock daily files

  file:    by_date/stock_daily/2023/2023-12-22.parquet
  size:    235 KB
  rows:    7,327
  symbols: 1,221

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-12-22	AAPL	Stock	195.18	195.41	192.97	193.6	37122800.0
2023-12-22	MSFT	Stock	373.68	375.18	372.71	374.58	17091100.0
2023-12-22	NVDA	Stock	49.195	49.383	48.467	48.83	252507000.0
2023-12-22	AMZN	Stock	153.77	154.35	152.71	153.42	29480100.0
2023-12-22	GOOGL	Stock	140.77	141.99	140.71	141.49	26532199.0
2023-12-22	META	Stock	355.58	357.2	351.22	353.39	11764200.0
2023-12-22	TSLA	Stock	256.76	258.22	251.37	252.54	93249800.0
2023-12-22	TLT	Stock	99.38	99.38	98.24	98.475	29244249.0
2023-12-22	ES	Stock	61.01	62.02	60.79	61.08	1062200.0
2023-12-22	CL	Stock	78.14	78.72	77.98	78.5	4042400.0
2023-12-22	A	Stock	139.61	140.36	138.79	139.57	1204100.0
2023-12-22	AA	Stock	32.96	34.44	32.88	33.77	9064600.0
2023-12-22	AACG	Stock	0.83	0.86	0.81	0.81	2800.0
2023-12-22	AACIW-DELISTED	Stock	0.025	0.025	0.025	0.025	606.0
2023-12-22	AACT	Stock	10.5	10.5	10.43	10.43	64700.0
2023-12-22	AAGR-DELISTED	Stock	1.08	1.21	0.953	1.04	1391459.0
2023-12-22	AAGRW-DELISTED	Stock	0.04	0.04	0.017	0.03	54775.0
2023-12-22	AAL	Stock	14.38	14.4	14.21	14.31	25169900.0
2023-12-22	AAMC-DELISTED	Stock	4.33	4.868	4.29	4.35	13200.0
2023-12-22	AAME	Stock	2.06	2.15	2.03	2.11	9000.0
2023-12-22	AAMI	Stock	19.11	19.12	18.7	18.83	429700.0
2023-12-22	AAN-DELISTED	Stock	11.23	11.475	11.11	11.11	311300.0
2023-12-22	AAOI	Stock	20.82	21.62	19.87	20.9	2217700.0
2023-12-22	AAON	Stock	72.64	73.66	72.42	73.41	318600.0
2023-12-22	AAP	Stock	60.15	61.93	60.15	61.25	1174700.0
2023-12-22	AAT	Stock	22.96	23.3	22.64	22.65	307700.0
2023-12-22	AATC	Stock	7.1868	7.19	7.01	7.01	2535.0
2023-12-22	AAU-DELISTED	Stock	0.145	0.148	0.145	0.145	168919.0
2023-12-22	AAUAF-DELISTED	Stock	0.145	0.148	0.145	0.145	166751.0
2023-12-22	AAXJ	Stock	64.62	65.04	64.62	64.92	547840.0
2023-12-22	AB	Stock	30.96	32.3	30.95	31.78	471000.0
2023-12-22	ABAT	Stock	5.65	5.75	5.44	5.56	484204.0
2023-12-22	ABBNY-DELISTED	Stock	43.7	43.7	43.28	43.41	95777.0
2023-12-22	ABBV	Stock	153.29	155.46	153.09	154.94	3372800.0
2023-12-22	ABCB	Stock	52.25	52.9	51.68	52.52	349800.0
2023-12-22	ABCL	Stock	5.7	5.83	5.635	5.69	877000.0
2023-12-22	ABEO	Stock	4.8	4.99	4.72	4.97	279900.0
2023-12-22	ABEV	Stock	2.79	2.83	2.78	2.81	7502300.0
2023-12-22	ABG	Stock	226.37	228.56	224.09	224.18	139900.0
2023-12-22	ABLLW	Stock	0.59	0.5901	0.5	0.58001	9653.0
2023-12-22	ABLV	Stock	2.82	2.82	2.82	2.82	1000.0
2023-12-22	ABLVW	Stock	0.0347	0.0347	0.0347	0.0347	108.0
2023-12-22	ABM	Stock	45.7	46.3	45.25	45.64	526100.0
2023-12-22	ABNB	Stock	141.88	142.51	139.73	140.8	2936100.0
2023-12-22	ABOS	Stock	3.27	3.59	3.27	3.57	612800.0
2023-12-22	ABR	Stock	15.95	16.31	15.59	15.76	5727100.0
2023-12-22	ABR.D	Stock	18.1979	18.3	18.0	18.06	34261.0
2023-12-22	ABR.E	Stock	18.35	18.35	18.06	18.06	7424.0
2023-12-22	ABR.F	Stock	18.63	18.78	18.41	18.78	31663.0
2023-12-22	ABSI	Stock	3.29	3.53	3.25	3.32	801100.0

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

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