PREVIEW / stock_daily / 2023-09-22

all stock daily files

  file:    by_date/stock_daily/2023/2023-09-22.parquet
  size:    237 KB
  rows:    7,401
  symbols: 1,415

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-09-22	AAPL	Stock	174.67	177.08	174.05	174.79	56725400.0
2023-09-22	MSFT	Stock	321.32	321.45	316.15	317.01	21447900.0
2023-09-22	NVDA	Stock	41.572	42.115	41.231	41.61	479236000.0
2023-09-22	AMZN	Stock	131.11	132.03	128.52	129.12	59904300.0
2023-09-22	GOOGL	Stock	130.76	132.025	129.6	130.25	26397337.0
2023-09-22	META	Stock	299.3	305.38	298.27	299.08	25369600.0
2023-09-22	TSLA	Stock	257.4	257.79	244.48	244.88	127524100.0
2023-09-22	TLT	Stock	90.81	91.605	90.67	91.43	29530323.0
2023-09-22	ES	Stock	63.08	63.16	62.38	62.58	2179700.0
2023-09-22	CL	Stock	73.32	73.68	72.34	72.45	4242600.0
2023-09-22	A	Stock	109.73	112.16	109.11	111.41	2050500.0
2023-09-22	AA	Stock	28.27	28.596	28.05	28.35	5095000.0
2023-09-22	AAC-DELISTED	Stock	10.7339	10.74	10.725	10.725	4310.0
2023-09-22	AACG	Stock	1.14	1.14	1.14	1.14	600.0
2023-09-22	AACIW-DELISTED	Stock	0.0571	0.0571	0.0571	0.0571	1000.0
2023-09-22	AACT	Stock	10.26	10.265	10.26	10.26	104500.0
2023-09-22	AAIC-DELISTED	Stock	4.39	4.41	4.34	4.36	70237.0
2023-09-22	AAIC.C-DELISTED	Stock	24.0759	24.08	24.0759	24.08	200.0
2023-09-22	AAL	Stock	13.09	13.16	12.86	12.9	24670900.0
2023-09-22	AAMC-DELISTED	Stock	4.0882	4.4353	4.0353	4.0588	84150.0
2023-09-22	AAME	Stock	1.99	1.99	1.9	1.95	8400.0
2023-09-22	AAMI	Stock	20.25	20.5	20.07	20.09	191800.0
2023-09-22	AAN-DELISTED	Stock	10.72	10.843	10.42	10.45	415000.0
2023-09-22	AAOI	Stock	9.47	9.69	9.29	9.58	1536700.0
2023-09-22	AAON	Stock	56.66	57.73	56.53	56.95	353900.0
2023-09-22	AAP	Stock	58.64	58.89	57.17	57.6	1566200.0
2023-09-22	AAT	Stock	19.29	19.56	18.98	19.0	439700.0
2023-09-22	AATC	Stock	6.126	6.13	6.09	6.09	1417.0
2023-09-22	AAU-DELISTED	Stock	0.1269	0.135	0.125	0.1339	156843.0
2023-09-22	AAUAF-DELISTED	Stock	0.1269	0.135	0.125	0.1339	164494.0
2023-09-22	AAXJ	Stock	64.71	64.73	64.345	64.42	297690.0
2023-09-22	AB	Stock	31.94	32.2	31.27	31.32	203200.0
2023-09-22	ABAT	Stock	10.79	11.2	10.57	10.85	334424.0
2023-09-22	ABBNY-DELISTED	Stock	35.5	35.73	35.44	35.54	353515.0
2023-09-22	ABBV	Stock	153.9	153.9	152.52	152.74	3049200.0
2023-09-22	ABCB	Stock	37.5	37.78	36.77	37.18	326200.0
2023-09-22	ABCL	Stock	4.93	5.0	4.88	5.0	2438400.0
2023-09-22	ABCM-DELISTED	Stock	22.6	22.65	22.55	22.55	9015500.0
2023-09-22	ABEO	Stock	3.61	3.95	3.61	3.79	109800.0
2023-09-22	ABEV	Stock	2.67	2.67	2.63	2.63	11873200.0
2023-09-22	ABG	Stock	227.64	231.46	222.2	223.0	260700.0
2023-09-22	ABLLW	Stock	0.3497	0.3498	0.271	0.297	281830.0
2023-09-22	ABLV	Stock	3.35	3.58	3.21	3.37	13600.0
2023-09-22	ABLVW	Stock	0.0589	0.0589	0.0589	0.0589	100.0
2023-09-22	ABM	Stock	40.05	40.23	39.4	39.44	535000.0
2023-09-22	ABNB	Stock	133.71	134.184	131.12	132.2	4278500.0
2023-09-22	ABOS	Stock	4.73	4.86	4.42	4.45	271800.0
2023-09-22	ABR	Stock	15.01	15.07	14.85	14.89	2185800.0
2023-09-22	ABR.D	Stock	18.41	18.78	18.41	18.5	5263.0
2023-09-22	ABR.E	Stock	18.615	18.615	18.615	18.615	405.0

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

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