PREVIEW / stock_daily / 2023-09-14

all stock daily files

  file:    by_date/stock_daily/2023/2023-09-14.parquet
  size:    237 KB
  rows:    7,379
  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-14	AAPL	Stock	174.0	176.1	173.58	175.74	60895800.0
2023-09-14	MSFT	Stock	339.15	340.86	336.57	338.7	20267000.0
2023-09-14	NVDA	Stock	45.95	45.987	45.131	45.581	370097000.0
2023-09-14	AMZN	Stock	145.08	145.86	142.95	144.72	64033600.0
2023-09-14	GOOGL	Stock	137.6	138.695	136.24	138.1	24750968.0
2023-09-14	META	Stock	306.74	312.87	305.03	311.72	19343100.0
2023-09-14	TSLA	Stock	271.32	276.71	270.42	276.04	107709800.0
2023-09-14	TLT	Stock	93.94	94.21	93.4	93.53	27800615.0
2023-09-14	ES	Stock	63.89	64.46	63.74	64.44	2596500.0
2023-09-14	CL	Stock	72.89	73.47	72.57	73.46	3409500.0
2023-09-14	A	Stock	113.79	115.31	111.68	114.88	1815800.0
2023-09-14	AA	Stock	29.52	30.3	29.414	30.19	6722600.0
2023-09-14	AAC-DELISTED	Stock	10.72	10.73	10.7	10.72	180383.0
2023-09-14	AACG	Stock	1.13	1.19	1.13	1.14	5300.0
2023-09-14	AACIW-DELISTED	Stock	0.09	0.09	0.09	0.09	100.0
2023-09-14	AACT	Stock	10.24	10.25	10.235	10.24	47100.0
2023-09-14	AAIC-DELISTED	Stock	4.54	4.65	4.54	4.6	198201.0
2023-09-14	AAIC.C-DELISTED	Stock	24.4367	24.5037	24.42	24.4797	2535.0
2023-09-14	AAL	Stock	13.44	13.47	13.15	13.26	31461300.0
2023-09-14	AAM.A-DELISTED	Stock	25.02	25.02	24.99	25.02	21478.0
2023-09-14	AAM.B-DELISTED	Stock	24.99	25.01	24.99	25.01	4246.0
2023-09-14	AAMC-DELISTED	Stock	4.2118	4.3529	4.0471	4.0471	49130.0
2023-09-14	AAME	Stock	2.0	2.0	1.87	1.95	3200.0
2023-09-14	AAMI	Stock	20.43	20.59	20.25	20.3	118900.0
2023-09-14	AAN-DELISTED	Stock	10.17	10.49	10.09	10.42	692100.0
2023-09-14	AAOI	Stock	9.16	10.12	9.16	9.755	3323000.0
2023-09-14	AAON	Stock	61.56	62.25	60.56	60.94	574300.0
2023-09-14	AAP	Stock	58.47	59.66	58.2	59.62	2431700.0
2023-09-14	AAT	Stock	20.49	20.83	20.49	20.78	321600.0
2023-09-14	AATC	Stock	6.03	6.11	6.03	6.05	1374.0
2023-09-14	AAU-DELISTED	Stock	0.124	0.1389	0.124	0.13	245751.0
2023-09-14	AAUAF-DELISTED	Stock	0.124	0.1389	0.124	0.13	247800.0
2023-09-14	AAXJ	Stock	65.83	65.92	65.55	65.78	211591.0
2023-09-14	AB	Stock	31.99	32.39	31.92	32.29	321200.0
2023-09-14	ABBNY-DELISTED	Stock	36.15	36.4	36.02	36.22	315567.0
2023-09-14	ABBV	Stock	152.01	154.69	151.8	153.64	6336900.0
2023-09-14	ABCB	Stock	39.01	39.61	38.55	39.6	400300.0
2023-09-14	ABCL	Stock	5.28	5.315	5.16	5.17	1107300.0
2023-09-14	ABCM-DELISTED	Stock	22.8	22.91	22.72	22.74	3078400.0
2023-09-14	ABEO	Stock	4.24	4.3	4.07	4.1	81800.0
2023-09-14	ABEV	Stock	2.75	2.77	2.72	2.73	19488200.0
2023-09-14	ABG	Stock	222.46	234.56	222.46	234.19	266100.0
2023-09-14	ABLLW	Stock	0.4	0.4263	0.3999	0.4	54064.0
2023-09-14	ABLV	Stock	3.08	3.14	3.01	3.06	22200.0
2023-09-14	ABM	Stock	40.57	41.61	40.57	41.45	540100.0
2023-09-14	ABNB	Stock	144.61	145.72	141.69	144.12	8365500.0
2023-09-14	ABOS	Stock	5.49	5.73	5.45	5.51	168800.0
2023-09-14	ABR	Stock	15.85	15.93	15.75	15.87	1404000.0
2023-09-14	ABR.D	Stock	18.8	18.9316	18.7487	18.86	6312.0
2023-09-14	ABR.E	Stock	18.61	18.61	18.335	18.44	1016.0

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

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