PREVIEW / etf_daily / 2023-11-29

all etf daily files

  file:    by_date/etf_daily/2023/2023-11-29.parquet
  size:    113 KB
  rows:    3,158

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-29	SPY	ETF	457.15	458.32	454.2	454.61	63146000.0
2023-11-29	QQQ	ETF	392.69	394.14	389.46	389.81	38811745.0
2023-11-29	IWM	ETF	179.55	181.75	178.7	178.98	31590200.0
2023-11-29	DIA	ETF	354.97	356.13	354.37	354.65	2736300.0
2023-11-29	GLD	ETF	189.16	189.99	189.02	189.54	8407300.0
2023-11-29	TLT	ETF	92.11	92.7	91.78	92.63	61647800.0
2023-11-29	AAA	ETF	24.975	25.04	24.91	24.975	5500.0
2023-11-29	AAAU	ETF	20.21	20.3	20.2	20.26	1257200.0
2023-11-29	AADR	ETF	53.89	54.19	53.89	54.19	400.0
2023-11-29	AAPB	ETF	27.18	27.34	26.65	26.755	14305.0
2023-11-29	AAPD	ETF	20.45	20.6966	20.3659	20.665	115284.0
2023-11-29	AAPU	ETF	27.47	27.7	27.0695	27.14	80912.0
2023-11-29	AAPY	ETF	26.5888	26.6	26.5643	26.5643	518.0
2023-11-29	AAXJ	ETF	65.55	65.8	65.36	65.43	447600.0
2023-11-29	ABEQ	ETF	27.95	27.96	27.9	27.935	5300.0
2023-11-29	ACES	ETF	31.29	32.009	31.14	31.23	77200.0
2023-11-29	ACIO	ETF	32.4	32.4	32.195	32.23	45900.0
2023-11-29	ACSI	ETF	47.722	47.722	47.722	47.722	100.0
2023-11-29	ACT	ETF	27.6	27.85	27.56	27.59	173369.0
2023-11-29	ACTV	ETF	30.1	30.1	29.798	29.798	34800.0
2023-11-29	ACVF	ETF	35.0	35.0	34.751	34.751	11000.0
2023-11-29	ACWF	ETF	36.564	36.65	36.49	36.5204	4921.0
2023-11-29	ACWI	ETF	98.15	98.33	97.7	97.77	4086800.0
2023-11-29	ACWV	ETF	98.51	98.51	98.01	98.14	120600.0
2023-11-29	ACWX	ETF	49.32	49.47	49.23	49.31	1342100.0
2023-11-29	ADFI	ETF	8.352	8.4	8.352	8.4	10100.0
2023-11-29	ADIV	ETF	13.81	13.81	13.805	13.805	600.0
2023-11-29	ADME	ETF	37.175	37.175	36.99	37.01	11800.0
2023-11-29	ADPV	ETF	23.48	23.49	23.32	23.35	20839.0
2023-11-29	AEMB	ETF	37.14	37.29	37.14	37.253	1000.0
2023-11-29	AESR	ETF	13.09	13.09	13.01	13.01	27400.0
2023-11-29	AETH	ETF	30.4099	30.4099	30.2938	30.2938	1032.0
2023-11-29	AFIF	ETF	8.99	8.99	8.96	8.97	9900.0
2023-11-29	AFK	ETF	13.97	14.0	13.88	13.97	16600.0
2023-11-29	AFLG	ETF	26.24	26.24	26.129	26.129	500.0
2023-11-29	AFMC	ETF	24.66	24.68	24.505	24.505	1800.0
2023-11-29	AFSM	ETF	24.76	24.76	24.559	24.559	1100.0
2023-11-29	AFTY	ETF	14.054	14.054	14.054	14.054	100.0
2023-11-29	AGG	ETF	96.42	96.67	96.34	96.58	8006800.0
2023-11-29	AGGH	ETF	21.485	21.55	21.41	21.55	20101.0
2023-11-29	AGGY	ETF	42.67	42.76	42.63	42.76	102600.0
2023-11-29	AGNG	ETF	26.587	26.69	26.587	26.69	2900.0
2023-11-29	AGOX	ETF	23.85	23.85	23.68	23.73	20100.0
2023-11-29	AGQ	ETF	30.73	31.16	30.34	30.48	940700.0
2023-11-29	AGQI	ETF	12.77	12.77	12.72	12.7397	489493.0
2023-11-29	AGZ	ETF	107.11	107.22	107.11	107.21	17500.0
2023-11-29	AGZD	ETF	22.39	22.4	22.27	22.29	46200.0
2023-11-29	AHLT	ETF	24.13	24.14	24.1247	24.1287	820.0
2023-11-29	AHYB	ETF	44.6	44.6	44.575	44.59	2100.0
2023-11-29	AIA	ETF	57.77	58.06	57.62	57.65	76900.0

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

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