PREVIEW / stock_daily / 2023-12-11

all stock daily files

  file:    by_date/stock_daily/2023/2023-12-11.parquet
  size:    236 KB
  rows:    7,378
  symbols: 1,285

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-11	AAPL	Stock	193.11	193.49	191.42	193.18	60943700.0
2023-12-11	MSFT	Stock	368.48	371.6	366.1	371.3	27708800.0
2023-12-11	NVDA	Stock	47.491	47.531	45.83	46.627	509728000.0
2023-12-11	AMZN	Stock	145.66	146.19	143.64	145.89	50907300.0
2023-12-11	GOOGL	Stock	132.38	133.335	131.36	133.29	31138011.0
2023-12-11	META	Stock	329.4	329.89	320.0	325.28	25802500.0
2023-12-11	TSLA	Stock	242.74	243.44	237.45	239.74	97913900.0
2023-12-11	TLT	Stock	94.01	94.44	93.53	94.34	33909733.0
2023-12-11	ES	Stock	59.28	60.91	59.16	60.79	2885300.0
2023-12-11	CL	Stock	77.35	77.88	77.26	77.64	3958200.0
2023-12-11	A	Stock	127.62	129.63	127.22	128.97	1897100.0
2023-12-11	AA	Stock	24.75	25.32	24.67	24.93	4290700.0
2023-12-11	AACG	Stock	0.85	0.93	0.85	0.9	7100.0
2023-12-11	AACIW-DELISTED	Stock	0.025	0.027	0.0249	0.027	912.0
2023-12-11	AACT	Stock	10.39	10.4	10.39	10.4	2500.0
2023-12-11	AAGR-DELISTED	Stock	1.67	1.8	1.05	1.1	1145615.0
2023-12-11	AAGRW-DELISTED	Stock	0.0598	0.06	0.04	0.04	4037.0
2023-12-11	AAIC-DELISTED	Stock	4.73	4.78	4.73	4.76	269972.0
2023-12-11	AAIC.C-DELISTED	Stock	24.5	24.65	24.4446	24.65	6290.0
2023-12-11	AAL	Stock	13.76	13.79	13.61	13.72	28383700.0
2023-12-11	AAMC-DELISTED	Stock	6.97	7.28	5.63	6.48	236400.0
2023-12-11	AAME	Stock	1.84	1.91	1.84	1.89	2900.0
2023-12-11	AAMI	Stock	18.57	18.66	18.365	18.58	104500.0
2023-12-11	AAN-DELISTED	Stock	10.39	10.54	10.25	10.44	326200.0
2023-12-11	AAOI	Stock	19.8	19.8	18.01	18.56	2813400.0
2023-12-11	AAON	Stock	65.88	66.41	65.33	66.24	230000.0
2023-12-11	AAP	Stock	56.24	59.22	55.95	57.08	3398700.0
2023-12-11	AAT	Stock	21.43	21.61	21.36	21.46	493700.0
2023-12-11	AATC	Stock	7.18	7.215	6.71	7.0	26163.0
2023-12-11	AAU-DELISTED	Stock	0.145	0.1472	0.1419	0.145	344923.0
2023-12-11	AAUAF-DELISTED	Stock	0.145	0.1472	0.1419	0.145	348027.0
2023-12-11	AAXJ	Stock	64.3	64.835	64.25	64.82	577538.0
2023-12-11	AB	Stock	28.68	30.48	28.68	29.82	991700.0
2023-12-11	ABAT	Stock	4.01	4.15	3.95	4.02	532228.0
2023-12-11	ABBNY-DELISTED	Stock	41.66	42.2	41.64	42.03	188698.0
2023-12-11	ABBV	Stock	150.67	152.71	150.64	151.24	6343500.0
2023-12-11	ABCB	Stock	46.94	47.4	46.77	47.07	374600.0
2023-12-11	ABCL	Stock	4.85	4.86	4.7	4.79	1173000.0
2023-12-11	ABEO	Stock	4.76	4.84	4.58	4.66	85300.0
2023-12-11	ABEV	Stock	2.86	2.9	2.86	2.89	8328600.0
2023-12-11	ABG	Stock	215.06	218.68	213.27	216.5	78500.0
2023-12-11	ABLLW	Stock	0.3401	0.3999	0.33	0.3889	227094.0
2023-12-11	ABLV	Stock	2.99	2.99	2.99	2.99	3300.0
2023-12-11	ABM	Stock	43.65	44.25	43.65	44.04	379700.0
2023-12-11	ABNB	Stock	141.36	144.5	140.85	142.91	4560500.0
2023-12-11	ABOS	Stock	2.77	2.78	2.67	2.72	517500.0
2023-12-11	ABR	Stock	13.8	14.39	13.77	14.1	4875400.0
2023-12-11	ABR.D	Stock	17.07	17.39	17.07	17.16	14387.0
2023-12-11	ABR.E	Stock	17.12	17.36	16.98	17.05	7986.0
2023-12-11	ABR.F	Stock	18.93	18.998	18.7	18.7	14347.0

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

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