PREVIEW / stock_daily / 2023-07-24

all stock daily files

  file:    by_date/stock_daily/2023/2023-07-24.parquet
  size:    242 KB
  rows:    7,519
  symbols: 1,557

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-24	AAPL	Stock	193.41	194.91	192.25	192.75	45377800.0
2023-07-24	MSFT	Stock	345.85	346.92	342.31	345.11	26678100.0
2023-07-24	NVDA	Stock	44.731	45.109	44.04	44.612	382516000.0
2023-07-24	AMZN	Stock	130.31	131.66	128.35	128.8	45591100.0
2023-07-24	GOOGL	Stock	121.66	123.0	120.98	121.53	29723667.0
2023-07-24	META	Stock	295.78	297.52	288.3	291.61	24915700.0
2023-07-24	TSLA	Stock	255.85	269.85	254.12	269.06	136508500.0
2023-07-24	TLT	Stock	101.985	102.15	101.3	101.36	17546711.0
2023-07-24	ES	Stock	74.27	74.43	73.22	73.7	1830600.0
2023-07-24	CL	Stock	77.12	77.61	76.78	77.48	3494500.0
2023-07-24	A	Stock	127.62	129.39	127.19	127.72	2001200.0
2023-07-24	AA	Stock	32.89	34.306	32.77	33.75	6036700.0
2023-07-24	AAC-DELISTED	Stock	10.56	10.57	10.54	10.56	218938.0
2023-07-24	AACG	Stock	1.38	1.42	1.35	1.38	11800.0
2023-07-24	AACT	Stock	10.18	10.18	10.17	10.17	154600.0
2023-07-24	AAIC-DELISTED	Stock	4.7	4.8	4.7	4.7	150395.0
2023-07-24	AAIC.C-DELISTED	Stock	23.25	23.4	23.25	23.4	3045.0
2023-07-24	AAL	Stock	17.29	17.32	16.86	16.88	28457900.0
2023-07-24	AAM.A-DELISTED	Stock	22.88	23.678	22.88	23.678	5086.0
2023-07-24	AAM.B-DELISTED	Stock	22.96	23.68	22.9123	23.68	3202.0
2023-07-24	AAMC-DELISTED	Stock	28.2941	28.8235	26.5353	26.9941	74290.0
2023-07-24	AAME	Stock	1.86	1.88	1.8	1.8	9100.0
2023-07-24	AAMI	Stock	21.85	22.37	21.85	22.18	275900.0
2023-07-24	AAN-DELISTED	Stock	15.71	16.15	15.61	16.04	205100.0
2023-07-24	AAOI	Stock	7.875	8.68	7.77	8.52	2382700.0
2023-07-24	AAON	Stock	67.4267	69.3133	67.34	67.9267	386850.0
2023-07-24	AAP	Stock	70.8	72.89	70.8	72.76	2284900.0
2023-07-24	AAT	Stock	21.97	22.56	21.97	22.41	352800.0
2023-07-24	AATC	Stock	4.5	4.51	4.4	4.4	5290.0
2023-07-24	AAU-DELISTED	Stock	0.168	0.17	0.15	0.1505	319236.0
2023-07-24	AAUAF-DELISTED	Stock	0.168	0.17	0.15	0.1505	333119.0
2023-07-24	AAXJ	Stock	67.49	68.62	67.47	68.34	716995.0
2023-07-24	AB	Stock	33.6	34.21	33.6	34.01	170200.0
2023-07-24	ABBNY-DELISTED	Stock	40.376	40.6	40.27	40.29	135329.0
2023-07-24	ABBV	Stock	143.1	144.43	142.84	143.18	4468700.0
2023-07-24	ABC-DELISTED	Stock	193.0	193.55	190.925	191.45	788415.0
2023-07-24	ABCB	Stock	39.55	41.19	39.55	40.85	431900.0
2023-07-24	ABCL	Stock	7.87	7.96	7.62	7.65	2063000.0
2023-07-24	ABCM-DELISTED	Stock	24.15	24.518	23.53	23.6	2939383.0
2023-07-24	ABEO	Stock	3.73	3.74	3.58	3.6	112300.0
2023-07-24	ABEV	Stock	3.18	3.22	3.14	3.15	20481900.0
2023-07-24	ABG	Stock	231.89	235.21	228.06	232.94	209100.0
2023-07-24	ABLLW	Stock	0.2673	0.27	0.2381	0.269	12165.0
2023-07-24	ABLV	Stock	10.66	10.66	10.63	10.63	11499.0
2023-07-24	ABM	Stock	43.94	44.21	43.58	44.15	466500.0
2023-07-24	ABNB	Stock	147.06	148.29	144.18	147.62	4370800.0
2023-07-24	ABOS	Stock	7.45	7.45	6.655	6.87	1274700.0
2023-07-24	ABR	Stock	16.23	16.48	16.17	16.29	3217600.0
2023-07-24	ABR.D	Stock	18.56	18.85	18.5	18.85	9707.0
2023-07-24	ABR.E	Stock	18.39	18.395	18.3	18.35	2466.0

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

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