PREVIEW / stock_daily / 2022-12-22

all stock daily files

  file:    by_date/stock_daily/2022/2022-12-22.parquet
  size:    248 KB
  rows:    7,723
  symbols: 1,958

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-22	AAPL	Stock	134.35	134.56	130.3	132.23	77852100.0
2022-12-22	MSFT	Stock	241.26	241.99	233.87	238.19	28651700.0
2022-12-22	NVDA	Stock	16.094	16.138	14.882	15.339	565045000.0
2022-12-22	AMZN	Stock	85.52	85.68	82.25	83.79	81431300.0
2022-12-22	GOOGL	Stock	88.16	88.54	86.32	87.76	27658293.0
2022-12-22	META	Stock	117.2	118.62	114.38	117.12	23618100.0
2022-12-22	TSLA	Stock	136.0	136.63	122.26	125.35	210090300.0
2022-12-22	TLT	Stock	103.67	104.12	103.38	103.68	11322512.0
2022-12-22	ES	Stock	83.71	84.0	81.86	83.14	1164500.0
2022-12-22	CL	Stock	78.99	79.31	78.22	79.28	2548400.0
2022-12-22	A	Stock	148.41	149.19	146.61	149.01	1166800.0
2022-12-22	AA	Stock	44.58	44.63	41.82	43.85	3730300.0
2022-12-22	AAC-DELISTED	Stock	10.09	10.09	10.07	10.07	141647.0
2022-12-22	AACG	Stock	1.44	1.45	1.35	1.45	8700.0
2022-12-22	AACIW-DELISTED	Stock	0.0298	0.0307	0.02966	0.0307	12466.0
2022-12-22	AAIC-DELISTED	Stock	2.87	2.9	2.82	2.87	195023.0
2022-12-22	AAIC.C-DELISTED	Stock	21.3	21.3	21.3	21.3	699.0
2022-12-22	AAL	Stock	12.98	13.0	12.23	12.56	25372900.0
2022-12-22	AAM.A-DELISTED	Stock	23.16	23.2899	23.035	23.09	12691.0
2022-12-22	AAM.B-DELISTED	Stock	23.17	23.4309	23.0	23.056	6330.0
2022-12-22	AAMC-DELISTED	Stock	5.7647	5.8574	5.7	5.7647	14168.0
2022-12-22	AAME	Stock	2.42	2.5	2.41	2.5	8400.0
2022-12-22	AAMI	Stock	19.35	19.35	18.69	19.14	90300.0
2022-12-22	AAN-DELISTED	Stock	11.19	11.245	10.86	11.23	369200.0
2022-12-22	AAOI	Stock	2.13	2.13	1.95	2.0	214500.0
2022-12-22	AAON	Stock	51.1667	51.3867	50.4533	51.08	426300.0
2022-12-22	AAP	Stock	140.54	142.35	138.52	142.08	715600.0
2022-12-22	AAT	Stock	26.2	26.5	25.88	26.49	266400.0
2022-12-22	AATC	Stock	4.32	4.32	3.7367	3.75	167370.0
2022-12-22	AAU-DELISTED	Stock	0.2469	0.2499	0.246	0.2461	251646.0
2022-12-22	AAUAF-DELISTED	Stock	0.2469	0.2499	0.246	0.246	253548.0
2022-12-22	AAWW-DELISTED	Stock	100.18	100.76	100.18	100.62	227707.0
2022-12-22	AAXJ	Stock	65.12	65.17	64.1506	64.62	558014.0
2022-12-22	AB	Stock	35.5	35.58	34.37	34.82	503900.0
2022-12-22	ABB-DELISTED	Stock	30.2	30.215	29.76	30.13	827041.0
2022-12-22	ABBNY-DELISTED	Stock	30.2	30.215	29.76	30.13	940746.0
2022-12-22	ABBV	Stock	161.87	163.39	161.53	163.27	3606000.0
2022-12-22	ABC-DELISTED	Stock	169.33	171.06	168.08	169.27	649493.0
2022-12-22	ABCB	Stock	47.4	47.68	46.4	47.13	330700.0
2022-12-22	ABCL	Stock	10.52	10.56	10.27	10.54	1256100.0
2022-12-22	ABCM-DELISTED	Stock	15.71	15.96	15.33	15.74	260502.0
2022-12-22	ABEO	Stock	2.65	2.65	2.39	2.6	262400.0
2022-12-22	ABEV	Stock	2.75	2.77	2.72	2.76	11960000.0
2022-12-22	ABG	Stock	159.47	166.43	157.47	166.27	284600.0
2022-12-22	ABGI-DELISTED	Stock	10.1	10.12	10.06	10.06	28309.0
2022-12-22	ABM	Stock	45.32	45.32	43.4	43.73	368800.0
2022-12-22	ABNB	Stock	85.54	86.09	82.58	84.87	5643100.0
2022-12-22	ABOS	Stock	5.19	5.6	5.19	5.56	88200.0
2022-12-22	ABR	Stock	13.58	13.6	13.24	13.59	1089400.0
2022-12-22	ABR.D	Stock	16.61	16.7562	16.2	16.255	21712.0

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

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