PREVIEW / stock_daily / 2023-01-26

all stock daily files

  file:    by_date/stock_daily/2023/2023-01-26.parquet
  size:    248 KB
  rows:    7,705
  symbols: 1,884

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-01-26	AAPL	Stock	143.17	144.25	141.9	143.96	54105100.0
2023-01-26	MSFT	Stock	243.65	248.31	242.0	248.0	33454500.0
2023-01-26	NVDA	Stock	19.701	20.166	19.278	19.802	489535000.0
2023-01-26	AMZN	Stock	98.24	99.49	96.92	99.22	68523600.0
2023-01-26	GOOGL	Stock	96.5	97.57	95.38	97.52	30113974.0
2023-01-26	META	Stock	144.4	147.51	143.3	147.3	25482100.0
2023-01-26	TSLA	Stock	159.97	161.42	154.76	160.27	234815100.0
2023-01-26	TLT	Stock	107.14	107.65	106.49	106.98	15549352.0
2023-01-26	ES	Stock	79.49	80.75	79.31	80.32	1256900.0
2023-01-26	CL	Stock	75.62	75.81	75.12	75.53	3744000.0
2023-01-26	A	Stock	156.97	157.66	155.19	156.23	776300.0
2023-01-26	AA	Stock	52.43	52.75	50.41	52.11	3967400.0
2023-01-26	AAC-DELISTED	Stock	10.13	10.1779	10.13	10.17	7365900.0
2023-01-26	AACG	Stock	1.44	1.48	1.36	1.48	14500.0
2023-01-26	AACIU	Stock	10.5	10.5	10.5	10.5	1007.0
2023-01-26	AACIW-DELISTED	Stock	0.1	0.1004	0.0995	0.1	63547.0
2023-01-26	AAIC-DELISTED	Stock	3.04	3.0402	2.99	3.03	146171.0
2023-01-26	AAIC.C-DELISTED	Stock	22.67	22.8	21.9601	22.8	2050.0
2023-01-26	AAL	Stock	16.54	16.74	15.73	16.61	47488900.0
2023-01-26	AAM.A-DELISTED	Stock	24.868	24.868	24.6935	24.7701	11816.0
2023-01-26	AAM.B-DELISTED	Stock	24.5	24.9699	24.2954	24.5	39894.0
2023-01-26	AAMC-DELISTED	Stock	9.1206	9.5796	9.1206	9.5588	5348.0
2023-01-26	AAME	Stock	2.54	2.55	2.53	2.55	1900.0
2023-01-26	AAMI	Stock	22.43	22.65	22.3	22.65	99900.0
2023-01-26	AAN-DELISTED	Stock	14.12	14.145	13.81	13.95	107400.0
2023-01-26	AAOI	Stock	2.22	2.3	2.2	2.2	151700.0
2023-01-26	AAON	Stock	49.86	49.8733	48.9933	49.2667	168450.0
2023-01-26	AAP	Stock	150.24	150.99	147.39	147.62	642100.0
2023-01-26	AAT	Stock	27.22	27.39	26.97	27.28	165600.0
2023-01-26	AATC	Stock	4.15	4.18	4.12	4.12	3988.0
2023-01-26	AAU-DELISTED	Stock	0.24	0.2498	0.2372	0.24	107739.0
2023-01-26	AAUAF-DELISTED	Stock	0.24	0.2498	0.2372	0.24	109628.0
2023-01-26	AAWW-DELISTED	Stock	102.05	102.1	101.5	101.98	1241009.0
2023-01-26	AAXJ	Stock	72.98	73.09	72.585	73.08	1605119.0
2023-01-26	AB	Stock	37.79	38.29	37.63	38.24	140100.0
2023-01-26	ABB-DELISTED	Stock	34.71	34.76	34.385	34.75	1480680.0
2023-01-26	ABBNY-DELISTED	Stock	34.71	34.76	34.385	34.75	1661114.0
2023-01-26	ABBV	Stock	147.92	148.7	147.11	147.4	4577800.0
2023-01-26	ABC-DELISTED	Stock	163.73	165.2	162.8	164.81	761397.0
2023-01-26	ABCB	Stock	47.66	47.9	46.58	46.79	910400.0
2023-01-26	ABCL	Stock	10.53	10.692	10.22	10.52	1060000.0
2023-01-26	ABCM-DELISTED	Stock	16.94	17.4	16.52	16.75	689540.0
2023-01-26	ABEO	Stock	2.64	2.64	2.59	2.62	187100.0
2023-01-26	ABEV	Stock	2.7	2.71	2.64	2.68	28767400.0
2023-01-26	ABG	Stock	195.0	202.72	195.0	200.63	342300.0
2023-01-26	ABM	Stock	45.45	45.94	45.15	45.93	174900.0
2023-01-26	ABNB	Stock	106.3	109.49	105.675	109.42	5196600.0
2023-01-26	ABOS	Stock	5.92	5.99	5.43	5.52	71300.0
2023-01-26	ABR	Stock	14.55	14.71	14.5	14.67	1195000.0
2023-01-26	ABR.D	Stock	20.01	20.3099	19.75	19.85	20415.0

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

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