PREVIEW / stock_daily / 2023-12-04

all stock daily files

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

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-04	AAPL	Stock	189.98	190.05	187.45	189.43	43389500.0
2023-12-04	MSFT	Stock	369.1	369.52	362.9	369.14	32063300.0
2023-12-04	NVDA	Stock	46.077	46.077	45.01	45.51	437543000.0
2023-12-04	AMZN	Stock	145.25	145.35	142.81	144.84	48294200.0
2023-12-04	GOOGL	Stock	129.88	130.03	127.9	129.27	36669876.0
2023-12-04	META	Stock	317.29	320.86	313.66	320.02	19037100.0
2023-12-04	TSLA	Stock	235.75	239.37	233.29	235.58	104099800.0
2023-12-04	TLT	Stock	92.49	92.83	92.09	92.615	33766250.0
2023-12-04	ES	Stock	60.11	61.18	59.47	60.69	2223500.0
2023-12-04	CL	Stock	78.5	79.19	78.5	78.98	4154400.0
2023-12-04	A	Stock	128.41	129.22	127.87	128.88	1543200.0
2023-12-04	AA	Stock	27.28	27.93	26.765	26.81	4965000.0
2023-12-04	AACG	Stock	0.88	0.9	0.85	0.89	9700.0
2023-12-04	AACIW-DELISTED	Stock	0.05	0.05	0.05	0.05	100.0
2023-12-04	AACT	Stock	10.395	10.4	10.38	10.38	5300.0
2023-12-04	AAIC-DELISTED	Stock	4.73	4.78	4.71	4.72	85754.0
2023-12-04	AAIC.C-DELISTED	Stock	24.38	24.4214	24.3171	24.33	637.0
2023-12-04	AAL	Stock	13.03	13.49	12.93	13.35	50756400.0
2023-12-04	AAMC-DELISTED	Stock	3.26	3.4	3.18	3.35	14000.0
2023-12-04	AAME	Stock	1.9	1.94	1.88	1.94	1600.0
2023-12-04	AAMI	Stock	18.0	18.29	17.75	17.91	202800.0
2023-12-04	AAN-DELISTED	Stock	9.44	9.83	9.41	9.8	427000.0
2023-12-04	AAOI	Stock	16.12	17.02	15.99	16.68	3204900.0
2023-12-04	AAON	Stock	62.01	64.6	62.01	64.46	370600.0
2023-12-04	AAP	Stock	54.12	56.0	53.81	55.63	1930700.0
2023-12-04	AAT	Stock	21.0	21.48	21.0	21.35	391600.0
2023-12-04	AATC	Stock	6.55	6.97	6.49	6.85	43362.0
2023-12-04	AAU-DELISTED	Stock	0.145	0.1495	0.1445	0.145	130356.0
2023-12-04	AAUAF-DELISTED	Stock	0.145	0.1495	0.1445	0.145	122822.0
2023-12-04	AAXJ	Stock	65.06	65.18	64.7	64.76	1432193.0
2023-12-04	AB	Stock	28.99	29.31	28.46	28.46	390300.0
2023-12-04	ABAT	Stock	4.41	4.92	4.33	4.54	617099.0
2023-12-04	ABBNY-DELISTED	Stock	39.85	40.02	39.68	39.94	492839.0
2023-12-04	ABBV	Stock	143.41	145.49	143.27	144.15	4845300.0
2023-12-04	ABCB	Stock	44.64	46.5	44.64	46.35	332100.0
2023-12-04	ABCL	Stock	4.81	4.93	4.62	4.64	1842900.0
2023-12-04	ABCM-DELISTED	Stock	23.98	23.99	23.97	23.985	3675930.0
2023-12-04	ABEO	Stock	4.65	4.7	4.32	4.64	408700.0
2023-12-04	ABEV	Stock	2.83	2.85	2.82	2.82	9295600.0
2023-12-04	ABG	Stock	217.4	222.72	216.75	222.71	146600.0
2023-12-04	ABLLW	Stock	0.3802	0.4	0.34	0.34	9668.0
2023-12-04	ABLV	Stock	2.871	2.871	2.61	2.66	17500.0
2023-12-04	ABM	Stock	41.93	43.01	41.93	42.91	288600.0
2023-12-04	ABNB	Stock	134.0	136.75	132.72	133.7	5263400.0
2023-12-04	ABOS	Stock	2.62	2.719	2.58	2.69	760000.0
2023-12-04	ABR	Stock	13.42	13.86	13.4	13.86	6142500.0
2023-12-04	ABR.D	Stock	17.28	17.45	17.13	17.29	41129.0
2023-12-04	ABR.E	Stock	17.1	17.3005	17.098	17.2	8102.0
2023-12-04	ABR.F	Stock	19.23	19.35	19.2	19.26	33294.0
2023-12-04	ABSI	Stock	2.07	2.43	1.74	1.96	3600600.0

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

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