PREVIEW / stock_daily / 2022-12-30

all stock daily files

  file:    by_date/stock_daily/2022/2022-12-30.parquet
  size:    249 KB
  rows:    7,790
  symbols: 1,971

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-30	AAPL	Stock	128.41	129.95	127.43	129.93	77034200.0
2022-12-30	MSFT	Stock	238.21	239.96	236.66	239.82	21938500.0
2022-12-30	NVDA	Stock	14.334	14.629	14.233	14.614	310490000.0
2022-12-30	AMZN	Stock	83.12	84.05	82.47	84.0	62401200.0
2022-12-30	GOOGL	Stock	86.98	88.3	86.57	88.23	23986297.0
2022-12-30	META	Stock	118.16	120.42	117.74	120.34	19583800.0
2022-12-30	TSLA	Stock	119.95	124.48	119.75	123.18	157777300.0
2022-12-30	TLT	Stock	99.87	100.55	99.37	99.56	20810209.0
2022-12-30	ES	Stock	85.1	85.32	83.11	83.84	1050900.0
2022-12-30	CL	Stock	79.33	79.45	78.21	78.79	2238600.0
2022-12-30	A	Stock	149.76	149.85	147.83	149.65	699800.0
2022-12-30	AA	Stock	46.01	46.48	44.69	45.47	3614400.0
2022-12-30	AAC-DELISTED	Stock	10.08	10.09	10.075	10.075	213043.0
2022-12-30	AACG	Stock	1.23	1.32	1.13	1.27	14400.0
2022-12-30	AAIC-DELISTED	Stock	2.9	2.93	2.9	2.93	69603.0
2022-12-30	AAIC.C-DELISTED	Stock	21.07	21.0899	20.87	21.0899	1552.0
2022-12-30	AAL	Stock	12.55	12.83	12.53	12.72	19002800.0
2022-12-30	AAM.A-DELISTED	Stock	23.35	23.35	21.69	21.84	61607.0
2022-12-30	AAM.B-DELISTED	Stock	22.31	23.32	21.63	21.75	52388.0
2022-12-30	AAMC-DELISTED	Stock	6.0294	6.0294	5.9265	5.9559	25554.0
2022-12-30	AAME	Stock	2.37	2.42	2.32	2.34	5500.0
2022-12-30	AAMI	Stock	19.9	20.7	19.745	20.58	263500.0
2022-12-30	AAN-DELISTED	Stock	11.59	12.06	11.59	11.95	317300.0
2022-12-30	AAOI	Stock	1.9	1.94	1.85	1.89	221100.0
2022-12-30	AAON	Stock	50.8067	51.4067	49.88	50.2133	153750.0
2022-12-30	AAP	Stock	145.55	147.45	145.02	147.03	1004700.0
2022-12-30	AAT	Stock	26.56	26.71	26.19	26.5	211900.0
2022-12-30	AATC	Stock	3.62	3.85	3.56	3.6	198265.0
2022-12-30	AAU-DELISTED	Stock	0.24	0.2483	0.23	0.2443	191479.0
2022-12-30	AAUAF-DELISTED	Stock	0.24	0.2483	0.23	0.2443	188885.0
2022-12-30	AAWW-DELISTED	Stock	100.86	100.86	100.74	100.77	224975.0
2022-12-30	AAXJ	Stock	65.29	65.48	64.62	64.79	572589.0
2022-12-30	AB	Stock	33.9	34.5	33.75	34.37	402800.0
2022-12-30	ABB-DELISTED	Stock	30.6	30.72	30.2841	30.46	1043137.0
2022-12-30	ABBNY-DELISTED	Stock	30.6	30.72	30.2841	30.46	1150756.0
2022-12-30	ABBV	Stock	162.23	162.85	159.82	161.61	3680400.0
2022-12-30	ABC-DELISTED	Stock	165.42	166.23	164.25	165.72	855208.0
2022-12-30	ABCB	Stock	46.99	47.4	46.74	47.14	301900.0
2022-12-30	ABCL	Stock	9.92	10.16	9.9	10.13	1413900.0
2022-12-30	ABCM-DELISTED	Stock	15.4	15.71	15.06	15.57	369181.0
2022-12-30	ABEO	Stock	2.74	3.08	2.67	3.08	241900.0
2022-12-30	ABEV	Stock	2.73	2.78	2.72	2.72	6640700.0
2022-12-30	ABG	Stock	173.69	181.26	173.69	179.25	307500.0
2022-12-30	ABGI-DELISTED	Stock	10.08	10.1	10.08	10.09	99044.0
2022-12-30	ABM	Stock	44.47	44.96	44.19	44.42	218500.0
2022-12-30	ABNB	Stock	83.61	86.06	83.6	85.5	3372500.0
2022-12-30	ABOS	Stock	5.24	5.41	5.121	5.4	42000.0
2022-12-30	ABR	Stock	13.16	13.24	13.02	13.19	1699800.0
2022-12-30	ABR.D	Stock	17.2	17.48	17.2	17.26	38544.0
2022-12-30	ABR.E	Stock	16.9391	16.9958	16.51	16.61	24082.0

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

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