PREVIEW / stock_daily / 2022-12-27

all stock daily files

  file:    by_date/stock_daily/2022/2022-12-27.parquet
  size:    247 KB
  rows:    7,732
  symbols: 1,940

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-27	AAPL	Stock	131.38	131.41	128.72	130.03	69007800.0
2022-12-27	MSFT	Stock	238.7	238.93	235.83	236.96	16688600.0
2022-12-27	NVDA	Stock	15.074	15.1	14.056	14.121	464902000.0
2022-12-27	AMZN	Stock	84.97	85.35	83.0	83.04	57284000.0
2022-12-27	GOOGL	Stock	88.795	88.94	87.01	87.39	20097346.0
2022-12-27	META	Stock	117.93	118.6	116.05	116.88	21392300.0
2022-12-27	TSLA	Stock	117.5	119.67	108.76	109.1	208643400.0
2022-12-27	TLT	Stock	100.49	101.07	100.01	100.14	26475730.0
2022-12-27	ES	Stock	84.55	85.27	84.0	84.97	715100.0
2022-12-27	CL	Stock	79.56	80.23	79.26	79.94	3078600.0
2022-12-27	A	Stock	149.23	149.81	147.3	149.55	879500.0
2022-12-27	AA	Stock	44.9	45.58	44.59	44.86	2031300.0
2022-12-27	AAC-DELISTED	Stock	10.08	10.1	10.07	10.09	360270.0
2022-12-27	AACG	Stock	1.4	1.4	1.35	1.36	6100.0
2022-12-27	AAIC-DELISTED	Stock	2.83	2.88	2.83	2.875	68393.0
2022-12-27	AAIC.C-DELISTED	Stock	21.0	21.1104	21.0	21.0	1050.0
2022-12-27	AAL	Stock	12.62	12.79	12.4	12.53	18878200.0
2022-12-27	AAM.A-DELISTED	Stock	22.93	23.1999	22.13	22.74	36936.0
2022-12-27	AAM.B-DELISTED	Stock	23.02	23.3588	22.0761	22.54	11689.0
2022-12-27	AAMC-DELISTED	Stock	5.7744	5.9059	5.7647	5.8676	26653.0
2022-12-27	AAME	Stock	2.35	2.42	2.35	2.4	5900.0
2022-12-27	AAMI	Stock	19.32	19.48	19.013	19.22	99700.0
2022-12-27	AAN-DELISTED	Stock	11.38	11.41	11.19	11.35	130000.0
2022-12-27	AAOI	Stock	1.87	1.93	1.8	1.83	203900.0
2022-12-27	AAON	Stock	50.76	51.5467	49.3667	51.2667	204150.0
2022-12-27	AAP	Stock	143.28	145.08	141.83	145.02	717100.0
2022-12-27	AAT	Stock	26.53	26.76	26.38	26.66	68900.0
2022-12-27	AATC	Stock	3.78	3.9399	3.78	3.86	77482.0
2022-12-27	AAU-DELISTED	Stock	0.2401	0.2486	0.2401	0.2403	275435.0
2022-12-27	AAUAF-DELISTED	Stock	0.2401	0.2486	0.2401	0.2403	278215.0
2022-12-27	AAWW-DELISTED	Stock	100.72	100.89	100.59	100.83	120634.0
2022-12-27	AAXJ	Stock	65.38	66.052	65.13	65.76	350096.0
2022-12-27	AB	Stock	33.91	34.3	33.51	34.08	470800.0
2022-12-27	ABB-DELISTED	Stock	30.61	30.76	30.5	30.64	674735.0
2022-12-27	ABBNY-DELISTED	Stock	30.61	30.76	30.5	30.64	773621.0
2022-12-27	ABBV	Stock	163.49	163.81	161.78	162.99	2669200.0
2022-12-27	ABC-DELISTED	Stock	170.0	170.31	168.79	168.99	368918.0
2022-12-27	ABCB	Stock	47.96	48.37	47.67	47.96	169200.0
2022-12-27	ABCL	Stock	10.44	10.44	9.435	9.48	1573600.0
2022-12-27	ABCM-DELISTED	Stock	15.45	15.9	15.375	15.8	227700.0
2022-12-27	ABEO	Stock	2.51	2.52	2.34	2.41	398700.0
2022-12-27	ABEV	Stock	2.73	2.76	2.71	2.72	15878600.0
2022-12-27	ABG	Stock	168.67	173.75	168.67	172.5	213800.0
2022-12-27	ABLV	Stock	10.17	10.17	10.17	10.17	20000.0
2022-12-27	ABM	Stock	43.99	44.74	43.51	44.59	209600.0
2022-12-27	ABNB	Stock	84.78	84.93	82.83	83.49	3982400.0
2022-12-27	ABOS	Stock	5.28	5.28	4.96	5.07	59900.0
2022-12-27	ABR	Stock	13.68	13.73	13.5	13.59	1098600.0
2022-12-27	ABR.D	Stock	16.3	16.77	16.25	16.7105	27122.0
2022-12-27	ABR.E	Stock	16.4699	16.9167	16.4	16.55	16852.0

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

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