PREVIEW / stock_daily / 2023-12-14

all stock daily files

  file:    by_date/stock_daily/2023/2023-12-14.parquet
  size:    239 KB
  rows:    7,414
  symbols: 1,267

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-14	AAPL	Stock	198.02	199.62	196.16	198.11	66831600.0
2023-12-14	MSFT	Stock	373.31	373.76	364.13	365.93	43277500.0
2023-12-14	NVDA	Stock	48.39	48.67	47.422	48.35	391232000.0
2023-12-14	AMZN	Stock	149.93	150.54	145.52	147.42	58400800.0
2023-12-14	GOOGL	Stock	133.38	133.72	129.685	131.94	38722413.0
2023-12-14	META	Stock	333.85	334.7	328.64	333.17	19607300.0
2023-12-14	TSLA	Stock	241.22	253.88	240.79	251.05	160829200.0
2023-12-14	TLT	Stock	97.66	99.04	97.42	99.04	87798591.0
2023-12-14	ES	Stock	63.57	64.56	63.24	63.53	3227700.0
2023-12-14	CL	Stock	78.29	78.78	76.2	76.27	8434000.0
2023-12-14	A	Stock	135.0	138.17	135.0	137.96	2950500.0
2023-12-14	AA	Stock	27.04	30.135	26.94	29.9	16594000.0
2023-12-14	AACG	Stock	0.91	0.91	0.85	0.85	20700.0
2023-12-14	AACIW-DELISTED	Stock	0.02	0.025	0.0161	0.0161	15800.0
2023-12-14	AACT	Stock	10.41	10.42	10.41	10.41	47100.0
2023-12-14	AAGR-DELISTED	Stock	0.72	0.79	0.67	0.672	2169560.0
2023-12-14	AAGRW-DELISTED	Stock	0.0251	0.0311	0.0251	0.031	13320.0
2023-12-14	AAL	Stock	14.3	14.65	14.27	14.59	42803900.0
2023-12-14	AAMC-DELISTED	Stock	5.53	5.56	5.14	5.56	29000.0
2023-12-14	AAME	Stock	2.0	2.06	1.92	2.01	19100.0
2023-12-14	AAMI	Stock	19.78	20.23	19.67	19.83	171800.0
2023-12-14	AAN-DELISTED	Stock	11.61	11.9	11.48	11.72	567400.0
2023-12-14	AAOI	Stock	22.0	23.68	21.6	23.19	3953800.0
2023-12-14	AAON	Stock	68.0	71.67	67.99	71.23	885000.0
2023-12-14	AAP	Stock	62.32	66.04	61.99	63.97	3467000.0
2023-12-14	AAT	Stock	23.24	23.72	23.15	23.47	666800.0
2023-12-14	AATC	Stock	6.62	7.35	6.53	6.85	27765.0
2023-12-14	AAU-DELISTED	Stock	0.145	0.147	0.145	0.1451	212771.0
2023-12-14	AAUAF-DELISTED	Stock	0.145	0.147	0.145	0.1451	213098.0
2023-12-14	AAXJ	Stock	65.66	66.33	65.66	66.29	2296738.0
2023-12-14	AB	Stock	30.93	32.87	30.93	31.87	1169100.0
2023-12-14	ABAT	Stock	4.19	4.69	4.19	4.66	1178561.0
2023-12-14	ABBNY-DELISTED	Stock	42.86	43.4	42.86	43.2	286444.0
2023-12-14	ABBV	Stock	154.36	155.16	152.76	154.88	7869600.0
2023-12-14	ABCB	Stock	51.47	53.35	51.47	52.56	571800.0
2023-12-14	ABCL	Stock	5.17	5.519	5.16	5.48	3298400.0
2023-12-14	ABEO	Stock	4.8	4.85	4.63	4.78	148600.0
2023-12-14	ABEV	Stock	2.92	2.95	2.91	2.91	15270500.0
2023-12-14	ABG	Stock	227.65	238.28	227.65	234.34	278600.0
2023-12-14	ABLLW	Stock	0.6	0.6	0.5505	0.58	13240.0
2023-12-14	ABLV	Stock	2.9	3.08	2.89	3.06	33400.0
2023-12-14	ABLVW	Stock	0.056	0.056	0.0559	0.0559	2000.0
2023-12-14	ABM	Stock	52.97	53.05	46.51	46.96	1397300.0
2023-12-14	ABNB	Stock	145.0	149.92	144.98	147.26	9568600.0
2023-12-14	ABOS	Stock	2.94	3.075	2.89	3.0	605300.0
2023-12-14	ABR	Stock	15.25	16.05	15.24	15.7	7017100.0
2023-12-14	ABR.D	Stock	17.59	17.7499	17.2243	17.63	85027.0
2023-12-14	ABR.E	Stock	17.9	18.4	17.9	18.0	12899.0
2023-12-14	ABR.F	Stock	19.06	19.08	18.7901	18.85	50049.0
2023-12-14	ABSI	Stock	2.45	2.83	2.45	2.76	1344800.0

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

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