PREVIEW / stock_daily / 2023-03-24

all stock daily files

  file:    by_date/stock_daily/2023/2023-03-24.parquet
  size:    243 KB
  rows:    7,568
  symbols: 1,719

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-24	AAPL	Stock	158.86	160.34	157.85	160.25	59196500.0
2023-03-24	MSFT	Stock	277.24	280.63	275.28	280.57	28172000.0
2023-03-24	NVDA	Stock	27.031	27.167	26.355	26.779	454920000.0
2023-03-24	AMZN	Stock	98.07	98.3	96.4	98.13	56095400.0
2023-03-24	GOOGL	Stock	104.99	105.49	103.84	105.44	30411043.0
2023-03-24	META	Stock	205.18	207.58	203.55	206.01	27716400.0
2023-03-24	TSLA	Stock	191.65	192.36	187.15	190.41	116312400.0
2023-03-24	TLT	Stock	107.09	107.43	106.26	106.85	23657586.0
2023-03-24	ES	Stock	73.56	75.75	73.24	75.73	1923300.0
2023-03-24	CL	Stock	72.25	73.54	72.1	73.42	5013500.0
2023-03-24	A	Stock	130.14	131.98	128.22	131.96	1571600.0
2023-03-24	AA	Stock	39.28	40.185	38.816	40.08	4013700.0
2023-03-24	AAC-DELISTED	Stock	10.35	10.35	10.32	10.32	42096.0
2023-03-24	AACG	Stock	1.8	1.89	1.8	1.88	8900.0
2023-03-24	AACIW-DELISTED	Stock	0.1096	0.1099	0.0896	0.1099	400.0
2023-03-24	AAIC-DELISTED	Stock	2.65	2.69	2.61	2.69	38208.0
2023-03-24	AAIC.C-DELISTED	Stock	20.25	20.25	20.205	20.246	1700.0
2023-03-24	AAL	Stock	13.5	13.74	13.36	13.72	19871300.0
2023-03-24	AAM.A-DELISTED	Stock	20.28	21.31	20.28	20.795	20359.0
2023-03-24	AAM.B-DELISTED	Stock	21.0682	21.2399	20.43	20.7999	36216.0
2023-03-24	AAMC-DELISTED	Stock	17.3235	18.4235	17.3235	18.1765	33082.0
2023-03-24	AAME	Stock	2.39	2.49	2.35	2.49	3700.0
2023-03-24	AAMI	Stock	22.3	22.755	22.275	22.59	119800.0
2023-03-24	AAN-DELISTED	Stock	9.02	9.25	8.92	9.21	440000.0
2023-03-24	AAOI	Stock	2.42	2.43	2.361	2.41	51000.0
2023-03-24	AAON	Stock	60.7667	61.0	59.2	60.8333	561000.0
2023-03-24	AAP	Stock	110.94	111.2	109.05	110.83	2009800.0
2023-03-24	AAT	Stock	16.27	17.1	16.04	17.09	537800.0
2023-03-24	AATC	Stock	4.05	4.05	3.92	4.04	11327.0
2023-03-24	AAU-DELISTED	Stock	0.196	0.2	0.19	0.197	132238.0
2023-03-24	AAUAF-DELISTED	Stock	0.196	0.2	0.19	0.197	135617.0
2023-03-24	AAXJ	Stock	66.53	66.8	66.39	66.78	242057.0
2023-03-24	AB	Stock	33.61	33.99	33.14	33.49	459500.0
2023-03-24	ABB-DELISTED	Stock	32.51	32.765	32.17	32.7501	1908876.0
2023-03-24	ABBNY-DELISTED	Stock	32.51	32.765	32.17	32.75	2147051.0
2023-03-24	ABBV	Stock	155.28	158.48	154.59	158.02	4678700.0
2023-03-24	ABC-DELISTED	Stock	150.85	156.585	150.25	156.5	786152.0
2023-03-24	ABCB	Stock	34.9	36.9	34.58	36.77	468300.0
2023-03-24	ABCL	Stock	7.26	7.375	7.13	7.34	1204400.0
2023-03-24	ABCM-DELISTED	Stock	13.09	13.18	12.9	12.96	1123810.0
2023-03-24	ABEO	Stock	2.39	2.83	2.39	2.71	213000.0
2023-03-24	ABEV	Stock	2.6	2.66	2.57	2.63	18549700.0
2023-03-24	ABG	Stock	195.61	199.1	191.09	198.36	138400.0
2023-03-24	ABM	Stock	42.05	43.5	41.8	43.43	493100.0
2023-03-24	ABNB	Stock	119.5	119.7	115.39	116.92	4290900.0
2023-03-24	ABOS	Stock	4.05	4.05	3.829	3.92	54000.0
2023-03-24	ABR	Stock	10.67	11.16	10.58	11.11	4524000.0
2023-03-24	ABR.D	Stock	16.715	16.715	16.5	16.5499	26207.0
2023-03-24	ABR.E	Stock	16.1618	16.3435	15.9404	16.17	4719.0
2023-03-24	ABR.F	Stock	17.18	17.3	17.0	17.025	26428.0

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

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