PREVIEW / etf_daily / 2023-11-09

all etf daily files

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

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-09	SPY	ETF	438.43	438.47	433.4	433.84	83174400.0
2023-11-09	QQQ	ETF	373.64	374.8	369.57	370.07	53859421.0
2023-11-09	IWM	ETF	171.03	171.03	166.98	167.24	38577400.0
2023-11-09	DIA	ETF	342.01	342.05	338.77	339.11	3940700.0
2023-11-09	GLD	ETF	180.98	182.28	180.89	181.49	6486300.0
2023-11-09	TLT	ETF	88.94	89.03	86.74	87.5	88975100.0
2023-11-09	AAA	ETF	24.86	24.9	24.814	24.85	41200.0
2023-11-09	AAAU	ETF	19.34	19.47	19.33	19.39	1600400.0
2023-11-09	AADR	ETF	49.48	49.48	48.95	48.95	700.0
2023-11-09	AAPB	ETF	25.31	25.44	25.04	25.2	13079.0
2023-11-09	AAPD	ETF	21.35	21.48	21.2213	21.4	315863.0
2023-11-09	AAPU	ETF	25.82	26.04	25.5703	25.68	105377.0
2023-11-09	AAPY	ETF	26.57	26.57	26.4407	26.4407	308.0
2023-11-09	AAXJ	ETF	64.08	64.29	63.48	63.53	421900.0
2023-11-09	ABEQ	ETF	27.034	27.034	27.034	27.034	100.0
2023-11-09	ACES	ETF	30.13	30.255	29.0	29.09	52800.0
2023-11-09	ACIO	ETF	31.222	31.26	31.0	31.04	35200.0
2023-11-09	ACSI	ETF	45.89	45.89	45.539	45.539	1000.0
2023-11-09	ACT	ETF	27.98	28.2	27.42	27.52	345722.0
2023-11-09	ACTV	ETF	28.78	28.81	28.32	28.369	14300.0
2023-11-09	ACVF	ETF	33.57	33.57	33.266	33.266	300.0
2023-11-09	ACWF	ETF	34.99	35.0	34.69	34.7004	3432.0
2023-11-09	ACWI	ETF	94.14	94.22	93.17	93.24	12563900.0
2023-11-09	ACWV	ETF	96.35	96.61	95.61	95.69	144700.0
2023-11-09	ACWX	ETF	47.47	47.6	47.02	47.04	3609300.0
2023-11-09	ADFI	ETF	8.23	8.26	8.18	8.215	23600.0
2023-11-09	ADIV	ETF	13.375	13.375	13.375	13.375	100.0
2023-11-09	ADME	ETF	35.76	35.79	35.534	35.534	20700.0
2023-11-09	ADPV	ETF	22.55	22.77	22.36	22.43	17214.0
2023-11-09	AEMB	ETF	35.71	35.71	35.71	35.71	100.0
2023-11-09	AESR	ETF	12.52	12.52	12.35	12.37	21300.0
2023-11-09	AETH	ETF	29.36	30.7022	29.3035	30.7022	2376.0
2023-11-09	AFIF	ETF	8.95	8.95	8.91	8.92	165500.0
2023-11-09	AFK	ETF	13.48	13.64	13.19	13.4	5200.0
2023-11-09	AFLG	ETF	25.106	25.106	25.106	25.106	100.0
2023-11-09	AFTY	ETF	14.22	14.22	14.215	14.215	100.0
2023-11-09	AGG	ETF	94.42	94.44	93.73	93.74	9163200.0
2023-11-09	AGGH	ETF	21.35	21.35	21.2116	21.2352	58155.0
2023-11-09	AGGY	ETF	41.821	41.821	41.55	41.55	85300.0
2023-11-09	AGNG	ETF	25.307	25.307	25.13	25.255	3700.0
2023-11-09	AGOV	ETF	71.32	72.6315	70.81	72.6315	255.0
2023-11-09	AGOX	ETF	23.02	23.02	22.79	22.83	95700.0
2023-11-09	AGQ	ETF	25.25	25.99	24.95	25.08	1083900.0
2023-11-09	AGRH	ETF	25.59	25.59	25.5301	25.5371	1066.0
2023-11-09	AGZ	ETF	106.06	106.06	105.78	105.81	27700.0
2023-11-09	AGZD	ETF	22.2	22.35	22.18	22.2	70700.0
2023-11-09	AHLT	ETF	25.41	25.61	25.3058	25.574	4988.0
2023-11-09	AHYB	ETF	43.661	43.661	43.435	43.435	800.0
2023-11-09	AIA	ETF	56.92	57.03	56.21	56.35	13000.0
2023-11-09	AIEQ	ETF	30.0	30.02	29.595	29.601	15700.0

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

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