PREVIEW / stock_daily / 2023-05-16

all stock daily files

  file:    by_date/stock_daily/2023/2023-05-16.parquet
  size:    241 KB
  rows:    7,529
  symbols: 1,668

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-05-16	AAPL	Stock	171.99	173.14	171.8	172.07	42110300.0
2023-05-16	MSFT	Stock	309.83	313.71	309.83	311.74	26730300.0
2023-05-16	NVDA	Stock	28.841	29.87	28.832	29.213	449405000.0
2023-05-16	AMZN	Stock	111.05	114.79	111.05	113.4	71472900.0
2023-05-16	GOOGL	Stock	116.49	120.75	116.43	119.51	45035558.0
2023-05-16	META	Stock	235.79	239.64	235.52	238.82	18163800.0
2023-05-16	TSLA	Stock	165.65	169.52	164.35	166.52	98288800.0
2023-05-16	TLT	Stock	102.4	102.9	102.11	102.88	29251698.0
2023-05-16	ES	Stock	76.8	77.17	74.48	74.52	2306800.0
2023-05-16	CL	Stock	81.15	81.29	80.4	80.77	7159500.0
2023-05-16	A	Stock	126.97	127.4	125.79	126.29	1190000.0
2023-05-16	AA	Stock	36.49	37.03	36.025	36.1	3234200.0
2023-05-16	AAC-DELISTED	Stock	10.46	10.48	10.46	10.475	131918.0
2023-05-16	AACG	Stock	1.5	1.52	1.45	1.48	14500.0
2023-05-16	AACIU	Stock	10.33	10.33	10.33	10.33	400.0
2023-05-16	AAIC-DELISTED	Stock	2.56	2.58	2.53	2.57	57779.0
2023-05-16	AAIC.C-DELISTED	Stock	21.39	21.39	21.39	21.39	100.0
2023-05-16	AAL	Stock	14.21	14.45	13.97	14.2	20303200.0
2023-05-16	AAM.A-DELISTED	Stock	23.07	23.5513	23.0	23.0668	8959.0
2023-05-16	AAM.B-DELISTED	Stock	23.5	23.5	22.71	23.37	8600.0
2023-05-16	AAMC-DELISTED	Stock	24.4412	26.8235	23.5294	25.2206	227939.0
2023-05-16	AAME	Stock	2.24	2.24	2.22	2.22	1000.0
2023-05-16	AAMI	Stock	21.56	21.74	21.46	21.65	91100.0
2023-05-16	AAN-DELISTED	Stock	12.41	12.47	12.19	12.21	147100.0
2023-05-16	AAOI	Stock	1.65	1.76	1.65	1.73	244200.0
2023-05-16	AAON	Stock	62.1333	62.5267	60.6333	60.9333	431850.0
2023-05-16	AAP	Stock	120.42	120.78	117.32	117.34	1015800.0
2023-05-16	AAT	Stock	18.87	18.98	18.31	18.32	298800.0
2023-05-16	AATC	Stock	4.25	4.34	4.25	4.32	20140.0
2023-05-16	AAU-DELISTED	Stock	0.112	0.1146	0.1065	0.1125	232506.0
2023-05-16	AAUAF-DELISTED	Stock	0.112	0.1146	0.1065	0.1125	232937.0
2023-05-16	AAXJ	Stock	66.29	66.305	65.98	66.09	343973.0
2023-05-16	AB	Stock	33.9	34.17	33.36	33.37	193100.0
2023-05-16	ABB-DELISTED	Stock	36.77	36.85	36.58	36.64	1090154.0
2023-05-16	ABBNY-DELISTED	Stock	36.79	36.85	36.58	36.64	1208573.0
2023-05-16	ABBV	Stock	145.86	146.94	143.23	143.29	4685400.0
2023-05-16	ABC-DELISTED	Stock	173.38	174.775	172.935	174.6	972061.0
2023-05-16	ABCB	Stock	30.14	30.36	29.22	29.24	321300.0
2023-05-16	ABCL	Stock	5.91	5.94	5.67	5.7	1322800.0
2023-05-16	ABCM-DELISTED	Stock	17.44	17.58	16.7	17.24	680540.0
2023-05-16	ABEO	Stock	3.15	3.15	3.0	3.03	28800.0
2023-05-16	ABEV	Stock	2.98	2.99	2.93	2.94	8687500.0
2023-05-16	ABG	Stock	198.57	201.42	195.5	197.53	280900.0
2023-05-16	ABLV	Stock	10.44	10.48	10.44	10.48	2799.0
2023-05-16	ABM	Stock	43.24	43.68	42.89	43.58	183000.0
2023-05-16	ABNB	Stock	105.72	107.58	104.3	105.41	5585300.0
2023-05-16	ABOS	Stock	6.03	6.03	5.365	5.61	179000.0
2023-05-16	ABR	Stock	12.78	12.83	12.45	12.46	3638700.0
2023-05-16	ABR.D	Stock	17.32	17.41	16.7901	16.81	17084.0
2023-05-16	ABR.E	Stock	17.28	17.28	16.0	16.19	67854.0

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

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