PREVIEW / stock_daily / 2023-01-20

all stock daily files

  file:    by_date/stock_daily/2023/2023-01-20.parquet
  size:    249 KB
  rows:    7,721
  symbols: 1,922

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
2023-01-20	AAPL	Stock	135.28	138.02	134.22	137.87	80223600.0
2023-01-20	MSFT	Stock	234.86	240.74	234.51	240.22	35389800.0
2023-01-20	NVDA	Stock	17.011	17.856	16.825	17.839	564967000.0
2023-01-20	AMZN	Stock	93.86	97.35	93.2	97.25	67481500.0
2023-01-20	GOOGL	Stock	95.1	98.3	95.02	98.02	63191078.0
2023-01-20	META	Stock	135.89	139.94	134.61	139.37	28688600.0
2023-01-20	TSLA	Stock	128.68	133.51	127.35	133.42	138858100.0
2023-01-20	TLT	Stock	106.96	107.24	106.11	106.2	22754067.0
2023-01-20	ES	Stock	79.79	80.1	77.39	79.74	2319600.0
2023-01-20	CL	Stock	74.75	75.54	74.03	75.44	11899800.0
2023-01-20	A	Stock	153.5	156.01	152.41	155.92	1343700.0
2023-01-20	AA	Stock	49.135	51.73	48.68	51.0	6098000.0
2023-01-20	AAC-DELISTED	Stock	10.14	10.14	10.12	10.12	50629.0
2023-01-20	AACG	Stock	1.38	1.44	1.31	1.37	18300.0
2023-01-20	AACIW-DELISTED	Stock	0.095	0.1001	0.0931	0.095	89197.0
2023-01-20	AAIC-DELISTED	Stock	3.0	3.06	3.0	3.05	87325.0
2023-01-20	AAIC.C-DELISTED	Stock	21.855	21.98	21.855	21.98	890.0
2023-01-20	AAL	Stock	16.37	16.54	16.14	16.34	22487700.0
2023-01-20	AAM.A-DELISTED	Stock	24.69	24.69	24.35	24.67	11334.0
2023-01-20	AAM.B-DELISTED	Stock	24.35	24.56	24.01	24.11	21146.0
2023-01-20	AAMC-DELISTED	Stock	8.7911	9.0	8.5882	8.6029	35129.0
2023-01-20	AAME	Stock	2.45	2.5	2.37	2.5	5400.0
2023-01-20	AAMI	Stock	22.2	22.91	21.9	22.83	189600.0
2023-01-20	AAN-DELISTED	Stock	13.69	14.22	13.52	14.18	203600.0
2023-01-20	AAOI	Stock	2.29	2.3	2.18	2.21	125200.0
2023-01-20	AAON	Stock	49.3333	49.3333	48.5067	48.8467	227250.0
2023-01-20	AAP	Stock	143.56	147.55	142.86	147.49	950500.0
2023-01-20	AAT	Stock	27.41	27.41	26.97	27.22	192100.0
2023-01-20	AATC	Stock	4.0	4.05	4.0	4.02	5060.0
2023-01-20	AAU-DELISTED	Stock	0.24	0.2428	0.2307	0.2336	289882.0
2023-01-20	AAUAF-DELISTED	Stock	0.24	0.2428	0.2307	0.2334	302422.0
2023-01-20	AAWW-DELISTED	Stock	101.81	102.04	101.75	102.03	281852.0
2023-01-20	AAXJ	Stock	71.13	71.71	70.94	71.68	478340.0
2023-01-20	AB	Stock	36.48	37.44	36.12	37.37	126100.0
2023-01-20	ABB-DELISTED	Stock	33.6	33.96	33.55	33.96	995741.0
2023-01-20	ABBNY-DELISTED	Stock	33.62	33.96	33.55	33.96	1123848.0
2023-01-20	ABBV	Stock	149.43	149.71	147.15	149.59	7059000.0
2023-01-20	ABC-DELISTED	Stock	163.88	164.32	161.27	162.17	830251.0
2023-01-20	ABCB	Stock	47.62	48.35	47.04	48.22	375400.0
2023-01-20	ABCL	Stock	10.33	10.43	10.05	10.34	1023000.0
2023-01-20	ABCM-DELISTED	Stock	15.81	16.38	15.6	16.38	503737.0
2023-01-20	ABEO	Stock	2.55	2.59	2.5	2.56	170600.0
2023-01-20	ABEV	Stock	2.58	2.62	2.56	2.6	17740300.0
2023-01-20	ABG	Stock	185.62	190.03	184.93	189.96	97600.0
2023-01-20	ABGI-DELISTED	Stock	10.14	10.15	10.14	10.14	242805.0
2023-01-20	ABM	Stock	44.72	44.98	44.01	44.93	211100.0
2023-01-20	ABNB	Stock	99.01	101.37	98.111	101.28	5104000.0
2023-01-20	ABOS	Stock	6.02	6.02	5.44	5.72	52800.0
2023-01-20	ABR	Stock	14.2	14.31	14.02	14.27	1304600.0
2023-01-20	ABR.D	Stock	20.0	20.25	19.675	19.825	11468.0

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

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