PREVIEW / stock_daily / 2023-03-29

all stock daily files

  file:    by_date/stock_daily/2023/2023-03-29.parquet
  size:    245 KB
  rows:    7,613
  symbols: 1,745

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-03-29	AAPL	Stock	159.37	161.05	159.35	160.77	51305700.0
2023-03-29	MSFT	Stock	278.96	281.14	278.41	280.51	25087000.0
2023-03-29	NVDA	Stock	26.825	27.078	26.597	26.984	393694000.0
2023-03-29	AMZN	Stock	98.69	100.42	98.56	100.25	49783300.0
2023-03-29	GOOGL	Stock	102.28	102.49	100.65	101.39	28779572.0
2023-03-29	META	Stock	203.56	205.72	202.54	205.35	18851100.0
2023-03-29	TSLA	Stock	193.13	195.29	189.44	193.88	123660000.0
2023-03-29	TLT	Stock	103.7	104.45	103.6	104.32	16804393.0
2023-03-29	ES	Stock	76.47	77.7	76.47	77.55	1510200.0
2023-03-29	CL	Stock	75.0	75.15	74.39	74.47	2873200.0
2023-03-29	A	Stock	133.95	134.24	132.63	133.85	1002800.0
2023-03-29	AA	Stock	41.3	41.4	40.71	40.94	4154800.0
2023-03-29	AAC-DELISTED	Stock	10.35	10.35	10.3151	10.33	16484.0
2023-03-29	AACG	Stock	1.85	1.86	1.81	1.83	5600.0
2023-03-29	AACIW-DELISTED	Stock	0.1099	0.1099	0.1099	0.1099	100.0
2023-03-29	AAIC-DELISTED	Stock	2.69	2.71	2.6605	2.68	22212.0
2023-03-29	AAIC.C-DELISTED	Stock	20.1	20.229	20.055	20.19	2400.0
2023-03-29	AAL	Stock	14.18	14.39	14.06	14.35	15907000.0
2023-03-29	AAM.A-DELISTED	Stock	21.08	21.3299	20.92	21.14	40865.0
2023-03-29	AAM.B-DELISTED	Stock	21.56	21.6	21.33	21.46	21510.0
2023-03-29	AAMC-DELISTED	Stock	22.7441	22.9382	21.1765	21.3088	146237.0
2023-03-29	AAME	Stock	2.36	2.5	2.36	2.5	2000.0
2023-03-29	AAMI	Stock	23.11	23.44	22.7	23.0	117100.0
2023-03-29	AAN-DELISTED	Stock	9.0	9.19	8.96	9.03	723900.0
2023-03-29	AAOI	Stock	1.82	1.83	1.745	1.83	226700.0
2023-03-29	AAON	Stock	63.62	64.2	62.7533	63.1867	419850.0
2023-03-29	AAP	Stock	116.32	117.57	114.76	117.55	1371500.0
2023-03-29	AAT	Stock	17.67	18.05	17.61	18.0	382200.0
2023-03-29	AATC	Stock	3.97	4.07	3.85	4.07	10203.0
2023-03-29	AAU-DELISTED	Stock	0.2018	0.202	0.1925	0.1951	264558.0
2023-03-29	AAUAF-DELISTED	Stock	0.2018	0.202	0.1925	0.193	270430.0
2023-03-29	AAXJ	Stock	67.28	67.5	67.06	67.37	343301.0
2023-03-29	AB	Stock	35.89	35.96	35.28	35.69	213300.0
2023-03-29	ABB-DELISTED	Stock	32.52	32.85	32.51	32.8	1126049.0
2023-03-29	ABBNY-DELISTED	Stock	32.52	32.85	32.51	32.8	1265179.0
2023-03-29	ABBV	Stock	158.98	159.7	156.36	158.0	3959900.0
2023-03-29	ABC-DELISTED	Stock	158.61	159.23	157.64	158.94	376925.0
2023-03-29	ABCB	Stock	37.49	37.51	36.53	36.85	380800.0
2023-03-29	ABCL	Stock	7.62	7.65	7.48	7.62	1364200.0
2023-03-29	ABCM-DELISTED	Stock	13.24	13.42	13.14	13.31	200975.0
2023-03-29	ABEO	Stock	2.79	2.85	2.65	2.81	108800.0
2023-03-29	ABEV	Stock	2.8	2.89	2.78	2.86	20946900.0
2023-03-29	ABG	Stock	200.51	200.51	196.91	199.65	316600.0
2023-03-29	ABLV	Stock	10.34	10.3474	10.34	10.3474	2000.0
2023-03-29	ABM	Stock	44.36	44.56	43.94	44.45	289500.0
2023-03-29	ABNB	Stock	118.34	119.19	117.151	118.8	2711500.0
2023-03-29	ABOS	Stock	4.07	4.2	3.855	4.07	85900.0
2023-03-29	ABR	Stock	11.09	11.11	10.93	11.04	3317800.0
2023-03-29	ABR.D	Stock	17.04	17.38	17.0	17.14	24827.0
2023-03-29	ABR.E	Stock	16.3	16.89	16.3	16.6001	12566.0

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

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