PREVIEW / stock_daily / 2023-10-26

all stock daily files

  file:    by_date/stock_daily/2023/2023-10-26.parquet
  size:    233 KB
  rows:    7,332
  symbols: 1,334

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-26	AAPL	Stock	170.37	171.38	165.67	166.89	70625300.0
2023-10-26	MSFT	Stock	340.54	341.63	326.94	327.89	37828500.0
2023-10-26	NVDA	Stock	41.853	42.256	39.88	40.326	541001000.0
2023-10-26	AMZN	Stock	120.63	121.64	118.35	119.57	100419500.0
2023-10-26	GOOGL	Stock	123.27	124.3297	121.27	122.28	57061140.0
2023-10-26	META	Stock	295.0	295.0	279.4	288.35	66684100.0
2023-10-26	TSLA	Stock	211.32	214.8	204.88	205.76	115112600.0
2023-10-26	TLT	Stock	83.48	84.815	83.4	84.73	49704075.0
2023-10-26	ES	Stock	54.48	55.4	54.13	54.16	2644200.0
2023-10-26	CL	Stock	73.29	73.94	72.89	73.08	6871000.0
2023-10-26	A	Stock	103.47	104.91	103.24	104.31	1599100.0
2023-10-26	AA	Stock	23.99	24.19	23.37	23.51	6386800.0
2023-10-26	AAC-DELISTED	Stock	10.0	10.45	9.0052	9.725	223648.0
2023-10-26	AACG	Stock	1.0	1.08	1.0	1.08	5200.0
2023-10-26	AACT	Stock	10.31	10.31	10.29	10.29	2300.0
2023-10-26	AAIC-DELISTED	Stock	4.05	4.19	4.05	4.13	124488.0
2023-10-26	AAIC.C-DELISTED	Stock	23.8695	23.8695	23.8	23.8	1300.0
2023-10-26	AAL	Stock	11.05	11.25	10.97	11.15	40009500.0
2023-10-26	AAMC-DELISTED	Stock	3.7029	3.7235	3.5294	3.5412	15470.0
2023-10-26	AAME	Stock	1.75	1.9	1.75	1.88	1900.0
2023-10-26	AAMI	Stock	15.81	16.21	15.81	16.01	115000.0
2023-10-26	AAN-DELISTED	Stock	7.25	7.39	7.16	7.31	431700.0
2023-10-26	AAOI	Stock	7.05	7.24	6.81	6.87	821400.0
2023-10-26	AAON	Stock	54.2	55.45	53.69	53.82	615500.0
2023-10-26	AAP	Stock	49.99	51.34	49.61	51.03	1751700.0
2023-10-26	AAT	Stock	17.59	18.01	17.47	17.85	354200.0
2023-10-26	AATC	Stock	5.7	5.725	5.7	5.7	5632.0
2023-10-26	AAU-DELISTED	Stock	0.135	0.1422	0.135	0.1406	43079.0
2023-10-26	AAUAF-DELISTED	Stock	0.135	0.1422	0.135	0.1406	41829.0
2023-10-26	AAXJ	Stock	61.08	61.425	60.985	61.22	512394.0
2023-10-26	AB	Stock	28.33	28.6	27.58	28.55	530100.0
2023-10-26	ABAT	Stock	4.54	4.9088	3.79	3.9	1002521.0
2023-10-26	ABBNY-DELISTED	Stock	33.06	33.28	32.88	33.01	426479.0
2023-10-26	ABBV	Stock	144.86	145.95	144.23	145.2	5569400.0
2023-10-26	ABCB	Stock	35.38	36.44	35.31	36.18	316900.0
2023-10-26	ABCL	Stock	4.05	4.17	4.03	4.14	1210200.0
2023-10-26	ABCM-DELISTED	Stock	22.83	22.995	22.815	22.86	3693921.0
2023-10-26	ABEO	Stock	3.89	3.95	3.7	3.84	77500.0
2023-10-26	ABEV	Stock	2.48	2.54	2.48	2.5	14251000.0
2023-10-26	ABG	Stock	186.14	192.89	186.14	189.04	230300.0
2023-10-26	ABLLW	Stock	0.33	0.3396	0.272	0.3395	22584.0
2023-10-26	ABLV	Stock	2.49	2.54	2.45	2.45	8500.0
2023-10-26	ABM	Stock	39.69	40.17	39.36	39.61	231000.0
2023-10-26	ABNB	Stock	118.14	119.548	114.4	115.47	5217500.0
2023-10-26	ABOS	Stock	3.31	3.4	3.18	3.22	460100.0
2023-10-26	ABR	Stock	13.08	13.25	12.73	12.81	8417200.0
2023-10-26	ABR.D	Stock	16.42	16.5	16.23	16.23	23953.0
2023-10-26	ABR.E	Stock	16.445	16.445	16.1001	16.1001	8628.0
2023-10-26	ABR.F	Stock	17.75	17.7543	17.5625	17.6	1888.0
2023-10-26	ABSI	Stock	1.17	1.23	1.111	1.15	293600.0

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

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