PREVIEW / stock_daily / 2023-10-19

all stock daily files

  file:    by_date/stock_daily/2023/2023-10-19.parquet
  size:    233 KB
  rows:    7,318
  symbols: 1,332

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-10-19	AAPL	Stock	176.04	177.84	175.19	175.46	59302900.0
2023-10-19	MSFT	Stock	332.15	336.88	330.91	331.32	25052100.0
2023-10-19	NVDA	Stock	42.811	43.297	41.882	42.101	501233000.0
2023-10-19	AMZN	Stock	130.57	132.24	127.47	128.4	60961400.0
2023-10-19	GOOGL	Stock	138.5	139.66	137.38	137.75	26066011.0
2023-10-19	META	Stock	319.88	321.89	311.75	312.81	18709200.0
2023-10-19	TSLA	Stock	225.95	230.61	216.78	220.11	170772700.0
2023-10-19	TLT	Stock	83.88	84.57	82.74	82.77	87696929.0
2023-10-19	ES	Stock	54.28	54.93	53.81	53.9	2376500.0
2023-10-19	CL	Stock	73.25	73.72	72.56	73.19	8005100.0
2023-10-19	A	Stock	109.25	111.38	108.86	109.51	2028900.0
2023-10-19	AA	Stock	26.16	26.22	24.215	24.24	13580600.0
2023-10-19	AAC-DELISTED	Stock	10.77	10.77	10.76	10.76	41335.0
2023-10-19	AACG	Stock	1.1	1.12	1.02	1.03	1500.0
2023-10-19	AACT	Stock	10.3	10.3	10.27	10.27	457500.0
2023-10-19	AAIC-DELISTED	Stock	4.37	4.395	4.3	4.315	45636.0
2023-10-19	AAIC.C-DELISTED	Stock	23.8725	23.8725	23.7	23.7	5107.0
2023-10-19	AAL	Stock	11.35	12.01	11.35	11.45	63900500.0
2023-10-19	AAMC-DELISTED	Stock	3.8765	3.8824	3.8294	3.8529	12240.0
2023-10-19	AAME	Stock	1.93	1.93	1.93	1.93	1000.0
2023-10-19	AAMI	Stock	17.21	17.35	16.92	16.94	102600.0
2023-10-19	AAN-DELISTED	Stock	9.72	9.725	9.23	9.33	416700.0
2023-10-19	AAOI	Stock	7.58	7.72	7.287	7.45	1391500.0
2023-10-19	AAON	Stock	53.65	53.96	52.79	52.85	606100.0
2023-10-19	AAP	Stock	52.89	53.56	51.04	51.3	1751800.0
2023-10-19	AAT	Stock	18.38	18.79	18.07	18.08	201900.0
2023-10-19	AATC	Stock	5.55	5.55	5.525	5.525	226.0
2023-10-19	AAU-DELISTED	Stock	0.14	0.1433	0.13	0.136	587367.0
2023-10-19	AAUAF-DELISTED	Stock	0.14	0.1433	0.13	0.136	589107.0
2023-10-19	AAXJ	Stock	62.6	62.935	62.4	62.47	610200.0
2023-10-19	AB	Stock	29.24	29.41	28.73	29.31	394800.0
2023-10-19	ABAT	Stock	6.9	7.1697	6.68	6.73	169059.0
2023-10-19	ABBNY-DELISTED	Stock	33.63	34.005	33.63	33.9	388020.0
2023-10-19	ABBV	Stock	148.55	148.55	143.33	145.52	6147100.0
2023-10-19	ABCB	Stock	37.74	38.41	37.08	37.2	407200.0
2023-10-19	ABCL	Stock	4.33	4.42	4.27	4.29	1428500.0
2023-10-19	ABCM-DELISTED	Stock	22.9	22.92	22.71	22.75	8207547.0
2023-10-19	ABEO	Stock	4.27	4.35	4.22	4.28	34000.0
2023-10-19	ABEV	Stock	2.46	2.51	2.45	2.45	8848800.0
2023-10-19	ABG	Stock	211.72	213.68	206.1	207.05	153100.0
2023-10-19	ABLLW	Stock	0.3366	0.3366	0.3	0.335	46101.0
2023-10-19	ABLV	Stock	2.83	2.83	2.72	2.79	3300.0
2023-10-19	ABM	Stock	41.94	42.27	41.35	41.53	315700.0
2023-10-19	ABNB	Stock	122.39	123.48	119.33	119.97	4374400.0
2023-10-19	ABOS	Stock	3.56	3.622	3.41	3.49	421500.0
2023-10-19	ABR	Stock	14.21	14.39	13.94	13.94	2833000.0
2023-10-19	ABR.D	Stock	16.71	16.8	16.4105	16.6	18142.0
2023-10-19	ABR.E	Stock	16.84	16.8495	16.4	16.53	5705.0
2023-10-19	ABR.F	Stock	17.89	17.89	17.65	17.84	7264.0
2023-10-19	ABSI	Stock	1.4	1.4	1.31	1.34	222400.0

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

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