PREVIEW / stock_daily / 2023-08-22

all stock daily files

  file:    by_date/stock_daily/2023/2023-08-22.parquet
  size:    238 KB
  rows:    7,418
  symbols: 1,462

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-22	AAPL	Stock	177.06	177.68	176.25	177.23	42084200.0
2023-08-22	MSFT	Stock	325.5	326.08	321.46	322.46	16102000.0
2023-08-22	NVDA	Stock	48.135	48.187	45.333	45.668	755293000.0
2023-08-22	AMZN	Stock	135.08	135.65	133.73	134.25	32935100.0
2023-08-22	GOOGL	Stock	128.51	130.278	128.32	129.08	22067520.0
2023-08-22	META	Stock	292.55	292.9	286.75	287.6	12999900.0
2023-08-22	TSLA	Stock	240.25	240.82	229.55	233.19	130597900.0
2023-08-22	TLT	Stock	92.64	93.275	92.46	93.23	21323072.0
2023-08-22	ES	Stock	63.84	64.22	63.52	63.87	1271400.0
2023-08-22	CL	Stock	73.59	73.79	73.13	73.51	3096500.0
2023-08-22	A	Stock	117.85	118.61	117.33	117.64	1422300.0
2023-08-22	AA	Stock	28.91	29.09	28.18	28.78	4594300.0
2023-08-22	AAC-DELISTED	Stock	10.66	10.68	10.655	10.68	95891.0
2023-08-22	AACG	Stock	1.24	1.24	1.21	1.23	1700.0
2023-08-22	AACT	Stock	10.21	10.21	10.2	10.2	57400.0
2023-08-22	AAIC-DELISTED	Stock	4.43	4.45	4.375	4.39	51286.0
2023-08-22	AAIC.C-DELISTED	Stock	23.99	23.99	23.9	23.9001	2650.0
2023-08-22	AAL	Stock	15.3	15.33	14.82	14.83	25084500.0
2023-08-22	AAM.A-DELISTED	Stock	25.2	25.24	25.2	25.22	43107.0
2023-08-22	AAM.B-DELISTED	Stock	25.27	25.27	25.22	25.22	5549.0
2023-08-22	AAMC-DELISTED	Stock	5.2176	5.3706	4.8294	4.8765	97410.0
2023-08-22	AAME	Stock	1.93	2.01	1.91	1.91	1900.0
2023-08-22	AAMI	Stock	20.81	21.08	20.57	20.8	176300.0
2023-08-22	AAN-DELISTED	Stock	12.55	12.62	11.97	11.99	219200.0
2023-08-22	AAOI	Stock	15.54	16.15	14.63	15.48	3934800.0
2023-08-22	AAON	Stock	62.4	62.47	58.75	59.79	773400.0
2023-08-22	AAP	Stock	67.0	68.07	66.56	67.34	3549400.0
2023-08-22	AAT	Stock	20.68	20.81	20.41	20.46	151600.0
2023-08-22	AATC	Stock	5.81	5.86	5.76	5.82	4679.0
2023-08-22	AAU-DELISTED	Stock	0.1282	0.1282	0.121	0.1222	105540.0
2023-08-22	AAUAF-DELISTED	Stock	0.1282	0.1282	0.121	0.123	108740.0
2023-08-22	AAXJ	Stock	64.41	64.41	63.84	64.0	1785952.0
2023-08-22	AB	Stock	30.51	30.51	29.41	29.58	375800.0
2023-08-22	ABBNY-DELISTED	Stock	37.21	37.32	36.98	37.04	542461.0
2023-08-22	ABBV	Stock	150.0	150.0	147.97	148.24	3209900.0
2023-08-22	ABC-DELISTED	Stock	180.77	181.05	177.92	177.96	772602.0
2023-08-22	ABCB	Stock	40.66	41.01	39.18	39.29	246600.0
2023-08-22	ABCL	Stock	5.58	5.63	5.37	5.5	1411600.0
2023-08-22	ABCM-DELISTED	Stock	22.33	22.43	22.115	22.18	683813.0
2023-08-22	ABEO	Stock	3.92	3.92	3.67	3.77	110100.0
2023-08-22	ABEV	Stock	2.87	2.92	2.86	2.88	10423900.0
2023-08-22	ABG	Stock	218.94	221.14	217.96	219.06	115800.0
2023-08-22	ABLLW	Stock	0.3397	0.3925	0.3366	0.34	83806.0
2023-08-22	ABLV	Stock	5.1	5.35	4.91	5.01	74076.0
2023-08-22	ABLVW	Stock	0.0735	0.0735	0.04	0.04	12799.0
2023-08-22	ABM	Stock	45.1	45.32	44.74	44.74	265900.0
2023-08-22	ABNB	Stock	124.25	127.24	124.001	127.08	4946000.0
2023-08-22	ABOS	Stock	6.59	6.78	6.42	6.46	329000.0
2023-08-22	ABR	Stock	15.41	15.48	15.02	15.05	1970200.0
2023-08-22	ABR.D	Stock	18.4327	18.4327	18.17	18.24	7782.0

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

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