PREVIEW / stock_daily / 2022-12-20

all stock daily files

  file:    by_date/stock_daily/2022/2022-12-20.parquet
  size:    249 KB
  rows:    7,760
  symbols: 1,991

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
2022-12-20	AAPL	Stock	131.39	133.25	129.89	132.3	77432800.0
2022-12-20	MSFT	Stock	239.4	242.91	238.42	241.8	25150800.0
2022-12-20	NVDA	Stock	16.064	16.31	15.852	16.085	403260000.0
2022-12-20	AMZN	Stock	85.33	86.61	84.33	85.19	74348300.0
2022-12-20	GOOGL	Stock	88.11	89.175	87.4401	89.02	23453836.0
2022-12-20	META	Stock	113.26	117.33	112.46	117.09	28742500.0
2022-12-20	TSLA	Stock	146.05	148.47	137.66	137.8	159563300.0
2022-12-20	TLT	Stock	103.38	103.81	103.1	103.44	28869030.0
2022-12-20	ES	Stock	82.81	83.08	81.98	82.66	1379900.0
2022-12-20	CL	Stock	77.9	78.07	77.13	77.69	2831900.0
2022-12-20	A	Stock	147.27	149.18	145.88	147.93	1548200.0
2022-12-20	AA	Stock	42.62	44.33	42.58	44.09	4948100.0
2022-12-20	AAC-DELISTED	Stock	10.08	10.09	10.08	10.085	156145.0
2022-12-20	AACG	Stock	1.43	1.5	1.41	1.43	11800.0
2022-12-20	AACIW-DELISTED	Stock	0.03	0.03	0.03	0.03	10000.0
2022-12-20	AAIC-DELISTED	Stock	2.98	2.98	2.84	2.88	193960.0
2022-12-20	AAIC.C-DELISTED	Stock	21.4017	21.49	21.25	21.25	688.0
2022-12-20	AAL	Stock	12.42	12.62	12.38	12.53	20354200.0
2022-12-20	AAM.A-DELISTED	Stock	23.1	23.5	22.72	22.82	24321.0
2022-12-20	AAM.B-DELISTED	Stock	22.79	23.15	22.7	22.945	26260.0
2022-12-20	AAME	Stock	2.46	2.46	2.45	2.45	3600.0
2022-12-20	AAMI	Stock	18.85	19.29	18.82	19.15	131100.0
2022-12-20	AAN-DELISTED	Stock	11.38	11.7	11.29	11.36	395100.0
2022-12-20	AAOI	Stock	2.13	2.3	2.13	2.21	188600.0
2022-12-20	AAON	Stock	50.6533	51.0	50.1667	50.2733	184200.0
2022-12-20	AAP	Stock	140.0	141.49	138.89	139.38	797200.0
2022-12-20	AAT	Stock	26.23	26.41	25.95	26.24	302600.0
2022-12-20	AATC	Stock	5.01	5.01	4.6373	4.755	55789.0
2022-12-20	AAU-DELISTED	Stock	0.2429	0.25	0.2429	0.246	237123.0
2022-12-20	AAUAF-DELISTED	Stock	0.2429	0.25	0.2429	0.246	240067.0
2022-12-20	AAWW-DELISTED	Stock	100.22	100.49	100.15	100.47	146571.0
2022-12-20	AAXJ	Stock	64.43	64.92	64.38	64.6	553582.0
2022-12-20	AB	Stock	35.85	36.59	35.8	36.05	255200.0
2022-12-20	ABB-DELISTED	Stock	30.06	30.3	30.045	30.13	827079.0
2022-12-20	ABBNY-DELISTED	Stock	30.06	30.3	30.045	30.12	935438.0
2022-12-20	ABBV	Stock	161.61	161.85	160.07	160.58	4221000.0
2022-12-20	ABC-DELISTED	Stock	167.55	168.61	167.045	167.38	714909.0
2022-12-20	ABCB	Stock	46.9	47.19	46.59	46.68	388500.0
2022-12-20	ABCL	Stock	9.85	10.43	9.81	10.41	1913900.0
2022-12-20	ABCM-DELISTED	Stock	15.25	15.26	14.39	15.06	1142726.0
2022-12-20	ABEO	Stock	2.52	2.75	2.47	2.6	465700.0
2022-12-20	ABEV	Stock	2.75	2.8	2.75	2.76	12795400.0
2022-12-20	ABG	Stock	160.72	164.24	157.53	158.71	239500.0
2022-12-20	ABGI-DELISTED	Stock	10.04	10.06	10.04	10.04	5200.0
2022-12-20	ABM	Stock	45.17	45.42	44.43	45.01	279400.0
2022-12-20	ABMD-DELISTED	Stock	381.3	381.3	380.5	380.83	1876460.0
2022-12-20	ABNB	Stock	86.71	90.86	86.52	87.62	7325800.0
2022-12-20	ABOS	Stock	5.5	5.9	5.49	5.81	109400.0
2022-12-20	ABR	Stock	13.37	13.53	13.19	13.4	1094800.0
2022-12-20	ABR.D	Stock	16.5999	16.6	16.48	16.5011	24900.0

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

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