PREVIEW / etf_daily / 2023-11-06

all etf daily files

  file:    by_date/etf_daily/2023/2023-11-06.parquet
  size:    111 KB
  rows:    3,104

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-11-06	SPY	ETF	435.47	436.15	433.68	435.69	67831700.0
2023-11-06	QQQ	ETF	368.49	369.78	366.91	369.21	38848743.0
2023-11-06	IWM	ETF	174.49	174.78	171.39	172.31	35294400.0
2023-11-06	DIA	ETF	340.86	341.64	339.89	341.04	2766000.0
2023-11-06	GLD	ETF	184.14	184.23	183.34	183.35	8274700.0
2023-11-06	TLT	ETF	87.07	87.2	86.6	86.78	41341900.0
2023-11-06	AAA	ETF	24.9	24.9	24.784	24.83	2200.0
2023-11-06	AAAU	ETF	19.68	19.68	19.59	19.6	982300.0
2023-11-06	AADR	ETF	49.88	49.88	49.62	49.62	400.0
2023-11-06	AAPB	ETF	23.88	24.45	23.871	24.43	21098.0
2023-11-06	AAPD	ETF	22.11	22.1296	21.74	21.77	357475.0
2023-11-06	AAPU	ETF	24.43	25.07	24.43	25.07	278095.0
2023-11-06	AAXJ	ETF	65.1	65.19	64.71	64.79	392800.0
2023-11-06	ABEQ	ETF	27.48	27.495	27.42	27.454	7900.0
2023-11-06	ACES	ETF	32.29	32.29	30.964	31.17	60700.0
2023-11-06	ACIO	ETF	31.19	31.19	30.98	31.07	123400.0
2023-11-06	ACSI	ETF	45.57	45.793	45.57	45.793	100.0
2023-11-06	ACT	ETF	28.15	28.545	27.86	27.95	281012.0
2023-11-06	ACTV	ETF	29.09	29.11	28.99	29.033	17500.0
2023-11-06	ACVF	ETF	33.55	33.55	33.383	33.469	2500.0
2023-11-06	ACWF	ETF	34.9584	34.9584	34.7541	34.8611	8396.0
2023-11-06	ACWI	ETF	93.99	94.07	93.51	93.87	2623400.0
2023-11-06	ACWV	ETF	96.61	96.74	96.5	96.61	188100.0
2023-11-06	ACWX	ETF	47.76	47.78	47.49	47.6	3928100.0
2023-11-06	ADFI	ETF	8.2	8.23	8.19	8.215	14500.0
2023-11-06	ADIV	ETF	15.03	15.03	13.49	13.538	1100.0
2023-11-06	ADME	ETF	35.63	35.635	35.547	35.635	11300.0
2023-11-06	ADPV	ETF	22.3806	22.43	22.36	22.43	45745.0
2023-11-06	AEMB	ETF	35.888	35.888	35.726	35.726	200.0
2023-11-06	AESR	ETF	12.35	12.365	12.31	12.33	14000.0
2023-11-06	AETH	ETF	28.8	28.83	28.5367	28.5367	4065.0
2023-11-06	AFIF	ETF	8.92	8.92	8.91	8.92	8000.0
2023-11-06	AFK	ETF	14.74	14.74	13.9	13.92	14800.0
2023-11-06	AFLG	ETF	25.218	25.218	25.218	25.218	100.0
2023-11-06	AFMC	ETF	23.561	23.561	23.561	23.561	100.0
2023-11-06	AFSM	ETF	23.732	23.732	23.732	23.732	100.0
2023-11-06	AFTY	ETF	14.4	14.44	14.37	14.37	2000.0
2023-11-06	AGG	ETF	93.93	93.99	93.63	93.71	8521600.0
2023-11-06	AGGH	ETF	22.28	22.28	21.2	21.215	73655.0
2023-11-06	AGGY	ETF	41.58	41.605	41.506	41.51	155200.0
2023-11-06	AGNG	ETF	25.92	25.95	25.79	25.91	1500.0
2023-11-06	AGOV	ETF	73.275	73.275	73.275	73.275	63.0
2023-11-06	AGOX	ETF	22.77	22.83	22.74	22.79	13900.0
2023-11-06	AGQ	ETF	26.46	26.46	26.04	26.11	811100.0
2023-11-06	AGRH	ETF	25.48	25.48	25.475	25.475	516.0
2023-11-06	AGZ	ETF	105.88	106.0	105.88	105.89	28200.0
2023-11-06	AGZD	ETF	22.2	22.23	22.08	22.2	501800.0
2023-11-06	AHLT	ETF	25.4	25.47	25.3992	25.4183	6062.0
2023-11-06	AHYB	ETF	43.78	43.78	43.69	43.69	900.0
2023-11-06	AIA	ETF	57.86	57.91	57.5	57.6	41200.0

> showing 50 of 3,104 rows — these rows as CSV

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