PREVIEW / stock_daily / 2023-09-15

all stock daily files

  file:    by_date/stock_daily/2023/2023-09-15.parquet
  size:    238 KB
  rows:    7,391
  symbols: 1,421

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-09-15	AAPL	Stock	176.48	176.5	173.82	175.01	109205100.0
2023-09-15	MSFT	Stock	336.92	337.4	329.65	330.22	37666900.0
2023-09-15	NVDA	Stock	45.341	45.599	43.808	43.9	506831000.0
2023-09-15	AMZN	Stock	142.69	143.57	140.09	140.39	102861700.0
2023-09-15	GOOGL	Stock	137.98	138.52	136.48	137.4	38919614.0
2023-09-15	META	Stock	311.61	312.0	298.75	300.31	28106400.0
2023-09-15	TSLA	Stock	277.55	278.98	271.0	274.39	133422800.0
2023-09-15	TLT	Stock	93.46	93.48	92.96	92.96	25642922.0
2023-09-15	ES	Stock	64.24	64.84	64.05	64.21	4358600.0
2023-09-15	CL	Stock	73.29	73.79	72.92	73.17	5586000.0
2023-09-15	A	Stock	114.43	121.92	113.43	115.91	6882600.0
2023-09-15	AA	Stock	29.89	29.89	28.8	28.85	8705200.0
2023-09-15	AAC-DELISTED	Stock	10.73	10.73	10.71	10.71	17674.0
2023-09-15	AACG	Stock	1.21	1.21	1.13	1.13	1300.0
2023-09-15	AACIW-DELISTED	Stock	0.0786	0.0843	0.0718	0.0843	365.0
2023-09-15	AACT	Stock	10.24	10.25	10.24	10.25	14000.0
2023-09-15	AAIC-DELISTED	Stock	4.58	4.61	4.58	4.59	133438.0
2023-09-15	AAIC.C-DELISTED	Stock	23.88	24.65	23.72	23.92	5168.0
2023-09-15	AAL	Stock	13.22	13.45	13.21	13.31	24956700.0
2023-09-15	AAM.A-DELISTED	Stock	25.02	25.02	25.0	25.0	21413.0
2023-09-15	AAM.B-DELISTED	Stock	25.05	25.05	25.0	25.0	18508.0
2023-09-15	AAMC-DELISTED	Stock	3.9353	4.2059	3.9235	4.0882	37570.0
2023-09-15	AAME	Stock	1.99	1.99	1.84	1.99	11400.0
2023-09-15	AAMI	Stock	20.23	20.37	20.06	20.28	606900.0
2023-09-15	AAN-DELISTED	Stock	9.92	10.37	9.69	9.75	9113800.0
2023-09-15	AAOI	Stock	9.8	10.04	9.452	9.84	2205600.0
2023-09-15	AAON	Stock	60.84	60.99	59.56	60.88	1397800.0
2023-09-15	AAP	Stock	61.01	61.1	58.86	59.82	4465700.0
2023-09-15	AAT	Stock	20.65	20.77	20.35	20.57	1650400.0
2023-09-15	AATC	Stock	6.05	6.09	6.05	6.08	2382.0
2023-09-15	AAU-DELISTED	Stock	0.135	0.1363	0.1242	0.13	262148.0
2023-09-15	AAUAF-DELISTED	Stock	0.135	0.1363	0.1242	0.13	267070.0
2023-09-15	AAXJ	Stock	65.71	65.895	65.44	65.49	499882.0
2023-09-15	AB	Stock	32.33	32.95	31.96	32.94	513200.0
2023-09-15	ABBNY-DELISTED	Stock	36.42	36.58	36.26	36.3	209575.0
2023-09-15	ABBV	Stock	152.78	154.7	151.93	152.12	8861500.0
2023-09-15	ABCB	Stock	39.36	39.81	39.17	39.39	1365800.0
2023-09-15	ABCL	Stock	5.31	5.46	5.27	5.34	2364800.0
2023-09-15	ABCM-DELISTED	Stock	22.82	22.82	22.61	22.65	6656336.0
2023-09-15	ABEO	Stock	4.06	4.18	3.91	4.03	130700.0
2023-09-15	ABEV	Stock	2.75	2.77	2.72	2.73	19021000.0
2023-09-15	ABG	Stock	233.55	235.0	222.98	225.13	811600.0
2023-09-15	ABLLW	Stock	0.44249	0.44249	0.39	0.396	37515.0
2023-09-15	ABLV	Stock	2.98	3.14	2.98	3.13	7300.0
2023-09-15	ABLVW	Stock	0.0461	0.0461	0.0442	0.0442	3536.0
2023-09-15	ABM	Stock	41.21	41.7	40.4	40.55	1748100.0
2023-09-15	ABNB	Stock	143.585	144.95	142.1	142.75	74786400.0
2023-09-15	ABOS	Stock	5.48	5.65	5.27	5.53	1026100.0
2023-09-15	ABR	Stock	15.87	16.06	15.73	16.03	4094900.0
2023-09-15	ABR.D	Stock	18.86	18.93	18.715	18.8699	5328.0

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

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