PREVIEW / stock_daily / 2025-07-18

all stock daily files

  file:    by_date/stock_daily/2025/2025-07-18.parquet
  size:    246 KB
  rows:    7,114
  symbols: 309

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
2025-07-18	AAPL	Stock	210.87	211.79	209.7045	211.18	48642279.0
2025-07-18	MSFT	Stock	514.48	514.64	507.43	510.05	21202752.0
2025-07-18	NVDA	Stock	173.64	174.25	171.26	172.41	146224352.0
2025-07-18	AMZN	Stock	225.14	226.4	222.98	226.13	37802538.0
2025-07-18	GOOGL	Stock	185.4	186.42	183.71	185.06	34014509.0
2025-07-18	META	Stock	702.19	704.71	691.65	704.28	12817211.0
2025-07-18	TSLA	Stock	321.66	330.9	321.42	329.65	94340432.0
2025-07-18	TLT	Stock	85.43	85.46	85.1	85.24	27534948.0
2025-07-18	ES	Stock	64.79	65.55	64.79	65.41	3868760.0
2025-07-18	CL	Stock	86.7	87.51	86.5	86.84	4973725.0
2025-07-18	A	Stock	116.82	117.2	113.53	113.99	1521783.0
2025-07-18	AA	Stock	29.78	30.6799	29.29	30.33	7414425.0
2025-07-18	AACBR	Stock	0.174	0.27	0.1739	0.27	628.0
2025-07-18	AACG	Stock	0.834	0.853	0.81561	0.82	45808.0
2025-07-18	AACIW	Stock	0.2678	0.2796	0.26	0.2697	1263.0
2025-07-18	AACT	Stock	11.39	11.39	11.35	11.36	99609.0
2025-07-18	AAGR-DELISTED	Stock	0.0001	0.01	0.0001	0.0001	18240.0
2025-07-18	AAL	Stock	12.52	12.59	12.2	12.51	70388801.0
2025-07-18	AAM	Stock	10.45	10.46	10.45	10.45	566828.0
2025-07-18	AAME	Stock	2.2061	2.26	2.16	2.175	6417.0
2025-07-18	AAMI	Stock	40.15	40.5689	39.82	40.06	220750.0
2025-07-18	AAOI	Stock	30.0	30.2	27.63	28.63	3933787.0
2025-07-18	AAON	Stock	79.75	79.75	77.59	78.69	2237021.0
2025-07-18	AAP	Stock	61.61	61.62	60.67	61.13	1448321.0
2025-07-18	AAPG	Stock	40.0037	41.38	40.0037	40.39	7108.0
2025-07-18	AARD	Stock	12.11	12.11	11.34	11.62	71052.0
2025-07-18	AAT	Stock	20.19	20.32	20.04	20.14	332363.0
2025-07-18	AATC	Stock	7.5	7.507	7.49	7.49	1922.0
2025-07-18	AAUC	Stock	13.22	13.57	12.99	13.52	71272.0
2025-07-18	AAXJ	Stock	85.02	85.08	84.58	84.61	712534.0
2025-07-18	AB	Stock	41.0	41.476	40.888	41.21	162240.0
2025-07-18	ABAT	Stock	2.48	2.48	2.23	2.4	7465974.0
2025-07-18	ABBV	Stock	191.505	192.34	188.57	189.26	5331869.0
2025-07-18	ABCB	Stock	67.69	67.83	66.89	67.34	226882.0
2025-07-18	ABCL	Stock	3.945	4.7	3.94	4.48	11573838.0
2025-07-18	ABEO	Stock	6.71	6.92	6.58	6.59	720488.0
2025-07-18	ABEV	Stock	2.39	2.39	2.33	2.35	26991434.0
2025-07-18	ABG	Stock	232.13	234.36	227.29	229.96	175240.0
2025-07-18	ABI	Stock	25.065	25.065	25.065	25.065	2.0
2025-07-18	ABLLW	Stock	1.14	1.14	1.1201	1.1249	13072.0
2025-07-18	ABLV	Stock	1.07	1.1	1.045	1.06	4634.0
2025-07-18	ABM	Stock	48.53	48.655	47.45	47.72	353423.0
2025-07-18	ABNB	Stock	139.99	140.74	138.92	139.34	2981412.0
2025-07-18	ABOS	Stock	1.49	1.58	1.48	1.5	511937.0
2025-07-18	ABR	Stock	11.41	11.425	11.16	11.21	2353045.0
2025-07-18	ABR.D	Stock	17.77	17.821	17.617	17.617	8491.0
2025-07-18	ABR.E	Stock	17.38	17.455	17.38	17.395	2889.0
2025-07-18	ABR.F	Stock	21.21	21.31	21.21	21.2878	2742.0
2025-07-18	ABSI	Stock	2.9	3.23	2.895	3.12	8711581.0
2025-07-18	ABT	Stock	122.63	125.63	122.27	123.67	19569693.0

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

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