PREVIEW / etf_daily / 2023-10-17

all etf daily files

  file:    by_date/etf_daily/2023/2023-10-17.parquet
  size:    109 KB
  rows:    3,064

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-10-17	SPY	ETF	432.81	438.14	432.45	436.02	75324700.0
2023-10-17	QQQ	ETF	365.81	369.92	363.66	368.2	50999102.0
2023-10-17	IWM	ETF	171.94	176.42	171.9	174.95	39823200.0
2023-10-17	DIA	ETF	338.33	341.52	338.27	339.99	3777800.0
2023-10-17	GLD	ETF	178.37	179.13	177.98	178.29	8231900.0
2023-10-17	TLT	ETF	84.89	85.63	84.5	85.25	52949100.0
2023-10-17	AAA	ETF	24.85	24.85	24.83	24.83	500.0
2023-10-17	AAAU	ETF	19.06	19.13	19.01	19.05	1484200.0
2023-10-17	AADR	ETF	50.05	50.05	50.05	50.05	200.0
2023-10-17	AAPB	ETF	23.98	24.361	23.71	24.14	6436.0
2023-10-17	AAPD	ETF	22.07	22.259	21.8319	21.99	155296.0
2023-10-17	AAPU	ETF	24.54	24.9689	24.23	24.7	68392.0
2023-10-17	AAXJ	ETF	63.48	64.06	63.47	63.82	497100.0
2023-10-17	ABEQ	ETF	27.572	27.67	27.572	27.651	2000.0
2023-10-17	ACES	ETF	33.7	34.95	33.7	34.58	214000.0
2023-10-17	ACIO	ETF	30.75	31.0	30.71	30.91	112800.0
2023-10-17	ACSI	ETF	45.376	45.376	45.376	45.376	100.0
2023-10-17	ACT	ETF	28.35	28.68	28.195	28.29	215571.0
2023-10-17	ACTV	ETF	29.08	29.675	29.08	29.582	11300.0
2023-10-17	ACVF	ETF	33.35	33.69	33.328	33.539	13100.0
2023-10-17	ACWF	ETF	34.8366	34.87	34.8092	34.8644	1304.0
2023-10-17	ACWI	ETF	92.9	94.09	92.88	93.66	5424200.0
2023-10-17	ACWV	ETF	95.66	96.33	95.66	96.06	351200.0
2023-10-17	ACWX	ETF	46.68	47.29	46.68	47.08	777900.0
2023-10-17	ADFI	ETF	8.1	8.14	8.08	8.095	20600.0
2023-10-17	ADIV	ETF	13.24	13.258	13.24	13.258	200.0
2023-10-17	ADME	ETF	35.54	35.88	35.54	35.76	25000.0
2023-10-17	ADPV	ETF	24.3878	24.4097	24.3853	24.3875	3415.0
2023-10-17	ADVE	ETF	29.6048	29.6048	29.5374	29.5374	339.0
2023-10-17	AEMB	ETF	35.08	35.1	35.08	35.1	200.0
2023-10-17	AESR	ETF	12.44	12.5	12.41	12.45	26800.0
2023-10-17	AETH	ETF	23.55	23.55	23.3291	23.3291	12145.0
2023-10-17	AFIF	ETF	8.9	8.9	8.82	8.82	20600.0
2023-10-17	AFK	ETF	13.97	14.16	13.96	14.12	1900.0
2023-10-17	AFLG	ETF	25.178	25.22	25.178	25.22	100.0
2023-10-17	AFMC	ETF	23.875	23.885	23.867	23.867	800.0
2023-10-17	AFTY	ETF	14.307	14.307	14.307	14.307	100.0
2023-10-17	AGG	ETF	92.51	92.69	92.35	92.45	8198300.0
2023-10-17	AGGH	ETF	21.03	21.07	20.96	21.0081	33925.0
2023-10-17	AGGY	ETF	41.01	41.08	40.94	41.0	111300.0
2023-10-17	AGNG	ETF	26.0	26.14	25.96	26.02	2100.0
2023-10-17	AGOV	ETF	73.5	73.5	73.5	73.5	91.0
2023-10-17	AGOX	ETF	22.685	22.92	22.685	22.86	14300.0
2023-10-17	AGQ	ETF	25.53	26.25	25.38	25.88	861600.0
2023-10-17	AGZ	ETF	105.1	105.12	104.95	104.98	14100.0
2023-10-17	AGZD	ETF	22.18	22.27	22.15	22.25	167300.0
2023-10-17	AHLT	ETF	26.8	26.8164	26.8	26.8164	1387.0
2023-10-17	AHOY	ETF	20.0	20.0	19.8951	19.8951	1241.0
2023-10-17	AHYB	ETF	42.72	42.76	42.66	42.71	600.0
2023-10-17	AIA	ETF	55.94	56.55	55.94	56.38	47700.0

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

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