PREVIEW / stock_daily / 2023-12-07

all stock daily files

  file:    by_date/stock_daily/2023/2023-12-07.parquet
  size:    236 KB
  rows:    7,347
  symbols: 1,264

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-07	AAPL	Stock	193.63	195.0	193.59	194.27	47477700.0
2023-12-07	MSFT	Stock	368.23	371.45	366.32	370.95	23118900.0
2023-12-07	NVDA	Stock	45.7	46.629	45.604	46.596	350823000.0
2023-12-07	AMZN	Stock	146.15	147.92	145.34	146.88	52352800.0
2023-12-07	GOOGL	Stock	135.04	138.56	134.7	136.93	56767100.0
2023-12-07	META	Stock	317.77	328.24	317.77	326.59	15905100.0
2023-12-07	TSLA	Stock	241.55	244.08	236.98	242.64	107142300.0
2023-12-07	TLT	Stock	95.18	96.08	95.06	95.32	47970168.0
2023-12-07	ES	Stock	60.75	60.75	59.5	60.37	2712500.0
2023-12-07	CL	Stock	77.62	77.98	77.17	77.62	3107200.0
2023-12-07	A	Stock	129.2	130.48	127.81	128.68	1696600.0
2023-12-07	AA	Stock	25.16	25.29	24.27	24.94	6780000.0
2023-12-07	AACG	Stock	0.86	0.89	0.85	0.89	2500.0
2023-12-07	AACIW-DELISTED	Stock	0.03	0.03	0.0213	0.0256	122420.0
2023-12-07	AACT	Stock	10.37	10.38	10.37	10.38	9800.0
2023-12-07	AAGR-DELISTED	Stock	6.14	8.1899	4.4	4.7	156368.0
2023-12-07	AAGRW-DELISTED	Stock	0.06	0.0625	0.05	0.06	2191.0
2023-12-07	AAIC-DELISTED	Stock	4.63	4.64	4.59	4.62	728673.0
2023-12-07	AAIC.C-DELISTED	Stock	24.49	24.5	24.4881	24.4881	1199.0
2023-12-07	AAL	Stock	13.69	14.15	13.68	13.91	49511700.0
2023-12-07	AAMC-DELISTED	Stock	4.0	6.39	3.9	5.21	3009700.0
2023-12-07	AAME	Stock	1.91	1.93	1.91	1.92	1300.0
2023-12-07	AAMI	Stock	18.07	18.66	17.99	18.65	128100.0
2023-12-07	AAN-DELISTED	Stock	10.16	10.51	10.02	10.46	631000.0
2023-12-07	AAOI	Stock	17.16	18.33	16.8	17.66	2460400.0
2023-12-07	AAON	Stock	63.83	65.27	62.88	65.23	352700.0
2023-12-07	AAP	Stock	55.73	56.55	55.38	56.25	2363900.0
2023-12-07	AAT	Stock	21.31	21.63	21.06	21.48	419500.0
2023-12-07	AATC	Stock	7.195	7.33	7.11	7.33	6171.0
2023-12-07	AAU-DELISTED	Stock	0.147	0.1479	0.1432	0.1451	189151.0
2023-12-07	AAUAF-DELISTED	Stock	0.147	0.1479	0.1432	0.1451	194412.0
2023-12-07	AAXJ	Stock	64.37	64.68	64.31	64.64	296438.0
2023-12-07	AB	Stock	28.5	29.58	28.5	29.4	536400.0
2023-12-07	ABAT	Stock	4.0	4.31	3.95	4.1	426606.0
2023-12-07	ABBNY-DELISTED	Stock	40.48	40.68	40.36	40.62	156116.0
2023-12-07	ABBV	Stock	147.64	148.38	145.2	147.97	7225100.0
2023-12-07	ABCB	Stock	46.0	46.85	45.8	46.8	470400.0
2023-12-07	ABCL	Stock	4.87	4.96	4.79	4.84	854000.0
2023-12-07	ABEO	Stock	4.54	4.79	4.5	4.75	279500.0
2023-12-07	ABEV	Stock	2.89	2.89	2.84	2.84	5484200.0
2023-12-07	ABG	Stock	215.07	215.88	213.01	215.81	91400.0
2023-12-07	ABLLW	Stock	0.3331	0.4	0.32	0.3762	10000.0
2023-12-07	ABLV	Stock	2.45	2.84	2.45	2.84	26800.0
2023-12-07	ABM	Stock	43.11	43.61	42.69	43.6	386600.0
2023-12-07	ABNB	Stock	135.51	141.16	135.43	139.84	7108600.0
2023-12-07	ABOS	Stock	2.84	2.85	2.77	2.81	538700.0
2023-12-07	ABR	Stock	13.17	13.66	13.11	13.64	2981600.0
2023-12-07	ABR.D	Stock	17.15	17.39	17.08	17.08	34322.0
2023-12-07	ABR.E	Stock	17.1603	17.29	17.14	17.14	7847.0
2023-12-07	ABR.F	Stock	19.28	19.3299	18.8	18.8	28018.0

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

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