PREVIEW / stock_daily / 2023-08-09

all stock daily files

  file:    by_date/stock_daily/2023/2023-08-09.parquet
  size:    239 KB
  rows:    7,433
  symbols: 1,502

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-09	AAPL	Stock	180.87	180.93	177.01	178.19	60378500.0
2023-08-09	MSFT	Stock	326.47	327.11	321.05	322.23	22373300.0
2023-08-09	NVDA	Stock	44.274	44.312	42.134	42.554	586449000.0
2023-08-09	AMZN	Stock	139.97	140.32	137.1	137.85	50017300.0
2023-08-09	GOOGL	Stock	131.66	132.04	129.0	129.66	24912918.0
2023-08-09	META	Stock	312.88	313.63	302.85	305.21	19955800.0
2023-08-09	TSLA	Stock	250.87	251.1	241.9	242.19	101596300.0
2023-08-09	TLT	Stock	96.88	97.29	96.84	97.19	20151127.0
2023-08-09	ES	Stock	66.72	67.9	66.63	67.29	1546100.0
2023-08-09	CL	Stock	76.38	77.01	76.29	76.49	3314900.0
2023-08-09	A	Stock	128.16	129.42	127.53	127.63	1786100.0
2023-08-09	AA	Stock	33.48	34.09	33.03	33.62	4132700.0
2023-08-09	AAC-DELISTED	Stock	10.63	10.64	10.625	10.63	30644.0
2023-08-09	AACG	Stock	1.2	1.33	1.18	1.25	31200.0
2023-08-09	AACIW-DELISTED	Stock	0.068	0.07	0.068	0.07	700.0
2023-08-09	AACT	Stock	10.19	10.19	10.19	10.19	48500.0
2023-08-09	AAIC-DELISTED	Stock	4.41	4.55	4.41	4.5	38770.0
2023-08-09	AAIC.C-DELISTED	Stock	23.4	23.45	23.4	23.45	1050.0
2023-08-09	AAL	Stock	16.19	16.24	15.72	15.76	18744600.0
2023-08-09	AAM.A-DELISTED	Stock	24.28	24.35	24.16	24.32	13014.0
2023-08-09	AAM.B-DELISTED	Stock	24.3065	24.484	24.0401	24.265	5935.0
2023-08-09	AAMC-DELISTED	Stock	23.6765	24.1118	21.8294	22.1765	49980.0
2023-08-09	AAME	Stock	1.78	1.88	1.7	1.84	5400.0
2023-08-09	AAMI	Stock	20.07	20.33	19.85	20.16	109200.0
2023-08-09	AAN-DELISTED	Stock	13.72	13.72	13.27	13.59	232800.0
2023-08-09	AAOI	Stock	12.26	12.38	11.43	12.16	2767700.0
2023-08-09	AAON	Stock	64.08	64.08	61.8267	63.22	333300.0
2023-08-09	AAP	Stock	70.31	72.0	70.25	71.2	1158800.0
2023-08-09	AAT	Stock	22.44	22.55	22.16	22.38	270200.0
2023-08-09	AATC	Stock	4.51	4.51	4.41	4.41	7613.0
2023-08-09	AAU-DELISTED	Stock	0.141	0.1458	0.13	0.1319	449752.0
2023-08-09	AAUAF-DELISTED	Stock	0.141	0.1458	0.13	0.133	452875.0
2023-08-09	AAXJ	Stock	67.64	67.69	67.17	67.39	375547.0
2023-08-09	AB	Stock	30.12	30.39	29.21	29.4	529000.0
2023-08-09	ABBNY-DELISTED	Stock	39.23	39.35	39.1	39.15	135975.0
2023-08-09	ABBV	Stock	150.49	152.06	149.91	150.77	3737100.0
2023-08-09	ABC-DELISTED	Stock	186.0	186.85	184.85	185.72	1958755.0
2023-08-09	ABCB	Stock	44.2	44.5	43.58	43.75	234700.0
2023-08-09	ABCL	Stock	5.89	6.045	5.805	6.02	2584100.0
2023-08-09	ABCM-DELISTED	Stock	22.54	22.61	21.98	22.18	576359.0
2023-08-09	ABEO	Stock	2.99	3.07	2.96	3.0	51900.0
2023-08-09	ABEV	Stock	2.92	2.93	2.89	2.91	12669000.0
2023-08-09	ABG	Stock	220.9	223.42	218.29	223.21	145500.0
2023-08-09	ABLLW	Stock	0.2125	0.22	0.2	0.2	97221.0
2023-08-09	ABLV	Stock	8.78	9.09	8.0001	8.57	4486.0
2023-08-09	ABM	Stock	45.93	46.73	45.69	46.44	258300.0
2023-08-09	ABNB	Stock	140.14	140.55	137.33	137.87	3389700.0
2023-08-09	ABOS	Stock	7.0	7.064	6.66	6.78	532000.0
2023-08-09	ABR	Stock	16.5	16.75	16.47	16.51	3655800.0
2023-08-09	ABR.D	Stock	18.76	19.05	18.76	19.05	2954.0

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

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