PREVIEW / stock_daily / 2023-11-22

all stock daily files

  file:    by_date/stock_daily/2023/2023-11-22.parquet
  size:    233 KB
  rows:    7,337
  symbols: 1,297

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-22	AAPL	Stock	191.49	192.93	190.83	191.31	39617700.0
2023-11-22	MSFT	Stock	378.0	379.79	374.97	377.85	23345300.0
2023-11-22	NVDA	Stock	49.852	50.335	47.69	48.716	899420000.0
2023-11-22	AMZN	Stock	144.57	147.74	144.57	146.71	45669100.0
2023-11-22	GOOGL	Stock	137.47	139.42	137.47	138.49	17820456.0
2023-11-22	META	Stock	339.21	342.92	338.58	341.49	10702700.0
2023-11-22	TSLA	Stock	242.04	244.01	231.4	234.21	117950600.0
2023-11-22	TLT	Stock	91.12	91.32	90.38	90.87	31215577.0
2023-11-22	ES	Stock	59.09	59.6	58.48	59.53	3809000.0
2023-11-22	CL	Stock	76.9	77.5	76.86	77.28	3217300.0
2023-11-22	A	Stock	123.87	125.4	123.81	123.99	2630700.0
2023-11-22	AA	Stock	26.28	26.62	25.98	26.38	2923700.0
2023-11-22	AACG	Stock	0.95	0.97	0.87	0.93	2500.0
2023-11-22	AACIW-DELISTED	Stock	0.0699	0.0699	0.0699	0.0699	100.0
2023-11-22	AACT	Stock	10.36	10.36	10.36	10.36	38400.0
2023-11-22	AAIC-DELISTED	Stock	4.61	4.665	4.61	4.66	78863.0
2023-11-22	AAIC.C-DELISTED	Stock	24.08	24.08	24.08	24.08	400.0
2023-11-22	AAL	Stock	12.37	12.77	12.17	12.31	40937600.0
2023-11-22	AAMC-DELISTED	Stock	2.82	2.96	2.82	2.88	6200.0
2023-11-22	AAME	Stock	1.77	1.93	1.77	1.93	900.0
2023-11-22	AAMI	Stock	17.85	18.05	17.645	17.9	113200.0
2023-11-22	AAN-DELISTED	Stock	8.95	9.01	8.75	8.79	228500.0
2023-11-22	AAOI	Stock	13.62	13.96	13.01	13.21	1484000.0
2023-11-22	AAON	Stock	63.97	64.84	63.49	63.54	304900.0
2023-11-22	AAP	Stock	51.46	52.77	50.69	52.59	1579700.0
2023-11-22	AAT	Stock	18.86	18.87	18.64	18.76	294300.0
2023-11-22	AATC	Stock	6.54	6.54	6.495	6.54	1739.0
2023-11-22	AAU-DELISTED	Stock	0.145	0.145	0.14	0.14	124891.0
2023-11-22	AAUAF-DELISTED	Stock	0.145	0.145	0.14	0.14	128144.0
2023-11-22	AAXJ	Stock	65.78	65.915	65.5	65.77	596856.0
2023-11-22	AB	Stock	28.49	28.49	27.89	28.01	257100.0
2023-11-22	ABAT	Stock	4.19	4.27	3.96	4.11	263780.0
2023-11-22	ABBNY-DELISTED	Stock	38.49	38.49	38.19	38.39	74631.0
2023-11-22	ABBV	Stock	139.06	139.84	138.33	138.47	3428500.0
2023-11-22	ABCB	Stock	42.77	42.86	42.21	42.59	153400.0
2023-11-22	ABCL	Stock	4.41	4.45	4.33	4.43	876100.0
2023-11-22	ABCM-DELISTED	Stock	23.92	23.94	23.92	23.93	1901629.0
2023-11-22	ABEO	Stock	4.2	4.21	4.09	4.15	49000.0
2023-11-22	ABEV	Stock	2.76	2.78	2.73	2.76	12675600.0
2023-11-22	ABG	Stock	206.55	207.54	205.0	207.07	108600.0
2023-11-22	ABLLW	Stock	0.338	0.36	0.3299	0.33361	22780.0
2023-11-22	ABLV	Stock	3.01	3.04	2.867	2.89	31600.0
2023-11-22	ABLVW	Stock	0.0396	0.0747	0.0396	0.05	39700.0
2023-11-22	ABM	Stock	41.08	41.34	40.7	40.88	239300.0
2023-11-22	ABNB	Stock	127.75	130.58	127.71	129.04	3973900.0
2023-11-22	ABOS	Stock	2.36	2.39	2.295	2.36	422700.0
2023-11-22	ABR	Stock	12.27	12.35	12.13	12.17	3960000.0
2023-11-22	ABR.D	Stock	16.34	16.4945	16.2238	16.46	18586.0
2023-11-22	ABR.E	Stock	16.4	16.5	16.35	16.5	2006.0
2023-11-22	ABR.F	Stock	17.41	17.59	17.375	17.5	11216.0

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

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