PREVIEW / stock_daily / 2023-10-24

all stock daily files

  file:    by_date/stock_daily/2023/2023-10-24.parquet
  size:    233 KB
  rows:    7,322
  symbols: 1,329

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-10-24	AAPL	Stock	173.05	173.67	171.45	173.44	43816600.0
2023-10-24	MSFT	Stock	331.3	331.84	327.6	330.53	31153600.0
2023-10-24	NVDA	Stock	43.077	43.697	42.691	43.663	401463000.0
2023-10-24	AMZN	Stock	127.74	128.8	126.34	128.56	46477400.0
2023-10-24	GOOGL	Stock	137.83	139.3599	137.42	138.81	44814321.0
2023-10-24	META	Stock	316.78	318.35	310.63	312.55	19525500.0
2023-10-24	TSLA	Stock	216.5	222.05	214.11	216.52	118231100.0
2023-10-24	TLT	Stock	84.44	85.35	84.09	85.35	46267684.0
2023-10-24	ES	Stock	53.22	54.4	52.92	54.03	2546500.0
2023-10-24	CL	Stock	72.11	72.92	72.09	72.84	4163300.0
2023-10-24	A	Stock	107.5	108.06	105.36	105.64	3204200.0
2023-10-24	AA	Stock	23.66	24.21	23.36	23.44	7557400.0
2023-10-24	AAC-DELISTED	Stock	10.74	10.78	10.73	10.78	118575.0
2023-10-24	AACG	Stock	1.02	1.07	1.02	1.03	7100.0
2023-10-24	AACT	Stock	10.3	10.31	10.29	10.29	11100.0
2023-10-24	AAIC-DELISTED	Stock	4.06	4.2	4.06	4.15	566256.0
2023-10-24	AAIC.C-DELISTED	Stock	23.7112	23.7112	23.7	23.7	415.0
2023-10-24	AAL	Stock	11.36	11.43	11.09	11.21	39302800.0
2023-10-24	AAMC-DELISTED	Stock	3.7706	3.8559	3.7706	3.8118	5270.0
2023-10-24	AAME	Stock	1.94	1.94	1.94	1.94	300.0
2023-10-24	AAMI	Stock	16.3	16.485	15.97	16.13	219600.0
2023-10-24	AAN-DELISTED	Stock	7.28	7.818	7.0	7.01	1824700.0
2023-10-24	AAOI	Stock	7.19	7.63	7.19	7.44	1011200.0
2023-10-24	AAON	Stock	54.2	54.37	53.15	53.21	299600.0
2023-10-24	AAP	Stock	48.7	49.8	47.99	48.25	1719900.0
2023-10-24	AAT	Stock	17.79	17.97	17.55	17.62	475600.0
2023-10-24	AATC	Stock	5.725	5.725	5.7	5.7	2451.0
2023-10-24	AAU-DELISTED	Stock	0.1418	0.1445	0.135	0.1353	379071.0
2023-10-24	AAUAF-DELISTED	Stock	0.1418	0.1444	0.135	0.135	381652.0
2023-10-24	AAXJ	Stock	62.06	62.73	61.96	62.65	716488.0
2023-10-24	AB	Stock	29.07	29.52	28.71	28.89	318400.0
2023-10-24	ABAT	Stock	5.51	5.71	5.47	5.57	167234.0
2023-10-24	ABBNY-DELISTED	Stock	33.05	33.28	32.96	33.12	266397.0
2023-10-24	ABBV	Stock	145.15	146.97	145.1	146.31	3362900.0
2023-10-24	ABCB	Stock	36.13	36.27	34.99	35.45	325700.0
2023-10-24	ABCL	Stock	4.3	4.47	4.26	4.45	1099600.0
2023-10-24	ABCM-DELISTED	Stock	22.9	23.045	22.87	22.93	5000953.0
2023-10-24	ABEO	Stock	3.96	4.14	3.9	4.0	58000.0
2023-10-24	ABEV	Stock	2.46	2.5	2.45	2.5	14970400.0
2023-10-24	ABG	Stock	187.24	194.7	182.65	186.52	436600.0
2023-10-24	ABLLW	Stock	0.2997	0.3395	0.26	0.3395	3479.0
2023-10-24	ABLV	Stock	2.53	2.55	2.462	2.51	12700.0
2023-10-24	ABM	Stock	40.19	40.4	39.74	40.05	201300.0
2023-10-24	ABNB	Stock	121.18	123.17	120.57	122.01	3651600.0
2023-10-24	ABOS	Stock	3.32	3.5	3.32	3.425	251100.0
2023-10-24	ABR	Stock	13.63	13.94	13.63	13.75	2914100.0
2023-10-24	ABR.D	Stock	16.46	16.5995	16.3	16.51	14031.0
2023-10-24	ABR.E	Stock	16.5	16.5047	16.1	16.45	13319.0
2023-10-24	ABR.F	Stock	17.73	17.7499	17.58	17.625	10917.0
2023-10-24	ABSI	Stock	1.26	1.36	1.2	1.22	257600.0

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

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