PREVIEW / etf_daily / 2023-11-07

all etf daily files

  file:    by_date/etf_daily/2023/2023-11-07.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-07	SPY	ETF	435.69	437.59	434.51	436.93	64256100.0
2023-11-07	QQQ	ETF	370.27	373.58	369.045	372.7	50777398.0
2023-11-07	IWM	ETF	171.56	172.51	170.57	171.7	31168900.0
2023-11-07	DIA	ETF	340.73	342.07	340.3	341.54	2793700.0
2023-11-07	GLD	ETF	182.25	182.65	181.75	182.59	6795800.0
2023-11-07	TLT	ETF	87.61	88.5	87.59	88.06	37834200.0
2023-11-07	AAA	ETF	24.88	24.88	24.83	24.83	700.0
2023-11-07	AAAU	ETF	19.48	19.52	19.42	19.51	1222700.0
2023-11-07	AADR	ETF	49.01	49.27	49.01	49.27	500.0
2023-11-07	AAPB	ETF	24.43	25.2	24.42	25.04	17261.0
2023-11-07	AAPD	ETF	21.79	21.8066	21.3877	21.4586	313685.0
2023-11-07	AAPU	ETF	25.0	25.69	25.0	25.61	205682.0
2023-11-07	AAXJ	ETF	64.24	64.63	64.02	64.57	679300.0
2023-11-07	ABEQ	ETF	27.31	27.31	27.28	27.3	2800.0
2023-11-07	ACES	ETF	31.02	31.13	30.725	31.01	52500.0
2023-11-07	ACIO	ETF	31.1	31.23	31.061	31.15	74600.0
2023-11-07	ACSI	ETF	45.983	45.983	45.983	45.983	100.0
2023-11-07	ACT	ETF	27.8	27.91	27.56	27.71	209294.0
2023-11-07	ACTV	ETF	28.955	29.108	28.9	28.991	423400.0
2023-11-07	ACVF	ETF	33.48	33.63	33.48	33.526	4700.0
2023-11-07	ACWF	ETF	34.78	34.97	34.69	34.8824	42082.0
2023-11-07	ACWI	ETF	93.62	93.97	93.34	93.82	3239700.0
2023-11-07	ACWV	ETF	96.25	96.51	96.13	96.38	232000.0
2023-11-07	ACWX	ETF	47.24	47.41	47.11	47.3	3046600.0
2023-11-07	ADFI	ETF	8.18	8.255	8.18	8.255	7300.0
2023-11-07	ADIV	ETF	13.48	13.491	13.48	13.491	200.0
2023-11-07	ADME	ETF	35.61	35.77	35.61	35.7	21500.0
2023-11-07	ADPV	ETF	22.5	22.54	22.5	22.5109	4322.0
2023-11-07	ADVE	ETF	29.91	29.92	29.882	29.882	5200.0
2023-11-07	AEMB	ETF	35.891	35.891	35.891	35.891	100.0
2023-11-07	AESR	ETF	12.45	12.46	12.43	12.43	8200.0
2023-11-07	AETH	ETF	28.33	28.7131	28.22	28.7131	925.0
2023-11-07	AFIF	ETF	8.94	8.94	8.91	8.92	3800.0
2023-11-07	AFK	ETF	13.82	13.89	13.69	13.71	6200.0
2023-11-07	AFLG	ETF	25.25	25.261	25.25	25.261	200.0
2023-11-07	AFMC	ETF	23.48	23.48	23.474	23.474	100.0
2023-11-07	AFTY	ETF	14.363	14.363	14.363	14.363	100.0
2023-11-07	AGG	ETF	93.94	94.36	93.91	94.21	7306900.0
2023-11-07	AGGH	ETF	21.28	21.37	21.22	21.37	174770.0
2023-11-07	AGGY	ETF	41.62	41.765	41.6	41.72	93300.0
2023-11-07	AGNG	ETF	25.79	25.81	25.71	25.756	1100.0
2023-11-07	AGOV	ETF	74.31	74.31	72.5728	72.5728	335.0
2023-11-07	AGOX	ETF	22.85	22.91	22.82	22.85	19000.0
2023-11-07	AGQ	ETF	25.17	25.26	24.78	25.18	1404000.0
2023-11-07	AGRH	ETF	25.565	25.59	25.565	25.565	640.0
2023-11-07	AGZ	ETF	106.01	106.13	105.73	106.0	67600.0
2023-11-07	AGZD	ETF	22.15	22.22	22.14	22.2	45000.0
2023-11-07	AHLT	ETF	25.36	25.43	25.2515	25.2515	2395.0
2023-11-07	AHOY	ETF	19.85	19.8619	19.85	19.8619	568.0
2023-11-07	AHYB	ETF	43.672	43.672	43.651	43.665	800.0

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

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