PREVIEW / stock_daily / 2023-12-29

all stock daily files

  file:    by_date/stock_daily/2023/2023-12-29.parquet
  size:    237 KB
  rows:    7,382
  symbols: 1,226

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-29	AAPL	Stock	193.9	194.4	191.73	192.53	42628800.0
2023-12-29	MSFT	Stock	376.0	377.16	373.48	376.04	18723000.0
2023-12-29	NVDA	Stock	49.813	49.997	48.751	49.522	389293000.0
2023-12-29	AMZN	Stock	153.1	153.89	151.03	151.94	39789000.0
2023-12-29	GOOGL	Stock	139.63	140.36	138.78	139.69	18733017.0
2023-12-29	META	Stock	358.99	360.0	351.82	353.96	14980500.0
2023-12-29	TSLA	Stock	255.1	255.19	247.43	248.48	100615300.0
2023-12-29	TLT	Stock	99.13	99.815	98.795	98.88	41616185.0
2023-12-29	ES	Stock	61.54	61.86	61.14	61.72	1485900.0
2023-12-29	CL	Stock	79.12	79.78	79.1	79.71	2463300.0
2023-12-29	A	Stock	139.07	139.7	138.36	139.03	1014400.0
2023-12-29	AA	Stock	34.31	34.74	33.93	34.0	3294300.0
2023-12-29	AACG	Stock	1.22	1.27	1.11	1.16	33800.0
2023-12-29	AACIW-DELISTED	Stock	0.025	0.0251	0.0151	0.018	10534.0
2023-12-29	AACT	Stock	10.45	10.47	10.42	10.44	6400.0
2023-12-29	AAGR-DELISTED	Stock	1.26	1.28	1.06	1.25	484126.0
2023-12-29	AAGRW-DELISTED	Stock	0.0211	0.0279	0.0193	0.0195	15735.0
2023-12-29	AAL	Stock	13.95	13.97	13.69	13.74	24242000.0
2023-12-29	AAMC-DELISTED	Stock	4.45	4.59	3.89	4.14	32700.0
2023-12-29	AAME	Stock	2.21	2.46	2.21	2.45	19100.0
2023-12-29	AAMI	Stock	19.22	19.3	19.015	19.16	455000.0
2023-12-29	AAN-DELISTED	Stock	11.19	11.29	10.79	10.88	315300.0
2023-12-29	AAOI	Stock	21.76	22.16	17.721	19.32	7625300.0
2023-12-29	AAON	Stock	74.38	75.04	73.57	73.87	213800.0
2023-12-29	AAP	Stock	61.15	61.37	60.8	61.03	1393700.0
2023-12-29	AAT	Stock	22.98	22.98	22.51	22.51	296200.0
2023-12-29	AATC	Stock	7.05	7.05	6.91	7.05	2827.0
2023-12-29	AAU-DELISTED	Stock	0.145	0.1451	0.145	0.145	255527.0
2023-12-29	AAUAF-DELISTED	Stock	0.145	0.1451	0.145	0.145	249049.0
2023-12-29	AAXJ	Stock	66.23	66.77	66.23	66.57	481233.0
2023-12-29	AB	Stock	31.13	31.51	30.77	31.03	494900.0
2023-12-29	ABAT	Stock	4.97	4.97	4.66	4.69	463462.0
2023-12-29	ABBNY-DELISTED	Stock	44.34	44.55	44.17	44.3	117473.0
2023-12-29	ABBV	Stock	154.54	155.21	154.41	154.97	3711400.0
2023-12-29	ABCB	Stock	53.42	53.58	52.72	53.05	351200.0
2023-12-29	ABCL	Stock	5.95	5.95	5.63	5.71	1554900.0
2023-12-29	ABEO	Stock	5.19	5.19	4.97	5.01	144600.0
2023-12-29	ABEV	Stock	2.8	2.82	2.8	2.8	2003400.0
2023-12-29	ABG	Stock	226.6	226.6	222.82	224.97	126300.0
2023-12-29	ABLLW	Stock	0.7326	0.76	0.64	0.7464	148581.0
2023-12-29	ABLV	Stock	2.55	3.09	2.43	2.7	52300.0
2023-12-29	ABLVW	Stock	0.0308	0.0308	0.0308	0.0308	200.0
2023-12-29	ABM	Stock	45.22	45.31	44.74	44.83	257400.0
2023-12-29	ABNB	Stock	136.71	137.87	135.43	136.14	3074100.0
2023-12-29	ABOS	Stock	3.83	3.96	3.715	3.84	454900.0
2023-12-29	ABR	Stock	15.76	15.76	15.06	15.18	4801800.0
2023-12-29	ABR.D	Stock	17.77	17.92	17.65	17.65	33326.0
2023-12-29	ABR.E	Stock	17.805	18.0455	17.51	17.65	8777.0
2023-12-29	ABR.F	Stock	18.96	19.057	18.74	18.8	25370.0
2023-12-29	ABSI	Stock	4.78	4.862	4.13	4.2	1883400.0

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

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