PREVIEW / stock_daily / 2023-07-25

all stock daily files

  file:    by_date/stock_daily/2023/2023-07-25.parquet
  size:    241 KB
  rows:    7,478
  symbols: 1,528

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-07-25	AAPL	Stock	193.33	194.44	192.92	193.62	37283200.0
2023-07-25	MSFT	Stock	347.11	351.89	345.07	350.98	41637700.0
2023-07-25	NVDA	Stock	44.941	46.183	44.923	45.679	348081000.0
2023-07-25	AMZN	Stock	129.31	129.58	128.53	129.13	39236700.0
2023-07-25	GOOGL	Stock	121.36	123.145	121.02	122.21	52509551.0
2023-07-25	META	Stock	295.19	298.3	291.86	294.47	19585600.0
2023-07-25	TSLA	Stock	272.38	272.9	265.0	265.28	112757300.0
2023-07-25	TLT	Stock	100.83	101.5	100.8	101.17	17160556.0
2023-07-25	ES	Stock	73.72	74.41	73.56	73.89	1497400.0
2023-07-25	CL	Stock	77.83	77.92	77.17	77.84	4787400.0
2023-07-25	A	Stock	125.0	129.55	124.15	127.31	2199400.0
2023-07-25	AA	Stock	34.69	36.34	34.26	35.61	8928600.0
2023-07-25	AAC-DELISTED	Stock	10.59	10.61	10.59	10.59	1126012.0
2023-07-25	AACG	Stock	1.44	1.44	1.31	1.38	16200.0
2023-07-25	AACIW-DELISTED	Stock	0.064	0.064	0.064	0.064	1655.0
2023-07-25	AACT	Stock	10.17	10.19	10.17	10.19	82400.0
2023-07-25	AAIC-DELISTED	Stock	4.68	4.77	4.65	4.715	89356.0
2023-07-25	AAIC.C-DELISTED	Stock	23.64	23.64	23.5	23.5	400.0
2023-07-25	AAL	Stock	16.55	16.83	16.19	16.65	40053800.0
2023-07-25	AAM.A-DELISTED	Stock	23.68	23.99	23.0869	23.7235	12409.0
2023-07-25	AAM.B-DELISTED	Stock	23.4	24.0	22.95	23.98	18067.0
2023-07-25	AAMC-DELISTED	Stock	26.9412	27.0471	24.6176	25.0059	86360.0
2023-07-25	AAME	Stock	1.83	1.89	1.83	1.87	1800.0
2023-07-25	AAMI	Stock	22.16	22.479	22.0	22.05	435400.0
2023-07-25	AAN-DELISTED	Stock	15.97	15.97	15.33	15.39	159800.0
2023-07-25	AAOI	Stock	8.48	9.0	8.22	8.43	1809900.0
2023-07-25	AAON	Stock	67.44	67.9933	66.0467	67.4467	385500.0
2023-07-25	AAP	Stock	72.9	72.93	71.1	71.55	1490700.0
2023-07-25	AAT	Stock	22.31	22.49	22.12	22.29	589500.0
2023-07-25	AATC	Stock	4.4	4.48	4.4	4.48	3805.0
2023-07-25	AAU-DELISTED	Stock	0.159	0.159	0.1457	0.1491	146658.0
2023-07-25	AAUAF-DELISTED	Stock	0.159	0.159	0.1457	0.1491	149957.0
2023-07-25	AAXJ	Stock	69.12	69.3	68.89	68.95	519999.0
2023-07-25	AB	Stock	34.04	34.48	33.86	34.2	181400.0
2023-07-25	ABBNY-DELISTED	Stock	40.21	40.67	40.16	40.65	180551.0
2023-07-25	ABBV	Stock	142.4	142.93	141.32	141.63	4778200.0
2023-07-25	ABC-DELISTED	Stock	190.86	192.07	190.06	191.91	706558.0
2023-07-25	ABCB	Stock	40.79	41.45	40.3	40.64	408500.0
2023-07-25	ABCL	Stock	7.65	7.84	7.56	7.82	1532100.0
2023-07-25	ABCM-DELISTED	Stock	23.82	23.93	23.39	23.445	1009544.0
2023-07-25	ABEO	Stock	3.58	3.65	3.46	3.5	143500.0
2023-07-25	ABEV	Stock	3.12	3.15	3.1	3.14	10791600.0
2023-07-25	ABG	Stock	230.0	234.9	217.29	218.31	401900.0
2023-07-25	ABLLW	Stock	0.239	0.28	0.2386	0.239	9596.0
2023-07-25	ABLV	Stock	10.62	10.62	10.61	10.61	70722.0
2023-07-25	ABM	Stock	43.94	44.85	43.94	44.81	428200.0
2023-07-25	ABNB	Stock	147.61	150.78	147.46	148.65	4121300.0
2023-07-25	ABOS	Stock	6.8	6.97	6.582	6.905	900900.0
2023-07-25	ABR	Stock	16.32	16.43	16.02	16.04	2193400.0
2023-07-25	ABR.D	Stock	18.75	18.88	18.6543	18.88	4044.0

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

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