PREVIEW / etf_daily / 2022-07-26

all etf daily files

  file:    by_date/etf_daily/2022/2022-07-26.parquet
  size:    101 KB
  rows:    2,726

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
2022-07-26	SPY	ETF	393.84	394.06	389.95	390.89	52946400.0
2022-07-26	QQQ	ETF	298.53	298.79	293.54	294.37	50074122.0
2022-07-26	IWM	ETF	179.78	180.21	178.54	179.33	19391200.0
2022-07-26	DIA	ETF	318.89	319.48	317.1	317.54	2101700.0
2022-07-26	GLD	ETF	160.23	160.5	159.79	160.04	2672800.0
2022-07-26	TLT	ETF	118.86	119.24	117.4	117.48	13536000.0
2022-07-26	AAA	ETF	24.26	24.26	24.26	24.26	2.0
2022-07-26	AAAU	ETF	17.07	17.1	17.03	17.06	319600.0
2022-07-26	AADR	ETF	48.77	49.02	48.7	49.02	1000.0
2022-07-26	AAXJ	ETF	67.97	68.04	67.24	67.31	534400.0
2022-07-26	ABEQ	ETF	26.815	26.832	26.767	26.832	1200.0
2022-07-26	ACES	ETF	51.97	52.14	51.0	51.19	21000.0
2022-07-26	ACIO	ETF	29.49	29.51	29.331	29.43	31400.0
2022-07-26	ACSI	ETF	43.5684	43.5684	43.5684	43.5684	6.0
2022-07-26	ACT	ETF	22.27	22.55	22.265	22.49	147511.0
2022-07-26	ACTV	ETF	31.115	31.25	31.0129	31.0129	2948.0
2022-07-26	ACTX	ETF	0.7	0.7	0.7	0.7	3206.0
2022-07-26	ACVF	ETF	29.54	29.712	29.54	29.635	2000.0
2022-07-26	ACWF	ETF	32.1	32.1	31.8592	31.88	4039.0
2022-07-26	ACWI	ETF	86.36	86.45	85.62	85.75	3320400.0
2022-07-26	ACWV	ETF	95.09	95.54	95.09	95.37	134900.0
2022-07-26	ACWX	ETF	45.2	45.265	44.88	44.89	2050382.0
2022-07-26	ADFI	ETF	8.64	8.65	8.615	8.615	4900.0
2022-07-26	ADIV	ETF	13.73	13.73	13.71	13.71	400.0
2022-07-26	ADME	ETF	35.19	35.19	34.96	35.039	15200.0
2022-07-26	ADRE	ETF	38.5801	38.5801	38.35	38.35	1125.0
2022-07-26	AEMB	ETF	37.52	37.73	37.49	37.625	400.0
2022-07-26	AESR	ETF	11.47	11.47	11.41	11.435	4300.0
2022-07-26	AFIF	ETF	8.87	8.88	8.85	8.85	23388.0
2022-07-26	AFK	ETF	17.07	17.07	16.83	16.8407	4534.0
2022-07-26	AFLG	ETF	23.28	23.31	23.24	23.24	5000.0
2022-07-26	AFMC	ETF	22.049	22.049	22.049	22.049	100.0
2022-07-26	AFSM	ETF	23.192	23.195	23.192	23.195	200.0
2022-07-26	AFTY	ETF	17.817	17.817	17.817	17.817	100.0
2022-07-26	AGG	ETF	103.44	103.51	102.96	102.96	6312200.0
2022-07-26	AGGH	ETF	23.88	23.88	23.7901	23.8032	1181.0
2022-07-26	AGGY	ETF	45.64	45.68	45.41	45.41	71400.0
2022-07-26	AGNG	ETF	26.09	26.152	26.01	26.076	3100.0
2022-07-26	AGOV	ETF	80.85	80.85	80.7	80.7414	390.0
2022-07-26	AGOX	ETF	20.865	20.898	20.72	20.78	11600.0
2022-07-26	AGQ	ETF	20.33	20.62	20.28	20.36	455900.0
2022-07-26	AGZ	ETF	110.8	110.8237	110.11	110.55	31805.0
2022-07-26	AGZD	ETF	22.865	22.91	22.805	22.87	85600.0
2022-07-26	AHHX	ETF	8.604	8.62	8.56	8.585	4945.0
2022-07-26	AHYB	ETF	44.254	44.254	44.113	44.113	200.0
2022-07-26	AIA	ETF	61.51	61.53	60.78	60.87	41643.0
2022-07-26	AIEQ	ETF	32.62	32.62	32.3	32.385	4200.0
2022-07-26	AIQ	ETF	21.78	21.78	21.36	21.39	16133.0
2022-07-26	AIRR	ETF	39.81	40.419	39.81	40.28	13800.0
2022-07-26	AIVI	ETF	35.4	35.4	35.2	35.22	2400.0

> showing 50 of 2,726 rows — these rows as CSV

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