PREVIEW / stock_daily / 2023-11-24

all stock daily files

  file:    by_date/stock_daily/2023/2023-11-24.parquet
  size:    224 KB
  rows:    7,119
  symbols: 1,213

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-11-24	AAPL	Stock	190.87	190.9	189.25	189.97	24048300.0
2023-11-24	MSFT	Stock	377.33	377.97	375.14	377.43	10176600.0
2023-11-24	NVDA	Stock	48.47	48.921	47.745	47.776	294645000.0
2023-11-24	AMZN	Stock	146.7	147.2	145.32	146.74	22378400.0
2023-11-24	GOOGL	Stock	138.03	138.13	135.99	136.69	12514322.0
2023-11-24	META	Stock	340.13	341.86	336.77	338.23	5467500.0
2023-11-24	TSLA	Stock	233.75	238.75	232.33	235.45	65125200.0
2023-11-24	TLT	Stock	90.1	90.26	89.79	89.8	20199626.0
2023-11-24	ES	Stock	59.41	59.61	58.95	59.26	946600.0
2023-11-24	CL	Stock	77.48	77.48	77.02	77.31	1150400.0
2023-11-24	A	Stock	123.92	126.77	123.48	126.62	1226700.0
2023-11-24	AA	Stock	26.16	26.56	26.16	26.24	1282300.0
2023-11-24	AACG	Stock	0.97	0.98	0.92	0.92	2400.0
2023-11-24	AACT	Stock	10.36	10.36	10.35	10.35	27200.0
2023-11-24	AAIC-DELISTED	Stock	4.63	4.69	4.63	4.68	16824.0
2023-11-24	AAIC.C-DELISTED	Stock	24.05	24.2567	24.05	24.16	2724.0
2023-11-24	AAL	Stock	12.39	12.48	12.25	12.31	14803800.0
2023-11-24	AAMC-DELISTED	Stock	2.88	2.98	2.87	2.89	17900.0
2023-11-24	AAME	Stock	1.93	1.93	1.91	1.93	1400.0
2023-11-24	AAMI	Stock	17.79	18.0	17.79	17.93	44400.0
2023-11-24	AAN-DELISTED	Stock	8.8	8.96	8.77	8.89	102400.0
2023-11-24	AAOI	Stock	13.25	13.63	12.92	13.04	906500.0
2023-11-24	AAON	Stock	63.36	64.25	63.36	63.83	89300.0
2023-11-24	AAP	Stock	52.33	53.34	52.12	53.08	839100.0
2023-11-24	AAT	Stock	18.69	18.81	18.6	18.79	120100.0
2023-11-24	AATC	Stock	6.54	6.54	6.45	6.45	343.0
2023-11-24	AAU-DELISTED	Stock	0.145	0.145	0.135	0.135	126546.0
2023-11-24	AAUAF-DELISTED	Stock	0.145	0.145	0.14	0.14	127755.0
2023-11-24	AAXJ	Stock	65.45	65.74	65.2	65.74	204187.0
2023-11-24	AB	Stock	27.78	28.99	27.78	28.39	215200.0
2023-11-24	ABAT	Stock	4.01	4.46	4.0	4.36	183223.0
2023-11-24	ABBNY-DELISTED	Stock	38.59	38.81	38.59	38.73	79213.0
2023-11-24	ABBV	Stock	140.0	140.08	138.46	138.67	1636500.0
2023-11-24	ABCB	Stock	42.59	43.09	42.25	42.59	74700.0
2023-11-24	ABCL	Stock	4.44	4.49	4.4	4.43	492500.0
2023-11-24	ABCM-DELISTED	Stock	23.93	23.95	23.93	23.93	1597732.0
2023-11-24	ABEO	Stock	4.1	4.39	4.07	4.31	66100.0
2023-11-24	ABEV	Stock	2.74	2.76	2.73	2.75	9544500.0
2023-11-24	ABG	Stock	207.0	210.09	206.68	209.76	50200.0
2023-11-24	ABLLW	Stock	0.3899	0.3899	0.3175	0.3499	238176.0
2023-11-24	ABLV	Stock	3.01	3.01	2.81	2.89	10800.0
2023-11-24	ABLVW	Stock	0.0745	0.1299	0.0745	0.0899	20887.0
2023-11-24	ABM	Stock	40.74	41.34	40.59	41.22	139600.0
2023-11-24	ABNB	Stock	129.05	129.59	127.78	128.37	2058900.0
2023-11-24	ABOS	Stock	2.35	2.425	2.33	2.37	164600.0
2023-11-24	ABR	Stock	12.21	12.27	12.11	12.14	1918100.0
2023-11-24	ABR.D	Stock	16.51	16.64	16.46	16.64	6982.0
2023-11-24	ABR.E	Stock	16.36	16.8	16.33	16.8	2963.0
2023-11-24	ABR.F	Stock	17.64	18.73	17.49	18.3536	26484.0
2023-11-24	ABSI	Stock	1.41	1.44	1.36	1.44	158700.0

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

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