PREVIEW / stock_daily / 2023-11-17

all stock daily files

  file:    by_date/stock_daily/2023/2023-11-17.parquet
  size:    234 KB
  rows:    7,331
  symbols: 1,284

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-11-17	AAPL	Stock	190.25	190.38	188.57	189.69	50922700.0
2023-11-17	MSFT	Stock	373.61	374.37	367.0	369.85	40157000.0
2023-11-17	NVDA	Stock	49.524	49.717	49.007	49.298	325205000.0
2023-11-17	AMZN	Stock	142.66	145.23	142.54	145.18	49636700.0
2023-11-17	GOOGL	Stock	136.0	136.06	133.65	135.31	37287691.0
2023-11-17	META	Stock	330.26	335.5	329.35	335.04	14494400.0
2023-11-17	TSLA	Stock	232.0	237.39	226.54	234.3	142532800.0
2023-11-17	TLT	Stock	90.16	90.425	89.6358	90.04	44100610.0
2023-11-17	ES	Stock	57.63	58.9	57.3	58.51	5534200.0
2023-11-17	CL	Stock	76.0	76.16	75.5	75.58	3231700.0
2023-11-17	A	Stock	113.98	114.47	112.06	113.15	2700800.0
2023-11-17	AA	Stock	26.35	26.978	26.12	26.22	4988700.0
2023-11-17	AACG	Stock	0.82	0.93	0.81	0.93	2300.0
2023-11-17	AAIC-DELISTED	Stock	4.63	4.66	4.6108	4.64	54678.0
2023-11-17	AAIC.C-DELISTED	Stock	23.9999	24.1	23.9965	24.1	1153.0
2023-11-17	AAL	Stock	12.27	12.31	12.14	12.29	25699200.0
2023-11-17	AAMC-DELISTED	Stock	2.902	2.91	2.64	2.69	59100.0
2023-11-17	AAME	Stock	1.77	1.93	1.77	1.83	2600.0
2023-11-17	AAMI	Stock	17.33	17.42	17.21	17.26	115900.0
2023-11-17	AAN-DELISTED	Stock	8.68	8.88	8.64	8.88	347500.0
2023-11-17	AAOI	Stock	12.97	13.15	12.71	12.75	2085600.0
2023-11-17	AAON	Stock	63.07	63.47	62.71	62.78	347500.0
2023-11-17	AAP	Stock	54.0	54.27	49.03	50.33	5560000.0
2023-11-17	AAT	Stock	19.51	19.51	19.18	19.23	623600.0
2023-11-17	AATC	Stock	6.46	6.46	6.25	6.35	6323.0
2023-11-17	AAU-DELISTED	Stock	0.14	0.1429	0.14	0.14	126530.0
2023-11-17	AAUAF-DELISTED	Stock	0.14	0.1429	0.14	0.14	117651.0
2023-11-17	AAXJ	Stock	65.51	65.63	65.3014	65.5	288209.0
2023-11-17	AB	Stock	28.17	28.49	28.0	28.06	360100.0
2023-11-17	ABAT	Stock	4.05	4.13	3.85	4.09	264137.0
2023-11-17	ABBNY-DELISTED	Stock	38.13	38.198	38.03	38.15	84102.0
2023-11-17	ABBV	Stock	138.36	138.88	137.38	138.3	4332300.0
2023-11-17	ABCB	Stock	43.58	43.89	43.16	43.39	567900.0
2023-11-17	ABCL	Stock	4.43	4.48	4.345	4.47	1326400.0
2023-11-17	ABCM-DELISTED	Stock	23.92	23.93	23.91	23.925	43810888.0
2023-11-17	ABEO	Stock	4.21	4.28	4.13	4.19	73500.0
2023-11-17	ABEV	Stock	2.77	2.79	2.75	2.77	19032600.0
2023-11-17	ABG	Stock	208.86	211.5	206.74	209.67	140700.0
2023-11-17	ABLLW	Stock	0.273	0.3286	0.265	0.28	259160.0
2023-11-17	ABLV	Stock	1.92	2.74	1.92	2.41	316100.0
2023-11-17	ABLVW	Stock	0.0156	0.0264	0.0144	0.0239	113388.0
2023-11-17	ABM	Stock	41.39	41.44	40.95	41.07	380700.0
2023-11-17	ABNB	Stock	126.65	127.97	125.45	127.15	3795700.0
2023-11-17	ABOS	Stock	2.24	2.34	2.23	2.28	366300.0
2023-11-17	ABR	Stock	12.34	12.66	12.24	12.5	4520800.0
2023-11-17	ABR.D	Stock	16.5	16.55	16.15	16.17	56749.0
2023-11-17	ABR.E	Stock	16.54	16.73	16.3	16.3	8060.0
2023-11-17	ABR.F	Stock	17.6749	17.817	17.27	17.27	32624.0
2023-11-17	ABSI	Stock	1.37	1.46	1.37	1.45	222200.0
2023-11-17	ABT	Stock	100.43	100.75	99.25	99.55	6069100.0

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

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