PREVIEW / etf_daily / 2023-11-28

all etf daily files

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

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-28	SPY	ETF	454.08	456.27	453.5	454.93	62115000.0
2023-11-28	QQQ	ETF	388.41	390.78	388.05	390.19	35491123.0
2023-11-28	IWM	ETF	178.55	179.22	177.2	178.04	28350200.0
2023-11-28	DIA	ETF	353.49	355.14	353.09	354.11	2759600.0
2023-11-28	GLD	ETF	187.9	189.4	187.52	189.26	10901900.0
2023-11-28	TLT	ETF	90.91	91.53	90.79	91.48	44989300.0
2023-11-28	AAA	ETF	24.91	25.0	24.91	24.95	3600.0
2023-11-28	AAAU	ETF	20.08	20.24	20.04	20.22	1633300.0
2023-11-28	AADR	ETF	53.52	53.52	53.5	53.5	400.0
2023-11-28	AAPB	ETF	26.91	27.1654	26.91	27.04	3260.0
2023-11-28	AAPD	ETF	20.63	20.641	20.47	20.55	86438.0
2023-11-28	AAPU	ETF	27.21	27.4799	27.1799	27.36	74859.0
2023-11-28	AAPY	ETF	26.56	26.57	26.56	26.57	131.0
2023-11-28	AAXJ	ETF	65.58	65.92	65.54	65.84	594800.0
2023-11-28	ABEQ	ETF	27.83	27.94	27.83	27.94	2000.0
2023-11-28	ACES	ETF	30.1	30.91	29.77	30.91	467800.0
2023-11-28	ACIO	ETF	32.23	32.305	32.18	32.26	42800.0
2023-11-28	ACSI	ETF	47.735	47.735	47.735	47.735	100.0
2023-11-28	ACT	ETF	27.78	27.78	27.53	27.54	133554.0
2023-11-28	ACTV	ETF	29.78	29.78	29.62	29.7	7000.0
2023-11-28	ACVF	ETF	34.69	34.78	34.69	34.759	1000.0
2023-11-28	ACWF	ETF	36.3899	36.5841	36.3899	36.4919	3062.0
2023-11-28	ACWI	ETF	97.59	98.03	97.42	97.78	6387600.0
2023-11-28	ACWV	ETF	98.33	98.53	98.09	98.34	130500.0
2023-11-28	ACWX	ETF	49.19	49.44	49.09	49.33	1563700.0
2023-11-28	ADFI	ETF	8.34	8.36	8.33	8.36	13700.0
2023-11-28	ADIV	ETF	13.85	13.85	13.85	13.85	100.0
2023-11-28	ADME	ETF	37.141	37.141	37.0	37.069	3600.0
2023-11-28	ADPV	ETF	23.42	23.42	23.42	23.42	111.0
2023-11-28	AEMB	ETF	36.762	36.975	36.762	36.975	400.0
2023-11-28	AESR	ETF	13.01	13.067	13.0	13.041	28500.0
2023-11-28	AETH	ETF	30.52	31.2	30.43	31.0572	5995.0
2023-11-28	AFIF	ETF	8.96	8.97	8.94	8.96	22900.0
2023-11-28	AFK	ETF	14.03	14.03	13.83	13.97	3200.0
2023-11-28	AFLG	ETF	26.182	26.182	26.182	26.182	100.0
2023-11-28	AFTY	ETF	14.179	14.179	14.179	14.179	100.0
2023-11-28	AGG	ETF	95.61	96.13	95.57	96.11	9749400.0
2023-11-28	AGGH	ETF	21.3522	21.3994	21.35	21.3717	1679.0
2023-11-28	AGGY	ETF	42.31	42.52	42.31	42.48	79700.0
2023-11-28	AGNG	ETF	26.52	26.57	26.51	26.51	1300.0
2023-11-28	AGOX	ETF	23.63	23.72	23.63	23.69	27500.0
2023-11-28	AGQ	ETF	29.99	30.6	29.72	30.6	1270100.0
2023-11-28	AGQI	ETF	12.76	12.8134	12.7401	12.77	1535181.0
2023-11-28	AGZ	ETF	106.53	106.96	106.53	106.94	9400.0
2023-11-28	AGZD	ETF	22.35	22.43	22.28	22.31	89800.0
2023-11-28	AHLT	ETF	24.32	24.45	24.2	24.23	8228.0
2023-11-28	AHOY	ETF	20.9199	20.9199	20.804	20.804	272.0
2023-11-28	AHYB	ETF	44.319	44.39	44.25	44.39	1500.0
2023-11-28	AIA	ETF	58.08	58.23	57.88	58.14	25600.0
2023-11-28	AIEQ	ETF	30.9	31.0	30.761	30.898	37800.0

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

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