PREVIEW / stock_daily / 2023-02-01

all stock daily files

  file:    by_date/stock_daily/2023/2023-02-01.parquet
  size:    249 KB
  rows:    7,699
  symbols: 1,886

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-02-01	AAPL	Stock	143.97	146.61	141.32	145.43	77663600.0
2023-02-01	MSFT	Stock	248.0	255.18	245.47	252.75	31259900.0
2023-02-01	NVDA	Stock	19.691	21.192	19.611	20.943	660477000.0
2023-02-01	AMZN	Stock	102.53	106.24	101.24	105.15	80450100.0
2023-02-01	GOOGL	Stock	98.71	101.19	97.58	100.43	35531104.0
2023-02-01	META	Stock	148.03	153.58	147.06	153.12	55661000.0
2023-02-01	TSLA	Stock	173.89	183.81	169.93	181.41	213806300.0
2023-02-01	TLT	Stock	107.55	108.59	106.42	108.18	25305791.0
2023-02-01	ES	Stock	81.9	83.3	81.49	82.71	1689000.0
2023-02-01	CL	Stock	74.43	75.3	74.11	74.99	3722200.0
2023-02-01	A	Stock	153.31	156.29	151.72	155.45	1499900.0
2023-02-01	AA	Stock	52.1	54.73	51.62	54.58	5479100.0
2023-02-01	AAC-DELISTED	Stock	10.19	10.19	10.155	10.16	1313248.0
2023-02-01	AACG	Stock	1.48	1.53	1.43	1.48	4800.0
2023-02-01	AAIC-DELISTED	Stock	3.01	3.09	2.991	3.07	94255.0
2023-02-01	AAIC.C-DELISTED	Stock	22.79	22.79	22.6302	22.6302	600.0
2023-02-01	AAL	Stock	16.04	16.72	15.92	16.69	26925300.0
2023-02-01	AAM.A-DELISTED	Stock	25.3	25.41	24.5723	25.41	6185.0
2023-02-01	AAM.B-DELISTED	Stock	25.15	25.5	24.9	25.41	5451.0
2023-02-01	AAMC-DELISTED	Stock	11.5294	11.5294	10.3235	11.3456	39729.0
2023-02-01	AAME	Stock	2.51	2.55	2.48	2.48	3400.0
2023-02-01	AAMI	Stock	23.41	23.93	23.31	23.8	284400.0
2023-02-01	AAN-DELISTED	Stock	14.55	15.11	14.39	14.89	239300.0
2023-02-01	AAOI	Stock	2.37	2.65	2.36	2.6	262700.0
2023-02-01	AAON	Stock	50.56	52.64	50.3467	51.84	338100.0
2023-02-01	AAP	Stock	151.94	157.73	150.15	156.84	1010500.0
2023-02-01	AAT	Stock	28.31	29.09	28.26	28.97	342700.0
2023-02-01	AATC	Stock	4.17	4.17	4.1	4.15	11712.0
2023-02-01	AAU-DELISTED	Stock	0.234	0.237	0.2313	0.2326	64925.0
2023-02-01	AAUAF-DELISTED	Stock	0.234	0.237	0.2313	0.2326	66102.0
2023-02-01	AAWW-DELISTED	Stock	102.21	102.25	102.13	102.21	289815.0
2023-02-01	AAXJ	Stock	71.37	72.25	71.03	72.03	603384.0
2023-02-01	AB	Stock	37.71	38.86	37.6	38.58	190400.0
2023-02-01	ABB-DELISTED	Stock	35.01	35.54	34.71	35.33	1277414.0
2023-02-01	ABBNY-DELISTED	Stock	35.01	35.54	34.71	35.33	1416594.0
2023-02-01	ABBV	Stock	146.63	147.44	145.25	146.6	5439900.0
2023-02-01	ABC-DELISTED	Stock	168.15	168.575	160.2	161.1	1575004.0
2023-02-01	ABCB	Stock	47.03	48.71	46.28	47.96	422500.0
2023-02-01	ABCL	Stock	10.58	10.845	10.215	10.76	1595000.0
2023-02-01	ABCM-DELISTED	Stock	13.9	14.94	13.87	14.58	963035.0
2023-02-01	ABEO	Stock	2.55	2.65	2.52	2.65	105200.0
2023-02-01	ABEV	Stock	2.59	2.63	2.5	2.59	95144700.0
2023-02-01	ABG	Stock	219.37	234.01	219.37	231.64	359700.0
2023-02-01	ABGI-DELISTED	Stock	10.15	10.15	10.15	10.15	451200.0
2023-02-01	ABM	Stock	46.75	47.64	46.33	47.23	250500.0
2023-02-01	ABNB	Stock	111.11	114.89	109.83	113.99	4053600.0
2023-02-01	ABOS	Stock	6.76	6.835	6.36	6.65	152600.0
2023-02-01	ABR	Stock	14.93	15.26	14.86	15.16	2274800.0
2023-02-01	ABR.D	Stock	20.5	20.85	20.38	20.71	48084.0
2023-02-01	ABR.E	Stock	20.6	21.7	20.45	21.42	15887.0

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

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