PREVIEW / stock_daily / 2024-01-09

all stock daily files

  file:    by_date/stock_daily/2024/2024-01-09.parquet
  size:    233 KB
  rows:    7,259
  symbols: 1,169

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
2024-01-09	AAPL	Stock	183.92	185.15	182.73	185.14	42841800.0
2024-01-09	MSFT	Stock	372.01	375.99	371.19	375.79	20830000.0
2024-01-09	NVDA	Stock	52.401	54.325	51.69	53.14	773100000.0
2024-01-09	AMZN	Stock	148.33	151.71	148.21	151.37	43812600.0
2024-01-09	GOOGL	Stock	138.5	141.485	138.15	140.95	24759598.0
2024-01-09	META	Stock	356.4	360.64	355.36	357.43	13463900.0
2024-01-09	TSLA	Stock	238.11	238.96	232.04	234.96	96705700.0
2024-01-09	TLT	Stock	96.64	97.165	96.585	96.62	34373950.0
2024-01-09	ES	Stock	59.78	59.78	57.96	58.0	7426200.0
2024-01-09	CL	Stock	80.3	80.86	79.98	80.82	3714500.0
2024-01-09	A	Stock	132.27	135.65	130.01	130.68	1435000.0
2024-01-09	AA	Stock	31.82	32.45	31.55	31.94	5792100.0
2024-01-09	AACG	Stock	1.05	1.12	1.05	1.11	1400.0
2024-01-09	AACIW-DELISTED	Stock	0.0196	0.0196	0.018	0.018	5889.0
2024-01-09	AACT	Stock	10.45	10.45	10.45	10.45	500.0
2024-01-09	AAGR-DELISTED	Stock	1.05	1.05	0.97	1.0	184648.0
2024-01-09	AAGRW-DELISTED	Stock	0.02155	0.02155	0.016	0.016	9335.0
2024-01-09	AAL	Stock	14.51	14.63	14.36	14.38	35790700.0
2024-01-09	AAMC-DELISTED	Stock	4.23	4.35	3.89	3.89	25200.0
2024-01-09	AAME	Stock	2.49	2.55	2.44	2.55	3600.0
2024-01-09	AAMI	Stock	18.59	18.86	18.59	18.81	418200.0
2024-01-09	AAN-DELISTED	Stock	11.27	11.36	10.905	10.99	237200.0
2024-01-09	AAOI	Stock	19.88	22.01	19.51	21.77	2682600.0
2024-01-09	AAON	Stock	72.75	73.36	72.46	72.68	347300.0
2024-01-09	AAP	Stock	61.61	62.32	61.07	61.39	992100.0
2024-01-09	AAT	Stock	22.86	23.19	22.77	23.15	250800.0
2024-01-09	AATC	Stock	7.17	7.25	7.1	7.243	1972.0
2024-01-09	AAU-DELISTED	Stock	0.1301	0.14	0.1281	0.1363	100077.0
2024-01-09	AAUAF-DELISTED	Stock	0.1301	0.14	0.1281	0.1363	104630.0
2024-01-09	AAXJ	Stock	64.02	64.11	63.825	64.0	515317.0
2024-01-09	AB	Stock	31.3	31.75	31.23	31.55	488100.0
2024-01-09	ABAT	Stock	4.09	4.15	3.99	4.09	325390.0
2024-01-09	ABBNY-DELISTED	Stock	42.47	42.56	42.26	42.32	275003.0
2024-01-09	ABBV	Stock	161.43	163.47	160.84	162.31	4454000.0
2024-01-09	ABCB	Stock	50.72	51.91	50.22	50.9	493700.0
2024-01-09	ABCL	Stock	5.89	5.925	5.67	5.71	1161800.0
2024-01-09	ABEO	Stock	5.81	5.9	5.58	5.63	203300.0
2024-01-09	ABEV	Stock	2.76	2.78	2.74	2.74	4660200.0
2024-01-09	ABG	Stock	205.05	209.06	204.29	209.05	93700.0
2024-01-09	ABLLW	Stock	0.94	0.989	0.9	0.901	524492.0
2024-01-09	ABLV	Stock	2.65	2.65	2.65	2.65	300.0
2024-01-09	ABM	Stock	42.03	42.23	41.64	42.13	1211800.0
2024-01-09	ABNB	Stock	138.52	139.54	137.79	139.53	3560900.0
2024-01-09	ABOS	Stock	4.2	4.38	4.13	4.35	334300.0
2024-01-09	ABR	Stock	14.43	14.88	14.41	14.79	2494800.0
2024-01-09	ABR.D	Stock	18.19	18.39	18.03	18.29	22292.0
2024-01-09	ABR.E	Stock	18.14	18.1877	17.9	18.18	3623.0
2024-01-09	ABR.F	Stock	18.87	19.15	18.87	18.95	23910.0
2024-01-09	ABSI	Stock	4.18	4.22	3.95	4.11	1422400.0
2024-01-09	ABT	Stock	112.15	113.54	112.06	112.73	3802100.0

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

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