PREVIEW / etf_daily / 2023-10-16

all etf daily files

  file:    by_date/etf_daily/2023/2023-10-16.parquet
  size:    110 KB
  rows:    3,073

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-16	SPY	ETF	433.82	437.14	433.57	436.04	75433200.0
2023-10-16	QQQ	ETF	366.62	370.48	366.47	369.41	44201059.0
2023-10-16	IWM	ETF	171.74	173.39	171.02	173.02	31140300.0
2023-10-16	DIA	ETF	338.77	340.91	338.41	339.89	3969300.0
2023-10-16	GLD	ETF	177.84	178.33	177.54	177.96	8385400.0
2023-10-16	TLT	ETF	86.19	86.37	85.9	86.2	38309800.0
2023-10-16	AAA	ETF	24.86	24.86	24.825	24.825	4000.0
2023-10-16	AAAU	ETF	19.0	19.05	18.97	19.01	784300.0
2023-10-16	AADR	ETF	49.68	49.69	49.68	49.69	600.0
2023-10-16	AAPB	ETF	24.05	24.5488	24.02	24.48	11683.0
2023-10-16	AAPD	ETF	22.05	22.05	21.75	21.81	90189.0
2023-10-16	AAPU	ETF	24.69	25.1	24.62	25.02	134885.0
2023-10-16	AAXJ	ETF	63.6	64.2	63.48	64.08	290800.0
2023-10-16	ABEQ	ETF	27.429	27.6	27.429	27.54	12300.0
2023-10-16	ACES	ETF	33.77	34.37	33.43	34.21	84400.0
2023-10-16	ACIO	ETF	30.71	30.92	30.71	30.9	54900.0
2023-10-16	ACSI	ETF	45.25	45.25	45.25	45.25	100.0
2023-10-16	ACT	ETF	28.04	28.39	27.92	28.33	239152.0
2023-10-16	ACTV	ETF	28.9	29.3	28.9	29.182	3700.0
2023-10-16	ACVF	ETF	33.35	33.64	33.35	33.53	6900.0
2023-10-16	ACWF	ETF	34.67	34.905	34.67	34.8892	10039.0
2023-10-16	ACWI	ETF	93.09	93.78	93.03	93.62	4269600.0
2023-10-16	ACWV	ETF	95.88	96.3	95.69	96.17	308400.0
2023-10-16	ACWX	ETF	46.79	47.14	46.76	47.09	2523600.0
2023-10-16	ADFI	ETF	8.15	8.17	8.13	8.13	15800.0
2023-10-16	ADIV	ETF	13.24	13.295	13.24	13.295	200.0
2023-10-16	ADME	ETF	35.63	35.82	35.63	35.791	18500.0
2023-10-16	AEMB	ETF	35.305	35.305	35.305	35.305	100.0
2023-10-16	AESR	ETF	12.41	12.49	12.4	12.45	45700.0
2023-10-16	AETH	ETF	23.92	23.92	23.55	23.7091	4158.0
2023-10-16	AFIF	ETF	8.93	8.93	8.9	8.9	34700.0
2023-10-16	AFK	ETF	13.85	14.06	13.85	13.92	3000.0
2023-10-16	AFMC	ETF	23.582	23.658	23.582	23.658	700.0
2023-10-16	AFSM	ETF	23.4	23.673	23.36	23.673	1900.0
2023-10-16	AFTY	ETF	14.28	14.36	14.28	14.36	900.0
2023-10-16	AGG	ETF	93.32	93.41	93.1	93.12	6332700.0
2023-10-16	AGGH	ETF	21.22	21.22	21.13	21.13	19939.0
2023-10-16	AGGY	ETF	41.28	41.325	41.23	41.24	141600.0
2023-10-16	AGNG	ETF	25.99	26.0	25.95	25.98	1200.0
2023-10-16	AGOV	ETF	73.02	73.4998	72.61	73.4998	476.0
2023-10-16	AGOX	ETF	22.64	22.88	22.64	22.77	42300.0
2023-10-16	AGQ	ETF	25.36	25.59	25.19	25.28	663700.0
2023-10-16	AGRH	ETF	25.6298	25.6298	25.6	25.6	314.0
2023-10-16	AGZ	ETF	105.44	105.56	105.39	105.47	12000.0
2023-10-16	AGZD	ETF	22.18	22.21	22.12	22.16	35300.0
2023-10-16	AHLT	ETF	26.68	26.68	26.5311	26.5311	1165.0
2023-10-16	AHYB	ETF	42.89	42.92	42.877	42.877	1000.0
2023-10-16	AIA	ETF	55.93	56.59	55.85	56.43	58600.0
2023-10-16	AIEQ	ETF	29.69	30.069	29.69	30.0	19100.0
2023-10-16	AIQ	ETF	27.12	27.485	27.08	27.43	514200.0

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

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