PREVIEW / stock_daily / 2022-12-28

all stock daily files

  file:    by_date/stock_daily/2022/2022-12-28.parquet
  size:    248 KB
  rows:    7,720
  symbols: 1,954

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-28	AAPL	Stock	129.67	131.03	125.87	126.04	85438400.0
2022-12-28	MSFT	Stock	236.89	239.72	234.17	234.53	17457100.0
2022-12-28	NVDA	Stock	13.927	14.262	13.884	14.036	351066000.0
2022-12-28	AMZN	Stock	82.8	83.48	81.69	81.82	58228600.0
2022-12-28	GOOGL	Stock	86.98	88.04	85.94	86.02	19523176.0
2022-12-28	META	Stock	116.25	118.15	115.51	115.62	19612500.0
2022-12-28	TSLA	Stock	110.35	116.27	108.24	112.71	221070500.0
2022-12-28	TLT	Stock	100.65	100.78	99.35	99.55	17302853.0
2022-12-28	ES	Stock	85.17	85.58	84.09	84.28	962500.0
2022-12-28	CL	Stock	80.17	80.44	78.81	78.82	1918700.0
2022-12-28	A	Stock	149.78	151.37	147.64	148.09	784300.0
2022-12-28	AA	Stock	44.86	44.86	43.43	43.8	3116300.0
2022-12-28	AAC-DELISTED	Stock	10.09	10.095	10.08	10.09	244274.0
2022-12-28	AACG	Stock	1.3	1.39	1.3	1.31	11500.0
2022-12-28	AACIU	Stock	10.12	10.12	10.12	10.12	494.0
2022-12-28	AACIW-DELISTED	Stock	0.07	0.07	0.031	0.031	15600.0
2022-12-28	AAIC-DELISTED	Stock	2.82	2.85	2.82	2.84	96999.0
2022-12-28	AAL	Stock	12.52	12.68	12.25	12.32	20470400.0
2022-12-28	AAM.A-DELISTED	Stock	22.76	23.1	22.4731	22.73	26422.0
2022-12-28	AAM.B-DELISTED	Stock	22.24	23.24	22.24	23.005	15466.0
2022-12-28	AAME	Stock	2.37	2.37	2.33	2.33	1400.0
2022-12-28	AAMI	Stock	19.21	19.43	18.97	19.13	129000.0
2022-12-28	AAN-DELISTED	Stock	11.36	11.65	11.21	11.32	249000.0
2022-12-28	AAOI	Stock	1.83	1.861	1.691	1.74	227100.0
2022-12-28	AAON	Stock	51.16	51.8333	50.3067	50.4	130950.0
2022-12-28	AAP	Stock	144.95	146.6	144.33	145.3	685500.0
2022-12-28	AAT	Stock	26.77	26.78	25.98	26.09	172400.0
2022-12-28	AATC	Stock	3.84	3.89	3.7	3.77	86806.0
2022-12-28	AAU-DELISTED	Stock	0.2499	0.254	0.2355	0.2355	392956.0
2022-12-28	AAUAF-DELISTED	Stock	0.2499	0.254	0.2355	0.2355	394994.0
2022-12-28	AAWW-DELISTED	Stock	100.95	101.44	100.81	101.2	130554.0
2022-12-28	AAXJ	Stock	65.4	65.47	64.42	64.42	1083702.0
2022-12-28	AB	Stock	33.86	34.1	32.93	33.13	469500.0
2022-12-28	ABB-DELISTED	Stock	30.64	30.76	30.26	30.27	1005717.0
2022-12-28	ABBNY-DELISTED	Stock	30.64	30.76	30.26	30.27	1111835.0
2022-12-28	ABBV	Stock	163.7	164.69	162.11	162.23	2944500.0
2022-12-28	ABC-DELISTED	Stock	169.56	169.93	167.12	167.29	553981.0
2022-12-28	ABCB	Stock	47.89	49.12	46.85	46.96	285500.0
2022-12-28	ABCL	Stock	9.41	9.635	9.345	9.57	1565100.0
2022-12-28	ABCM-DELISTED	Stock	15.91	16.26	15.41	15.46	204400.0
2022-12-28	ABEO	Stock	2.46	2.5	2.34	2.4	158400.0
2022-12-28	ABEV	Stock	2.76	2.79	2.73	2.75	18334800.0
2022-12-28	ABG	Stock	174.23	174.38	169.42	169.96	152900.0
2022-12-28	ABM	Stock	44.77	45.02	43.96	44.09	302200.0
2022-12-28	ABNB	Stock	83.25	84.25	81.91	82.49	4931700.0
2022-12-28	ABOS	Stock	4.98	5.07	4.58	4.81	98200.0
2022-12-28	ABR	Stock	13.56	13.58	13.1	13.15	1271800.0
2022-12-28	ABR.D	Stock	16.81	17.12	16.61	16.97	30655.0
2022-12-28	ABR.E	Stock	16.77	16.8659	16.27	16.51	19733.0
2022-12-28	ABR.F	Stock	17.81	18.05	17.75	17.99	20936.0

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

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