PREVIEW / stock_daily / 2023-09-12

all stock daily files

  file:    by_date/stock_daily/2023/2023-09-12.parquet
  size:    236 KB
  rows:    7,380
  symbols: 1,422

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-12	AAPL	Stock	179.49	180.13	174.82	176.3	90370200.0
2023-09-12	MSFT	Stock	335.82	336.79	331.48	331.77	17565500.0
2023-09-12	NVDA	Stock	44.738	45.673	44.531	44.87	349256000.0
2023-09-12	AMZN	Stock	142.32	143.0	140.61	141.23	42668500.0
2023-09-12	GOOGL	Stock	136.26	136.8701	135.19	135.34	18405505.0
2023-09-12	META	Stock	306.33	308.66	300.23	301.66	13480400.0
2023-09-12	TSLA	Stock	270.76	278.39	266.6	267.48	135999900.0
2023-09-12	TLT	Stock	93.89	94.24	93.5808	94.23	20034330.0
2023-09-12	ES	Stock	62.53	62.65	61.73	62.39	1905100.0
2023-09-12	CL	Stock	73.99	73.99	72.49	72.52	3639400.0
2023-09-12	A	Stock	113.4	113.97	112.08	112.78	2035000.0
2023-09-12	AA	Stock	28.45	28.82	28.12	28.2	3630500.0
2023-09-12	AAC-DELISTED	Stock	10.71	10.715	10.69	10.71	34835.0
2023-09-12	AACG	Stock	1.16	1.16	1.16	1.16	500.0
2023-09-12	AACT	Stock	10.26	10.26	10.23	10.23	56800.0
2023-09-12	AAIC-DELISTED	Stock	4.57	4.63	4.57	4.59	44638.0
2023-09-12	AAIC.C-DELISTED	Stock	24.535	24.535	24.38	24.41	1500.0
2023-09-12	AAL	Stock	14.19	14.29	14.08	14.11	20755000.0
2023-09-12	AAM.A-DELISTED	Stock	25.0	25.0	24.98	24.98	12535.0
2023-09-12	AAM.B-DELISTED	Stock	24.98	24.9954	24.98	24.99	6328.0
2023-09-12	AAMC-DELISTED	Stock	4.1353	4.1765	3.8294	4.0294	41820.0
2023-09-12	AAME	Stock	1.83	1.98	1.83	1.88	5200.0
2023-09-12	AAMI	Stock	20.33	20.56	20.33	20.45	180800.0
2023-09-12	AAN-DELISTED	Stock	10.27	10.36	10.0	10.13	612700.0
2023-09-12	AAOI	Stock	11.65	12.55	11.31	11.36	1814500.0
2023-09-12	AAON	Stock	64.4	65.07	62.74	62.94	529100.0
2023-09-12	AAP	Stock	60.59	61.48	57.46	57.46	5582400.0
2023-09-12	AAT	Stock	20.45	20.6	20.38	20.59	270200.0
2023-09-12	AATC	Stock	6.025	6.05	6.025	6.05	1520.0
2023-09-12	AAU-DELISTED	Stock	0.123	0.127	0.123	0.1255	95000.0
2023-09-12	AAUAF-DELISTED	Stock	0.123	0.127	0.123	0.127	93398.0
2023-09-12	AAXJ	Stock	65.14	65.6	65.07	65.43	386265.0
2023-09-12	AB	Stock	31.71	32.49	31.71	32.23	263100.0
2023-09-12	ABBNY-DELISTED	Stock	36.71	36.99	36.69	36.8	138127.0
2023-09-12	ABBV	Stock	149.5	149.6	147.62	149.27	2424800.0
2023-09-12	ABCB	Stock	38.98	39.33	38.59	39.16	422900.0
2023-09-12	ABCL	Stock	5.33	5.33	5.13	5.14	1853800.0
2023-09-12	ABCM-DELISTED	Stock	22.87	22.88	22.71	22.77	5458936.0
2023-09-12	ABEO	Stock	4.34	4.4	4.19	4.19	42200.0
2023-09-12	ABEV	Stock	2.75	2.75	2.72	2.73	8301900.0
2023-09-12	ABG	Stock	220.34	223.86	218.77	222.61	153400.0
2023-09-12	ABLLW	Stock	0.4599	0.46	0.38	0.425	181883.0
2023-09-12	ABLV	Stock	2.83	3.22	2.83	3.14	17500.0
2023-09-12	ABLVW	Stock	0.0255	0.051	0.0255	0.051	1013.0
2023-09-12	ABM	Stock	39.0	39.76	39.0	39.37	439500.0
2023-09-12	ABNB	Stock	146.88	151.155	146.82	147.5	7342700.0
2023-09-12	ABOS	Stock	5.61	5.71	5.51	5.53	124000.0
2023-09-12	ABR	Stock	15.9	16.01	15.73	15.74	1660300.0
2023-09-12	ABR.D	Stock	18.93	18.93	18.862	18.87	1651.0
2023-09-12	ABR.E	Stock	18.75	18.75	18.525	18.5274	2624.0

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

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