PREVIEW / stock_daily / 2022-12-19

all stock daily files

  file:    by_date/stock_daily/2022/2022-12-19.parquet
  size:    250 KB
  rows:    7,782
  symbols: 1,997

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-19	AAPL	Stock	135.11	135.2	131.32	132.37	79592600.0
2022-12-19	MSFT	Stock	244.86	245.21	238.71	240.45	29696400.0
2022-12-19	NVDA	Stock	16.572	16.609	16.145	16.254	354039000.0
2022-12-19	AMZN	Stock	87.51	87.63	84.51	84.92	83531500.0
2022-12-19	GOOGL	Stock	90.255	90.56	88.21	88.44	29493030.0
2022-12-19	META	Stock	116.83	117.8	114.33	114.48	29769900.0
2022-12-19	TSLA	Stock	154.0	155.25	145.82	149.87	139390600.0
2022-12-19	TLT	Stock	105.83	105.84	104.98	105.31	26126829.0
2022-12-19	ES	Stock	82.5	83.54	82.1	82.83	1120600.0
2022-12-19	CL	Stock	77.6	78.92	77.42	77.98	3440300.0
2022-12-19	A	Stock	148.91	149.13	146.24	146.95	1277300.0
2022-12-19	AA	Stock	43.0	43.2	41.91	42.32	3189400.0
2022-12-19	AAC-DELISTED	Stock	10.09	10.09	10.07	10.09	2078258.0
2022-12-19	AACG	Stock	1.61	1.61	1.48	1.54	3200.0
2022-12-19	AAIC-DELISTED	Stock	2.9	2.98	2.865	2.98	321289.0
2022-12-19	AAIC.C-DELISTED	Stock	21.73	21.73	21.365	21.365	1752.0
2022-12-19	AAL	Stock	12.85	12.89	12.46	12.48	21884000.0
2022-12-19	AAM.A-DELISTED	Stock	23.32	23.5	22.8	23.1	26431.0
2022-12-19	AAM.B-DELISTED	Stock	23.38	23.6	22.9101	23.0098	13723.0
2022-12-19	AAMC-DELISTED	Stock	5.8529	5.8971	5.7868	5.7941	8531.0
2022-12-19	AAME	Stock	2.48	2.48	2.48	2.48	6800.0
2022-12-19	AAMI	Stock	18.5	19.0	18.5	18.89	136400.0
2022-12-19	AAN-DELISTED	Stock	11.77	12.0	11.46	11.54	403200.0
2022-12-19	AAOI	Stock	2.15	2.16	2.12	2.13	198400.0
2022-12-19	AAON	Stock	51.22	51.6667	49.84	50.6867	351150.0
2022-12-19	AAP	Stock	140.75	142.41	140.19	140.9	917400.0
2022-12-19	AAT	Stock	26.62	26.74	26.15	26.3	213900.0
2022-12-19	AATC	Stock	5.0141	5.09	5.0141	5.05	4052.0
2022-12-19	AAU-DELISTED	Stock	0.2401	0.2464	0.24	0.2441	353152.0
2022-12-19	AAUAF-DELISTED	Stock	0.2401	0.2464	0.24	0.242	355998.0
2022-12-19	AAWW-DELISTED	Stock	100.33	100.49	100.15	100.18	210191.0
2022-12-19	AAXJ	Stock	65.39	65.39	64.795	64.91	499830.0
2022-12-19	AB	Stock	37.49	37.65	35.97	36.3	365200.0
2022-12-19	ABB-DELISTED	Stock	30.13	30.3	30.04	30.115	985857.0
2022-12-19	ABBNY-DELISTED	Stock	30.13	30.3	30.04	30.11	1109387.0
2022-12-19	ABBV	Stock	160.78	162.23	160.06	161.49	4033400.0
2022-12-19	ABC-DELISTED	Stock	167.02	168.75	166.355	167.21	1002350.0
2022-12-19	ABCB	Stock	46.08	47.07	45.84	46.77	374200.0
2022-12-19	ABCL	Stock	10.2	10.25	9.865	9.94	1679600.0
2022-12-19	ABCM-DELISTED	Stock	15.48	15.495	15.1	15.26	684471.0
2022-12-19	ABEO	Stock	2.66	2.87	2.51	2.54	347600.0
2022-12-19	ABEV	Stock	2.8	2.89	2.78	2.85	33141600.0
2022-12-19	ABG	Stock	167.1	168.74	161.21	161.87	246300.0
2022-12-19	ABGI-DELISTED	Stock	10.06	10.06	10.06	10.06	400.0
2022-12-19	ABM	Stock	44.02	45.13	44.01	45.02	449900.0
2022-12-19	ABMD-DELISTED	Stock	381.25	381.69	381.18	381.25	991984.0
2022-12-19	ABNB	Stock	89.51	89.76	85.4	85.93	4717100.0
2022-12-19	ABOS	Stock	5.68	5.68	5.21	5.57	87500.0
2022-12-19	ABR	Stock	13.54	13.71	13.36	13.44	1495000.0
2022-12-19	ABR.D	Stock	16.95	17.07	16.4999	16.55	30161.0

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

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