PREVIEW / stock_daily / 2023-02-21

all stock daily files

  file:    by_date/stock_daily/2023/2023-02-21.parquet
  size:    247 KB
  rows:    7,665
  symbols: 1,836

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-21	AAPL	Stock	150.2	151.3	148.41	148.48	58867200.0
2023-02-21	MSFT	Stock	254.48	255.49	251.59	252.67	28397400.0
2023-02-21	NVDA	Stock	21.0	21.494	20.618	20.655	410015000.0
2023-02-21	AMZN	Stock	95.34	95.61	94.27	94.58	56580400.0
2023-02-21	GOOGL	Stock	93.0	93.1	91.72	91.79	33629256.0
2023-02-21	META	Stock	174.31	178.17	171.88	172.08	34592600.0
2023-02-21	TSLA	Stock	204.99	209.71	197.22	197.37	180018600.0
2023-02-21	TLT	Stock	101.005	101.2	100.28	100.39	22727975.0
2023-02-21	ES	Stock	79.49	79.68	78.25	78.36	1612400.0
2023-02-21	CL	Stock	73.9	74.73	73.9	74.26	4098100.0
2023-02-21	A	Stock	146.6	146.65	142.63	143.42	1693800.0
2023-02-21	AA	Stock	48.13	49.79	47.81	48.07	5382000.0
2023-02-21	AAC-DELISTED	Stock	10.21	10.23	10.21	10.23	42794.0
2023-02-21	AACG	Stock	2.25	2.25	1.84	1.86	55100.0
2023-02-21	AAIC-DELISTED	Stock	3.0	3.02	2.99	3.01	98267.0
2023-02-21	AAIC.C-DELISTED	Stock	23.75	23.75	23.15	23.15	1100.0
2023-02-21	AAL	Stock	16.06	16.2	15.52	15.69	24449000.0
2023-02-21	AAM.A-DELISTED	Stock	24.4067	24.54	23.66	23.67	7676.0
2023-02-21	AAM.B-DELISTED	Stock	24.78	24.78	23.55	23.68	16943.0
2023-02-21	AAMC-DELISTED	Stock	12.0559	12.2941	11.4118	11.8441	30573.0
2023-02-21	AAME	Stock	2.47	2.51	2.36	2.36	3400.0
2023-02-21	AAMI	Stock	25.52	25.84	25.42	25.63	135100.0
2023-02-21	AAN-DELISTED	Stock	14.55	14.66	13.84	13.85	245700.0
2023-02-21	AAOI	Stock	2.86	2.91	2.71	2.72	166600.0
2023-02-21	AAON	Stock	52.7467	53.0667	51.52	51.7133	461100.0
2023-02-21	AAP	Stock	147.78	148.35	144.03	144.19	1270000.0
2023-02-21	AAT	Stock	26.04	26.13	25.45	25.48	193500.0
2023-02-21	AATC	Stock	4.25	4.39	4.25	4.39	2465.0
2023-02-21	AAU-DELISTED	Stock	0.2291	0.2318	0.22	0.221	330589.0
2023-02-21	AAUAF-DELISTED	Stock	0.2291	0.2318	0.22	0.221	334206.0
2023-02-21	AAWW-DELISTED	Stock	102.01	102.12	101.7064	101.755	248430.0
2023-02-21	AAXJ	Stock	67.49	67.81	67.15	67.18	803884.0
2023-02-21	AB	Stock	40.0	40.28	39.16	39.3	291700.0
2023-02-21	ABB-DELISTED	Stock	33.74	33.86	33.42	33.495	897718.0
2023-02-21	ABBNY-DELISTED	Stock	33.74	33.86	33.42	33.49	1016397.0
2023-02-21	ABBV	Stock	149.82	153.02	149.82	152.0	8466100.0
2023-02-21	ABC-DELISTED	Stock	160.8	161.92	160.17	160.8	896889.0
2023-02-21	ABCB	Stock	48.48	48.72	47.46	47.51	244600.0
2023-02-21	ABCL	Stock	9.48	9.54	8.87	8.89	3522500.0
2023-02-21	ABCM-DELISTED	Stock	14.32	14.48	14.2	14.3	409772.0
2023-02-21	ABEO	Stock	2.37	2.41	2.32	2.35	95600.0
2023-02-21	ABEV	Stock	2.52	2.55	2.5	2.52	24748900.0
2023-02-21	ABG	Stock	240.38	240.38	222.02	223.29	240200.0
2023-02-21	ABGI-DELISTED	Stock	10.18	10.19	10.18	10.18	113564.0
2023-02-21	ABLV	Stock	10.27	10.29	10.27	10.29	41371.0
2023-02-21	ABM	Stock	48.27	48.54	47.73	48.15	254100.0
2023-02-21	ABNB	Stock	129.77	132.85	128.145	128.78	6618700.0
2023-02-21	ABOS	Stock	5.45	5.45	5.27	5.3	54400.0
2023-02-21	ABR	Stock	15.45	15.55	15.2	15.3	3598300.0
2023-02-21	ABR.D	Stock	20.5	20.66	20.2	20.23	32413.0

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

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