PREVIEW / stock_daily / 2022-12-21

all stock daily files

  file:    by_date/stock_daily/2022/2022-12-21.parquet
  size:    249 KB
  rows:    7,742
  symbols: 1,966

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-21	AAPL	Stock	132.98	136.81	132.75	135.45	85928000.0
2022-12-21	MSFT	Stock	241.69	245.62	240.11	244.43	23690600.0
2022-12-21	NVDA	Stock	16.114	16.627	16.102	16.501	325025000.0
2022-12-21	AMZN	Stock	86.18	87.23	85.21	86.77	59267200.0
2022-12-21	GOOGL	Stock	89.08	90.22	88.32	89.58	24745637.0
2022-12-21	META	Stock	116.7	120.34	115.62	119.76	20392800.0
2022-12-21	TSLA	Stock	139.34	141.26	135.89	137.57	145417400.0
2022-12-21	TLT	Stock	104.29	104.4	102.96	103.7	15894092.0
2022-12-21	ES	Stock	83.06	83.99	82.72	83.98	1202500.0
2022-12-21	CL	Stock	78.02	78.99	78.0	78.99	3025200.0
2022-12-21	A	Stock	148.94	150.27	147.89	150.09	1248100.0
2022-12-21	AA	Stock	44.68	45.745	43.95	44.87	3986200.0
2022-12-21	AAC-DELISTED	Stock	10.08	10.0908	10.08	10.085	608407.0
2022-12-21	AACG	Stock	1.34	1.44	1.34	1.43	4500.0
2022-12-21	AACIW-DELISTED	Stock	0.03	0.03	0.03	0.03	5002.0
2022-12-21	AAIC-DELISTED	Stock	2.87	2.94	2.8495	2.86	228216.0
2022-12-21	AAIC.C-DELISTED	Stock	21.2064	21.32	21.16	21.3	3629.0
2022-12-21	AAL	Stock	12.69	13.22	12.65	13.03	29778900.0
2022-12-21	AAM.A-DELISTED	Stock	22.81	23.345	22.81	23.1802	21206.0
2022-12-21	AAM.B-DELISTED	Stock	22.85	23.49	22.6566	23.48	30604.0
2022-12-21	AAMC-DELISTED	Stock	5.8824	6.1765	5.785	5.785	21590.0
2022-12-21	AAME	Stock	2.44	2.44	2.41	2.42	3700.0
2022-12-21	AAMI	Stock	19.41	19.67	19.25	19.58	150800.0
2022-12-21	AAN-DELISTED	Stock	11.53	11.62	11.24	11.36	354300.0
2022-12-21	AAOI	Stock	2.2	2.24	2.13	2.13	66500.0
2022-12-21	AAON	Stock	50.82	51.7133	50.1667	51.4	237000.0
2022-12-21	AAP	Stock	140.24	142.35	139.2	142.29	676800.0
2022-12-21	AAT	Stock	26.39	26.75	26.35	26.39	206200.0
2022-12-21	AATC	Stock	4.75	4.83	4.155	4.4361	82296.0
2022-12-21	AAU-DELISTED	Stock	0.2434	0.2508	0.2434	0.2501	166493.0
2022-12-21	AAUAF-DELISTED	Stock	0.2434	0.2508	0.2434	0.25	168906.0
2022-12-21	AAWW-DELISTED	Stock	100.36	100.67	100.2225	100.63	258108.0
2022-12-21	AAXJ	Stock	64.61	65.25	64.37	65.2	974462.0
2022-12-21	AB	Stock	36.05	36.8	35.95	35.95	342700.0
2022-12-21	ABB-DELISTED	Stock	30.27	30.595	30.26	30.465	719749.0
2022-12-21	ABBNY-DELISTED	Stock	30.27	30.595	30.26	30.47	824938.0
2022-12-21	ABBV	Stock	161.45	162.73	160.36	162.21	3707200.0
2022-12-21	ABC-DELISTED	Stock	168.25	169.83	167.03	169.32	798347.0
2022-12-21	ABCB	Stock	47.09	48.09	46.83	47.68	305000.0
2022-12-21	ABCL	Stock	10.51	10.88	10.51	10.6	1593000.0
2022-12-21	ABCM-DELISTED	Stock	15.23	16.225	15.1089	15.86	491938.0
2022-12-21	ABEO	Stock	2.58	2.74	2.4	2.68	372900.0
2022-12-21	ABEV	Stock	2.73	2.77	2.72	2.75	20335200.0
2022-12-21	ABG	Stock	159.5	167.79	159.19	165.18	226300.0
2022-12-21	ABGI-DELISTED	Stock	10.06	10.06	10.06	10.06	100.0
2022-12-21	ABM	Stock	45.37	46.11	45.35	45.74	294700.0
2022-12-21	ABMD-DELISTED	Stock	380.8	381.28	380.51	381.15	16992670.0
2022-12-21	ABNB	Stock	87.49	88.79	86.59	87.07	5594800.0
2022-12-21	ABOS	Stock	5.8	5.8	5.2	5.22	83300.0
2022-12-21	ABR	Stock	13.55	13.71	13.54	13.68	1021900.0

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

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