PREVIEW / stock_daily / 2023-02-22

all stock daily files

  file:    by_date/stock_daily/2023/2023-02-22.parquet
  size:    247 KB
  rows:    7,640
  symbols: 1,809

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-22	AAPL	Stock	148.87	149.95	147.16	148.91	51011300.0
2023-02-22	MSFT	Stock	254.09	254.34	250.34	251.51	22491100.0
2023-02-22	NVDA	Stock	20.707	21.104	20.421	20.754	513184000.0
2023-02-22	AMZN	Stock	95.1	97.01	94.8	95.79	59534100.0
2023-02-22	GOOGL	Stock	91.7	92.11	90.61	91.65	30884017.0
2023-02-22	META	Stock	171.07	172.76	169.69	171.12	22433200.0
2023-02-22	TSLA	Stock	197.93	201.99	191.78	200.86	191828500.0
2023-02-22	TLT	Stock	100.99	101.69	100.95	101.31	15165423.0
2023-02-22	ES	Stock	78.44	79.36	78.14	78.43	1919600.0
2023-02-22	CL	Stock	74.5	75.04	74.19	74.41	3645600.0
2023-02-22	A	Stock	143.37	143.44	140.95	142.08	1691300.0
2023-02-22	AA	Stock	49.73	50.96	48.51	48.98	7719800.0
2023-02-22	AAC-DELISTED	Stock	10.23	10.23	10.22	10.23	39922.0
2023-02-22	AACG	Stock	1.94	2.01	1.85	1.9	15700.0
2023-02-22	AAIC-DELISTED	Stock	3.02	3.04	3.0029	3.02	76044.0
2023-02-22	AAIC.C-DELISTED	Stock	23.4	23.74	23.125	23.125	3456.0
2023-02-22	AAL	Stock	15.64	15.82	15.42	15.56	22273800.0
2023-02-22	AAM.A-DELISTED	Stock	23.7	24.2476	23.7	24.2	8873.0
2023-02-22	AAM.B-DELISTED	Stock	23.81	24.61	23.67	24.6	11327.0
2023-02-22	AAMC-DELISTED	Stock	11.7097	12.0588	11.4029	11.5441	46138.0
2023-02-22	AAME	Stock	2.46	2.51	2.36	2.4	2200.0
2023-02-22	AAMI	Stock	25.63	25.94	25.0	25.14	171400.0
2023-02-22	AAN-DELISTED	Stock	13.81	14.46	13.73	14.14	237500.0
2023-02-22	AAOI	Stock	2.72	2.99	2.72	2.82	320000.0
2023-02-22	AAON	Stock	51.9067	52.3533	51.5	52.02	481650.0
2023-02-22	AAP	Stock	143.95	144.76	142.25	143.62	1785900.0
2023-02-22	AAT	Stock	25.56	26.15	25.51	25.74	325500.0
2023-02-22	AATC	Stock	4.3	4.3	4.22	4.26	11894.0
2023-02-22	AAU-DELISTED	Stock	0.22	0.2264	0.216	0.2166	395023.0
2023-02-22	AAUAF-DELISTED	Stock	0.22	0.2264	0.216	0.2166	394587.0
2023-02-22	AAWW-DELISTED	Stock	101.8	101.95	101.18	101.82	252842.0
2023-02-22	AAXJ	Stock	67.19	67.19	66.63	66.81	722282.0
2023-02-22	AB	Stock	39.25	39.5	38.7	38.77	185000.0
2023-02-22	ABB-DELISTED	Stock	33.52	33.71	33.38	33.49	779641.0
2023-02-22	ABBNY-DELISTED	Stock	33.52	33.71	33.38	33.49	886285.0
2023-02-22	ABBV	Stock	151.0	152.15	150.24	150.67	6041700.0
2023-02-22	ABC-DELISTED	Stock	160.99	161.61	159.25	160.12	668275.0
2023-02-22	ABCB	Stock	47.62	47.91	46.84	47.22	370400.0
2023-02-22	ABCL	Stock	8.7	8.81	8.235	8.79	3904100.0
2023-02-22	ABCM-DELISTED	Stock	14.29	14.3	14.01	14.21	416826.0
2023-02-22	ABEO	Stock	2.34	2.36	2.31	2.33	87800.0
2023-02-22	ABEV	Stock	2.54	2.56	2.51	2.54	31602600.0
2023-02-22	ABG	Stock	223.45	231.76	223.45	228.98	276400.0
2023-02-22	ABLV	Stock	10.28	10.3	10.28	10.29	36844.0
2023-02-22	ABM	Stock	48.05	48.64	48.04	48.2	326200.0
2023-02-22	ABNB	Stock	128.14	128.88	124.55	127.21	5759000.0
2023-02-22	ABOS	Stock	5.26	5.6	5.1	5.31	39500.0
2023-02-22	ABR	Stock	15.33	15.53	15.25	15.29	3500700.0
2023-02-22	ABR.D	Stock	20.07	20.07	19.96	20.0	9530.0
2023-02-22	ABR.E	Stock	19.98	20.03	19.88	19.8801	2367.0

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

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