PREVIEW / stock_daily / 2023-08-11

all stock daily files

  file:    by_date/stock_daily/2023/2023-08-11.parquet
  size:    239 KB
  rows:    7,428
  symbols: 1,486

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-08-11	AAPL	Stock	177.32	178.62	176.55	177.79	51988100.0
2023-08-11	MSFT	Stock	320.26	322.41	319.21	321.01	24342600.0
2023-08-11	NVDA	Stock	41.751	42.018	40.639	40.855	533085000.0
2023-08-11	AMZN	Stock	137.4	139.33	137.0	138.41	42832100.0
2023-08-11	GOOGL	Stock	128.66	129.93	128.17	129.56	19591080.0
2023-08-11	META	Stock	302.57	304.72	300.36	301.64	13967800.0
2023-08-11	TSLA	Stock	241.77	243.79	238.02	242.65	98866600.0
2023-08-11	TLT	Stock	95.3	95.865	95.2	95.37	26753471.0
2023-08-11	ES	Stock	66.49	67.05	66.2	67.04	1473600.0
2023-08-11	CL	Stock	76.46	76.92	76.26	76.9	2742300.0
2023-08-11	A	Stock	126.77	127.82	126.35	126.86	1256700.0
2023-08-11	AA	Stock	32.465	32.495	31.809	31.96	4730900.0
2023-08-11	AAC-DELISTED	Stock	10.65	10.65	10.635	10.64	3467.0
2023-08-11	AACG	Stock	1.27	1.33	1.23	1.29	9200.0
2023-08-11	AACIW-DELISTED	Stock	0.0981	0.1	0.0976	0.0999	2400.0
2023-08-11	AACT	Stock	10.21	10.21	10.2	10.2	37600.0
2023-08-11	AAIC-DELISTED	Stock	4.54	4.54	4.48	4.51	42563.0
2023-08-11	AAIC.C-DELISTED	Stock	23.4997	23.7163	23.35	23.6999	4960.0
2023-08-11	AAL	Stock	15.66	15.75	15.56	15.65	16049800.0
2023-08-11	AAM.A-DELISTED	Stock	24.2	24.49	24.16	24.42	6596.0
2023-08-11	AAM.B-DELISTED	Stock	23.82	24.63	23.82	24.31	6133.0
2023-08-11	AAMC-DELISTED	Stock	21.1765	22.7588	21.1765	22.0588	23460.0
2023-08-11	AAME	Stock	1.7	1.93	1.7	1.81	2900.0
2023-08-11	AAMI	Stock	20.02	20.098	19.87	19.93	81900.0
2023-08-11	AAN-DELISTED	Stock	13.26	13.32	12.95	13.01	151600.0
2023-08-11	AAOI	Stock	14.0	14.04	12.1	12.39	4768600.0
2023-08-11	AAON	Stock	62.78	63.3733	62.6533	63.08	228600.0
2023-08-11	AAP	Stock	70.87	72.55	70.63	72.28	1182900.0
2023-08-11	AAT	Stock	22.09	22.31	22.08	22.28	145200.0
2023-08-11	AATC	Stock	4.7	5.28	4.7	5.28	50713.0
2023-08-11	AAU-DELISTED	Stock	0.13	0.1398	0.13	0.1337	202275.0
2023-08-11	AAUAF-DELISTED	Stock	0.13	0.1398	0.13	0.1337	203430.0
2023-08-11	AAXJ	Stock	66.53	66.79	66.13	66.36	459948.0
2023-08-11	AB	Stock	29.22	30.38	29.2	30.13	262200.0
2023-08-11	ABBNY-DELISTED	Stock	38.29	38.614	38.29	38.52	105994.0
2023-08-11	ABBV	Stock	151.95	153.5	151.72	152.18	3454800.0
2023-08-11	ABC-DELISTED	Stock	187.09	187.85	186.33	187.37	1757618.0
2023-08-11	ABCB	Stock	43.26	44.28	43.26	44.02	189100.0
2023-08-11	ABCL	Stock	5.83	5.88	5.72	5.76	2414700.0
2023-08-11	ABCM-DELISTED	Stock	22.38	23.35	22.34	23.295	1342045.0
2023-08-11	ABEO	Stock	2.95	3.03	2.94	2.99	28300.0
2023-08-11	ABEV	Stock	2.91	2.93	2.89	2.9	8226300.0
2023-08-11	ABG	Stock	219.41	227.01	218.64	226.09	102000.0
2023-08-11	ABLLW	Stock	0.2339	0.26	0.205	0.26	30462.0
2023-08-11	ABLV	Stock	8.7	9.1	8.22	8.91	13094.0
2023-08-11	ABM	Stock	46.05	46.38	45.91	46.13	332600.0
2023-08-11	ABNB	Stock	134.15	134.26	131.7	133.68	4372200.0
2023-08-11	ABOS	Stock	6.99	7.32	6.86	7.14	388100.0
2023-08-11	ABR	Stock	16.58	16.67	16.47	16.58	2134600.0
2023-08-11	ABR.D	Stock	18.718	18.8	18.54	18.7	11363.0

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

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