PREVIEW / stock_daily / 2022-12-23

all stock daily files

  file:    by_date/stock_daily/2022/2022-12-23.parquet
  size:    245 KB
  rows:    7,669
  symbols: 1,929

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-23	AAPL	Stock	130.92	132.42	129.64	131.86	63814900.0
2022-12-23	MSFT	Stock	236.11	238.87	233.94	238.73	21207000.0
2022-12-23	NVDA	Stock	15.196	15.339	14.883	15.206	349326000.0
2022-12-23	AMZN	Stock	83.25	85.78	82.93	85.25	57433700.0
2022-12-23	GOOGL	Stock	87.11	89.545	87.07	89.23	23003035.0
2022-12-23	META	Stock	116.03	118.18	115.54	118.04	17796600.0
2022-12-23	TSLA	Stock	126.37	128.62	121.02	123.15	166989700.0
2022-12-23	TLT	Stock	102.58	102.81	102.0225	102.16	15408891.0
2022-12-23	ES	Stock	82.95	84.34	82.61	84.23	892600.0
2022-12-23	CL	Stock	79.21	79.58	78.94	79.45	1488500.0
2022-12-23	A	Stock	149.01	150.25	148.22	149.23	779400.0
2022-12-23	AA	Stock	44.17	44.57	43.5	44.2	2061800.0
2022-12-23	AAC-DELISTED	Stock	10.06	10.09	10.06	10.08	317513.0
2022-12-23	AACG	Stock	1.46	1.5	1.44	1.44	10000.0
2022-12-23	AACIW-DELISTED	Stock	0.03	0.0301	0.03	0.0301	25333.0
2022-12-23	AAIC-DELISTED	Stock	2.89	2.9	2.83	2.88	157734.0
2022-12-23	AAIC.C-DELISTED	Stock	20.71	21.15	20.49	21.1	7684.0
2022-12-23	AAL	Stock	12.51	12.71	12.33	12.71	17181200.0
2022-12-23	AAM.A-DELISTED	Stock	23.13	23.27	23.048	23.205	6930.0
2022-12-23	AAM.B-DELISTED	Stock	23.19	23.417	23.0	23.25	15422.0
2022-12-23	AAME	Stock	2.41	2.42	2.41	2.42	1900.0
2022-12-23	AAMI	Stock	19.17	19.38	19.06	19.32	89500.0
2022-12-23	AAN-DELISTED	Stock	11.24	11.45	11.24	11.37	138800.0
2022-12-23	AAOI	Stock	1.96	1.98	1.87	1.95	204100.0
2022-12-23	AAON	Stock	50.5067	51.0067	50.3533	50.5733	219450.0
2022-12-23	AAP	Stock	141.9	143.59	141.51	143.28	524500.0
2022-12-23	AAT	Stock	26.32	26.59	26.25	26.53	106100.0
2022-12-23	AATC	Stock	3.75	3.8459	3.74	3.8	154803.0
2022-12-23	AAU-DELISTED	Stock	0.2474	0.2491	0.2438	0.2451	163058.0
2022-12-23	AAUAF-DELISTED	Stock	0.2474	0.2491	0.2438	0.245	165930.0
2022-12-23	AAWW-DELISTED	Stock	100.72	100.76	100.57	100.69	108176.0
2022-12-23	AAXJ	Stock	64.6	64.65	64.21	64.51	409925.0
2022-12-23	AB	Stock	34.48	34.75	34.08	34.27	415800.0
2022-12-23	ABB-DELISTED	Stock	30.14	30.315	30.03	30.3	589679.0
2022-12-23	ABBNY-DELISTED	Stock	30.14	30.315	30.03	30.3	675249.0
2022-12-23	ABBV	Stock	163.39	163.82	162.33	163.1	2685100.0
2022-12-23	ABC-DELISTED	Stock	169.21	170.44	168.84	170.01	337901.0
2022-12-23	ABCB	Stock	47.16	47.97	47.08	47.86	149600.0
2022-12-23	ABCL	Stock	10.49	10.54	10.274	10.33	1234900.0
2022-12-23	ABCM-DELISTED	Stock	15.62	15.69	15.2509	15.46	172345.0
2022-12-23	ABEO	Stock	2.61	2.64	2.46	2.51	131400.0
2022-12-23	ABEV	Stock	2.82	2.85	2.81	2.81	10219400.0
2022-12-23	ABG	Stock	166.37	170.36	165.88	169.01	248800.0
2022-12-23	ABGI-DELISTED	Stock	10.08	10.09	10.07	10.07	24604.0
2022-12-23	ABLV	Stock	10.15	10.15	10.15	10.15	27500.0
2022-12-23	ABM	Stock	43.44	44.31	43.37	44.11	199300.0
2022-12-23	ABNB	Stock	84.7	85.51	83.5	85.25	3057700.0
2022-12-23	ABOS	Stock	5.54	5.66	4.93	5.21	96000.0
2022-12-23	ABR	Stock	13.53	13.73	13.52	13.7	821600.0
2022-12-23	ABR.D	Stock	16.01	16.35	16.01	16.3177	36498.0

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

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