PREVIEW / stock_daily / 2024-07-01

all stock daily files

  file:    by_date/stock_daily/2024/2024-07-01.parquet
  size:    230 KB
  rows:    7,196
  symbols: 920

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
2024-07-01	AAPL	Stock	212.09	217.51	211.92	216.75	60402900.0
2024-07-01	MSFT	Stock	448.66	457.37	445.66	456.73	17662800.0
2024-07-01	NVDA	Stock	123.47	124.84	118.83	124.3	284885500.0
2024-07-01	AMZN	Stock	193.49	198.3	192.82	197.2	41192000.0
2024-07-01	GOOGL	Stock	183.03	183.88	181.3	182.99	16006128.0
2024-07-01	META	Stock	504.95	506.58	493.17	504.68	10328200.0
2024-07-01	TSLA	Stock	201.02	213.23	200.85	209.86	135691400.0
2024-07-01	TLT	Stock	90.42	91.08	89.82	89.91	49735376.0
2024-07-01	ES	Stock	57.07	57.39	56.32	56.56	1984800.0
2024-07-01	CL	Stock	97.44	97.7	95.42	95.54	4205200.0
2024-07-01	A	Stock	130.69	131.79	127.06	127.4	2364800.0
2024-07-01	AA	Stock	40.25	40.87	39.54	39.7	3228000.0
2024-07-01	AACG	Stock	0.81	0.84	0.78	0.83	13400.0
2024-07-01	AACIW-DELISTED	Stock	0.148	0.1481	0.145	0.145	1650.0
2024-07-01	AACT	Stock	10.66	10.665	10.66	10.66	5000.0
2024-07-01	AAGR-DELISTED	Stock	0.235	0.26	0.2221	0.2461	3217761.0
2024-07-01	AAGRW-DELISTED	Stock	0.01495	0.01495	0.01495	0.01495	125.0
2024-07-01	AAL	Stock	11.33	11.41	11.0	11.04	28624300.0
2024-07-01	AAMC-DELISTED	Stock	2.0	2.15	1.88	2.15	4000.0
2024-07-01	AAME	Stock	1.59	1.69	1.59	1.69	800.0
2024-07-01	AAMI	Stock	22.1	22.275	21.76	21.92	191300.0
2024-07-01	AAN-DELISTED	Stock	9.98	9.99	9.93	9.95	897500.0
2024-07-01	AAOI	Stock	8.39	8.66	7.85	8.08	1778500.0
2024-07-01	AAON	Stock	87.63	87.85	83.14	83.58	1160700.0
2024-07-01	AAP	Stock	62.58	62.82	59.45	59.71	1767600.0
2024-07-01	AAT	Stock	22.24	22.45	22.07	22.4	381100.0
2024-07-01	AATC	Stock	6.35	6.6	6.35	6.6	11052.0
2024-07-01	AAUAF-DELISTED	Stock	0.057	0.065	0.055	0.0608	85653.0
2024-07-01	AAXJ	Stock	72.36	72.49	72.0	72.15	358147.0
2024-07-01	AB	Stock	33.87	33.99	33.42	33.49	146200.0
2024-07-01	ABAT	Stock	1.25	1.28	1.09	1.16	740768.0
2024-07-01	ABBV	Stock	171.27	173.88	169.54	170.37	5194500.0
2024-07-01	ABCB	Stock	50.08	50.61	49.69	50.33	312400.0
2024-07-01	ABCL	Stock	2.97	2.98	2.77	2.78	1885900.0
2024-07-01	ABEO	Stock	4.22	4.33	4.18	4.2	120000.0
2024-07-01	ABEV	Stock	2.06	2.07	2.03	2.04	17360800.0
2024-07-01	ABG	Stock	228.04	230.02	225.42	228.24	205500.0
2024-07-01	ABLLW	Stock	0.62	0.7	0.5726	0.69	47201.0
2024-07-01	ABLV	Stock	0.935	1.05	0.935	1.05	2600.0
2024-07-01	ABM	Stock	51.01	51.2	50.02	50.16	527200.0
2024-07-01	ABNB	Stock	152.2	152.2	149.14	151.63	2905000.0
2024-07-01	ABOS	Stock	2.4	2.48	2.325	2.385	340100.0
2024-07-01	ABR	Stock	14.35	14.48	13.97	14.19	4074200.0
2024-07-01	ABR.D	Stock	18.57	18.89	18.54	18.55	4570.0
2024-07-01	ABR.E	Stock	18.18	18.18	18.03	18.115	23707.0
2024-07-01	ABR.F	Stock	19.75	19.89	19.575	19.89	13759.0
2024-07-01	ABSI	Stock	3.08	3.125	2.93	3.01	1138300.0
2024-07-01	ABT	Stock	104.16	105.51	102.61	103.2	4588900.0
2024-07-01	ABTC	Stock	90.0	92.25	85.875	90.75	3312.0
2024-07-01	ABTS	Stock	8.295	9.0	8.295	8.835	2667.0

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

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