PREVIEW / stock_daily / 2023-09-13

all stock daily files

  file:    by_date/stock_daily/2023/2023-09-13.parquet
  size:    236 KB
  rows:    7,378
  symbols: 1,423

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-13	AAPL	Stock	176.51	177.3	173.98	174.21	84267900.0
2023-09-13	MSFT	Stock	331.31	336.85	331.17	336.06	16544400.0
2023-09-13	NVDA	Stock	44.6	45.93	44.503	45.485	398355000.0
2023-09-13	AMZN	Stock	140.95	144.98	140.87	144.85	60465200.0
2023-09-13	GOOGL	Stock	135.09	136.9	134.15	136.71	20749496.0
2023-09-13	META	Stock	302.36	307.18	301.32	305.06	13210900.0
2023-09-13	TSLA	Stock	270.07	274.98	268.1	271.3	111673700.0
2023-09-13	TLT	Stock	93.92	94.5301	93.82	94.21	23332277.0
2023-09-13	ES	Stock	62.63	63.65	62.6	63.35	1884400.0
2023-09-13	CL	Stock	72.93	73.22	72.47	72.83	3111800.0
2023-09-13	A	Stock	110.0	115.9	109.0	113.43	2520500.0
2023-09-13	AA	Stock	28.22	28.69	28.07	28.65	3960500.0
2023-09-13	AAC-DELISTED	Stock	10.72	10.72	10.705	10.72	126604.0
2023-09-13	AACG	Stock	1.16	1.17	1.16	1.16	1000.0
2023-09-13	AACIW-DELISTED	Stock	0.06	0.08	0.06	0.08	290.0
2023-09-13	AACT	Stock	10.235	10.24	10.235	10.235	8000.0
2023-09-13	AAIC-DELISTED	Stock	4.63	4.63	4.545	4.55	216103.0
2023-09-13	AAIC.C-DELISTED	Stock	24.43	24.43	24.43	24.43	198.0
2023-09-13	AAL	Stock	13.5	13.73	13.2	13.31	58836000.0
2023-09-13	AAM.A-DELISTED	Stock	24.98	25.02	24.98	24.99	29399.0
2023-09-13	AAM.B-DELISTED	Stock	25.0	25.0	24.99	24.99	2279.0
2023-09-13	AAMC-DELISTED	Stock	3.9882	4.1765	3.9235	4.0882	78370.0
2023-09-13	AAME	Stock	1.97	1.97	1.86	1.95	4100.0
2023-09-13	AAMI	Stock	20.44	20.44	20.18	20.26	93400.0
2023-09-13	AAN-DELISTED	Stock	9.94	10.24	9.87	10.05	615100.0
2023-09-13	AAOI	Stock	9.75	10.7	8.818	9.12	6637400.0
2023-09-13	AAON	Stock	62.64	63.69	60.88	61.23	524200.0
2023-09-13	AAP	Stock	57.46	58.31	56.4	57.93	3406600.0
2023-09-13	AAT	Stock	20.66	20.66	20.19	20.23	360900.0
2023-09-13	AATC	Stock	6.0	6.0	5.95	5.95	378.0
2023-09-13	AAU-DELISTED	Stock	0.124	0.1268	0.123	0.125	70280.0
2023-09-13	AAUAF-DELISTED	Stock	0.124	0.1268	0.123	0.125	74297.0
2023-09-13	AAXJ	Stock	65.41	65.52	65.21	65.32	396004.0
2023-09-13	AB	Stock	32.23	32.45	31.88	31.88	230500.0
2023-09-13	ABBNY-DELISTED	Stock	36.04	36.24	35.78	35.83	261373.0
2023-09-13	ABBV	Stock	149.42	152.4	149.05	151.16	5953700.0
2023-09-13	ABCB	Stock	39.36	39.38	38.21	38.55	299400.0
2023-09-13	ABCL	Stock	5.14	5.27	5.12	5.25	1462100.0
2023-09-13	ABCM-DELISTED	Stock	22.81	22.8899	22.66	22.795	3173214.0
2023-09-13	ABEO	Stock	4.25	4.35	4.09	4.2	92400.0
2023-09-13	ABEV	Stock	2.76	2.78	2.74	2.74	28396300.0
2023-09-13	ABG	Stock	222.61	223.11	218.35	220.58	144100.0
2023-09-13	ABLLW	Stock	0.4195	0.4249	0.3775	0.405	23772.0
2023-09-13	ABLV	Stock	3.26	3.27	3.06	3.12	27200.0
2023-09-13	ABLVW	Stock	0.0446	0.0599	0.0252	0.0487	10102.0
2023-09-13	ABM	Stock	39.26	40.44	39.26	40.19	640200.0
2023-09-13	ABNB	Stock	146.0	147.0	143.605	144.715	7893300.0
2023-09-13	ABOS	Stock	5.52	5.622	5.44	5.515	313300.0
2023-09-13	ABR	Stock	15.65	15.81	15.53	15.65	1775600.0
2023-09-13	ABR.D	Stock	18.86	18.86	18.7	18.7	1037.0

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

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