PREVIEW / stock_daily / 2022-12-29

all stock daily files

  file:    by_date/stock_daily/2022/2022-12-29.parquet
  size:    248 KB
  rows:    7,715
  symbols: 1,941

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-29	AAPL	Stock	127.99	130.48	127.73	129.61	75703700.0
2022-12-29	MSFT	Stock	235.65	241.92	235.65	241.01	19770700.0
2022-12-29	NVDA	Stock	14.402	14.683	14.227	14.603	354923000.0
2022-12-29	AMZN	Stock	82.87	84.55	82.55	84.18	54995900.0
2022-12-29	GOOGL	Stock	86.62	88.845	86.61	88.45	23333537.0
2022-12-29	META	Stock	116.4	121.03	115.77	120.26	22366200.0
2022-12-29	TSLA	Stock	120.39	123.57	117.5	121.82	221923300.0
2022-12-29	TLT	Stock	99.86	100.99	99.79	100.68	16592967.0
2022-12-29	ES	Stock	84.71	85.47	84.39	85.08	605800.0
2022-12-29	CL	Stock	79.29	79.66	78.96	79.37	1954200.0
2022-12-29	A	Stock	149.61	151.9	149.02	151.09	854400.0
2022-12-29	AA	Stock	44.03	46.7	43.73	46.56	4744700.0
2022-12-29	AAC-DELISTED	Stock	10.09	10.09	10.08	10.09	113391.0
2022-12-29	AACG	Stock	1.45	1.5	1.24	1.35	26500.0
2022-12-29	AAIC-DELISTED	Stock	2.83	2.935	2.82	2.92	73424.0
2022-12-29	AAL	Stock	12.39	12.71	12.3	12.7	19706300.0
2022-12-29	AAM.A-DELISTED	Stock	22.9861	23.26	22.7	23.0339	20767.0
2022-12-29	AAM.B-DELISTED	Stock	22.8	23.4	22.32	22.3239	20320.0
2022-12-29	AAMC-DELISTED	Stock	5.8483	5.9765	5.8088	5.9746	22729.0
2022-12-29	AAME	Stock	2.34	2.35	2.18	2.18	9100.0
2022-12-29	AAMI	Stock	19.31	20.24	19.31	20.17	198600.0
2022-12-29	AAN-DELISTED	Stock	11.44	11.83	11.44	11.8	170600.0
2022-12-29	AAOI	Stock	1.73	1.98	1.73	1.9	280900.0
2022-12-29	AAON	Stock	50.8067	51.46	50.5867	51.2333	283050.0
2022-12-29	AAP	Stock	146.11	146.9	145.67	146.31	719100.0
2022-12-29	AAT	Stock	26.27	26.69	26.21	26.65	183600.0
2022-12-29	AATC	Stock	3.79	3.8499	3.63	3.63	156515.0
2022-12-29	AAU-DELISTED	Stock	0.235	0.2454	0.2338	0.24	328505.0
2022-12-29	AAUAF-DELISTED	Stock	0.235	0.2454	0.2338	0.24	331133.0
2022-12-29	AAWW-DELISTED	Stock	101.05	101.23	100.52	100.845	229233.0
2022-12-29	AAXJ	Stock	65.01	65.775	65.01	65.72	434665.0
2022-12-29	AB	Stock	33.1	34.7	33.1	34.36	448100.0
2022-12-29	ABB-DELISTED	Stock	30.72	30.96	30.685	30.885	932039.0
2022-12-29	ABBNY-DELISTED	Stock	30.72	30.96	30.685	30.88	1037903.0
2022-12-29	ABBV	Stock	162.96	163.88	162.19	162.56	3112500.0
2022-12-29	ABC-DELISTED	Stock	168.0	168.54	165.85	166.05	1052055.0
2022-12-29	ABCB	Stock	47.06	47.67	46.64	47.32	236400.0
2022-12-29	ABCL	Stock	9.67	10.14	9.51	10.05	1634700.0
2022-12-29	ABCM-DELISTED	Stock	15.62	15.95	15.5	15.53	205505.0
2022-12-29	ABEO	Stock	2.37	2.92	2.36	2.82	1376000.0
2022-12-29	ABEV	Stock	2.78	2.79	2.73	2.75	11113700.0
2022-12-29	ABG	Stock	172.24	176.54	170.05	175.0	168600.0
2022-12-29	ABLV	Stock	10.18	10.18	10.18	10.18	8616.0
2022-12-29	ABM	Stock	44.35	45.0	43.99	44.77	203000.0
2022-12-29	ABNB	Stock	82.97	85.56	82.29	85.23	4031300.0
2022-12-29	ABOS	Stock	4.8	5.467	4.73	5.37	55300.0
2022-12-29	ABR	Stock	13.2	13.35	13.12	13.25	1706500.0
2022-12-29	ABR.D	Stock	16.9175	17.3399	16.9101	17.12	15967.0
2022-12-29	ABR.E	Stock	16.69	16.8	16.58	16.8	11606.0
2022-12-29	ABR.F	Stock	18.0747	18.22	18.0	18.14	4697.0

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

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