PREVIEW / stock_daily / 2023-01-09

all stock daily files

  file:    by_date/stock_daily/2023/2023-01-09.parquet
  size:    249 KB
  rows:    7,713
  symbols: 1,950

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-09	AAPL	Stock	130.47	133.41	129.89	130.15	70790800.0
2023-01-09	MSFT	Stock	226.45	231.24	226.41	227.12	27369800.0
2023-01-09	NVDA	Stock	15.284	16.056	15.141	15.628	504231000.0
2023-01-09	AMZN	Stock	87.46	89.48	87.08	87.36	65266100.0
2023-01-09	GOOGL	Stock	88.36	90.05	87.86	88.02	29003901.0
2023-01-09	META	Stock	131.16	132.95	129.28	129.47	26649100.0
2023-01-09	TSLA	Stock	118.96	123.52	117.11	119.77	190284000.0
2023-01-09	TLT	Stock	104.41	105.93	104.27	105.74	21472166.0
2023-01-09	ES	Stock	85.29	86.84	85.18	85.71	1183600.0
2023-01-09	CL	Stock	79.96	80.4	78.56	78.73	2826000.0
2023-01-09	A	Stock	149.69	151.28	147.2	147.47	1269600.0
2023-01-09	AA	Stock	47.59	50.65	47.49	50.27	6175600.0
2023-01-09	AAC-DELISTED	Stock	10.11	10.13	10.11	10.13	1480409.0
2023-01-09	AACG	Stock	1.42	1.48	1.4	1.4	7400.0
2023-01-09	AACIW-DELISTED	Stock	0.035	0.0439	0.0349	0.0349	17100.0
2023-01-09	AAIC-DELISTED	Stock	2.96	3.0	2.96	2.995	43648.0
2023-01-09	AAIC.C-DELISTED	Stock	21.29	21.29	21.29	21.29	300.0
2023-01-09	AAL	Stock	14.25	14.79	14.23	14.61	31496900.0
2023-01-09	AAM.A-DELISTED	Stock	23.7	24.0899	23.7	23.74	9204.0
2023-01-09	AAM.B-DELISTED	Stock	23.91	24.2	23.65	23.65	8418.0
2023-01-09	AAMC-DELISTED	Stock	7.2794	7.5353	7.2794	7.5265	14460.0
2023-01-09	AAME	Stock	2.55	2.58	2.49	2.58	2800.0
2023-01-09	AAMI	Stock	20.88	21.03	20.71	20.9	111200.0
2023-01-09	AAN-DELISTED	Stock	13.12	13.42	13.0	13.28	320200.0
2023-01-09	AAOI	Stock	1.93	2.28	1.923	2.15	216300.0
2023-01-09	AAON	Stock	49.66	50.24	49.38	49.6067	277350.0
2023-01-09	AAP	Stock	154.03	155.12	152.15	152.26	781200.0
2023-01-09	AAT	Stock	27.02	27.11	26.58	26.73	178800.0
2023-01-09	AATC	Stock	3.74	3.8	3.74	3.76	24022.0
2023-01-09	AAU-DELISTED	Stock	0.2602	0.2694	0.2516	0.2556	287921.0
2023-01-09	AAUAF-DELISTED	Stock	0.2602	0.2694	0.2516	0.2556	291407.0
2023-01-09	AAWW-DELISTED	Stock	101.31	101.6	101.18	101.27	240046.0
2023-01-09	AAXJ	Stock	69.67	69.871	69.29	69.29	2563793.0
2023-01-09	AB	Stock	37.0	37.1	36.34	36.54	421200.0
2023-01-09	ABB-DELISTED	Stock	32.98	33.2493	32.79	32.7994	1687445.0
2023-01-09	ABBNY-DELISTED	Stock	32.98	33.2493	32.79	32.8	1904969.0
2023-01-09	ABBV	Stock	165.9	166.28	160.88	161.66	7833000.0
2023-01-09	ABC-DELISTED	Stock	166.21	167.72	164.94	164.97	973769.0
2023-01-09	ABCB	Stock	47.53	47.84	47.18	47.35	258800.0
2023-01-09	ABCL	Stock	9.71	9.75	9.36	9.55	5366500.0
2023-01-09	ABCM-DELISTED	Stock	15.95	16.58	15.29	16.39	308870.0
2023-01-09	ABEO	Stock	3.15	3.19	3.02	3.06	164300.0
2023-01-09	ABEV	Stock	2.68	2.73	2.67	2.72	15844300.0
2023-01-09	ABG	Stock	184.73	187.93	182.86	184.24	129700.0
2023-01-09	ABGI-DELISTED	Stock	10.11	10.11	10.11	10.11	133.0
2023-01-09	ABM	Stock	46.24	46.55	45.46	45.54	222200.0
2023-01-09	ABNB	Stock	90.255	92.05	88.88	89.24	4319400.0
2023-01-09	ABOS	Stock	5.36	5.635	5.21	5.45	48800.0
2023-01-09	ABR	Stock	13.9	13.95	13.73	13.74	1423800.0
2023-01-09	ABR.D	Stock	18.83	19.43	18.83	19.192	20681.0

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

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